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