public static DateTime GetDateFromDateID(object obj) { if (obj is DBNull) { return(DateTime.MinValue); } return(DateTimeUtils2.GetDateFromDateId(GetInt(obj))); }
public static string GetDBDateID(DateTime dt, bool nullable) { if (nullable && dt == DateTime.MinValue) { return("null"); } else { return(DateTimeUtils2.GetDateIdFromDateTime(dt).ToString()); } }
public static string GetSQL(Dictionary <string, string> replacementFieldSet, Dictionary <string, string> replacementOtherSet, string scriptTemplate, string key) { scriptTemplate = ReplaceFieldParameters(replacementFieldSet, scriptTemplate); scriptTemplate = ReplaceOtherParameters(replacementOtherSet, scriptTemplate); #if DEBUG const string folder = @"C:\Temp\SQLLogs\"; if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } File.WriteAllText(folder + key + DateTimeUtils2.FormatDateTimeToKey() + ".sql", scriptTemplate); #endif return(scriptTemplate); }