protected void btnDelete_Click(object sender, EventArgs e) { int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string workType = hdfWorkType.Value.Trim(); PostPageChanges(); ArrayList assetIdArrayList = GetAssetIdArrayList(); if (assetIdArrayList.Count > 0) { FlatSectionJl flatSectionJl = new FlatSectionJl(); flatSectionJl.LoadByAssetIdArrayList(assetIdArrayList, 1, currentProjectId, workType, companyId); if (flatSectionJl.Table.Rows.Count > 0) { // Delete store dataset Session.Remove("flatSectionJlTDS"); // Store datasets Session["jlNavigatorTDS"] = jlNavigatorTDS; Session["flatSectionJlTDS"] = flatSectionJl.Data; // Redirect string url = "./jl_delete.aspx?source_page=jl_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState(); Response.Redirect(url); } } else { RestoreNavigatorState(); cvSelection.IsValid = false; } }
private void FLLateralsSave(string lateralId, bool requiresRoboticPrep, DateTime? equiresRoboticPrepIssueCompleted, bool holdClientIssue, bool holdLFSIssue, bool dyeTestReq, DateTime? dyeTestComplete) { int workIdJl = Int32.Parse(hdfWorkIdJl.Value); int companyId = Int32.Parse(hdfCompanyId.Value); flatSectionJlTDSForFLL = new FlatSectionJlTDS(); FlatSectionJlGateway flatSectionJlGateway = new FlatSectionJlGateway(flatSectionJlTDSForFLL); flatSectionJlGateway.LoadAllByWorkId(workIdJl, companyId); string latId = lateralId.Substring(3, lateralId.Length - 3); if (flatSectionJlGateway.Table.Rows.Count > 0) { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDSForFLL); flatSectionJl.UpdateAllLateralsFromFLL(latId, requiresRoboticPrep, equiresRoboticPrepIssueCompleted, holdClientIssue, holdLFSIssue, dyeTestReq, dyeTestComplete); } Session["flatSectionJlTDSForFLL"] = flatSectionJlTDSForFLL; flatSectionJlTDSForFLL.AcceptChanges(); }
private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); // Update Comments and History FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS); flatSectionJlCommentDetails.Save(companyId); FlatSectionJlHistoryDetails flatSectionJlHistoryDetails = new FlatSectionJlHistoryDetails(flatSectionJlTDS); flatSectionJlHistoryDetails.Save(companyId); // Update FlatSectionJl for new Comments int workId = Int32.Parse(hdfWorkId.Value.Trim()); string workType = "Junction Lining Lateral"; FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId); JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS); jlNavigator.UpdateComments(workId, workType, companyId); Session["flatSectionJlTDS"] = flatSectionJlTDS; Session["jlNavigatorTDS"] = jlNavigatorTDS; DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void WorkUpdate() { // Get general variables int projectId = Int32.Parse(hdfCurrentProject.Value.Trim()); int companyId = Convert.ToInt32(Session["companyID"]); FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl); dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)"; foreach (DataRowView row in dataViewFlatSectionJl) { int workId = Int32.Parse(row["WorkID"].ToString()); int assetId = Int32.Parse(row["AssetID"].ToString()); string workType = "Junction Lining Lateral"; // Get original variables WorkGateway workGateway = new WorkGateway(); workGateway.LoadByWorkId(workId, companyId); string originalWorkType = workGateway.GetWorkTypeOriginal(workId); int? originalLibraryCategoriesId = workGateway.GetLibraryCategoriesIdOriginal(workId); string originalComment = workGateway.GetCommentsOriginal(workId); string originalHistory = workGateway.GetHistoryOriginal(workId); // Get new comment WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway(); workCommentsGateway.LoadByWorkIdWorkType(workId, companyId, "Junction Lining Lateral"); WorkComments workComments = new WorkComments(workCommentsGateway.Data); string newComments = workComments.GetAllComments(workId, companyId, workCommentsGateway.Table.Rows.Count, "\n"); // Get new history WorkHistoryGateway workHistoryGateway = new WorkHistoryGateway(); workHistoryGateway.LoadByWorkIdWorkType(workId, companyId, "Junction Lining Lateral"); WorkHistory workHistory = new WorkHistory(workHistoryGateway.Data); string newHistory = workHistory.GetAllHistory(workId, companyId, workHistoryGateway.Table.Rows.Count, "\n"); Work work = new Work(null); work.UpdateDirect(workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, originalComment, originalHistory, workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, newComments, newHistory); flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId); } }
private void Save() { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl); dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)"; string summary = ""; bool existsDataModificated = false; string fieldToUpdate = ddlFieldToUpdate.SelectedValue; foreach (DataRowView row in dataViewFlatSectionJl) { if (IsValidLateralToUpdate(fieldToUpdate, row)) { int workId = Int32.Parse(row["WorkID"].ToString()); // Date fields if ((fieldToUpdate == "VideoInspection") || (fieldToUpdate == "PipeLocated") || (fieldToUpdate == "ServicesLocated") || (fieldToUpdate == "CoInstalled") || (fieldToUpdate == "BackfilledConcrete") || (fieldToUpdate == "BackfilledSoil") || (fieldToUpdate == "Grouted") || (fieldToUpdate == "Cored") || (fieldToUpdate == "Prepped") || (fieldToUpdate == "PreVideo") || (fieldToUpdate == "Measured") || (fieldToUpdate == "NoticeDelivered") || (fieldToUpdate == "InProcess") || (fieldToUpdate == "InStock") || (fieldToUpdate == "Delivered") || (fieldToUpdate == "LinerInstalled") || (fieldToUpdate == "FinalVideo") || (fieldToUpdate == "CoCutDown") || (fieldToUpdate == "FinalRestoration") || (fieldToUpdate == "DigRequiredPriorToLiningCompleted") || (fieldToUpdate == "DigRequiredAfterLiningCompleted") || (fieldToUpdate == "HoldClientIssueResolved") || (fieldToUpdate == "HoldLFSIssueResolved") || (fieldToUpdate == "LateralRequiresRoboticPrepCompleted") ) { // ... Update row flatSectionJl.UpdateDateField(workId, fieldToUpdate, tkrdpValue.SelectedDate); existsDataModificated = true; } else { // String fields if (fieldToUpdate == "CoPitLocation") { // ... Update row flatSectionJl.UpdateStringField(workId, fieldToUpdate, ddlCoPitLocationValue.SelectedValue); existsDataModificated = true; } // String fields if (fieldToUpdate == "PrepType") { // ... Update row flatSectionJl.UpdateStringField(workId, fieldToUpdate, ddlPrepType.SelectedValue); existsDataModificated = true; } // String fields if (fieldToUpdate == "LinerType") { // ... Update row flatSectionJl.UpdateStringField(workId, fieldToUpdate, ddlLinerType.SelectedValue); existsDataModificated = true; } // String fields if (fieldToUpdate == "ContractYear") { // ... Update row flatSectionJl.UpdateStringField(workId, fieldToUpdate, tbxValue.Text); existsDataModificated = true; } // Boolean fields if ((fieldToUpdate == "CoRequired") || (fieldToUpdate == "OutOfScope") || (fieldToUpdate == "DigRequiredPriorToLining") || (fieldToUpdate == "DigRequiredAfterLining") || (fieldToUpdate == "HoldClientIssue") || (fieldToUpdate == "HoldLFSIssue") || (fieldToUpdate == "LateralRequiresRoboticPrep")) { // ... Update row flatSectionJl.UpdateBooleanField(workId, fieldToUpdate, cbxValue.Checked); existsDataModificated = true; } // Special field - Comment if (fieldToUpdate == "Comment") { // ... Update row AddComments(workId, tbxComments.Text); ViewState["UpdateComments"] = true; existsDataModificated = true; } } } else { string[] flowOderId = row["LateralDescription"].ToString().Split('-'); if (summary.Trim().Length == 0) { string reason = ""; switch (fieldToUpdate) { case "DigRequiredPriorToLining": reason = "Dig Required Prior To Lining Completed has value."; break; case "DigRequiredPriorToLiningCompleted": reason = "Dig Required Prior To Lining is not checked."; break; case "DigRequiredAfterLining": reason = "Dig Required After Lining Completed has value."; break; case "DigRequiredAfterLiningCompleted": reason = "Dig Required After Lining is not checked."; break; case "HoldClientIssue": reason = "Hold - Client Issue Resolved has value."; break; case "HoldClientIssueResolved": reason = "Hold - Client Issue is not checked."; break; case "HoldLFSIssue": reason = "Hold - LFS Issue Resolved has value."; break; case "HoldLFSIssueResolved": reason = "Hold - LFS Issue is not checked."; break; case "LateralRequiresRoboticPrep": reason = "Requires Robotic Prep Completed has value."; break; case "LateralRequiresRoboticPrepCompleted": reason = "Requires Robotic Prep is not checked."; break; } summary = "The following laterals were not updated because " + reason + "\n\n"; summary = summary + "\t - " + flowOderId[1] + "-JL-" + flowOderId[2] + "\n"; } else { summary = summary + "\t - " + flowOderId[1] + "-JL-" + flowOderId[2] + "\n"; } } } if (summary.Trim().Length == 0) { summary = "All the laterals were updated\n\n"; } tbxSummary.Text = summary; // Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; if (existsDataModificated) { // Update database UpdateDatabase(); } }
private void UpdateDatabase() { // Get ids & location int projectId = Int32.Parse(hdfCurrentProject.Value.Trim()); int companyId = Int32.Parse(Session["companyID"].ToString()); // Load project ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); // Get location Int64 countryId = projectGateway.GetCountryID(projectId); Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = (Int64)projectGateway.GetProvinceID(projectId); Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = (Int64)projectGateway.GetCountyID(projectId); Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = (Int64)projectGateway.GetCityID(projectId); // Save DB.Open(); DB.BeginTransaction(); try { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); if (Convert.ToBoolean(ViewState["UpdateComments"])) { // Update Comments FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS); flatSectionJlCommentDetails.Save(companyId); // Update works WorkUpdate(); } else { flatSectionJl.UpdateDirect(countryId, provinceId, countyId, cityId, projectId, companyId); } DB.CommitTransaction(); flatSectionJlTDS.AcceptChanges(); // Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // STEP1 - BEGIN // // //////////////////////////////////////////////////////////////////////// // STEP1 - BEGIN - AUXILIAR EVENTS // protected void ddlFieldToUpdate_SelectedIndexChanged(object sender, EventArgs e) { // Date fields if ((ddlFieldToUpdate.SelectedValue == "VideoInspection") || (ddlFieldToUpdate.SelectedValue == "PipeLocated") || (ddlFieldToUpdate.SelectedValue == "ServicesLocated") || (ddlFieldToUpdate.SelectedValue == "CoInstalled") || (ddlFieldToUpdate.SelectedValue == "BackfilledConcrete") || (ddlFieldToUpdate.SelectedValue == "BackfilledSoil") || (ddlFieldToUpdate.SelectedValue == "Grouted") || (ddlFieldToUpdate.SelectedValue == "Cored") || (ddlFieldToUpdate.SelectedValue == "Prepped") || (ddlFieldToUpdate.SelectedValue == "PreVideo") || (ddlFieldToUpdate.SelectedValue == "Measured") || (ddlFieldToUpdate.SelectedValue == "NoticeDelivered") || (ddlFieldToUpdate.SelectedValue == "InProcess") || (ddlFieldToUpdate.SelectedValue == "InStock") || (ddlFieldToUpdate.SelectedValue == "Delivered") || (ddlFieldToUpdate.SelectedValue == "LinerInstalled") || (ddlFieldToUpdate.SelectedValue == "FinalVideo") || (ddlFieldToUpdate.SelectedValue == "CoCutDown") || (ddlFieldToUpdate.SelectedValue == "FinalRestoration") || (ddlFieldToUpdate.SelectedValue == "DigRequiredPriorToLiningCompleted") || (ddlFieldToUpdate.SelectedValue == "DigRequiredAfterLiningCompleted") || (ddlFieldToUpdate.SelectedValue == "HoldClientIssueResolved") || (ddlFieldToUpdate.SelectedValue == "HoldLFSIssueResolved") || (ddlFieldToUpdate.SelectedValue == "LateralRequiresRoboticPrepCompleted") ) { tkrdpValue.Visible = true; cbxValue.Visible = false; ddlCoPitLocationValue.Visible = false; tbxComments.Visible = false; ddlPrepType.Visible = false; ddlLinerType.Visible = false; tbxValue.Visible = false; } else { tbxValue.Visible = false; // String fields if (ddlFieldToUpdate.SelectedValue == "CoPitLocation") { tkrdpValue.Visible = false; cbxValue.Visible = false; ddlCoPitLocationValue.Visible = true; ddlPrepType.Visible = false; ddlLinerType.Visible = false; tbxComments.Visible = false; } // String fields if (ddlFieldToUpdate.SelectedValue == "PrepType") { tkrdpValue.Visible = false; cbxValue.Visible = false; ddlCoPitLocationValue.Visible = false; ddlPrepType.Visible = true; ddlLinerType.Visible = false; tbxComments.Visible = false; } // String fields if (ddlFieldToUpdate.SelectedValue == "LinerType") { tkrdpValue.Visible = false; cbxValue.Visible = false; ddlCoPitLocationValue.Visible = false; ddlPrepType.Visible = false; ddlLinerType.Visible = true; tbxComments.Visible = false; } // String fields if (ddlFieldToUpdate.SelectedValue == "ContractYear") { tkrdpValue.Visible = false; cbxValue.Visible = false; ddlCoPitLocationValue.Visible = false; ddlPrepType.Visible = false; ddlLinerType.Visible = false; tbxComments.Visible = false; tbxValue.Visible = true; } // Boolean fields if ((ddlFieldToUpdate.SelectedValue == "CoRequired") || (ddlFieldToUpdate.SelectedValue == "OutOfScope") || (ddlFieldToUpdate.SelectedValue == "DigRequiredPriorToLining") || (ddlFieldToUpdate.SelectedValue == "DigRequiredAfterLining") || (ddlFieldToUpdate.SelectedValue == "HoldClientIssue") || (ddlFieldToUpdate.SelectedValue == "HoldLFSIssue") || (ddlFieldToUpdate.SelectedValue == "LateralRequiresRoboticPrep")) { tkrdpValue.Visible = false; cbxValue.Visible = true; ddlCoPitLocationValue.Visible = false; ddlPrepType.Visible = false; ddlLinerType.Visible = false; tbxComments.Visible = false; } // Special fields - Comment if (ddlFieldToUpdate.SelectedValue == "Comment") { tkrdpValue.Visible = false; cbxValue.Visible = false; ddlCoPitLocationValue.Visible = false; ddlPrepType.Visible = false; ddlLinerType.Visible = false; tbxComments.Visible = true; FlatSectionJlCommentDetailsGateway flatSectionJlCommentDetailsGateway = new FlatSectionJlCommentDetailsGateway(flatSectionJlTDS); flatSectionJlCommentDetailsGateway.ClearBeforeFill = false; FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl); dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)"; foreach (DataRowView row in dataViewFlatSectionJl) { int workId = Int32.Parse(row["WorkID"].ToString()); int companyId = Int32.Parse(Session["companyID"].ToString()); // Get comments flatSectionJlCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, "Junction Lining Lateral"); } } } }
private void Save2() { Page.Validate(); if (Page.IsValid) { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); // Update flatSectionJlTDS foreach (GridViewRow row in grdvJl.Rows) { // ... Get standard fields int workId = int.Parse(((HiddenField)row.FindControl("hdfWorkID")).Value); int assetId = int.Parse(((HiddenField)row.FindControl("hdfAssetID")).Value); int section_ = int.Parse(((HiddenField)row.FindControl("hdfSection_")).Value); int companyId = int.Parse(hdfCompanyId.Value); string address = ((TextBox)row.FindControl("tbxAddress")).Text.Trim(); DateTime? pipeLocated = null; if (((RadDatePicker)row.FindControl("tkrdpPipeLocated")).SelectedDate.HasValue) pipeLocated = ((RadDatePicker)row.FindControl("tkrdpPipeLocated")).SelectedDate.Value; DateTime? servicesLocated = null; if (((RadDatePicker)row.FindControl("tkrdpServicesLocated")).SelectedDate.HasValue) servicesLocated = ((RadDatePicker)row.FindControl("tkrdpServicesLocated")).SelectedDate.Value; DateTime? coInstalled = null; if (((RadDatePicker)row.FindControl("tkrdpCoInstalled")).SelectedDate.HasValue) coInstalled = ((RadDatePicker)row.FindControl("tkrdpCoInstalled")).SelectedDate; DateTime? backfilledConcrete = null; if (((RadDatePicker)row.FindControl("tkrdpBackfilledConcrete")).SelectedDate.HasValue) backfilledConcrete = ((RadDatePicker)row.FindControl("tkrdpBackfilledConcrete")).SelectedDate.Value; DateTime? backfilledSoil = null; if (((RadDatePicker)row.FindControl("tkrdpBackfilledSoil")).SelectedDate.HasValue) backfilledSoil = ((RadDatePicker)row.FindControl("tkrdpBackfilledSoil")).SelectedDate.Value; DateTime? grouted = null; if (((RadDatePicker)row.FindControl("tkrdpGrouted")).SelectedDate.HasValue) grouted = ((RadDatePicker)row.FindControl("tkrdpGrouted")).SelectedDate.Value; DateTime? cored = null; if (((RadDatePicker)row.FindControl("tkrdpCored")).SelectedDate.HasValue) cored = ((RadDatePicker)row.FindControl("tkrdpCored")).SelectedDate.Value; DateTime? prepped = null; if (((RadDatePicker)row.FindControl("tkrdpPrepped")).SelectedDate.HasValue) prepped = ((RadDatePicker)row.FindControl("tkrdpPrepped")).SelectedDate; DateTime? measured = null; if (((RadDatePicker)row.FindControl("tkrdpMeasured")).SelectedDate.HasValue) measured = ((RadDatePicker)row.FindControl("tkrdpMeasured")).SelectedDate; string linerSize = ""; if (((TextBox)row.FindControl("tbxLinerSize")).Text.Trim() != "") linerSize = ((TextBox)row.FindControl("tbxLinerSize")).Text.Trim(); DateTime? inProcess = null; if (((RadDatePicker)row.FindControl("tkrdpInProcess")).SelectedDate.HasValue) inProcess = ((RadDatePicker)row.FindControl("tkrdpInProcess")).SelectedDate.Value; DateTime? inStock = null; if (((RadDatePicker)row.FindControl("tkrdpInStock")).SelectedDate.HasValue) inStock = ((RadDatePicker)row.FindControl("tkrdpInStock")).SelectedDate.Value; DateTime? tkrdplivered = null; if (((RadDatePicker)row.FindControl("tkrdpDelivered")).SelectedDate.HasValue) tkrdplivered = ((RadDatePicker)row.FindControl("tkrdpDelivered")).SelectedDate.Value; DateTime? preVideo = null; if (((RadDatePicker)row.FindControl("tkrdpPreVideo")).SelectedDate.HasValue) preVideo = ((RadDatePicker)row.FindControl("tkrdpPreVideo")).SelectedDate; DateTime? linerInstalled = null; if (((RadDatePicker)row.FindControl("tkrdpLinerInstalled")).SelectedDate.HasValue) linerInstalled = ((RadDatePicker)row.FindControl("tkrdpLinerInstalled")).SelectedDate.Value; DateTime? finalVideo = null; if (((RadDatePicker)row.FindControl("tkrdpFinalVideo")).SelectedDate.HasValue) finalVideo = ((RadDatePicker)row.FindControl("tkrdpFinalVideo")).SelectedDate.Value; string distanceFromUSMH = ""; if (((TextBox)row.FindControl("tbxDistanceFromUSMH")).Text.Trim() != "") distanceFromUSMH = ((TextBox)row.FindControl("tbxDistanceFromUSMH")).Text.Trim(); string comments = ""; if (((TextBox)row.FindControl("tbxComments")).Text.Trim() != "") comments = ((TextBox)row.FindControl("tbxComments")).Text.Trim(); string history = ""; if (((TextBox)row.FindControl("tbxHistory")).Text.Trim() != "") history = ((TextBox)row.FindControl("tbxHistory")).Text.Trim(); decimal? cost = null; if (((TextBox)row.FindControl("tbxCost")).Text.Trim() != "") cost = decimal.Parse(((TextBox)row.FindControl("tbxCost")).Text.Trim()); bool deleted = false; bool selected = true; DateTime? videoInspection = null; if (((RadDatePicker)row.FindControl("tkrdpVideoInspection")).SelectedDate.HasValue) videoInspection = ((RadDatePicker)row.FindControl("tkrdpVideoInspection")).SelectedDate.Value; string coPitLocation = ""; coPitLocation = ((DropDownList)row.FindControl("ddlCoPitLocation")).SelectedValue; DateTime? coCutDown = null; if (((RadDatePicker)row.FindControl("tkrdpCoCutDown")).SelectedDate.HasValue) coCutDown = ((RadDatePicker)row.FindControl("tkrdpCoCutDown")).SelectedDate.Value; DateTime? finalRestoration = null; if (((RadDatePicker)row.FindControl("tkrdpFinalRestoration")).SelectedDate.HasValue) finalRestoration = ((RadDatePicker)row.FindControl("tkrdpFinalRestoration")).SelectedDate.Value; string clientLateralId = ""; if (((TextBox)row.FindControl("tbxClientLateralId")).Text.Trim() != "") clientLateralId = ((TextBox)row.FindControl("tbxClientLateralId")).Text.Trim(); string videoLengthToPropertyLine = ""; if (((TextBox)row.FindControl("tbxVideoLengthToPropertyLine")).Text.Trim() != "") videoLengthToPropertyLine = ((TextBox)row.FindControl("tbxVideoLengthToPropertyLine")).Text.Trim(); DateTime? noticeDelivered = null; if (((RadDatePicker)row.FindControl("tkrdpNoticeDelivered")).SelectedDate.HasValue) noticeDelivered = ((RadDatePicker)row.FindControl("tkrdpNoticeDelivered")).SelectedDate.Value; string hamiltonInspectionNumber = ""; if (((TextBox)row.FindControl("tbxHamiltonInspectionNumber")).Text.Trim() != "") hamiltonInspectionNumber = ((TextBox)row.FindControl("tbxHamiltonInspectionNumber")).Text.Trim(); string flange = ""; flange = ((DropDownList)row.FindControl("ddlFlange")).SelectedValue; string gasket = ""; gasket = ((DropDownList)row.FindControl("ddlGasket")).SelectedValue; string connectionType = ""; connectionType = ((DropDownList)row.FindControl("ddlConnectionType")).SelectedValue; string distanceFromDSMH = ""; if (((TextBox)row.FindControl("tbxDistanceFromDSMH")).Text.Trim() != "") distanceFromDSMH = ((TextBox)row.FindControl("tbxDistanceFromDSMH")).Text.Trim(); string depthOfLocated = ""; if (((TextBox)row.FindControl("tbxDepthOfLocated")).Text.Trim() != "") depthOfLocated = ((TextBox)row.FindControl("tbxDepthOfLocated")).Text.Trim(); bool digRequiredPriorToLining = ((CheckBox)row.FindControl("cbxDigRequiredPriorToLining")).Checked; DateTime? digRequiredPriorToLiningCompleted = null; if (((RadDatePicker)row.FindControl("tkrdpDigRequiredPriorToLiningCompleted")).SelectedDate.HasValue) digRequiredPriorToLiningCompleted = ((RadDatePicker)row.FindControl("tkrdpDigRequiredPriorToLiningCompleted")).SelectedDate.Value; bool digRequiredAfterLining = ((CheckBox)row.FindControl("cbxDigRequiredAfterLining")).Checked; DateTime? digRequiredAfterLiningCompleted = null; if (((RadDatePicker)row.FindControl("tkrdpDigRequiredAfterLiningCompleted")).SelectedDate.HasValue) digRequiredAfterLiningCompleted = ((RadDatePicker)row.FindControl("tkrdpDigRequiredAfterLiningCompleted")).SelectedDate.Value; bool outOfScope = ((CheckBox)row.FindControl("cbxOutOfScope")).Checked; bool holdClientIssue = ((CheckBox)row.FindControl("cbxHoldClientIssue")).Checked; DateTime? holdClientIssueResolved = null; if (((RadDatePicker)row.FindControl("tkrdpHoldClientIssueResolved")).SelectedDate.HasValue) holdClientIssueResolved = ((RadDatePicker)row.FindControl("tkrdpHoldClientIssueResolved")).SelectedDate.Value; bool holdLFSIssue = ((CheckBox)row.FindControl("cbxHoldLFSIssue")).Checked; DateTime? holdLFSIssueResolved = null; if (((RadDatePicker)row.FindControl("tkrdpHoldLFSIssueResolved")).SelectedDate.HasValue) holdLFSIssueResolved = ((RadDatePicker)row.FindControl("tkrdpHoldLFSIssueResolved")).SelectedDate.Value; bool requiresRoboticPrep = ((CheckBox)row.FindControl("cbxRequiresRoboticPrep")).Checked; DateTime? requiresRoboticPrepCompleted = null; if (((RadDatePicker)row.FindControl("tkrdpRequiresRoboticPrepCompleted")).SelectedDate.HasValue) requiresRoboticPrepCompleted = ((RadDatePicker)row.FindControl("tkrdpRequiresRoboticPrepCompleted")).SelectedDate.Value; string linerType = ""; linerType = ((DropDownList)row.FindControl("ddlLinerType")).SelectedValue; string prepType = ""; prepType = ((DropDownList)row.FindControl("ddlPrepType")).SelectedValue; bool dyeTestReq = ((CheckBox)row.FindControl("ckbxDyeTestReq")).Checked; DateTime? DyeTestComplete = null; if (((RadDatePicker)row.FindControl("tkrdpDyeTestComplete")).SelectedDate.HasValue) DyeTestComplete = ((RadDatePicker)row.FindControl("tkrdpDyeTestComplete")).SelectedDate.Value; bool coRequired = false; if (prepType == "CO Req") coRequired = true; bool pitRequired = false; if (prepType == "Pit Req") pitRequired = true; bool liningThruCo = true; bool postContractDigRequired = true; string contractYear = ""; if (((TextBox)row.FindControl("tbxContractYear")).Text.Trim() != "") contractYear = ((TextBox)row.FindControl("tbxContractYear")).Text.Trim(); // ... Update row flatSectionJl.Update(workId, assetId, section_, companyId, address, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, tkrdplivered, preVideo, linerInstalled, finalVideo, distanceFromUSMH, distanceFromDSMH, cost, deleted, selected, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, coCutDown, finalRestoration, clientLateralId, videoLengthToPropertyLine, liningThruCo, noticeDelivered, hamiltonInspectionNumber, flange, gasket, connectionType, depthOfLocated, digRequiredPriorToLining, digRequiredPriorToLiningCompleted, digRequiredAfterLining, digRequiredAfterLiningCompleted, outOfScope, holdClientIssue, holdClientIssueResolved, holdLFSIssue, holdLFSIssueResolved, requiresRoboticPrep, requiresRoboticPrepCompleted, linerType, prepType, dyeTestReq, DyeTestComplete, contractYear); } // Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; } }
private void UpdateDatabase() { // Get ids string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value); // Delete DB.Open(); DB.BeginTransaction(); try { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); flatSectionJl.DeleteDirect(companyId); DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void Delete() { Page.Validate(); if (Page.IsValid) { // Delete jliners FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); // ... Delete in flatSectionJlinerTDS foreach (FlatSectionJlTDS.FlatSectionJlRow flatSectionJlRow in (FlatSectionJlTDS.FlatSectionJlDataTable)flatSectionJl.Table) { if ((flatSectionJlRow.Selected) && (!flatSectionJlRow.Deleted)) { flatSectionJl.Delete(flatSectionJlRow.WorkID); } } // ... Update assets string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); // Update databse UpdateDatabase(); // Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; // Redirect string url = ""; if (Request.QueryString["source_page"] == "jl_navigator2.aspx") { url = "./jl_navigator2.aspx?source_page=jl_delete.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState() + "&update=yes"; } if (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") { url = "./flat_section_jl_summary.aspx?source_page=jl_delete.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState() + "&update=yes"; } Response.Redirect(url); } }
private int Update() { FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS); int jlSelected = 0; // Update flatSectionJlTDS foreach (GridViewRow row in grdvJl.Rows) { int workId = Int32.Parse(((HiddenField)row.FindControl("hdfWorkID")).Value.ToString().Trim()); bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; flatSectionJl.UpdateSelected(workId, selected); if (selected) jlSelected++; } // Save jliners selection flatSectionJlTDS.AcceptChanges(); // Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; return jlSelected; }