/// <summary> /// Save all PR to database (direct) /// </summary> /// <param name="companyId">companyId</param> /// <param name="newId">newId</param> public void Save(int companyId, Guid newId) { AddRecordTDS pointRepairsChanges = (AddRecordTDS)Data.GetChanges(); if (pointRepairsChanges != null) { if (pointRepairsChanges.PointRepairs.Rows.Count > 0) { AddRecordPointRepairsGateway addRecordPointRepairsGateway = new AddRecordPointRepairsGateway(pointRepairsChanges); foreach (AddRecordTDS.PointRepairsRow row in (AddRecordTDS.PointRepairsDataTable)pointRepairsChanges.PointRepairs) { // Insert new Notes if ((!row.Deleted) && (!row.InDatabase)) { string repairSize = ""; if (!row.IsRepairSizeNull()) repairSize = row.RepairSize; DateTime? installDate = null; if (!row.IsInstallDateNull()) installDate = row.InstallDate; string distance = ""; if (!row.IsDistanceNull()) distance = row.Distance; decimal? cost = null; if (!row.IsCostNull()) cost = row.Cost; int? reinstates = null; if (!row.IsReinstatesNull()) reinstates = row.Reinstates; string ltatMh = ""; if (!row.IsLTAtMHNull()) ltatMh = row.LTAtMH; string vtatMh = ""; if (!row.IsVTAtMHNull()) vtatMh = row.VTAtMH; string linerDistance = ""; if (!row.IsLinerDistanceNull()) linerDistance = row.LinerDistance; string direction = ""; if (!row.IsDirectionNull()) direction = row.Direction; string mhShot = ""; if (!row.IsMHShotNull()) mhShot = row.MHShot; string comments = ""; if (!row.IsCommentsNull()) comments = row.Comments; LFSRecordPointRepairs lfsRecordPointRepairs = new LFSRecordPointRepairs(null); lfsRecordPointRepairs.InsertDirect(newId, row.RefID, row.COMPANY_ID, row.DetailID, repairSize, installDate, distance, cost, reinstates, ltatMh, vtatMh, linerDistance, direction, mhShot, comments, row.Deleted, row.ExtraRepair, row.Cancelled, row.Approved, row.NotApproved, row.Archived); } // Update Notes if ((!row.Deleted) && (row.InDatabase)) { Guid id = row.ID; int refId = row.RefID; // original values string originalDetailId = addRecordPointRepairsGateway.GetDetailIDOriginal(id, refId, companyId); string originalRepairSize = addRecordPointRepairsGateway.GetRepairSizeOriginal(id, refId, companyId); DateTime? originalInstallDate = addRecordPointRepairsGateway.GetInstallDateOriginal(id, refId, companyId); string originalDistance = addRecordPointRepairsGateway.GetDistanceOriginal(id, refId, companyId); decimal? originalCost = addRecordPointRepairsGateway.GetCostOriginal(id, refId, companyId); int? originalReinstates = addRecordPointRepairsGateway.GetReinstatesOriginal(id, refId, companyId); string originalLTAtMH = addRecordPointRepairsGateway.GetLTAtMHOriginal(id, refId, companyId); string originalVTAtMH = addRecordPointRepairsGateway.GetVTAtMHOriginal(id, refId, companyId); string originalLinerDistance = addRecordPointRepairsGateway.GetLinerDistanceOriginal(id, refId, companyId); string originalDirection = addRecordPointRepairsGateway.GetDirectionOriginal(id, refId, companyId); string originalMhShot = addRecordPointRepairsGateway.GetMHShotOriginal(id, refId, companyId); string originalComments = addRecordPointRepairsGateway.GetCommentsOriginal(id, refId, companyId); bool originalDeleted = false; bool originalExtraRepair = addRecordPointRepairsGateway.GetExtraRepairOriginal(id, refId, companyId); bool originalCancelled = addRecordPointRepairsGateway.GetCancelledOriginal(id, refId, companyId); bool originalApproved = addRecordPointRepairsGateway.GetApprovedOriginal(id, refId, companyId); bool originalNotApproved = addRecordPointRepairsGateway.GetNotApprovedOriginal(id, refId, companyId); bool originalArchived = addRecordPointRepairsGateway.GetArchivedOriginal(id, refId, companyId); // new values string newDetailId = addRecordPointRepairsGateway.GetDetailID(id, refId, companyId); string newRepairSize = addRecordPointRepairsGateway.GetRepairSize(id, refId, companyId); DateTime? newInstallDate = addRecordPointRepairsGateway.GetInstallDate(id, refId, companyId); string newDistance = addRecordPointRepairsGateway.GetDistance(id, refId, companyId); decimal? newCost = addRecordPointRepairsGateway.GetCost(id, refId, companyId); int? newReinstates = addRecordPointRepairsGateway.GetReinstates(id, refId, companyId); string newLTAtMH = addRecordPointRepairsGateway.GetLTAtMH(id, refId, companyId); string newVTAtMH = addRecordPointRepairsGateway.GetVTAtMH(id, refId, companyId); string newLinerDistance = addRecordPointRepairsGateway.GetLinerDistance(id, refId, companyId); string newDirection = addRecordPointRepairsGateway.GetDirection(id, refId, companyId); string newMhShot = addRecordPointRepairsGateway.GetMHShot(id, refId, companyId); string newComments = addRecordPointRepairsGateway.GetComments(id, refId, companyId); bool newDeleted = false; bool newExtraRepair = addRecordPointRepairsGateway.GetExtraRepair(id, refId, companyId); bool newCancelled = addRecordPointRepairsGateway.GetCancelled(id, refId, companyId); bool newApproved = addRecordPointRepairsGateway.GetApproved(id, refId, companyId); bool newNotApproved = addRecordPointRepairsGateway.GetNotApproved(id, refId, companyId); bool newArchived = addRecordPointRepairsGateway.GetArchived(id, refId, companyId); LFSRecordPointRepairs lfsRecordPointRepairs = new LFSRecordPointRepairs(null); lfsRecordPointRepairs.UpdateDirect(id, refId, companyId, originalDetailId, originalRepairSize, originalInstallDate, originalDistance, originalCost, originalReinstates, originalLTAtMH, originalVTAtMH, originalLinerDistance, originalDirection, originalMhShot, originalComments, originalDeleted, originalExtraRepair, originalCancelled, originalApproved, originalNotApproved, originalArchived, id, refId, companyId, newDetailId, newRepairSize, newInstallDate, newDistance, newCost, newReinstates, newLTAtMH, newVTAtMH, newLinerDistance, newDirection, newMhShot, newComments, newDeleted, newExtraRepair, newCancelled, newApproved, newNotApproved, newArchived); } // Deleted notes if ((row.Deleted) && (row.InDatabase)) { LFSRecordPointRepairs lfsRecordPointRepairs = new LFSRecordPointRepairs(null); lfsRecordPointRepairs.DeleteDirect(row.ID, row.RefID, row.COMPANY_ID); } } } } }
protected void grdPointRepairs_RowDataBound(object sender, GridViewRowEventArgs e) { if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { // Initialize values Guid id = new Guid(((Label)e.Row.FindControl("lblId")).Text); int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefId")).Text); int companyId = Int32.Parse(((Label)e.Row.FindControl("lblCOMPANY_ID")).Text); AddRecordPointRepairsGateway addRecordPointRepairsGateway = new AddRecordPointRepairsGateway(addRecordTDS); // ... for direction if (addRecordPointRepairsGateway.GetDirection(id, refId, companyId) != "") { ((DropDownList)e.Row.FindControl("ddlDirectionEdit")).SelectedValue = addRecordPointRepairsGateway.GetDirection(id, refId, companyId); } else { ((DropDownList)e.Row.FindControl("ddlDirectionEdit")).SelectedIndex = 4; } // ... for MhShoot if (addRecordPointRepairsGateway.GetMHShot(id, refId, companyId) != "") { ((DropDownList)e.Row.FindControl("ddlMhShotEdit")).SelectedValue = addRecordPointRepairsGateway.GetMHShot(id, refId, companyId); } else { ((DropDownList)e.Row.FindControl("ddlMhShotEdit")).SelectedIndex = 2; } // ... For Install Date if (addRecordPointRepairsGateway.Table.Rows.Count > 0) { if (addRecordPointRepairsGateway.GetInstallDate(id, refId, companyId).HasValue) { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateEdit")).SelectedDate = (DateTime)addRecordPointRepairsGateway.GetInstallDate(id, refId, companyId); } } } if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { // Validation of permissions if (Convert.ToBoolean(Session["sgLFS_APP_EDIT"])) { // Button Validation e.Row.FindControl("ibtnEdit").Visible = true; e.Row.FindControl("ibtnDelete").Visible = true; } else { // Button validation e.Row.FindControl("ibtnEdit").Visible = false; e.Row.FindControl("ibtnDelete").Visible = false; } } if (e.Row.RowType == DataControlRowType.Footer) { if (Convert.ToBoolean(Session["sgLFS_APP_EDIT"])) { // Initialize variables ((DropDownList)e.Row.FindControl("ddlMhShotFooter")).SelectedIndex = 2; ((DropDownList)e.Row.FindControl("ddlDirectionFooter")).SelectedIndex = 4; // If the limit is reached AddRecordPointRepairs addRecordPointRepairs = new AddRecordPointRepairs(addRecordTDS); string newDetailId = addRecordPointRepairs.GetNewPointRepairsDetailId(addRecordTDS); if (newDetailId == "-1") { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxLinerDistanceFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ddlDirectionFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxLtMhFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxVtMhFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxDistanceFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxSizeFooter")).Visible = false; ((DropDownList)e.Row.FindControl("ddlMhShotFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxExptraRepairFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxCancelledFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxApprovedFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxNotApprovedFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxCommentFooter")).Visible = false; e.Row.FindControl("ibtnAdd").Visible = false; lblMaxNumber.Visible = true; } else { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxLinerDistanceFooter")).Visible = true; ((DropDownList)e.Row.FindControl("ddlDirectionFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxLtMhFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxVtMhFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxDistanceFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxSizeFooter")).Visible = true; ((DropDownList)e.Row.FindControl("ddlMhShotFooter")).Visible = true; ((CheckBox)e.Row.FindControl("ckbxExptraRepairFooter")).Visible = true; ((CheckBox)e.Row.FindControl("ckbxCancelledFooter")).Visible = true; ((CheckBox)e.Row.FindControl("ckbxApprovedFooter")).Visible = true; ((CheckBox)e.Row.FindControl("ckbxNotApprovedFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxCommentFooter")).Visible = true; e.Row.FindControl("ibtnAdd").Visible = true; lblMaxNumber.Visible = false; } } else { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxLinerDistanceFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxDirectionFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxLtMhFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxVtMhFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxDistanceFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxSizeFooter")).Visible = false; ((DropDownList)e.Row.FindControl("ddlMhShotFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxExptraRepairFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxCancelledFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxApprovedFooter")).Visible = false; ((CheckBox)e.Row.FindControl("ckbxNotApprovedFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxCommentFooter")).Visible = false; e.Row.FindControl("ibtnAdd").Visible = false; lblMaxNumber.Visible = false; } } }
protected void grdPointRepairs_RowDataBound(object sender, GridViewRowEventArgs e) { if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { // Initialize values Guid id = new Guid(((Label)e.Row.FindControl("lblId")).Text); int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefId")).Text); int companyId = Int32.Parse(((Label)e.Row.FindControl("lblCOMPANY_ID")).Text); AddRecordPointRepairsGateway addRecordPointRepairsGateway = new AddRecordPointRepairsGateway(addRecordTDS); if (addRecordPointRepairsGateway.Table.Rows.Count > 0) { if (addRecordPointRepairsGateway.GetInstallDate(id, refId, companyId).HasValue) { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateEdit")).SelectedDate = (DateTime)addRecordPointRepairsGateway.GetInstallDate(id, refId, companyId); } } } if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { if (Convert.ToBoolean(Session["sgLFS_APP_EDIT"])) { // Button Validation e.Row.FindControl("ibtnEdit").Visible = true; e.Row.FindControl("ibtnDelete").Visible = true; } else { // Button validation e.Row.FindControl("ibtnEdit").Visible = false; e.Row.FindControl("ibtnDelete").Visible = false; } } if (e.Row.RowType == DataControlRowType.Footer) { if (Convert.ToBoolean(Session["sgLFS_APP_EDIT"])) { // If the limit is reached AddRecordPointRepairs addRecordPointRepairs = new AddRecordPointRepairs(addRecordTDS); string newDetailId = addRecordPointRepairs.GetNewPointRepairsDetailId(addRecordTDS); if (newDetailId == "-1") { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxRepairSizeFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxDistanceFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxCostFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxReinstatesFooter")).Visible = false; e.Row.FindControl("ibtnAdd").Visible = false; lblMaxNumber.Visible = true; } else { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxRepairSizeFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxDistanceFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxCostFooter")).Visible = true; ((TextBox)e.Row.FindControl("tbxReinstatesFooter")).Visible = true; e.Row.FindControl("ibtnAdd").Visible = true; lblMaxNumber.Visible = false; } } else { ((RadDatePicker)e.Row.FindControl("tkrdpInstallDateFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxRepairSizeFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxDistanceFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxCostFooter")).Visible = false; ((TextBox)e.Row.FindControl("tbxReinstatesFooter")).Visible = false; e.Row.FindControl("ibtnAdd").Visible = false; lblMaxNumber.Visible = false; } } }