/// <summary>
/// UpdateForProcess
/// </summary>
/// <param name="companyId">companyId</param>
public void UpdateForReport(int companyId)
{
SectionGateway sectionGateway = new SectionGateway();
JlinerGateway jlinerGateway = new JlinerGateway(sectionGateway.Data);
Jliner jliner = new Jliner(sectionGateway.Data);
sectionGateway.ClearBeforeFill = false;
jlinerGateway.ClearBeforeFill = false;
SectionTDS.LFS_JUNCTION_LINER2Row lfsJunctionLiner2Row;
foreach (JlinertoBuildReportTDS.JLinersToBuildRow jLinersToBuildRow in ((JlinertoBuildReportTDS.JLinersToBuildDataTable)Table))
{
// Load sections
try
{
sectionGateway.GetRow(jLinersToBuildRow.ID);
}
catch
{
sectionGateway.LoadById(jLinersToBuildRow.ID, companyId);
}
// Load laterals
try
{
lfsJunctionLiner2Row = (SectionTDS.LFS_JUNCTION_LINER2Row) jlinerGateway.GetRow(jLinersToBuildRow.ID, jLinersToBuildRow.RefID);
}
catch
{
jlinerGateway.LoadByIdCompanyId(jLinersToBuildRow.ID, companyId);
lfsJunctionLiner2Row = (SectionTDS.LFS_JUNCTION_LINER2Row) jlinerGateway.GetRow(jLinersToBuildRow.ID, jLinersToBuildRow.RefID);
}
// Update InProcess
lfsJunctionLiner2Row.InProcess = DateTime.Now;
lfsJunctionLiner2Row.BuildRebuild++;
}
//Update
try
{
sectionGateway.Update();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public override void Validate()
{
// Validate page
base.Validate();
if (Page.IsValid)
{
// Update flatSectionJlineTDS
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);
double? distanceFromUSMH = null; if (((TextBox)row.FindControl("tbxDistanceFromUSMH")).Text.Trim() != "") distanceFromUSMH = double.Parse(((TextBox)row.FindControl("tbxDistanceFromUSMH")).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();
}
// ... Check validation fields
if (distanceFromDSMH.HasValue)
{
if ((double)distanceFromDSMH < 0)
{
CompareValidator cvDistanceFromDSMH = ((CompareValidator)row.FindControl("cvDistanceFromDSMH"));
cvDistanceFromDSMH.IsValid = false;
}
}
}
}
}
/// <summary>
/// Save to Section and Jliner rows
/// </summary>
/// <param name="sectionTDS">sectionTDS</param>
public void Save(SectionTDS sectionTDS)
{
FlatSectionJlinerTDS flatSectionJlinerChanges = (FlatSectionJlinerTDS)Data.GetChanges();
if (flatSectionJlinerChanges.FlatSectionJliner.Rows.Count > 0)
{
SectionGateway sectionGateway = new SectionGateway(sectionTDS);
LiquiForce.LFSLive.BL.CWP.Section.Section section = new LiquiForce.LFSLive.BL.CWP.Section.Section(sectionTDS);
JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS);
Jliner jliner = new Jliner(sectionTDS);
JlinerCommentGateway jlinerCommentGateway = new JlinerCommentGateway(sectionTDS);
JlinerComments jlinerComments = new JlinerComments(jlinerCommentGateway.Data);
JlinerHistoryGateway jlinerHistoryGateway = new JlinerHistoryGateway(sectionTDS);
JlinerHistory jlinerHistory = new JlinerHistory(jlinerHistoryGateway.Data);
sectionGateway.ClearBeforeFill = false;
jlinerGateway.ClearBeforeFill = false;
jlinerCommentGateway.ClearBeforeFill = false;
jlinerHistoryGateway.ClearBeforeFill = false;
foreach (FlatSectionJlinerTDS.FlatSectionJlinerRow flatSectionJlinerRow in (FlatSectionJlinerTDS.FlatSectionJlinerDataTable)flatSectionJlinerChanges.FlatSectionJliner)
{
// Load section and jliner
// ... Load section
try
{
//... Search section row
sectionGateway.GetRow(flatSectionJlinerRow.ID);
}
catch
{
//... Load section and section's jliners
sectionGateway.LoadById(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID);
jlinerGateway.LoadByIdCompanyId(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID);
jlinerCommentGateway.LoadById(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID);
jlinerHistoryGateway.LoadById(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID);
}
// Update
// ... Update jliner
string address = ""; if (!flatSectionJlinerRow.IsNull("Address")) address = flatSectionJlinerRow.Address;
DateTime? pipeLocated = null; if (!flatSectionJlinerRow.IsNull("PipeLocated")) pipeLocated = flatSectionJlinerRow.PipeLocated;
DateTime? servicesLocated = null; if (!flatSectionJlinerRow.IsNull("ServicesLocated")) servicesLocated = flatSectionJlinerRow.ServicesLocated;
DateTime? coInstalled = null; if (!flatSectionJlinerRow.IsNull("CoInstalled")) coInstalled = flatSectionJlinerRow.CoInstalled;
DateTime? backfilledConcrete = null; if (!flatSectionJlinerRow.IsNull("BackfilledConcrete")) backfilledConcrete = flatSectionJlinerRow.BackfilledConcrete;
DateTime? backfilledSoil = null; if (!flatSectionJlinerRow.IsNull("BackfilledSoil")) backfilledSoil = flatSectionJlinerRow.BackfilledSoil;
DateTime? grouted = null; if (!flatSectionJlinerRow.IsNull("Grouted")) grouted = flatSectionJlinerRow.Grouted;
DateTime? cored = null; if (!flatSectionJlinerRow.IsNull("Cored")) cored = flatSectionJlinerRow.Cored;
DateTime? prepped = null; if (!flatSectionJlinerRow.IsNull("Prepped")) prepped = flatSectionJlinerRow.Prepped;
DateTime? measured = null; if (!flatSectionJlinerRow.IsNull("Measured")) measured = flatSectionJlinerRow.Measured;
string linerSize = ""; if (!flatSectionJlinerRow.IsNull("LinerSize")) linerSize = flatSectionJlinerRow.LinerSize;
DateTime? inProcess = null; if (!flatSectionJlinerRow.IsNull("Inprocess")) inProcess = flatSectionJlinerRow.InProcess;
DateTime? inStock = null; if (!flatSectionJlinerRow.IsNull("InStock")) inStock = flatSectionJlinerRow.InStock;
DateTime? delivered = null; if (!flatSectionJlinerRow.IsNull("Delivered")) delivered = flatSectionJlinerRow.Delivered;
DateTime? preVideo = null; if (!flatSectionJlinerRow.IsNull("PreVideo")) preVideo = flatSectionJlinerRow.PreVideo;
DateTime? linerInstalled = null; if (!flatSectionJlinerRow.IsNull("LinerInstalled")) linerInstalled = flatSectionJlinerRow.LinerInstalled;
DateTime? finalVideo = null; if (!flatSectionJlinerRow.IsNull("FinalVideo")) finalVideo = flatSectionJlinerRow.FinalVideo;
double? distanceFromUSMH = null; if (!flatSectionJlinerRow.IsNull("DistanceFromUSMH")) distanceFromUSMH = flatSectionJlinerRow.DistanceFromUSMH;
double? distanceFromDSMH = null; if (!flatSectionJlinerRow.IsNull("DistanceFromDSMH")) distanceFromDSMH = flatSectionJlinerRow.DistanceFromDSMH;
string history = ""; if (!flatSectionJlinerRow.IsNull("History")) history = flatSectionJlinerRow.History;
string map = "";
string issue = flatSectionJlinerRow.Issue;
decimal? cost = null; if (!flatSectionJlinerRow.IsNull("Cost")) cost = flatSectionJlinerRow.Cost;
bool deleted = flatSectionJlinerRow.Deleted;
// ... Delete all comments and history for a jliner
if (deleted)
{
jlinerComments.DeleteAllCommentsForAJliner(flatSectionJlinerRow.ID, flatSectionJlinerRow.RefID, flatSectionJlinerRow.COMPANY_ID);
jlinerHistory.DeleteAllHistoryForAJliner(flatSectionJlinerRow.ID, flatSectionJlinerRow.RefID, flatSectionJlinerRow.COMPANY_ID);
}
DateTime? videoInspection = null; if (!flatSectionJlinerRow.IsNull("VideoInspection")) videoInspection = flatSectionJlinerRow.VideoInspection;
bool coRequired = flatSectionJlinerRow.CoRequired;
bool pitRequired = flatSectionJlinerRow.PitRequired;
string coPitLocation = ""; if (!flatSectionJlinerRow.IsNull("CoPitLocation")) coPitLocation = flatSectionJlinerRow.CoPitLocation;
bool postContractDigRequired = flatSectionJlinerRow.PostContractDigRequired;
DateTime? coCutDown = null; if (!flatSectionJlinerRow.IsNull("CoCutDown")) coCutDown = flatSectionJlinerRow.CoCutDown;
DateTime? finalRestoration = null; if (!flatSectionJlinerRow.IsNull("FinalRestoration")) finalRestoration = flatSectionJlinerRow.FinalRestoration;
string clientLateralId = ""; if (!flatSectionJlinerRow.IsNull("ClientLateralID")) clientLateralId = flatSectionJlinerRow.ClientLateralID;
string videoLengthToPropertyLine = ""; if (!flatSectionJlinerRow.IsNull("VideoLengthToPropertyLine")) videoLengthToPropertyLine = flatSectionJlinerRow.VideoLengthToPropertyLine;
bool liningThruCo = flatSectionJlinerRow.LiningThruCo;
string hamiltonInspectionNumber = ""; if (!flatSectionJlinerRow.IsNull("HamiltonInspectionNumber")) hamiltonInspectionNumber = flatSectionJlinerRow.HamiltonInspectionNumber;
DateTime? noticeDelivered = null; if (!flatSectionJlinerRow.IsNull("NoticeDelivered")) noticeDelivered = flatSectionJlinerRow.NoticeDelivered;
jliner.Update(flatSectionJlinerRow.ID, flatSectionJlinerRow.RefID, flatSectionJlinerRow.COMPANY_ID, flatSectionJlinerRow.DetailID, address, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, preVideo, linerInstalled, finalVideo, distanceFromUSMH, distanceFromDSMH,map, issue, cost, deleted, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, coCutDown, finalRestoration, clientLateralId, videoLengthToPropertyLine, liningThruCo, hamiltonInspectionNumber, noticeDelivered);
// ... Update section
section.UpdateJliners(flatSectionJlinerRow.ID, flatSectionJlinerRow.COMPANY_ID);
}
}
}
private void UpdateDatabase()
{
try
{
SectionGateway sectionGateway = new SectionGateway(sectionTDS);
sectionGateway.Update();
sectionTDS.AcceptChanges();
flatSectionJlinerTDS.AcceptChanges();
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
// Update IssueWithLaterals field
Section section = new Section(sectionTDS);
section.UpdateIssueWithLaterals();
sectionGateway.Update2();
sectionTDS.AcceptChanges();
}
catch (Exception ex)
{
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
/// <summary>
/// Save a JL Work
/// </summary>
/// <param name="originalId">originalId</param>
/// <param name="projectId">projectId</param>
/// <param name="section_assetId">section_assetId</param>
/// <param name="numLats">numLats</param>
/// <param name="notLinedYet">notLinedYet</param>
/// <param name="allMeasured">allMeasured</param>
/// <param name="issueWithLaterals">issueWithLaterals</param>
/// <param name="notMeasuredYet">notMeasuredYet</param>
/// <param name="notDeliveredYet">notDeliveredYet</param>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="companyId">companyId</param>
private void SaveJLWork(Guid originalId, int section_assetId, int numLats, int notLinedYet, bool allMeasured, string issueWithLaterals, int notMeasuredYet, int notDeliveredYet, int projectId, Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId)
{
// Insert Junction Lining Section
WorkJunctionLiningSection workJunctionLiningSection = new WorkJunctionLiningSection(null);
int sectionWorkId = workJunctionLiningSection.InsertDirect(projectId, section_assetId, null, numLats, notLinedYet, allMeasured, issueWithLaterals, notMeasuredYet, notDeliveredYet, false, companyId, "", "", "", "", false, "", 0);
// Insert Junction Lining Laterals
SectionTDS sectionTDS = new SectionTDS();
SectionGateway sectionGateway = new SectionGateway(sectionTDS);
sectionGateway.LoadById(originalId, companyId);
JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS);
jlinerGateway.LoadByIdCompanyId(originalId, companyId);
foreach (SectionTDS.LFS_JUNCTION_LINER2Row row in (SectionTDS.LFS_JUNCTION_LINER2DataTable)jlinerGateway.Table)
{
string lateralID = ""; if (!row.IsDetailIDNull()) lateralID = row.DetailID;
string address = ""; if (!row.IsAddressNull()) address = row.Address;
string distanceFromUSMH = ""; if (!row.IsDistanceFromUSMHNull()) distanceFromUSMH = row.DistanceFromUSMH.ToString();
string distanceFromDSMH = ""; if (!row.IsDistanceFromDSMHNull()) distanceFromDSMH = row.DistanceFromDSMH.ToString();
DateTime? pipeLocated = null; if (!row.IsPipeLocatedNull()) pipeLocated = row.PipeLocated;
DateTime? servicesLocated = null; if (!row.IsServicesLocatedNull()) servicesLocated = row.ServicesLocated;
DateTime? coInstalled = null; if (!row.IsCoInstalledNull()) coInstalled = row.CoInstalled;
DateTime? backfilledConcrete = null; if (!row.IsBackfilledConcreteNull()) backfilledConcrete = row.BackfilledConcrete;
DateTime? backfilledSoil = null; if (!row.IsBackfilledSoilNull()) backfilledSoil = row.BackfilledSoil;
DateTime? grouted = null; if (!row.IsGroutedNull()) grouted = row.Grouted;
DateTime? cored = null; if (!row.IsCoredNull()) cored = row.Cored;
DateTime? prepped = null; if (!row.IsPreppedNull()) prepped = row.Prepped;
DateTime? measured = null; if (!row.IsMeasuredNull()) measured = row.Measured;
string linerSize = ""; if (!row.IsLinerSizeNull()) linerSize = row.LinerSize;
DateTime? inProcess = null; if (!row.IsInProcessNull()) inProcess = row.InProcess;
DateTime? inStock = null; if (!row.IsInStockNull()) inStock = row.InStock;
DateTime? delivered = null; if (!row.IsDeliveredNull()) delivered = row.Delivered;
int? buildRebuid = null; if (!row.IsBuildRebuildNull()) buildRebuid = row.BuildRebuild;
DateTime? preVideo = null; if (!row.IsPreVideoNull()) preVideo = row.PreVideo;
DateTime? linerInstalled = null; if (!row.IsLinerInstalledNull()) linerInstalled = row.LinerInstalled;
DateTime? finalVideo = null; if (!row.IsFinalVideoNull()) finalVideo = row.FinalVideo;
string map = ""; if (!row.IsMapNull()) map = row.Map;
decimal? cost = null; if (!row.IsCostNull()) cost = row.Cost;
DateTime? videoInspection = null; if (!row.IsVideoInspectionNull()) videoInspection = row.VideoInspection;
bool coRequired = row.CoRequired;
bool pitRequired = row.PitRequired;
string coPitLocation = ""; if (!row.IsCoPitLocationNull()) coPitLocation = row.CoPitLocation;
bool postContractDigRequired = row.PostContractDigRequired;
string comments = ""; if (!row.IsCommentsNull()) comments = row.Comments;
string history = ""; if (!row.IsHistoryNull()) history = row.History;
DateTime? coCutDown = null; if (!row.IsCoCutDownNull()) coCutDown = row.CoCutDown;
DateTime? finalRestoration = null; if (!row.IsFinalRestorationNull()) finalRestoration = row.FinalRestoration;
string clientLateralId = ""; if (!row.IsClientLateralIDNull()) clientLateralId = row.ClientLateralID;
string videoLengthToPropertyLine = ""; if (!row.IsVideoLengthToPropertyLineNull()) videoLengthToPropertyLine = row.VideoLengthToPropertyLine;
bool liningThruCo = row.LiningThruCo;
DateTime? noticeDelivered = null; if (!row.IsNoticeDeliveredNull()) noticeDelivered = row.NoticeDelivered;
string hamiltonInspectionNumber = ""; if (!row.IsHamiltonInspectionNumberNull()) hamiltonInspectionNumber = row.HamiltonInspectionNumber;
bool dyeTestReq = row.DyeTestReq;
DateTime? dyeTestComplete = null; if (!row.IsDyeTestCompleteNull()) dyeTestComplete = row.DyeTestComplete;
// Fields only presents in new Junction lining
string flange = "";
string gasket = "";
string connectionType = "";
string depthOfLocated = "";
bool digRequiredPriorToLining = false;
DateTime? digRequiredPriorToLiningCompleted = null;
bool digRequiredAfterLining = false;
DateTime? digRequiredAfterLiningCompleted = null;
bool outOfScope = false;
bool holdClientIssue = false;
DateTime? holdClientIssueResolved = null;
bool holdLFSIssue = false;
DateTime? holdLFSIssueResolved = null;
bool requiresRoboticPrep = false;
DateTime? requiresRoboticPrepCompleted = null;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
int clientId = projectGateway.GetClientID(projectId);
// Insert into LFS Asset Lateral
LfsAssetSewerLateral lfsAssetSewerLateral = new LfsAssetSewerLateral(null);
int lateralAssetId = lfsAssetSewerLateral.InsertDirect(countryId, provinceId, countyId, cityId, section_assetId, address, lateralID, "", "", "", "", "Live", "", distanceFromUSMH, distanceFromDSMH, "", false, companyId, connectionType);
// Insert into LFS Asset Lateral Client
LfsAssetSewerLateralClient lfsAssetSewerLateralClient = new LfsAssetSewerLateralClient(null);
lfsAssetSewerLateralClient.InsertDirect(lateralAssetId, clientId, clientLateralId, false, companyId);
// Insert into Work Junction Lining Lateral
WorkJunctionLiningLateral workJunctionLiningLateral = new WorkJunctionLiningLateral(null);
int workLateral = workJunctionLiningLateral.InsertDirect(projectId, lateralAssetId, sectionWorkId, pipeLocated, servicesLocated, coInstalled, backfilledConcrete, backfilledSoil, grouted, cored, prepped, measured, linerSize, inProcess, inStock, delivered, buildRebuid, preVideo, linerInstalled, finalVideo, cost, videoInspection, coRequired, pitRequired, coPitLocation, postContractDigRequired, coCutDown, finalRestoration, false, companyId, comments, history, videoLengthToPropertyLine, liningThruCo, noticeDelivered, hamiltonInspectionNumber, flange, gasket, depthOfLocated, digRequiredPriorToLining, digRequiredPriorToLiningCompleted, digRequiredAfterLining, digRequiredAfterLiningCompleted, outOfScope, holdClientIssue, holdClientIssueResolved, holdLFSIssue, holdLFSIssueResolved, requiresRoboticPrep, requiresRoboticPrepCompleted, "", "", dyeTestReq, dyeTestComplete, "");
// Insert into Work Comments
JlinerCommentGateway jlinerCommentGateway = new JlinerCommentGateway(sectionTDS);
jlinerCommentGateway.LoadByIdRefId(originalId, row.RefID, companyId);
foreach (SectionTDS.LFS_JUNCTION_LINER2_COMMENTRow rowComment in (SectionTDS.LFS_JUNCTION_LINER2_COMMENTDataTable)jlinerCommentGateway.Table)
{
int loginId = rowComment.LoginID;
DateTime dateTime_ = rowComment.DateTime_;
string comment = rowComment.Comment;
WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway();
workCommentsGateway.LoadByWorkIdWorkType(workLateral, companyId, "Junction Lining Lateral");
WorkComments workComments = new WorkComments(workCommentsGateway.Data);
workComments.Insert(workLateral, 0, "Junction Lining Lateral", "Bulk Upload Comments", loginId, dateTime_, comment, null, false, companyId, false, "Junction Lining");
// Update Comments
workCommentsGateway.Update();
}
// Insert into Work History
JlinerHistoryGateway jlinerHistoryGateway = new JlinerHistoryGateway(sectionTDS);
jlinerHistoryGateway.LoadByIdRefId(originalId, row.RefID, companyId);
foreach (SectionTDS.LFS_JUNCTION_LINER2_HISTORYRow rowHistory in (SectionTDS.LFS_JUNCTION_LINER2_HISTORYDataTable)jlinerHistoryGateway.Table)
{
int loginId = rowHistory.LoginID;
DateTime dateTime_H = rowHistory.DateTime_;
string history_ = rowHistory.History;
WorkHistoryGateway workHistoryGateway = new WorkHistoryGateway();
workHistoryGateway.LoadByWorkIdWorkType(workLateral, companyId, "Junction Lining Lateral");
WorkHistory workHistory = new WorkHistory(workHistoryGateway.Data);
workHistory.Insert(workLateral, 0, "Junction Lining Lateral", "Bulk Upload History", loginId, dateTime_H, history_, null, false, companyId, false, "Junction Lining");
// Update History
workHistoryGateway.Update();
}
}
}
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);
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_APP_VIEW"]) && Convert.ToBoolean(Session["sgLFS_APP_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in flat_section_jliner_edit.aspx");
}
// Tag page
hdfCurrentClient.Value = (string)Request.QueryString["client"];
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfId.Value = Convert.ToString(Request.QueryString["rowId"]);
hdfRefId.Value = Convert.ToString(Request.QueryString["rowRefId"]);
hdfCompanyId.Value = Convert.ToString(Request.QueryString["rowCompanyId"]);
hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_APP_ADMIN"]).ToString();
hdfUpdate.Value = "yes";
// Prepare initial data
Session.Remove("commentsDummy");
// ... Names for UserList
int companyId = Int32.Parse(hdfCompanyId.Value);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreationDateTime.Value = DateTime.Now.ToString();
// If comming from
// ... flat_section_jliner_summary.aspx
if (Request.QueryString["source_page"] == "flat_section_jliner_summary.aspx" || Request.QueryString["source_page"] == "flat_section_jliner_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
Session["rowFocus"] = Convert.ToInt32(Request.QueryString["rowFocus"].ToString());
// ... Load comments to edit
sectionTDS = new SectionTDS();
flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"];
SectionGateway sectionGateway = new SectionGateway(sectionTDS);
sectionGateway.LoadById(new Guid(hdfId.Value), Convert.ToInt32(hdfCompanyId.Value));
JlinerGateway jlinerGateway = new JlinerGateway(sectionTDS);
jlinerGateway.LoadByIdCompanyIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfCompanyId.Value), Convert.ToInt32(hdfRefId.Value));
FlatSectionJlinerJuntionLiner2CommentGateway flatSectionJlinerJuntionLiner2CommentGateway = new FlatSectionJlinerJuntionLiner2CommentGateway(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2CommentGateway.LoadAllByIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfRefId.Value), Convert.ToInt32(hdfCompanyId.Value));
FlatSectionJlinerJuntionLiner2Comment flatSectionJlinerJuntionLiner2Comment = new FlatSectionJlinerJuntionLiner2Comment(flatSectionJlinerJuntionLiner2CommentGateway.Data);
flatSectionJlinerJuntionLiner2Comment.UpdateForProcess();
// ... Load history for transfers
FlatSectionJlinerJuntionLiner2HistoryGateway flatSectionJlinerJuntionLiner2HistoryGateway = new FlatSectionJlinerJuntionLiner2HistoryGateway(flatSectionJlinerTDS);
flatSectionJlinerJuntionLiner2HistoryGateway.LoadAllByIdRefId(new Guid(hdfId.Value), Convert.ToInt32(hdfRefId.Value), Convert.ToInt32(hdfCompanyId.Value));
// ... Store datasets
Session["sectionTDS"] = sectionTDS;
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
comments = flatSectionJlinerTDS.JuntionLiner2Comment;
Session["comments"] = comments;
}
}
else
{
// Restore datasets
sectionTDS = (SectionTDS)Session["sectionTDS"];
flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"];
Session["flatSectionJlinerTDS"] = flatSectionJlinerTDS;
comments = flatSectionJlinerTDS.JuntionLiner2Comment;
Session["comments"] = comments;
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// Update direct
/// </summary>
/// <param name="originalId">originalId</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="originalRecordId">originalRecordId</param>
/// <param name="originalClientId">originalClientId</param>
/// <param name="originalCompaniesId">originalCompaniesId</param>
/// <param name="originalSubArea">originalSubArea</param>
/// <param name="originalStreet">originalStreet</param>
/// <param name="originalUSMH">originalUSMH</param>
/// <param name="originalDSMH">originalDSMH</param>
/// <param name="originalSize_">originalSize_</param>
/// <param name="originalScaledLength">originalScaledLength</param>
/// <param name="originalP1Date">originalP1Date</param>
/// <param name="originalActualLength">originalActualLength</param>
/// <param name="originalLiveLats">originalLiveLats</param>
/// <param name="originalCXIsRemoved">originalCXIsRemoved</param>
/// <param name="originalM1Date">originalM1Date</param>
/// <param name="originalM2Date">originalM2Date</param>
/// <param name="originalInstallDate">originalInstallDate</param>
/// <param name="originalFinalVideo">originalFinalVideo</param>
/// <param name="originalComments">originalComments</param>
/// <param name="originalIssueIdentified">originalIssueIdentified</param>
/// <param name="originalIssueResolved">originalIssueResolved</param>
/// <param name="originalFullLengthLining">originalFullLengthLining</param>
/// <param name="originalSubcontractorLining">originalSubcontractorLining</param>
/// <param name="originalOutOfScopeInArea">originalOutOfScopeInArea</param>
/// <param name="originalIssueGivenToBayCity">originalIssueGivenToBayCity</param>
/// <param name="originalConfirmedSize">originalConfirmedSize</param>
/// <param name="originalInstallRate">originalInstallRate</param>
/// <param name="originalDeadlineDate">originalDeadlineDate</param>
/// <param name="originalProposedLiningDate">originalProposedLiningDate</param>
/// <param name="originalSalesIssue">originalSalesIssue</param>
/// <param name="originalLFSIssue">originalLFSIssue</param>
/// <param name="originalClientIssue">originalClientIssue</param>
/// <param name="originalInvestigationIssue">originalInvestigationIssue</param>
/// <param name="originalPointLining">originalPointLining</param>
/// <param name="originalGrouting">originalGrouting</param>
/// <param name="originalLateralLining">originalLateralLining</param>
/// <param name="originalVacExDate">originalVacExDateParameter</param>
/// <param name="originalPusherDate">originalPusherDate</param>
/// <param name="originalLinerOrdered">originalLinerOrdered</param>
/// <param name="originalRestoration">originalRestoration</param>
/// <param name="originalGroutDate">originalGroutDate</param>
/// <param name="originalJLiner">originalJLiner</param>
/// <param name="originalRehabAssessment">originalRehabAssessment</param>
/// <param name="originalEstimatedJoints">originalEstimatedJoints</param>
/// <param name="originalJointsTestSealed">originalJointsTestSealed</param>
/// <param name="originalPreFlushDate">originalPreFlushDate</param>
/// <param name="originalPreVideoDate">originalPreVideoDate</param>
/// <param name="originalUSMHMN">originalUSMHMN</param>
/// <param name="originalDSMHMN">originalDSMHMN</param>
/// <param name="originalUSMHDepth">originalUSMHDepth</param>
/// <param name="originalDSMHDepth">originalDSMHDepth</param>
/// <param name="originalMeasurementsTakenBy">originalMeasurementsTakenBy</param>
/// <param name="originalSteelTapeThruPipe">originalSteelTapeThruPipe</param>
/// <param name="originalUSMHAtMouth1200">originalUSMHAtMouth1200</param>
/// <param name="originalUSMHAtMouth100">originalUSMHAtMouth100</param>
/// <param name="originalUSMHAtMouth200">originalUSMHAtMouth200</param>
/// <param name="originalUSMHAtMouth300">originalUSMHAtMouth300</param>
/// <param name="originalUSMHAtMouth400">originalUSMHAtMouth400</param>
/// <param name="originalUSMHAtMouth500">originalUSMHAtMouth500</param>
/// <param name="originalDSMHAtMouth1200">originalDSMHAtMouth1200</param>
/// <param name="originalDSMHAtMouth100">originalDSMHAtMouth100</param>
/// <param name="originalDSMHAtMouth200">originalDSMHAtMouth200</param>
/// <param name="originalDSMHAtMouth300">originalDSMHAtMouth300</param>
/// <param name="originalDSMHAtMouth400">originalDSMHAtMouth400</param>
/// <param name="originalDSMHAtMouth500">originalDSMHAtMouth500</param>
/// <param name="originalHydrantAddress">originalHydrantAddress</param>
/// <param name="originalDistanceToInversionMH">originalDistanceToInversionMH</param>
/// <param name="originalRampsRequired">originalRampsRequired</param>
/// <param name="originalDegreeOfTrafficControl">originalDegreeOfTrafficControl</param>
/// <param name="originalStandarBypass">originalStandarBypass</param>
/// <param name="originalHydroWireDetails">originalHydroWireDetails</param>
/// <param name="originalPipeMaterialType">originalPipeMaterialType</param>
/// <param name="originalCappedLaterals">originalCappedLaterals</param>
/// <param name="originalRoboticPrepRequired">originalRoboticPrepRequired</param>
/// <param name="originalPipeSizeChange">originalPipeSizeChange</param>
/// <param name="originalM1Comments">originalM1Comments</param>
/// <param name="originalVideoDoneFrom">originalVideoDoneFrom</param>
/// <param name="originalToManhole">originalToManhole</param>
/// <param name="originalCutterDescriptionDuringMeasuring">originalCutterDescriptionDuringMeasuring</param>
/// <param name="originalFullLengthPointLiner">originalFullLengthPointLiner</param>
/// <param name="originalBypassRequired">originalBypassRequired</param>
/// <param name="originalRoboticDistances">originalRoboticDistances</param>
/// <param name="originalTrafficControlDetails">originalTrafficControlDetails</param>
/// <param name="originalLineWithID">originalLineWithID</param>
/// <param name="originalSchoolZone">originalSchoolZone</param>
/// <param name="originalRestaurantArea">originalRestaurantArea</param>
/// <param name="originalCarwashLaundromat">originalCarwashLaundromat</param>
/// <param name="originalHydroPulley">originalHydroPulley</param>
/// <param name="originalFridgeCart">originalFridgeCart</param>
/// <param name="originalTwoInchPump">originalTwoInchPump</param>
/// <param name="originalSixInchBypass">originalSixInchBypass</param>
/// <param name="originalScaffolding">originalScaffolding</param>
/// <param name="originalWinchExtension">originalWinchExtension</param>
/// <param name="originalExtraGenerator">originalExtraGenerator</param>
/// <param name="originalGreyCableExtension">originalGreyCableExtension</param>
/// <param name="originalEasementMats">originalEasementMats</param>
/// <param name="originalMeasurementType">originalMeasurementType</param>
/// <param name="originalDropPipe">originalDropPipe</param>
/// <param name="originalDropPipeInvertDepth">originalDropPipeInvertDepth</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalMeasuredFromManhole">originalMeasuredFromManhole</param>
/// <param name="originalMainLined">originalMainLined</param>
/// <param name="originalBenchingIssue">originalBenchingIssue</param>
/// <param name="originalArchived">originalArchived</param>
/// <param name="originalScaledLength1">originalScaledLength1</param>
/// <param name="originalHistory">originalHistory</param>
/// <param name="originalNumLats">originalNumLats</param>
/// <param name="originalNotLinedYet">originalNotLinedYet</param>
/// <param name="originalAllMeasured">originalAllMeasured</param>
/// <param name="originalCity">originalCity</param>
/// <param name="originalProvState">originalProvState</param>
/// <param name="originalIssueWithLaterals">originalIssueWithLaterals</param>
/// <param name="originalNotMeasuredYet">originalNotMeasuredYet</param>
/// <param name="originalNotDeliveredYet">originalNotDeliveredYet</param>
///
/// <param name="newId">newId</param>
/// <param name="newCompanyId">newCompanyId</param>
/// <param name="newRecordId">newRecordId</param>
/// <param name="newClientId">newClientId</param>
/// <param name="newCompaniesId">newCompaniesId</param>
/// <param name="newSubArea">newSubArea</param>
/// <param name="newStreet">newStreet</param>
/// <param name="newUSMH">newUSMH</param>
/// <param name="newDSMH">newDSMH</param>
/// <param name="newSize_">newSize_</param>
/// <param name="newScaledLength">newScaledLength</param>
/// <param name="newP1Date">newP1Date</param>
/// <param name="newActualLength">newActualLength</param>
/// <param name="newLiveLats">newLiveLats</param>
/// <param name="newCXIsRemoved">newCXIsRemoved</param>
/// <param name="newM1Date">newM1Date</param>
/// <param name="newM2Date">newM2Date</param>
/// <param name="newInstallDate">newInstallDate</param>
/// <param name="newFinalVideo">newFinalVideo</param>
/// <param name="newComments">newComments</param>
/// <param name="newIssueIdentified">newIssueIdentified</param>
/// <param name="newIssueResolved">newIssueResolved</param>
/// <param name="newFullLengthLining">newFullLengthLining</param>
/// <param name="newSubcontractorLining">newSubcontractorLining</param>
/// <param name="newOutOfScopeInArea">newOutOfScopeInArea</param>
/// <param name="newIssueGivenToBayCity">newIssueGivenToBayCity</param>
/// <param name="newConfirmedSize">newConfirmedSize</param>
/// <param name="newInstallRate">newInstallRate</param>
/// <param name="newDeadlineDate">newDeadlineDate</param>
/// <param name="newProposedLiningDate">newProposedLiningDate</param>
/// <param name="newSalesIssue">newSalesIssue</param>
/// <param name="newLFSIssue">newLFSIssue</param>
/// <param name="newClientIssue">newClientIssue</param>
/// <param name="newInvestigationIssue">newInvestigationIssue</param>
/// <param name="newPointLining">newPointLining</param>
/// <param name="newGrouting">newGrouting</param>
/// <param name="newLateralLining">newLateralLining</param>
/// <param name="newVacExDate">newVacExDateParameter</param>
/// <param name="newPusherDate">newPusherDate</param>
/// <param name="newLinerOrdered">newLinerOrdered</param>
/// <param name="newRestoration">newRestoration</param>
/// <param name="newGroutDate">newGroutDate</param>
/// <param name="newJLiner">newJLiner</param>
/// <param name="newRehabAssessment">newRehabAssessment</param>
/// <param name="newEstimatedJoints">newEstimatedJoints</param>
/// <param name="newJointsTestSealed">newJointsTestSealed</param>
/// <param name="newPreFlushDate">newPreFlushDate</param>
/// <param name="newPreVideoDate">newPreVideoDate</param>
/// <param name="newUSMHMN">newUSMHMN</param>
/// <param name="newDSMHMN">newDSMHMN</param>
/// <param name="newUSMHDepth">newUSMHDepth</param>
/// <param name="newDSMHDepth">newDSMHDepth</param>
/// <param name="newMeasurementsTakenBy">newMeasurementsTakenBy</param>
/// <param name="newSteelTapeThruPipe">newSteelTapeThruPipe</param>
/// <param name="newUSMHAtMouth1200">newUSMHAtMouth1200</param>
/// <param name="newUSMHAtMouth100">newUSMHAtMouth100</param>
/// <param name="newUSMHAtMouth200">newUSMHAtMouth200</param>
/// <param name="newUSMHAtMouth300">newUSMHAtMouth300</param>
/// <param name="newUSMHAtMouth400">newUSMHAtMouth400</param>
/// <param name="newUSMHAtMouth500">newUSMHAtMouth500</param>
/// <param name="newDSMHAtMouth1200">newDSMHAtMouth1200</param>
/// <param name="newDSMHAtMouth100">newDSMHAtMouth100</param>
/// <param name="newDSMHAtMouth200">newDSMHAtMouth200</param>
/// <param name="newDSMHAtMouth300">newDSMHAtMouth300</param>
/// <param name="newDSMHAtMouth400">newDSMHAtMouth400</param>
/// <param name="newDSMHAtMouth500">newDSMHAtMouth500</param>
/// <param name="newHydrantAddress">newHydrantAddress</param>
/// <param name="newDistanceToInversionMH">newDistanceToInversionMH</param>
/// <param name="newRampsRequired">newRampsRequired</param>
/// <param name="newDegreeOfTrafficControl">newDegreeOfTrafficControl</param>
/// <param name="newStandarBypass">newStandarBypass</param>
/// <param name="newHydroWireDetails">newHydroWireDetails</param>
/// <param name="newPipeMaterialType">newPipeMaterialType</param>
/// <param name="newCappedLaterals">newCappedLaterals</param>
/// <param name="newRoboticPrepRequired">newRoboticPrepRequired</param>
/// <param name="newPipeSizeChange">newPipeSizeChange</param>
/// <param name="newM1Comments">newM1Comments</param>
/// <param name="newVideoDoneFrom">newVideoDoneFrom</param>
/// <param name="newToManhole">newToManhole</param>
/// <param name="newCutterDescriptionDuringMeasuring">newCutterDescriptionDuringMeasuring</param>
/// <param name="newFullLengthPointLiner">newFullLengthPointLiner</param>
/// <param name="newBypassRequired">newBypassRequired</param>
/// <param name="newRoboticDistances">newRoboticDistances</param>
/// <param name="newTrafficControlDetails">newTrafficControlDetails</param>
/// <param name="newLineWithID">newLineWithID</param>
/// <param name="newSchoolZone">neSchoolZone</param>
/// <param name="newRestaurantArea">newRestaurantArea</param>
/// <param name="newCarwashLaundromat">newCarwashLaundromat</param>
/// <param name="newHydroPulley">newHydroPulley</param>
/// <param name="newFridgeCart">FridgeCart</param>
/// <param name="newTwoInchPump">newTwoInchPump</param>
/// <param name="newSixInchBypass">newSixInchBypass</param>
/// <param name="newScaffolding">newScaffolding</param>
/// <param name="newWinchExtension">WinchExtension</param>
/// <param name="newExtraGenerator">newExtraGenerator</param>
/// <param name="newGreyCableExtension">newGreyCableExtension</param>
/// <param name="newEasementMats">newEasementMats</param>
/// <param name="newMeasurementType">newMeasurementType</param>
/// <param name="newDropPipe">newDropPipe</param>
/// <param name="newDropPipeInvertDepth">newDropPipeInvertDepth</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newMeasuredFromManhole">newMeasuredFromManhole</param>
/// <param name="newMainLined">newMainLined</param>
/// <param name="newBenchingIssue">newBenchingIssue</param>
/// <param name="newArchived">newArchived</param>
/// <param name="newScaledLength1">newScaledLength1</param>
/// <param name="newHistory">newHistory</param>
/// <param name="newNumLats">newNumLats</param>
/// <param name="newNotLinedYet">newNotLinedYet</param>
/// <param name="newAllMeasured">newAllMeasured</param>
/// <param name="newCity">newCity</param>
/// <param name="newProvState">newProvState</param>
/// <param name="newIssueWithLaterals">newIssueWithLaterals</param>
/// <param name="newNotMeasuredYet">newNotMeasuredYet</param>
/// <param name="newNotDeliveredYet">newNotDeliveredYet</param>
public void UpdateDirect(Guid originalId, int originalCompanyId, string originalRecordId, string originalClientId, int? originalCompaniesId, string originalSubArea, string originalStreet, string originalUSMH, string originalDSMH, string originalSize_, string originalScaledLength, DateTime? originalP1Date, string originalActualLength, double? originalLiveLats, string originalCXIsRemoved, DateTime? originalM1Date, DateTime? originalM2Date, DateTime? originalInstallDate, DateTime? originalFinalVideo, string originalComments, bool originalIssueIdentified, bool originalIssueResolved, bool originalFullLengthLining, bool originalSubcontractorLining, bool originalOutOfScopeInArea, bool originalIssueGivenToBayCity, int? originalConfirmedSize, decimal? originalInstallRate, DateTime? originalDeadlineDate, DateTime? originalProposedLiningDate, bool originalSalesIssue, bool originalLFSIssue, bool originalClientIssue, bool originalInvestigationIssue, bool originalPointLining, bool originalGrouting, bool originalLateralLining, DateTime? originalVacExDate, DateTime? originalPusherDate, DateTime? originalLinerOrdered, DateTime? originalRestoration, DateTime? originalGroutDate, bool originalJLiner, bool originalRehabAssessment, int? originalEstimatedJoints, int? originalJointsTestSealed, DateTime? originalPreFlushDate, DateTime? originalPreVideoDate, string originalUSMHMN, string originalDSMHMN, string originalUSMHDepth, string originalDSMHDepth, string originalMeasurementsTakenBy, string originalSteelTapeThruPipe, double? originalUSMHAtMouth1200, double? originalUSMHAtMouth100, double? originalUSMHAtMouth200, double? originalUSMHAtMouth300, double? originalUSMHAtMouth400, double? originalUSMHAtMouth500, double? originalDSMHAtMouth1200, double? originalDSMHAtMouth100, double? originalDSMHAtMouth200, double? originalDSMHAtMouth300, double? originalDSMHAtMouth400, double? originalDSMHAtMouth500, string originalHydrantAddress, string originalDistanceToInversionMH, bool originalRampsRequired, string originalDegreeOfTrafficControl, bool originalStandarBypass, string originalHydroWireDetails, string originalPipeMaterialType, int? originalCappedLaterals, bool originalRoboticPrepRequired, bool originalPipeSizeChange, string originalM1Comments, string originalVideoDoneFrom, string originalToManhole, string originalCutterDescriptionDuringMeasuring, bool originalFullLengthPointLiner, bool originalBypassRequired, string originalRoboticDistances, string originalTrafficControlDetails, string originalLineWithID, bool originalSchoolZone, bool originalRestaurantArea, bool originalCarwashLaundromat, bool originalHydroPulley, bool originalFridgeCart, bool originalTwoInchPump, bool originalSixInchBypass, bool originalScaffolding, bool originalWinchExtension, bool originalExtraGenerator, bool originalGreyCableExtension, bool originalEasementMats, string originalMeasurementType, bool originalDropPipe, string originalDropPipeInvertDepth, bool originalDeleted, string originalMeasuredFromManhole, string originalMainLined, string originalBenchingIssue, bool originalArchived, double? originalScaledLength1, string originalHistory, int? originalNumLats, int? originalNotLinedYet, bool originalAllMeasured, string originalCity, string originalProvState, string originalIssueWithLaterals, int? originalNotMeasuredYet, int? originalNotDeliveredYet, Guid newId, int newCompanyId, string newRecordId, string newClientId, int? newCompaniesId, string newSubArea, string newStreet, string newUSMH, string newDSMH, string newSize_, string newScaledLength, DateTime? newP1Date, string newActualLength, double? newLiveLats, string newCXIsRemoved, DateTime? newM1Date, DateTime? newM2Date, DateTime? newInstallDate, DateTime? newFinalVideo, string newComments, bool newIssueIdentified, bool newIssueResolved, bool newFullLengthLining, bool newSubcontractorLining, bool newOutOfScopeInArea, bool newIssueGivenToBayCity, int? newConfirmedSize, decimal? newInstallRate, DateTime? newDeadlineDate, DateTime? newProposedLiningDate, bool newSalesIssue, bool newLFSIssue, bool newClientIssue, bool newInvestigationIssue, bool newPointLining, bool newGrouting, bool newLateralLining, DateTime? newVacExDate, DateTime? newPusherDate, DateTime? newLinerOrdered, DateTime? newRestoration, DateTime? newGroutDate, bool newJLiner, bool newRehabAssessment, int? newEstimatedJoints, int? newJointsTestSealed, DateTime? newPreFlushDate, DateTime? newPreVideoDate, string newUSMHMN, string newDSMHMN, string newUSMHDepth, string newDSMHDepth, string newMeasurementsTakenBy, string newSteelTapeThruPipe, double? newUSMHAtMouth1200, double? newUSMHAtMouth100, double? newUSMHAtMouth200, double? newUSMHAtMouth300, double? newUSMHAtMouth400, double? newUSMHAtMouth500, double? newDSMHAtMouth1200, double? newDSMHAtMouth100, double? newDSMHAtMouth200, double? newDSMHAtMouth300, double? newDSMHAtMouth400, double? newDSMHAtMouth500, string newHydrantAddress, string newDistanceToInversionMH, bool newRampsRequired, string newDegreeOfTrafficControl, bool newStandarBypass, string newHydroWireDetails, string newPipeMaterialType, int? newCappedLaterals, bool newRoboticPrepRequired, bool newPipeSizeChange, string newM1Comments, string newVideoDoneFrom, string newToManhole, string newCutterDescriptionDuringMeasuring, bool newFullLengthPointLiner, bool newBypassRequired, string newRoboticDistances, string newTrafficControlDetails, string newLineWithID, bool newSchoolZone, bool newRestaurantArea, bool newCarwashLaundromat, bool newHydroPulley, bool newFridgeCart, bool newTwoInchPump, bool newSixInchBypass, bool newScaffolding, bool newWinchExtension, bool newExtraGenerator, bool newGreyCableExtension, bool newEasementMats, string newMeasurementType, bool newDropPipe, string newDropPipeInvertDepth, bool newDeleted, string newMeasuredFromManhole, string newMainLined, string newBenchingIssue, bool newArchived, double? newScaledLength1, string newHistory, int? newNumLats, int? newNotLinedYet, bool newAllMeasured, string newCity, string newProvState, string newIssueWithLaterals, int? newNotMeasuredYet, int? newNotDeliveredYet)
{
SectionGateway sectionGateway = new SectionGateway(null);
sectionGateway.Update(originalId, originalCompanyId, originalRecordId, originalClientId, originalCompaniesId, originalSubArea, originalStreet, originalUSMH, originalDSMH, originalSize_, originalScaledLength, originalP1Date, originalActualLength, originalLiveLats, originalCXIsRemoved, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideo, originalComments, originalIssueIdentified, originalIssueResolved, originalFullLengthLining, originalSubcontractorLining, originalOutOfScopeInArea, originalIssueGivenToBayCity, originalConfirmedSize, originalInstallRate, originalDeadlineDate, originalProposedLiningDate, originalSalesIssue, originalLFSIssue, originalClientIssue, originalInvestigationIssue, originalPointLining, originalGrouting, originalLateralLining, originalVacExDate, originalPusherDate, originalLinerOrdered, originalRestoration, originalGroutDate, originalJLiner, originalRehabAssessment, originalEstimatedJoints, originalJointsTestSealed, originalPreFlushDate, originalPreVideoDate, originalUSMHMN, originalDSMHMN, originalUSMHDepth, originalDSMHDepth, originalMeasurementsTakenBy, originalSteelTapeThruPipe, originalUSMHAtMouth1200, originalUSMHAtMouth100, originalUSMHAtMouth200, originalUSMHAtMouth300, originalUSMHAtMouth400, originalUSMHAtMouth500, originalDSMHAtMouth1200, originalDSMHAtMouth100, originalDSMHAtMouth200, originalDSMHAtMouth300, originalDSMHAtMouth400, originalDSMHAtMouth500, originalHydrantAddress, originalDistanceToInversionMH, originalRampsRequired, originalDegreeOfTrafficControl, originalStandarBypass, originalHydroWireDetails, originalPipeMaterialType, originalCappedLaterals, originalRoboticPrepRequired, originalPipeSizeChange, originalM1Comments, originalVideoDoneFrom, originalToManhole, originalCutterDescriptionDuringMeasuring, originalFullLengthPointLiner, originalBypassRequired, originalRoboticDistances, originalTrafficControlDetails, originalLineWithID, originalSchoolZone, originalRestaurantArea, originalCarwashLaundromat, originalHydroPulley, originalFridgeCart, originalTwoInchPump, originalSixInchBypass, originalScaffolding, originalWinchExtension, originalExtraGenerator, originalGreyCableExtension, originalEasementMats, originalMeasurementType, originalDropPipe, originalDropPipeInvertDepth, originalDeleted, originalMeasuredFromManhole, originalMainLined, originalBenchingIssue, originalArchived, originalScaledLength1, originalHistory, originalNumLats, originalNotLinedYet, originalAllMeasured, originalCity, originalProvState, originalIssueWithLaterals, originalNotMeasuredYet, originalNotDeliveredYet, newId, newCompanyId, newRecordId, newClientId, newCompaniesId, newSubArea, newStreet, newUSMH, newDSMH, newSize_, newScaledLength, newP1Date, newActualLength, newLiveLats, newCXIsRemoved, newM1Date, newM2Date, newInstallDate, newFinalVideo, newComments, newIssueIdentified, newIssueResolved, newFullLengthLining, newSubcontractorLining, newOutOfScopeInArea, newIssueGivenToBayCity, newConfirmedSize, newInstallRate, newDeadlineDate, newProposedLiningDate, newSalesIssue, newLFSIssue, newClientIssue, newInvestigationIssue, newPointLining, newGrouting, newLateralLining, newVacExDate, newPusherDate, newLinerOrdered, newRestoration, newGroutDate, newJLiner, newRehabAssessment, newEstimatedJoints, newJointsTestSealed, newPreFlushDate, newPreVideoDate, newUSMHMN, newDSMHMN, newUSMHDepth, newDSMHDepth, newMeasurementsTakenBy, newSteelTapeThruPipe, newUSMHAtMouth1200, newUSMHAtMouth100, newUSMHAtMouth200, newUSMHAtMouth300, newUSMHAtMouth400, newUSMHAtMouth500, newDSMHAtMouth1200, newDSMHAtMouth100, newDSMHAtMouth200, newDSMHAtMouth300, newDSMHAtMouth400, newDSMHAtMouth500, newHydrantAddress, newDistanceToInversionMH, newRampsRequired, newDegreeOfTrafficControl, newStandarBypass, newHydroWireDetails, newPipeMaterialType, newCappedLaterals, newRoboticPrepRequired, newPipeSizeChange, newM1Comments, newVideoDoneFrom, newToManhole, newCutterDescriptionDuringMeasuring, newFullLengthPointLiner, newBypassRequired, newRoboticDistances, newTrafficControlDetails, newLineWithID, newSchoolZone, newRestaurantArea, newCarwashLaundromat, newHydroPulley, newFridgeCart, newTwoInchPump, newSixInchBypass, newScaffolding, newWinchExtension, newExtraGenerator, newGreyCableExtension, newEasementMats, newMeasurementType, newDropPipe, newDropPipeInvertDepth, newDeleted, newMeasuredFromManhole, newMainLined, newBenchingIssue, newArchived, newScaledLength1, newHistory, newNumLats, newNotLinedYet, newAllMeasured, newCity, newProvState, newIssueWithLaterals, newNotMeasuredYet, newNotDeliveredYet);
}
