private void StepAssociationsProcessGrid() { string associationsList = ""; if (grdAssociations.Rows.Count > 0) { foreach (GridViewRow row in grdAssociations.Rows) { // Save associations int associationsId = Int32.Parse(grdAssociations.DataKeys[row.RowIndex].Values["AssociationsID"].ToString()); bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; bool byDefault = ((CheckBox)row.FindControl("cbxByDefault")).Checked; UnitsOfMeasurementAssociationsToolAssociatedUnits unitsOfMeasurementAssociationsToolAssociatedUnits = new UnitsOfMeasurementAssociationsToolAssociatedUnits(unitsOfMeasurementAssociationsToolTDS); unitsOfMeasurementAssociationsToolAssociatedUnits.Update(associationsId, byDefault, selected); // Get List of Associations if (selected) { associationsList = associationsList + " - " + ((Label)row.FindControl("lblDescription")).Text ; if (byDefault) { associationsList = associationsList + ", DEFAULT"; } associationsList = associationsList + "\n"; } } } hdfAssociationsList.Value = associationsList; Session["unitsOfMeasurementAssociationsToolTDS"] = unitsOfMeasurementAssociationsToolTDS; Session["associations"] = unitsOfMeasurementAssociationsToolTDS.AssociatedUnits; associations = unitsOfMeasurementAssociationsToolTDS.AssociatedUnits; }
private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { UnitsOfMeasurementAssociationsToolAssociatedUnits unitsOfMeasurementAssociationsToolAssociatedUnits = new UnitsOfMeasurementAssociationsToolAssociatedUnits(unitsOfMeasurementAssociationsToolTDS); unitsOfMeasurementAssociationsToolAssociatedUnits.Save(); DB.CommitTransaction(); // Store datasets Session["unitsOfMeasurementAssociationsToolTDS"] = unitsOfMeasurementAssociationsToolTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
// //////////////////////////////////////////////////////////////////////// // STEP2 - ASSOCIATIONS - METHODS // private void StepAssociationsIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Please select the Units you want to associate with the module " + hdfModule.Value + " and set one as default"; // Load Data if (hdfLoadDataFirstTime.Value == "True") { int companyId = Int32.Parse(hdfCompanyId.Value); UnitsOfMeasurementAssociationsToolAssociatedUnits unitsOfMeasurementAssociationsToolAssociatedUnits = new UnitsOfMeasurementAssociationsToolAssociatedUnits(unitsOfMeasurementAssociationsToolTDS); unitsOfMeasurementAssociationsToolAssociatedUnits.LoadAll(hdfModule.Value, companyId); hdfLoadDataFirstTime.Value = "False"; } // ... Store tables Session["unitsOfMeasurementAssociationsToolTDS"] = unitsOfMeasurementAssociationsToolTDS; Session["associations"] = unitsOfMeasurementAssociationsToolTDS.AssociatedUnits; associations = unitsOfMeasurementAssociationsToolTDS.AssociatedUnits; grdAssociations.DataBind(); }