Skip to content

Instantly share code, notes, and snippets.

View DateTimeExtensions
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
samjgriffin89 / RsaEncryptionHelper
Created Jun 26, 2015
RSA Encryption/Decryption with X509 Certificates
View RsaEncryptionHelper
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
samjgriffin89 / DatabaseExtensions
Created May 1, 2015
Check to see if a column exists in a datareader
View DatabaseExtensions
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;
}
You can’t perform that action at this time.