/// <summary>
/// Gets project data
/// </summary>
/// <param name="id">project id</param>
/// <returns>DetailProjectData object</returns>
public static DetailProjectData GetDetailProjectData(string id)
{
DetailProjectData data = new DetailProjectData();
using (DbConnection connection = new OracleConnection(WebSettings.GetConnectionString()))
{
connection.Open();
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"SELECT IVR_PROJECT_ID, IVR_SERVER_ID, NAME, EMAIL_ADDRESSES, ENABLED," +
"SCHEDULE_CRON FROM " + schemaName +
".IVR_PROJECT WHERE IVR_PROJECT_ID =:PARAM_IVR_PROJECT_ID";
AddInputParameter(cmd, "PARAM_IVR_PROJECT_ID", id);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data.projectId = Convert.ToString(reader[0]);
data.serverId = Convert.ToString(reader[1]);
data.name = Convert.ToString(reader[2]);
data.emails = Convert.ToString(reader[3]);
data.enabled = Convert.ToString(reader[4]);
data.cron = Convert.ToString(reader[5]);
}
}
}
}
return(data);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.Params["id"];
// Is project added
if (string.IsNullOrEmpty(id))
{
Header.Title = PAGE_TITLE_ADD;
tbName.Text = string.Empty;
tbEmails.Text = string.Empty;
cbEnabled.Checked = true;
tbCron.Text = string.Empty;
}
else
{
Header.Title = PAGE_TITLE_EDIT;
DetailProjectData data = IlcWebDao.GetDetailProjectData(id);
tbName.Text = data.name;
tbEmails.Text = data.emails;
cbEnabled.Checked = (data.enabled == "1");
tbCron.Text = data.cron;
}
}
}
/// <summary>
/// Inserts project data
/// </summary>
/// <param name="data">DetailProjectData object</param>
/// <param name="user">principal object interface</param>
/// <returns>inserted project id</returns>
public static int InsertDetailProjectData(DetailProjectData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
AddInputParameter(cmd, "NAME", data.name);
AddInputParameter(cmd, "EMAILS", data.emails);
AddInputParameter(cmd, "ENABLED", data.enabled);
AddInputParameter(cmd, "CRON", data.cron);
AddInputParameter(cmd, "SERVER_ID", data.serverId);
return(ExecuteAndHandleNewId(cmd,
"INSERT INTO " + schemaName + ".IVR_PROJECT (NAME, EMAIL_ADDRESSES, ENABLED," +
"SCHEDULE_CRON, IVR_SERVER_ID) VALUES (:NAME, :EMAILS, :ENABLED, :CRON, :SERVER_ID)"));
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!IsValid)
{
return;
}
DetailProjectData data = new DetailProjectData();
data.name = tbName.Text;
data.emails = tbEmails.Text.Trim();
data.enabled = cbEnabled.Checked ? "1" : "0";
data.cron = tbCron.Text.Trim();
string id = Request.Params["id"];
string parentId = DropDownList1.SelectedValue;
bool isAdded = false;
data.serverId = parentId;
// Is project added
if (string.IsNullOrEmpty(id))
{
isAdded = true;
id = IlcWebDao.InsertDetailProjectData(data, User).ToString();
}
else
{
data.projectId = id;
IlcWebDao.UpdateDetailProjectData(data, User);
}
string strEvent = isAdded ? "'treeViewRefresh.project.add'" : "'treeViewRefresh.project.update'";
string response = "<html><head><script type='text/javascript' src='" +
ResolveClientUrl("~/scripts/popup.js") +
"'></script></head><body onload=\"javascript:modalHandleClose([" +
strEvent + ", '" + id + "," + parentId + "," + tbName.Text.Replace("'", "\\'") +
"'])\"></body></html>";
Response.Write(response);
}
/// <summary>
/// Updates project data
/// </summary>
/// <param name="data">DetailProjectData object</param>
/// <param name="user">principal object interface</param>
public static void UpdateDetailProjectData(DetailProjectData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"UPDATE " + schemaName + ".IVR_PROJECT " +
"SET IVR_SERVER_ID=:SERVER_ID, NAME=:NAME, EMAIL_ADDRESSES=:EMAILS," +
"ENABLED=:ENABLED, SCHEDULE_CRON=:CRON WHERE IVR_PROJECT_ID = :PROJECT_ID";
AddInputParameter(cmd, "SERVER_ID", data.serverId);
AddInputParameter(cmd, "NAME", data.name);
AddInputParameter(cmd, "EMAILS", data.emails);
AddInputParameter(cmd, "ENABLED", data.enabled);
AddInputParameter(cmd, "CRON", data.cron);
AddInputParameter(cmd, "PROJECT_ID", data.projectId);
cmd.ExecuteNonQuery();
}
}
}
