private bool StepSummaryFinish() { if (Page.IsValid) { int companyId = Convert.ToInt32(Session["companyID"]); 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 = ddlFrequency.SelectedValue; bool alarm = false; int? alarmDaysBefore = null; bool serviceRequest = true; int? serviceRequestDaysBefore = null; if (tbxServicesRequestDaysBefore.Text != "") serviceRequestDaysBefore = Convert.ToInt32(tbxServicesRequestDaysBefore.Text); ChecklistRulesAddNew checklistRulesAddNew = new ChecklistRulesAddNew(checklistRulesAddTDS); checklistRulesAddNew.Insert(name, description, mto, frequency, alarm, alarmDaysBefore, serviceRequest, serviceRequestDaysBefore, false, companyId); // Store database Session["checklistRulesAddTDS"] = checklistRulesAddTDS; Save(); hdfUpdate.Value = "yes"; return true; } else { return false; } }
private void Save() { // save to database DB.Open(); DB.BeginTransaction(); try { ChecklistRulesAddNew checklistRulesAddNew = new ChecklistRulesAddNew(checklistRulesAddTDS); checklistRulesAddNew.Save(arrayCategoriesSelected, arrayCompanyLevelsSelected, arrayUnitsSelected); // Store datasets checklistRulesAddTDS.AcceptChanges(); Session["checklistRulesAddTDS"] = checklistRulesAddTDS; DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }