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);
     }
 }
Exemple #2
0
        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);
        }
Exemple #3
0
        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);
        }
Exemple #6
0
        private static void SetStringColumn(string colName, string value)
        {
            user u = new user();

            u.ExecuteNonQuery(string.Format("UPDATE system_options SET {0} = '{1}'", colName, value));
        }