/// <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(); } } }