protected void btnDelete_Click(object sender, EventArgs e) { PostPageChanges(); ArrayList jlinerIdArrayList = GetJlinerIdArrayList(); if (jlinerIdArrayList.Count > 0) { FlatSectionJliner flatSectionJliner = new FlatSectionJliner(); flatSectionJliner.LoadBySaleDetailIdArrayList(jlinerIdArrayList, 1); if (flatSectionJliner.Table.Rows.Count > 0) { // Delete store dataset Session.Remove("flatSectionJlinerTDS"); // Store datasets Session["jlinerNavigatorTDS"] = jlinerNavigatorTDS; Session["flatSectionJlinerTDS"] = flatSectionJliner.Data; // Redirect string url = "./jliner_delete.aspx?source_page=jliner_navigator2.aspx&client=" + hdfCurrentClient.Value + GetNavigatorState(); Response.Redirect(url); } } else { RestoreNavigatorState(); cvSelection.IsValid = false; } }
private void Save() { FlatSectionJliner flatSectionJliner = new FlatSectionJliner(flatSectionJlinerTDS); DataView dataViewFlatSectionJliner = new DataView(flatSectionJlinerTDS.FlatSectionJliner); dataViewFlatSectionJliner.RowFilter = "(Selected = 1) AND (Deleted = 0)"; string summary = ""; bool existsDataModificated = false; foreach (DataRowView row in dataViewFlatSectionJliner) { if (row["Issue"].ToString() == "No" || row["Issue"].ToString() == "Dig Required After Lining") { string id_ = row["ID_"].ToString(); DateTime? value = null; if (tbxDate.Text.ToString() != "") value = DateTime.Parse(tbxDate.Text); // ... Update row flatSectionJliner.UpdateField(id_, ddlFieldToUpdate.SelectedValue, value); existsDataModificated = true; } else { if (summary.Trim().Length == 0) { summary = "The following laterals were not updated:\n\n"; summary = summary + "\t - " + row["ID_"].ToString() + "\n"; } else { summary = summary + "\t - " + row["ID_"].ToString() + "\n"; } } } if (summary.Trim().Length == 0) { summary = "All the laterals were updated\n\n"; } tbxSummary.Text = summary; // Store datasets Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; if (existsDataModificated) { // Update section and jliners sectionTDS = new SectionTDS(); flatSectionJliner.Save(sectionTDS); // Update database UpdateDatabase(); } }
private int Update() { FlatSectionJliner flatSectionJliner = new FlatSectionJliner(flatSectionJlinerTDS); int jlinerSelected = 0; // Update flatSectionJlinerTDS foreach (GridViewRow row in grdvJliner.Rows) { string id_ = ((TextBox)row.FindControl("tbxId_")).Text; bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; flatSectionJliner.UpdateSelected(id_, selected); if (selected) jlinerSelected++; } // Save jliners selection flatSectionJlinerTDS.AcceptChanges(); // Store datasets Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; return jlinerSelected; }
private void Save2() { Page.Validate(); if (Page.IsValid) { FlatSectionJliner flatSectionJliner = new FlatSectionJliner(flatSectionJlinerTDS); // Update flatSectionJlinerTDS foreach (GridViewRow row in grdvJliner.Rows) { // ... Get standard fields Guid id = new Guid(((HiddenField)row.FindControl("hdfId")).Value); int companyId = int.Parse(((HiddenField)row.FindControl("hdfCompanyId")).Value); int refId = int.Parse(((HiddenField)row.FindControl("hdfRefId")).Value); string recordId = ((HiddenField)row.FindControl("hdfRecordId")).Value; string detailId = ((HiddenField)row.FindControl("hdfDetailId")).Value; string id_ = ((TextBox)row.FindControl("tbxId_")).Text.Trim(); string address = ((TextBox)row.FindControl("tbxAddress")).Text.Trim(); DateTime? pipeLocated = null; if (((TextBox)row.FindControl("tbxPipeLocated")).Text.Trim() != "") pipeLocated = DateTime.Parse(((TextBox)row.FindControl("tbxPipeLocated")).Text.Trim()); DateTime? servicesLocated = null; if (((TextBox)row.FindControl("tbxServicesLocated")).Text.Trim() != "") servicesLocated = DateTime.Parse(((TextBox)row.FindControl("tbxServicesLocated")).Text.Trim()); DateTime? coInstalled = null; if (((TextBox)row.FindControl("tbxCoInstalled")).Text.Trim() != "") coInstalled = DateTime.Parse(((TextBox)row.FindControl("tbxCoInstalled")).Text.Trim()); DateTime? backfilledConcrete = null; if (((TextBox)row.FindControl("tbxBackfilledConcrete")).Text.Trim() != "") backfilledConcrete = DateTime.Parse(((TextBox)row.FindControl("tbxBackfilledConcrete")).Text.Trim()); DateTime? backfilledSoil = null; if (((TextBox)row.FindControl("tbxBackfilledSoil")).Text.Trim() != "") backfilledSoil = DateTime.Parse(((TextBox)row.FindControl("tbxBackfilledSoil")).Text.Trim()); DateTime? grouted = null; if (((TextBox)row.FindControl("tbxGrouted")).Text.Trim() != "") grouted = DateTime.Parse(((TextBox)row.FindControl("tbxGrouted")).Text.Trim()); DateTime? cored = null; if (((TextBox)row.FindControl("tbxCored")).Text.Trim() != "") cored = DateTime.Parse(((TextBox)row.FindControl("tbxCored")).Text.Trim()); DateTime? prepped = null; if (((TextBox)row.FindControl("tbxPrepped")).Text.Trim() != "") prepped = DateTime.Parse(((TextBox)row.FindControl("tbxPrepped")).Text.Trim()); DateTime? measured = null; if (((TextBox)row.FindControl("tbxMeasured")).Text.Trim() != "") measured = DateTime.Parse(((TextBox)row.FindControl("tbxMeasured")).Text.Trim()); string linerSize = ""; if (((TextBox)row.FindControl("tbxLinerSize")).Text.Trim() != "") linerSize = ((TextBox)row.FindControl("tbxLinerSize")).Text.Trim(); bool liningThruCo = ((CheckBox)row.FindControl("cbxLiningThruCo")).Checked; DateTime? inProcess = null; if (((TextBox)row.FindControl("tbxInProcess")).Text.Trim() != "") inProcess = DateTime.Parse(((TextBox)row.FindControl("tbxInProcess")).Text.Trim()); DateTime? inStock = null; if (((TextBox)row.FindControl("tbxInStock")).Text.Trim() != "") inStock = DateTime.Parse(((TextBox)row.FindControl("tbxInStock")).Text.Trim()); DateTime? delivered = null; if (((TextBox)row.FindControl("tbxDelivered")).Text.Trim() != "") delivered = DateTime.Parse(((TextBox)row.FindControl("tbxDelivered")).Text.Trim()); DateTime? preVideo = null; if (((TextBox)row.FindControl("tbxPreVideo")).Text.Trim() != "") preVideo = DateTime.Parse(((TextBox)row.FindControl("tbxPreVideo")).Text.Trim()); DateTime? linerInstalled = null; if (((TextBox)row.FindControl("tbxLinerInstalled")).Text.Trim() != "") linerInstalled = DateTime.Parse(((TextBox)row.FindControl("tbxLinerInstalled")).Text.Trim()); DateTime? finalVideo = null; if (((TextBox)row.FindControl("tbxFinalVideo")).Text.Trim() != "") finalVideo = DateTime.Parse(((TextBox)row.FindControl("tbxFinalVideo")).Text.Trim()); double? distanceFromUSMH = null; if (((TextBox)row.FindControl("tbxDistanceFromUSMH")).Text.Trim() != "") distanceFromUSMH = double.Parse(((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(); string issue = ((DropDownList)row.FindControl("ddlIssue")).SelectedValue.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 (((TextBox)row.FindControl("tbxVideoInspection")).Text.Trim() != "") videoInspection = DateTime.Parse(((TextBox)row.FindControl("tbxVideoInspection")).Text.Trim()); string videoLengthToPropertyLine = ""; if (((TextBox)row.FindControl("tbxVideoLengthToPropertyLine")).Text.Trim() != "") videoLengthToPropertyLine = ((TextBox)row.FindControl("tbxVideoLengthToPropertyLine")).Text.Trim(); bool coRequired = ((CheckBox)row.FindControl("cbxCoReq")).Checked; bool pitRequired = ((CheckBox)row.FindControl("cbxPitReq")).Checked; string coPitLocation = ""; coPitLocation = ((DropDownList)row.FindControl("ddlCoPitLocation")).SelectedValue; bool postContractDigRequired = ((CheckBox)row.FindControl("cbxPostContractDigRequired")).Checked; DateTime? coCutDown = null; if (((TextBox)row.FindControl("tbxCoCutDown")).Text.Trim() != "") coCutDown = DateTime.Parse(((TextBox)row.FindControl("tbxCoCutDown")).Text.Trim()); DateTime? finalRestoration = null; if (((TextBox)row.FindControl("tbxFinalRestoration")).Text.Trim() != "") finalRestoration = DateTime.Parse(((TextBox)row.FindControl("tbxFinalRestoration")).Text.Trim()); string clientLateralId = ""; if (((TextBox)row.FindControl("tbxClientLateralId")).Text.Trim() != "") clientLateralId = ((TextBox)row.FindControl("tbxClientLateralId")).Text.Trim(); string hamiltonInspectionNumber = ""; if (((TextBox)row.FindControl("tbxHamiltonInspectionNumber")).Text.Trim() != "") hamiltonInspectionNumber = ((TextBox)row.FindControl("tbxHamiltonInspectionNumber")).Text.Trim(); DateTime? noticeDelivered = null; if (((TextBox)row.FindControl("tbxNoticeDelivered")).Text.Trim() != "") noticeDelivered = DateTime.Parse(((TextBox)row.FindControl("tbxNoticeDelivered")).Text.Trim()); // ... Calculate fields double? distanceFromDSMH = null; if (distanceFromUSMH.HasValue) { SectionGateway sectionGateway = new SectionGateway(); sectionGateway.LoadById(id, companyId); Distance length = new Distance(sectionGateway.GetActualLength(id)) - new Distance(((double)distanceFromUSMH).ToString()); distanceFromDSMH = length.ToDoubleInEng3(); } // ... Update row flatSectionJliner.Update(id_, id, refId, companyId, recordId, detailId, address, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, preVideo, linerInstalled, finalVideo, distanceFromUSMH, distanceFromDSMH, comments, history, issue, cost, deleted, selected, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, coCutDown, finalRestoration, clientLateralId, videoLengthToPropertyLine, liningThruCo, hamiltonInspectionNumber, noticeDelivered); } // Store datasets Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; // Update section and jliners sectionTDS = new SectionTDS(); flatSectionJliner.Save(sectionTDS); } }
private void UpdateDatabase() { DB.Open(); DB.BeginTransaction(); try { Guid id = new Guid(hdfId.Value); int refId = Int32.Parse(hdfRefId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); // Save Comments FlatSectionJlinerJuntionLiner2Comment flatSectionJlinerJuntionLiner2Comment = new FlatSectionJlinerJuntionLiner2Comment(flatSectionJlinerTDS); flatSectionJlinerJuntionLiner2Comment.Save(id, companyId); // Save History FlatSectionJlinerJuntionLiner2History flatSectionJlinerJuntionLiner2History = new FlatSectionJlinerJuntionLiner2History(flatSectionJlinerTDS); flatSectionJlinerJuntionLiner2History.Save(id, companyId); // Save jliner FlatSectionJliner flatSectionJlinerUpdateCommentsHistory = new FlatSectionJliner(); flatSectionJlinerUpdateCommentsHistory.LoadByIdRefId(id, refId, companyId); flatSectionJlinerUpdateCommentsHistory.UpdateComments(id.ToString()); flatSectionJlinerUpdateCommentsHistory.UpdateHistory(id.ToString()); Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; flatSectionJlinerUpdateCommentsHistory.Save(companyId); // Update FlatSectionJliner for new Comments FlatSectionJliner flatSectionJlinerForCommentsHistory = new FlatSectionJliner(flatSectionJlinerTDS); flatSectionJlinerForCommentsHistory.UpdateCommentsHistoryForSummaryEdit(); Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS; 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 FlatSectionJliner flatSectionJliner = new FlatSectionJliner(flatSectionJlinerTDS); // ... Delete in flatSectionJlinerTDS foreach (FlatSectionJlinerTDS.FlatSectionJlinerRow flatSectionJlinerRow in (FlatSectionJlinerTDS.FlatSectionJlinerDataTable)flatSectionJliner.Table) { if ((flatSectionJlinerRow.Selected) && (!flatSectionJlinerRow.Deleted)) { flatSectionJliner.Delete(flatSectionJlinerRow.ID_); } } // ... Update section and jliners from flatSectionJlinerTDS flatSectionJliner.Save(sectionTDS); // Update databse UpdateDatabase(); // Redirect string url = ""; if (Request.QueryString["source_page"] == "jliner_navigator2.aspx") { url = "./jliner_navigator2.aspx?source_page=jliner_delete.aspx&client=" + hdfCurrentClient.Value + GetNavigatorState() + "&update=yes"; } if (Request.QueryString["source_page"] == "flat_section_jliner_summary.aspx") { url = "./flat_section_jliner_summary.aspx?source_page=jliner_delete.aspx&client=" + hdfCurrentClient.Value + GetNavigatorState() + "&update=yes"; } Response.Redirect(url); } }