private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { UnitsOfMeasurementNavigator unitsOfMeasurementNavigator = new UnitsOfMeasurementNavigator(unitsOfMeasurementNavigatorTDS); unitsOfMeasurementNavigator.Save(); DB.CommitTransaction(); // Store datasets unitsOfMeasurementNavigatorTDS.AcceptChanges(); Session["unitsOfMeasurementNavigatorTDS"] = unitsOfMeasurementNavigatorTDS; Session["unitsOfMeasurementNavigator"] = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
protected void grdUnitsOfMeasurement_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("dataEdit"); if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); int unitOfMeasurementId = (int)e.Keys["UnitOfMeasurementID"]; string description = ((TextBox)grdUnitsOfMeasurement.Rows[e.RowIndex].Cells[1].FindControl("tbxDescriptionEdit")).Text; string abbreviation = ((TextBox)grdUnitsOfMeasurement.Rows[e.RowIndex].Cells[1].FindControl("tbxAbbreviationEdit")).Text; UnitsOfMeasurementNavigator model = new UnitsOfMeasurementNavigator(unitsOfMeasurementNavigatorTDS); model.Update(unitOfMeasurementId, description, abbreviation, false, companyId); Session["unitsOfMeasurementNavigatorTDS"] = unitsOfMeasurementNavigatorTDS; Session["unitsOfMeasurementNavigator"] = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator; } else { e.Cancel = true; } }
private void GrdUnistOfMeasurementAdd() { ViewState["pageIndex"] = grdUnitsOfMeasurement.PageIndex; if (FooterValidate()) { int companyId = Int32.Parse(hdfCompanyId.Value); string description = ((TextBox)grdUnitsOfMeasurement.FooterRow.FindControl("tbxDescriptionNew")).Text.Trim(); string abbreviation = ((TextBox)grdUnitsOfMeasurement.FooterRow.FindControl("tbxAbbreviationNew")).Text.Trim(); UnitsOfMeasurementNavigator model = new UnitsOfMeasurementNavigator(unitsOfMeasurementNavigatorTDS); model.Insert(description, abbreviation, false, companyId, false); Session.Remove("unitOfMeasurementDummy"); Session["unitsOfMeasurementNavigatorTDS"] = unitsOfMeasurementNavigatorTDS; Session["unitsOfMeasurementNavigator"] = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator; grdUnitsOfMeasurement.DataBind(); grdUnitsOfMeasurement.PageIndex = grdUnitsOfMeasurement.PageCount - 1; } }
protected void grdUnitsOfMeasurement_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Units Of Measurement Gridview, if the gridview is edition mode if (grdUnitsOfMeasurement.EditIndex >= 0) { grdUnitsOfMeasurement.UpdateRow(grdUnitsOfMeasurement.EditIndex, true); } // Delete unit of Measurement int unitOfMeasurementId = (int)e.Keys["UnitOfMeasurementID"]; UnitsOfMeasurementNavigator model = new UnitsOfMeasurementNavigator(unitsOfMeasurementNavigatorTDS); model.Delete(unitOfMeasurementId); Session["unitsOfMeasurementNavigatorTDS"] = unitsOfMeasurementNavigatorTDS; Session["unitsOfMeasurementNavigator"] = unitsOfMeasurementNavigatorTDS.UnitsOfMeasurementNavigator; }