private void UpdateDatabase() { int companyId = Int32.Parse(hdfCompanyId.Value); int unitId = Int32.Parse(hdfUnitId.Value); DB.Open(); DB.BeginTransaction(); try { // process view UnitInformationTDS dataset = new UnitInformationTDS(); dataset.ChecklistDetails.Merge(unitsChecklistRulesEdit, true); UnitInformationChecklistDetails model = new UnitInformationChecklistDetails(dataset); model.Save(unitId, companyId); DB.CommitTransaction(); // Store datasets unitInformationTDS.AcceptChanges(); Session["unitInformationTDS"] = unitInformationTDS; Session["unitsChecklistRulesEdit"] = unitsChecklistRulesEdit; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void ChecklistRulesInformationProcessGrid() { UnitInformationTDS dataSet = new UnitInformationTDS(); dataSet.ChecklistDetails.Merge(unitsChecklistRulesEdit, true); UnitInformationChecklistDetails model = new UnitInformationChecklistDetails(dataSet); // update rows if (Session["unitsChecklistRulesEditDummy"] == null) { foreach (GridViewRow row in grdChecklistRulesInformation.Rows) { int ruleId = int.Parse(grdChecklistRulesInformation.DataKeys[row.RowIndex].Values["RuleID"].ToString()); DateTime? lastService = null; DateTime? nextDue = null; bool done = ((CheckBox)row.FindControl("cbxDone")).Checked; string state = ((DropDownList)row.FindControl("ddlState")).SelectedValue; if (((RadDatePicker)row.FindControl("tkrdpLastService")).SelectedDate.HasValue) { lastService = ((RadDatePicker)row.FindControl("tkrdpLastService")).SelectedDate.Value; } if (((RadDatePicker)row.FindControl("tkrdpNextDue")).SelectedDate.HasValue) { nextDue = ((RadDatePicker)row.FindControl("tkrdpNextDue")).SelectedDate.Value; } model.Update(ruleId, lastService, nextDue, state, done); } model.Table.AcceptChanges(); unitsChecklistRulesEdit = (UnitInformationTDS.ChecklistDetailsDataTable)model.Table; Session["unitsChecklistRulesEdit"] = unitsChecklistRulesEdit; } }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_EDIT"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["unit_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_checklist_rules.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfUnitId.Value = Request.QueryString["unit_id"].ToString(); hdfUpdate.Value = "no"; // If coming from // ... units_summary.aspx and units_edit.aspx if (Request.QueryString["source_page"] == "units_summary.aspx" || Request.QueryString["source_page"] == "units_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; unitInformationTDS = new UnitInformationTDS(); unitsChecklistRulesEdit = new UnitInformationTDS.ChecklistDetailsDataTable(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int unitId = Int32.Parse(hdfUnitId.Value.Trim()); // Load UnitInformationTDS dataSet = new UnitInformationTDS(); dataSet.ChecklistDetails.Merge(unitsChecklistRulesEdit, true); UnitInformationChecklistDetails model = new UnitInformationChecklistDetails(dataSet); model.LoadByUnitIdWithoutInProgressRules(unitId, int.Parse(hdfCompanyId.Value)); // Store tables unitsChecklistRulesEdit = (UnitInformationTDS.ChecklistDetailsDataTable)model.Table; Session["unitsChecklistRulesEdit"] = unitsChecklistRulesEdit; grdChecklistRulesInformation.DataBind(); } } else { // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesEdit = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesEdit"]; } }
private void LoadChecklitData(int unitId) { // Load UnitInformationTDS dataSet = new UnitInformationTDS(); dataSet.ChecklistDetails.Merge(unitsChecklistRulesTemp, true); UnitInformationChecklistDetails model = new UnitInformationChecklistDetails(dataSet); model.Load(unitId, int.Parse(hdfCompanyId.Value)); // Store tables unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)model.Table; Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp; grdChecklistRulesInformation.DataBind(); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_DELETE"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["unit_id"] == null) || ((string)Request.QueryString["unit_type"] == null) || ((string)Request.QueryString["unit_state"] == null) || ((string)Request.QueryString["active_tab"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_delete.aspx"); } // Tag Page hdfUnitId.Value = Request.QueryString["unit_id"].ToString(); hdfUnitType.Value = Request.QueryString["unit_type"].ToString(); hdfUnitState.Value = Request.QueryString["unit_state"].ToString(); hdfCompanyId.Value = Session["companyID"].ToString(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int unitId = Int32.Parse(hdfUnitId.Value.Trim()); // If comming from // ... units_navigator2.aspx if (Request.QueryString["source_page"] == "units_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; unitInformationTDS = new UnitInformationTDS(); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationChecklistDetails unitInformationChecklistDetails = new UnitInformationChecklistDetails(unitInformationTDS); unitInformationChecklistDetails.Load(unitId, companyId); UnitInformationServiceDetails unitInformationServiceDetails = new UnitInformationServiceDetails(unitInformationTDS); unitInformationServiceDetails.Load(unitId, companyId); UnitInformationInspectionDetails unitInformationInspectionDetails = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetails.LoadByUnitId(unitId, companyId); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.LoadAllByUnitId(unitId, companyId); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; } // ... units_summary.aspx if (Request.QueryString["source_page"] == "units_summary.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; } } else { // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; } }
private void Delete() { Page.Validate(); if (Page.IsValid) { // Delete int unitId = Int32.Parse(hdfUnitId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.Delete(unitId); UnitInformationChecklistDetails unitInformationChecklistDetails = new UnitInformationChecklistDetails(unitInformationTDS); unitInformationChecklistDetails.DeleteAll(); UnitInformationInspectionDetails unitInformationInspectionDetails = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetails.DeleteAll(); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.DeleteAll(unitId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.DeleteAll(unitId); // Update databse UpdateDatabase(); // Store datasets Session["unitInformationTDS"] = unitInformationTDS; // Redirect string url = ""; url = "./units_navigator2.aspx?source_page=units_delete.aspx" + GetNavigatorState() + "&update=yes"; Response.Redirect(url); } }