internal static void SetLastImportDate(DateTime lastDate)
{
try
{
user u = new user();
u.ExecuteNonQuery("UPDATE system_options SET last_import_date = '" +
CommonFunctions.ToMySQLDateTime(lastDate) + "'");
}
catch (Exception err)
{
LoggingHelper.Log("Error in system_options.SetLastImportDate", LogSeverity.Error, err, true);
}
}
internal static void SetImportFlag(bool value)
{
string sql = "UPDATE system_options SET is_importing = ";
if (value)
{
sql += "1";
}
else
{
sql += "0";
}
user u = new user();
u.ExecuteNonQuery(sql);
}
internal static void SetImportFlag(bool value)
{
string sql = "UPDATE system_options SET is_importing = ";
if (value)
{
sql += "1";
}
else
{
sql += "0";
}
user u = new user();
u.ExecuteNonQuery(sql);
//if (value)
// Properties.Settings.Default.OpenedExclusive = true;
}
private static void SetDateColumn(string colName, DateTime value)
{
user u = new user();
u.ExecuteNonQuery("UPDATE system_options SET " + colName + " = '" + CommonFunctions.ToMySQLDate(value) + "'");
}
private static void SetIntColumn(string colName, int value)
{
user u = new user();
u.ExecuteNonQuery("UPDATE system_options SET " + colName + " = " + value);
}
private static void SetStringColumn(string colName, string value)
{
user u = new user();
u.ExecuteNonQuery(string.Format("UPDATE system_options SET {0} = '{1}'", colName, value));
}