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