samjgriffin89

public static DateTime Truncate(this DateTime dateTime, TimeSpan timeSpan)
{
    if (timeSpan == TimeSpan.Zero) return dateTime; // Or could throw an ArgumentException
    return dateTime.AddTicks(-(dateTime.Ticks % timeSpan.Ticks));
}

samjgriffin89

private X509Certificate2 RsaCertificate
{
    get
    {
      var store = new X509Store(StoreName.My, StoreLocation.LocalMachine);
      store.Open(OpenFlags.ReadOnly);
      var certs = store.Certificates.Find(X509FindType.FindBySubjectDistinguishedName, ConfigurationManager.AppSettings.Get("CertificateSubjectName"), false);
      store.Close();

      return certs[0];

samjgriffin89

public static bool HasColumn(this IDataRecord dr, string columnName)
{
    for (int i = 0; i < dr.FieldCount; i++)
    {
      if (dr.GetName(i).Equals(columnName, StringComparison.InvariantCultureIgnoreCase)) return true;
    }
  
    return false;
}