Best Way to Code

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

             <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>

• 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

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>();

  this.customerid = Number(text);

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);

Visit here for All shortcuts

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

{{email.responseDate | date:'MM-dd-yyyy hh:mm a'}}

 Output: 07-09-2017 05:00 PM

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

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

• 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

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

  
  public search(name: string): void {
    if (name.trim().length > 0) {
      this.employees = this.employeeSource.filter(x => x.name.toLowerCase().indexOf(name.trim().toLowerCase()) >= 0);
    }
  }  
  
  

  public getTotalWeight(): number {
    var total = 0;
    if (this.items != null && this.items.length > 0) {      
      this.items.forEach(x => total += x.weight);
    }
    return total;
  }  

After creating a component/directive by calling its constructor, Angular calls the lifecycle hook methods in the following sequence at specific moments:

• ngOnChanges()
• ngOnInit()
• ngDoCheck()
• ngAfterContentInit()
• ngAfterContentChecked()
• ngAfterViewInit()
• ngAfterViewChecked()
• ngOnDestroy()

Run this script in your management studio as administrator.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT SPID = er.session_id ,
       DBName = DB_Name(er.database_id) ,
    BlkBy = er.blocking_session_id ,
       ElapsedMS = er.total_elapsed_time ,
       CPU = er.cpu_time ,
       IOReads = er.logical_reads + er.reads ,
       IOWrites = er.writes ,
       Executions = ec.execution_count ,
       CommandType = er.command ,
       ObjectName = OBJECT_SCHEMA_NAME(qt.objectid,dbid) + '.' + OBJECT_NAME(qt.objectid, qt.dbid) ,
       SQLStatement = SUBSTRING ( qt.text, er.statement_start_offset/2, (CASE WHEN er.statement_end_offset = -1 THEN LEN(CONVERT(nvarchar(MAX), qt.text)) * 2 ELSE er.statement_end_offset END - er.statement_start_offset)/2 ) ,
       Status = ses.status ,
       [Login] = ses.login_name ,
       HOST = ses.host_name ,
       
       LastWaitType = er.last_wait_type ,
       StartTime = er.start_time ,
       Protocol = con.net_transport ,
       transaction_isolation = CASE ses.transaction_isolation_level
            WHEN 0 THEN 'Unspecified'
            WHEN 1 THEN 'Read Uncommitted'
            WHEN 2 THEN 'Read Committed'
            WHEN 3 THEN 'Repeatable'
            WHEN 4 THEN 'Serializable'
            WHEN 5 THEN 'Snapshot'
        END ,
        ConnectionWrites = con.num_writes ,
        ConnectionReads = con.num_reads ,
        ClientAddress = con.client_net_address ,
        Authentication = con.auth_scheme
FROM sys.dm_exec_requests er
LEFT JOIN sys.dm_exec_sessions ses ON ses.session_id = er.session_id
LEFT JOIN sys.dm_exec_connections con ON con.session_id = ses.session_id CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) AS qt OUTER APPLY
( SELECT execution_count = MAX(cp.usecounts)
 FROM sys.dm_exec_cached_plans cp
 WHERE cp.plan_handle = er.plan_handle) ec
ORDER BY er.blocking_session_id DESC,
         er.logical_reads + er.reads DESC,
         er.session_id

You need to have sufficient permission to execute this command.

EXECUTE sp_MSForEachDB  'USE ?; select DB_NAME() AS DBName,xmluserid from carriertable where carriername=''LKVL'' and userid IS NOT NULL'

How to get the raw xml from a webservice request or response

XmlSerializer xmlSerializer = new XmlSerializer(oResponse.GetType());

using (StringWriter textWriter = new StringWriter())
{
    xmlSerializer.Serialize(textWriter, oResponse);
    var xmlText = textWriter.ToString();
}

Fast test way to sum from 1 to 100000 by using arithmetic series.

public static int Sum(int value)
{
 var n = value;
 var a1 = 1;
 var an = a1 + (n - 1);
 var sn = n * (a1 + an) / 2;
 return sn;
}

First Method

        public static int GetWorkingDays(DateTime from, DateTime to)
        {
            var workingDay = 1 + (to - from).Days;
            return Enumerable
                .Range(0, workingDay)
                .Select(x => from.AddDays(x))
                .Count(x => x.DayOfWeek != DayOfWeek.Saturday && x.DayOfWeek != DayOfWeek.Sunday);
        }

Second Method

        public static double GetWorkingDays(DateTime startD, DateTime endD)
        {
            double workingDay = 1 + ((endD - startD).TotalDays * 5 - (startD.DayOfWeek - endD.DayOfWeek) * 2) / 7;

            if (endD.DayOfWeek == DayOfWeek.Saturday) workingDay--;
            if (startD.DayOfWeek == DayOfWeek.Sunday) workingDay--;

            return workingDay;
        }

• Can support inheritance
• lives on the heap
• Are reference (pointer) types. Value passing around from method to method
• The reference can be null
• Have memory overhead per new instance
• Can have an explicit parameterless constructor
• Can have destructors

• Cannot support inheritance
• lives on the stack
• Are value types
• Are passed by value: all struct types implicitly inherit from the class System.ValueType. Assignment to a variable of a struct type creates a copy of the value being assigned
• Cannot have a null reference (unless Nullable is used)
• Do not have a memory overhead per new instance - unless 'boxed'
• Cannot have an explicit parameterless constructor
• Cannot have destructors

• Are compound data types typically used to contain a few variables that have some logical relationship
• Can contain methods and events
• Can support interfaces

If your primary key is auto increment

public void InsertOrUpdate(Blog blog) 
{ 
    using (var context = new BloggingContext()) 
    { 
        context.Entry(blog).State = blog.BlogId == 0 ? EntityState.Added : EntityState.Modified;  
        context.SaveChanges(); 
    } 
}

If your primary key is not auto increment

public void InsertOrUpdate(Blog blog) 
{ 
    using (var context = new BloggingContext()) 
    { 
        var q = context.Blog.FirstOrDefault(x=>x.BlogId=blog.BlogId);        
        if (q != null)
            context.Entry(q).State = EntityState.Detached;
        context.Entry(blog).State = q == null ?EntityState.Added : EntityState.Modified; 
        context.SaveChanges(); 
    } 
}