/// <summary>
/// Gets server data
/// </summary>
/// <param name="id">server id</param>
/// <returns>DetailServerData object</returns>
public static DetailServerData GetDetailServerData(string id)
{
DetailServerData data = new DetailServerData();
using (DbConnection connection = new OracleConnection(WebSettings.GetConnectionString()))
{
connection.Open();
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"SELECT IVR_SERVER_ID, NAME, NUM_CHANNELS, DB_CONN, ENABLED, AUTH_CHECKER," +
"SCHEDULE_CRON FROM " + schemaName + ".IVR_SERVER WHERE IVR_SERVER_ID =:PARAM_SERVER_ID";
AddInputParameter(cmd, "PARAM_SERVER_ID", id);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data.serverId = Convert.ToString(reader[0]);
data.name = Convert.ToString(reader[1]);
data.channels = Convert.ToString(reader[2]);
data.connectionString = Convert.ToString(reader[3]);
data.enabled = Convert.ToString(reader[4]);
data.checker = Convert.ToString(reader[5]);
data.cron = Convert.ToString(reader[6]);
}
}
}
}
return(data);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!IsValid)
{
return;
}
DetailServerData data = new DetailServerData();
data.name = tbName.Text;
data.channels = tbChannels.Text;
data.connectionString = tbConnString.Text;
data.enabled = cbEnabled.Checked ? "1" : "0";
//data.checker = checkerList.SelectedItem.Text == "NEW..."
// ? tbChecker.Text.Trim()
// : checkerList.SelectedItem.Text;
data.checker = serviceCheckBox.Checked ? "AspirinLoginChecker" : "";
data.cron = tbCron.Text.Trim();
string id = Request.Params["id"];
bool isAdded = false;
// Is server added
if (string.IsNullOrEmpty(id))
{
isAdded = true;
id = IlcWebDao.InsertDetailServerData(data, User).ToString();
}
else
{
data.serverId = id;
IlcWebDao.UpdateDetailServerData(data, User);
}
string strEvent = isAdded ? "'treeViewRefresh.server.add'" : "'treeViewRefresh.server.update'";
string response = "<html><head><script type='text/javascript' src='" +
ResolveClientUrl("~/scripts/popup.js") +
"'></script></head><body onload=\"javascript:modalHandleClose([" +
strEvent + ", '" + id + "," + tbName.Text.Replace("'", "\\'") +
"'])\"></body></html>";
Response.Write(response);
}
/// <summary>
/// Inserts server data
/// </summary>
/// <param name="data">DetailServerData object</param>
/// <param name="user">principal object interface</param>
/// <returns>inserted server id</returns>
public static int InsertDetailServerData(DetailServerData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
AddInputParameter(cmd, "NAME", data.name);
AddInputParameter(cmd, "CHANNELS", data.channels);
AddInputParameter(cmd, "CONN", data.connectionString);
AddInputParameter(cmd, "ENABLED", data.enabled);
AddInputParameter(cmd, "CHECKER", data.checker);
AddInputParameter(cmd, "CRON", data.cron);
return(ExecuteAndHandleNewId(cmd,
"INSERT INTO " + schemaName + ".IVR_SERVER(NAME, NUM_CHANNELS, DB_CONN, ENABLED," +
"AUTH_CHECKER,SCHEDULE_CRON) VALUES(:NAME, :CHANNELS, :CONN, :ENABLED, :CHECKER, :CRON)"));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.Params["id"];
// Is server added
if (string.IsNullOrEmpty(id))
{
Header.Title = PAGE_TITLE_ADD;
tbName.Text = string.Empty;
tbChannels.Text = "2";
tbConnString.Text = string.Empty;
cbEnabled.Checked = true;
serviceCheckBox.Checked = true;
//tbChecker.Text = string.Empty;
tbCron.Text = string.Empty;
}
else
{
Header.Title = PAGE_TITLE_EDIT;
DetailServerData data = IlcWebDao.GetDetailServerData(Request.Params["Id"]);
RangeValidator1.Text = string.Format("Enter number from {0} to {1}",
RangeValidator1.MinimumValue, RangeValidator1.MaximumValue);
tbName.Text = data.name;
tbChannels.Text = data.channels;
tbConnString.Text = data.connectionString;
cbEnabled.Checked = (data.enabled == "1");
serviceCheckBox.Checked = (!string.IsNullOrEmpty(data.checker));
//tbChecker.Text = data.checker;
tbCron.Text = data.cron;
}
}
}
/// <summary>
/// Updates server data
/// </summary>
/// <param name="data">DetailServerData object</param>
/// <param name="user">principal object interface</param>
public static void UpdateDetailServerData(DetailServerData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"UPDATE " + schemaName + ".IVR_SERVER SET NAME=:NAME, NUM_CHANNELS=:CHANNELS, DB_CONN=:CONN," +
"ENABLED=:ENABLED, AUTH_CHECKER=:CHECKER, SCHEDULE_CRON=:CRON " +
"WHERE IVR_SERVER_ID = :SERVER_ID";
AddInputParameter(cmd, "NAME", data.name);
AddInputParameter(cmd, "CHANNELS", data.channels);
AddInputParameter(cmd, "CONN", data.connectionString);
AddInputParameter(cmd, "ENABLED", data.enabled);
AddInputParameter(cmd, "CHECKER", data.checker);
AddInputParameter(cmd, "CRON", data.cron);
AddInputParameter(cmd, "SERVER_ID", data.serverId);
cmd.ExecuteNonQuery();
}
}
}
