protected void grdResins_RowDataBound(object sender, GridViewRowEventArgs e) { // Normal controls if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { int resinId = Int32.Parse(((Label)e.Row.FindControl("lblResinId")).Text); // Validate buttons if ((resinId == 1) || (resinId == 2) || (resinId == 3)) { ((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = false; ((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = false; } } // Edit controls if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { int companyId = Int32.Parse(hdfCompanyId.Value); int resinId = Int32.Parse(((Label)e.Row.FindControl("lblResinIdEdit")).Text); FlResinsAddGateway flResinsAddGatewayForGrid = new FlResinsAddGateway(flResinsAddTDS); if (flResinsAddGatewayForGrid.Table.Rows.Count > 0) { string applyCatalyst = flResinsAddGatewayForGrid.GetApplyCatalystTo(resinId); ((DropDownList)e.Row.FindControl("ddlApplyCatalystToEdit")).SelectedValue = applyCatalyst; } } }
/// <summary> /// Save all resins to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { FlResinsAddTDS flResinsAddChanges = (FlResinsAddTDS)Data.GetChanges(); if (flResinsAddChanges.FlResinsAdd.Rows.Count > 0) { FlResinsAddGateway flResinsAddGateway = new FlResinsAddGateway(flResinsAddChanges); foreach (FlResinsAddTDS.FlResinsAddRow row in (FlResinsAddTDS.FlResinsAddDataTable)flResinsAddChanges.FlResinsAdd) { // Insert new resins if ((!row.Deleted) && (!row.InDatabase)) { WorkFullLengthLiningResins workFullLengthLiningResins = new WorkFullLengthLiningResins(null); workFullLengthLiningResins.InsertDirect(row.ResinID, row.ResinMake, row.ResinType, row.ResinNumber, row.LbUsg, row.LbDrums, row.ActiveResin, row.ApplyCatalystTo, row.Filter, row.Deleted, row.COMPANY_ID); } //Update resins if ((!row.Deleted) && (row.InDatabase)) { int resinId = row.ResinID; bool originalDeleted = false; int originalCompanyId = companyId; // original values string originalResinMake = flResinsAddGateway.GetResinMakeOriginal(resinId); string originalResinType = flResinsAddGateway.GetResinTypeOriginal(resinId); string originalResinNumber = flResinsAddGateway.GetResinNumberOriginal(resinId); decimal originalLbUsg = flResinsAddGateway.GetLbUsgOriginal(resinId); int originalLbDrum = flResinsAddGateway.GetLbDrumsOriginal(resinId); decimal originalActiveResin = flResinsAddGateway.GetActiveResinOriginal(resinId); string originalApplyCatalystToNumber = flResinsAddGateway.GetApplyCatalystToOriginal(resinId); decimal originalFilter = flResinsAddGateway.GetFilterOriginal(resinId); // new values string newResinMake = flResinsAddGateway.GetResinMake(resinId); string newResinType = flResinsAddGateway.GetResinType(resinId); string newResinNumber = flResinsAddGateway.GetResinNumber(resinId); decimal newLbUsg = flResinsAddGateway.GetLbUsg(resinId); int newLbDrum = flResinsAddGateway.GetLbDrums(resinId); decimal newActiveResin = flResinsAddGateway.GetActiveResin(resinId); string newApplyCatalystToNumber = flResinsAddGateway.GetApplyCatalystTo(resinId); decimal newFilter = flResinsAddGateway.GetFilter(resinId); WorkFullLengthLiningResins workFullLengthLiningResins = new WorkFullLengthLiningResins(null); workFullLengthLiningResins.UpdateDirect(resinId, originalResinMake, originalResinType, originalResinNumber, originalLbUsg, originalLbDrum, originalActiveResin, originalApplyCatalystToNumber, originalFilter, originalDeleted, originalCompanyId, resinId, newResinMake, newResinType, newResinNumber, newLbUsg, newLbDrum, newActiveResin, newApplyCatalystToNumber, newFilter, originalDeleted, originalCompanyId); } // Deleted resins if ((row.Deleted) && (row.InDatabase)) { WorkFullLengthLiningResins workFullLengthLiningResins = new WorkFullLengthLiningResins(null); workFullLengthLiningResins.DeleteDirect(row.ResinID, row.COMPANY_ID); } } } }