TypeScript: Remove duplicate item in array

Posted by Unknown On Friday, July 21, 2017 8 comments

 this.carriers = this.carriers.filter((el, i, a) => i === a.indexOf(el))

Angular2: Form

Posted by Unknown On Wednesday, July 19, 2017 0 comments

             <form (submit)="showReport()">
                 <div class="form-group">
                     <label>Filter </label>
                     <input type="text" name="filter" class="form-control" [(ngModel)]="filter.keyword" />
                 </div>
                 <div class="text-right">
                     <button type="submit" name="search" class="btn btn-primary">Search </button>
                 </div>
             </form>

Angular2: Currency Format

Posted by Unknown On Friday, July 14, 2017 0 comments

Format: {{cost | currency:'USD':true:'1.2-2'}}
Output: $348.64

  • Format: {{currency:currencyCode:symbolDisplay:digitInfo}}
  • CurrencyCode Info: https://en.wikipedia.org/wiki/ISO_4217
  • SymbolDisplay: is a boolean indicating whether to use the currency symbol or code.
        true: use symbol (e.g. $).
        false(default): use code (e.g. USD).
  • DigitInfo Format: {minIntegerDigits}.{minFractionDigits}-{maxFractionDigits}
    •    1 : minIntegerDigits
    •    2 : minFractionDigits
    •    2 : maxFractionDigits

Angular2: Number Format

Posted by Unknown On 0 comments

Format: {{value | number : '1.2-2'}}
output: 250.12

Format: {minIntegerDigits}.{minFractionDigits}-{maxFractionDigits}
1 : minIntegerDigits
2 : minFractionDigits
2 : maxFractionDigits

C#: Generic - Convert any string to any enum type

Posted by Unknown On Tuesday, July 11, 2017 0 comments

Use an extension method to convert from string to enum.


 public static T ToEnum(this string enumString)
 {
    return (T) Enum.Parse(typeof (T), enumString);
 }

//Usage:

 Color colorEnum = "Red".ToEnum<Color>();

TypeScript: Convert string to number

Posted by Unknown On 0 comments

  this.customerid = Number(text);

JavaScript: Base64 encoding and decoding

Posted by Unknown On 0 comments
atob(): Decodes a string of data which has been encoded using base-64 encoding.
btoa(): Creates a base-64 encoded ASCII string from a "string" of binary data.

The "Unicode Problem": In most browsers, calling btoa() on a Unicode string will cause a Character Out Of Range exception. This paragraph shows some solutions.

Solution to unicode

C#: Encoding and Decoding base64

Posted by Unknown On 0 comments

Encoding


  byte[] textAsBytes = System.Text.Encoding.UTF8.GetBytes(text);
  var encodedText = Convert.ToBase64String(plainTextBytes);

Decoding


 var textAsBytes = Convert.FromBase64String(text);
 var decodedText = System.Text.Encoding.UTF8.GetString(textAsBytes);

Visual Studio 2017 keyboard shortcuts

Posted by Unknown On Monday, July 10, 2017 0 comments
This is cool thing you should know.

Visit here for All shortcuts

TypeScript: Clone an object

Posted by Unknown On 0 comments

let newObject = Object.assign({}, currentObject);

Angular 2: Format Date Time MM-dd-yyyy

Posted by Unknown On 0 comments




 Output: 07-09-2017 05:00 PM

TypeScript: Filter out array from another array (not in statement)

Posted by Unknown On Friday, July 7, 2017 0 comments

var arr1 = [1, 2, 3, 4, 5];
var arr2 = [2, 4];

var arr = arr1.filter(x => { return arr2.indexOf(x) === -1; });


SQL: Detecting fragmentation of Indexes on a database

Posted by Unknown On 0 comments
  • Fragmentation is between 5-30% – it is suggested to perform index reorganization
  • Fragmentation is higher than 30% – it is suggested to perform index rebuild

SELECT dbschemas.[name] as 'Schema', 
dbtables.[name] as 'Table', 
dbindexes.[name] as 'Index',
indexstats.alloc_unit_type_desc,
indexstats.avg_fragmentation_in_percent,
indexstats.page_count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS indexstats
INNER JOIN sys.tables dbtables on dbtables.[object_id] = indexstats.[object_id]
INNER JOIN sys.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id]
INNER JOIN sys.indexes AS dbindexes ON dbindexes.[object_id] = indexstats.[object_id]
AND indexstats.index_id = dbindexes.index_id
WHERE indexstats.database_id = DB_ID()
ORDER BY indexstats.avg_fragmentation_in_percent desc


Read more on https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql

TypeScript: Select fields from Array of Object

Posted by Unknown On Thursday, July 6, 2017 0 comments

var ids = this.products.map((p) => p.id);
var products= this.selectedProducts.map((p) => { p.id, p.name });