private void Save() { // Validate page hdfCheckUnitsFlag.Value = "Yes"; Page.Validate(); if (Page.IsValid) { string url = ""; // Save data int companyId = Int32.Parse(hdfCompanyId.Value); int ruleId = Int32.Parse(hdfRuleId.Value); // Get parameters string name = ""; if (tbxName.Text != "") name = tbxName.Text; bool mto = false; if (cbxMtoDot.Checked) mto = true; string description = ""; if (tbxDescription.Text != "") description = tbxDescription.Text; string frequency = tbxFrecuency.Text; bool alarm = false; int? alarmDaysBefore = null; bool serviceRequest = true; int? serviceRequestDaysBefore = null; if (tbxServicesRequestDaysBefore.Text != "") serviceRequestDaysBefore = Convert.ToInt32(tbxServicesRequestDaysBefore.Text); // Save last unitsSelected arrayUnitsSelectedForEdit.Clear(); if (cbxlUnitsSelected.Items.Count > 0) { foreach (ListItem lst in cbxlUnitsSelected.Items) { if (lst.Selected) arrayUnitsSelectedForEdit.Add(Int32.Parse(lst.Value)); } Session["arrayUnitsSelectedForEdit"] = arrayUnitsSelectedForEdit; } // Save to database DB.Open(); DB.BeginTransaction(); try { // Save Data ChecklistRulesDetails checklistRulesDetails = new ChecklistRulesDetails(ruleTDS); checklistRulesDetails.Save(ruleId, name, description, mto, frequency, alarm, alarmDaysBefore, serviceRequest, serviceRequestDaysBefore, false, companyId, arrayCategoriesSelectedForEdit, arrayCompanyLevelsSelectedForEdit, arrayUnitsSelectedForEdit); DB.CommitTransaction(); // Store datasets ruleTDS.AcceptChanges(); Session["ruleTDS"] = ruleTDS; Session["categoriesTDSForChecklist"] = categoriesTDS; Session["companyLevelsTDS"] = companyLevelsTDS; } catch (Exception ex) { DB.RollbackTransaction(); url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } // Redirect if (Request.QueryString["source_page"] == "checklist_rules_navigator.aspx" || Request.QueryString["source_page"] == "checklist_rules_add.aspx") { url = "./checklist_rules_navigator.aspx?source_page=checklist_rules_edit.aspx&rule_id=" + hdfRuleId.Value + "&update=yes"; Response.Redirect(url); } if (Request.QueryString["source_page"] == "checklist_rules_summary.aspx") { url = "./checklist_rules_summary.aspx?source_page=checklist_rules_edit.aspx&rule_id=" + hdfRuleId.Value + "&update=yes"; Response.Redirect(url); } } }
private void UpdateDatabase() { // Delete int ruleId = Int32.Parse(hdfRuleId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); // Delete DB.Open(); DB.BeginTransaction(); try { ChecklistRulesDetails checklistRulesDetails = new ChecklistRulesDetails(ruleTDS); checklistRulesDetails.Delete(ruleId, companyId); DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }