protected void Button1_Click(object sender, EventArgs e)
{
if (!IsValid)
{
return;
}
DetailItemData data = new DetailItemData();
data.phoneNumber = tbPhone.Text.Trim();
data.login = tbLogin.Text.Trim();
data.password = tbPassword.Text.Trim();
data.enabled = cbEnabled.Checked ? "1" : "0";
string id = Request.Params["id"];
string parentId = Request.Params["parentId"];
// Is item added
if (!string.IsNullOrEmpty(parentId))
{
data.projectId = parentId;
IlcWebDao.InsertDetailItemData(data, User);
}
else if (!string.IsNullOrEmpty(id))
{
data.itemId = id;
IlcWebDao.UpdateDetailItemData(data, User);
}
else
{
throw new ApplicationException("Unexpected page title");
}
Response.Write("<script type=\"text/javascript\"> if (window.opener) window.opener.location.reload(1); else returnValue = 'reload'; self.close(); </script>");
}
/// <summary>
/// Gets item data
/// </summary>
/// <param name="id">item id</param>
/// <returns>DetailItemData object</returns>
public static DetailItemData GetDetailItemData(string id)
{
DetailItemData data = new DetailItemData();
using (DbConnection connection = new OracleConnection(WebSettings.GetConnectionString()))
{
connection.Open();
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"SELECT ITEM_ID, TNUMBER, IVR_PROJECT_ID, USERID, PWD, ENABLED FROM " +
schemaName + ".SERVICE_INFO WHERE ITEM_ID=:PARAM_ITEM_ID";
AddInputParameter(cmd, "PARAM_ITEM_ID", id);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data.itemId = Convert.ToString(reader[0]);
data.phoneNumber = Convert.ToString(reader[1]);
data.projectId = Convert.ToString(reader[2]);
data.login = Convert.ToString(reader[3]);
data.password = Convert.ToString(reader[4]);
data.enabled = Convert.ToString(reader[5]);
}
}
}
}
return(data);
}
/// <summary>
/// Inserts item data
/// </summary>
/// <param name="data">DetailItemData object</param>
/// <param name="user">principal object interface</param>
/// <returns>inserted item id</returns>
public static int InsertDetailItemData(DetailItemData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
AddInputParameter(cmd, "PHONE", data.phoneNumber);
AddInputParameter(cmd, "LOGIN", data.login);
AddInputParameter(cmd, "PASSWORD", data.password);
AddInputParameter(cmd, "ENABLED", data.enabled);
AddInputParameter(cmd, "PROJECT_ID", data.projectId);
return(ExecuteAndHandleNewId(cmd,
"INSERT INTO " + schemaName + ".SERVICE_INFO (TNUMBER, USERID, PWD, ENABLED," +
"IVR_PROJECT_ID) VALUES(:PHONE, :LOGIN, :PASSWORD, :ENABLED, :PROJECT_ID)"));
}
}
}
/// <summary>
/// Updates item data
/// </summary>
/// <param name="data">DetailItemData object</param>
/// <param name="user">principal object interface</param>
public static void UpdateDetailItemData(DetailItemData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"UPDATE " + schemaName + ".SERVICE_INFO SET TNUMBER=:PHONE, USERID=:LOGIN," +
"PWD=:PASSWORD, ENABLED=:ENABLED WHERE ITEM_ID=:ITEM_ID";
AddInputParameter(cmd, "PHONE", data.phoneNumber);
AddInputParameter(cmd, "LOGIN", data.login);
AddInputParameter(cmd, "PASSWORD", data.password);
AddInputParameter(cmd, "ENABLED", data.enabled);
AddInputParameter(cmd, "ITEM_ID", data.itemId);
cmd.ExecuteNonQuery();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string parentId = Request.Params["parentId"];
// Is item added
if (!string.IsNullOrEmpty(parentId))
{
Header.Title = PAGE_TITLE_ADD;
tbPhone.Text = string.Empty;
tbLogin.Text = string.Empty;
tbPassword.Text = string.Empty;
cbEnabled.Checked = true;
return;
}
string id = Request.Params["id"];
if (!string.IsNullOrEmpty(id))
{
Header.Title = PAGE_TITLE_EDIT;
DetailItemData data = IlcWebDao.GetDetailItemData(id);
tbPhone.Text = data.phoneNumber;
tbLogin.Text = data.login;
tbPassword.Text = data.password;
cbEnabled.Checked = (data.enabled == "1");
return;
}
throw new ApplicationException("Unexpected query string");
}
}
