public static bool Validate(HostOptions hostOptions) { Boolean valid = true; if (hostOptions.SessionTimeout <= 0) valid = false; if (hostOptions.LockTimeout <= 0) valid = false; return valid; }
public int SaveHostOptions(HostOptions hostOptions) { try { int result = -1; using (DbConnection = new SQLitePersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand = new SQLiteCommand()) { string sql = "UPDATE HostOptions " + "SET sessiontimeout = @SessionTimeout, locktimeout = @LockTimeout " + "WHERE id = 1"; DbCommand.CommandText = sql; DbCommand.Parameters.Clear(); DbCommand.Parameters.AddWithValue("@SessionTimeout", hostOptions.SessionTimeout); DbCommand.Parameters.AddWithValue("@LockTimeout", hostOptions.LockTimeout); result = DbConnection.ExecuteCommand(DbCommand); } }else { throw new Exception("Unable to Connect"); } } return result; }catch { throw; } }
public HostOptions GetHostOptions() { try { HostOptions result = new HostOptions(); using (DbConnection = new SQLitePersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand = new SQLiteCommand()) { string sql = "SELECT SessionTimeout, LockTimeout from HostOptions"; DbCommand.CommandText = sql; DataTable returnDT = DbConnection.ExecuteQuery(DbCommand); if (returnDT.Rows.Count == 1) { DataRow row = returnDT.Rows[0]; result.SessionTimeout = Convert.ToInt32(row["SessionTimeout"]); result.LockTimeout = Convert.ToInt32(row["LockTimeout"]); row = null; } returnDT = null; } }else { throw new Exception("Unable to Connect"); } } return result; }catch { throw; } }