/// <summary> /// InitData /// </summary> protected override void InitData() { _data = new UnitsAddTDS(); }
private bool StepSummaryFinish() { if (Page.IsValid) { string type = (rbtnVehicle.Checked) ? type = "Vehicle" : type = "Equipment"; string code = tbxCode.Text; string description = ""; if (tbxDescription.Text != "") description = tbxDescription.Text; string vin = ""; if (tbxVinSerialNumber.Text != "") vin = tbxVinSerialNumber.Text; string manufacturer = ""; if (tbxManufacturer.Text != "") manufacturer = tbxManufacturer.Text; string model = ""; if (tbxModel.Text != "") model = tbxModel.Text; string year = ""; if (tbxYear.Text != "") year =tbxYear.Text; bool isTowable = (cbxIsTowable.Checked) ? isTowable = true : isTowable = false; Int64? licenseCountry = null; Int64? licenceState = null; if (type == "Vehicle") { if (ddlLicenseCountry.SelectedValue != "-1") { licenseCountry = Int64.Parse(ddlLicenseCountry.SelectedValue); if (ddlLicenseState.SelectedValue != "-1" && ddlLicenseState.SelectedValue != "") { licenceState = Int64.Parse(ddlLicenseState.SelectedValue); } } } string licensePlateNumber = ""; if (tbxLicensePlateNumber.Text != "") licensePlateNumber = tbxLicensePlateNumber.Text; string apportionedTagNumber = ""; if (tbxApportionedTagNumber.Text != "") apportionedTagNumber = tbxApportionedTagNumber.Text; int companyLevelIdSelected = 0; foreach (int companyLevelId in arrayCompanyLevelsSelected) { companyLevelIdSelected = companyLevelId; } UnitsAddTDS dataSet = new UnitsAddTDS(); dataSet.UnitsAddNew.Merge(unitsAddNew, true); UnitsAddNew modelU = new UnitsAddNew(dataSet); modelU.Insert(type, code, description, vin, manufacturer, model, year, isTowable, licenseCountry, licenceState, licensePlateNumber, apportionedTagNumber, companyLevelIdSelected); unitsAddNew.Rows.Clear(); unitsAddNew.Merge(modelU.Table); // Store database Session["unitsAddTDS"] = unitsAddTDS; Session["unitsAddNew"] = unitsAddNew; Save(); hdfUpdate.Value = "yes"; return true; } else { return false; } }
private void StepChecklistRulesInformationProcessGrid() { UnitsAddTDS dataSet = new UnitsAddTDS(); dataSet.UnitsChecklistRulesTemp.Merge(unitsChecklistRulesTempForAdd, true); UnitsChecklistRulesTemp model = new UnitsChecklistRulesTemp(dataSet); // Update rows if (Session["unitsChecklistRulesTempForAddDummy"] == null) { foreach (GridViewRow row in grdChecklistRulesInformation.Rows) { int ruleId = int.Parse(grdChecklistRulesInformation.DataKeys[row.RowIndex].Values["RuleID"].ToString()); int count = int.Parse(grdChecklistRulesInformation.DataKeys[row.RowIndex].Values["Count"].ToString()); DateTime? lastService = null; DateTime? nextDue = null; bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; bool done = ((CheckBox)row.FindControl("cbxDone")).Checked; string state = "Healthy"; 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, count, lastService, nextDue, state, done, selected); } model.Table.AcceptChanges(); unitsChecklistRulesTempForAdd = (UnitsAddTDS.UnitsChecklistRulesTempDataTable)model.Table; Session["unitsChecklistRulesTempForAdd"] = unitsChecklistRulesTempForAdd; } }
// //////////////////////////////////////////////////////////////////////// // STEP4 - CHECKLIST RULES INFORMATION - METHODS // private void StepChecklistRulesInformationIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Please review the checklist rules data that will be applied to the unit"; // Load UnitsAddTDS dataSet = new UnitsAddTDS(); dataSet.UnitsChecklistRulesTemp.Merge(unitsChecklistRulesTempForAdd, true); UnitsChecklistRulesTemp model = new UnitsChecklistRulesTemp(dataSet); int companyLevelIdSelected = 0; if (dataSet.UnitsChecklistRulesTemp.Rows.Count <= 0) { foreach (int companyLevelId in arrayCompanyLevelsSelected) { companyLevelIdSelected = companyLevelId; } model.Load(arrayCategoriesSelected, companyLevelIdSelected, int.Parse(hdfCompanyId.Value)); } else { if (Convert.ToBoolean(Session["arrayCategoriesSelectedChanged"]) || Convert.ToBoolean(Session["arrayCompanyLevelsSelectedChanged"])) { model.Data.Clear(); foreach (int companyLevelId in arrayCompanyLevelsSelected) { companyLevelIdSelected = companyLevelId; } model.Load(arrayCategoriesSelected, companyLevelIdSelected, int.Parse(hdfCompanyId.Value)); } } // Store tables unitsChecklistRulesTempForAdd = (UnitsAddTDS.UnitsChecklistRulesTempDataTable)model.Table; Session["unitsChecklistRulesTempForAdd"] = unitsChecklistRulesTempForAdd; grdChecklistRulesInformation.DataBind(); }
private void Save() { // Save to database DB.Open(); DB.BeginTransaction(); try { int companyId = Convert.ToInt32(Session["companyID"]); // Process view UnitsAddTDS dataset = new UnitsAddTDS(); dataset.UnitsAddNew.Merge(unitsAddNew, true); dataset.UnitsChecklistRulesTemp.Merge(unitsChecklistRulesTempForAdd, true); UnitsAddNew modelUnitsAddNew = new UnitsAddNew(dataset); modelUnitsAddNew.Save(arrayCategoriesSelected, companyId); DB.CommitTransaction(); // Store datasets unitsAddTDS.AcceptChanges(); Session["unitsAddTDS"] = unitsAddTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
// //////////////////////////////////////////////////////////////////////// // 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_ADD"]))) { 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) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_add.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfUpdate.Value = "no"; // ... Remove sessions Session.Remove("arrayCategoriesSelected"); Session.Remove("arrayCompanyLevelsSelected"); Session.Remove("unitsAddNew"); Session.Remove("unitsChecklistRulesTempForAdd"); Session.Remove("unitsChecklistRulesTempForAddDummy"); Session.Remove("arrayCategoriesSelectedChanged"); Session.Remove("arrayCompanyLevelsSelectedChanged"); // Initialize viewstate variables ViewState["StepFrom"] = "Out"; // ... Initialize tables unitsAddTDS = new UnitsAddTDS(); arrayCategoriesSelected = new ArrayList(); arrayCompanyLevelsSelected = new ArrayList(); unitsAddNew = new UnitsAddTDS.UnitsAddNewDataTable(); unitsChecklistRulesTempForAdd = new UnitsAddTDS.UnitsChecklistRulesTempDataTable(); // ... Store arrays Session["arrayCategoriesSelected"] = arrayCategoriesSelected; Session["arrayCompanyLevelsSelected"] = arrayCompanyLevelsSelected; Session["arrayCategoriesSelectedChanged"] = false; Session["arrayCompanyLevelsSelectedChanged"] = false; // ... Store tables Session["unitsAddTDS"] = unitsAddTDS; Session["unitsAddNew"] = unitsAddNew; Session["unitsChecklistRulesTempForAdd"] = unitsChecklistRulesTempForAdd; // ... For Categories categoriesTDS = new CategoriesTDS(); Session["categoriesTDSForUnitsAdd"] = categoriesTDS; // .. For Company Levels companyLevelsTDS = new CompanyLevelsTDS(); CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS); companyLevel.Load(int.Parse(hdfCompanyId.Value)); GetNodeForCompanyLevels(tvCompanyLevelsRoot.Nodes, 0); // StepTypeIn wzUnitAdd.ActiveStepIndex = 0; StepTypeIn(); } else { // Restore arrays arrayCategoriesSelected = (ArrayList)Session["arrayCategoriesSelected"]; arrayCompanyLevelsSelected = (ArrayList)Session["arrayCompanyLevelsSelected"]; // Restore tables categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnitsAdd"]; unitsAddTDS = (UnitsAddTDS)Session["unitsAddTDS"]; unitsAddNew = (UnitsAddTDS.UnitsAddNewDataTable)Session["unitsAddNew"]; unitsChecklistRulesTempForAdd = (UnitsAddTDS.UnitsChecklistRulesTempDataTable)Session["unitsChecklistRulesTempForAdd"]; } }