private bool Apply()
{
// Validate data
bool validData = true;
validData = ValidatePage();
if (validData)
{
// Laterals Gridview
// ... If the gridview is edition mode
if (grdLaterals.EditIndex >= 0)
{
grdLaterals.UpdateRow(grdLaterals.EditIndex, true);
}
// Save Lateral data
GrdFLAddLateralsNewAdd();
// Catalysts Gridview
if (ckbxWetOutDataIncludeWetOutInformation.Checked)
{
// ... If the gridview is edition mode
if (grdCatalysts.EditIndex >= 0)
{
grdCatalysts.UpdateRow(grdCatalysts.EditIndex, true);
}
// Save Lateral data
GrdCatalystsAdd();
}
// Save data
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
// Get Section Details
// ... FullLengthLiningSectionDetails data
string newStreet = ""; if (tbxStreet.Text != "") newStreet = tbxStreet.Text.Trim();
string newUsmh = ""; if (tbxUSMH.Text != "") newUsmh = tbxUSMH.Text.Trim();
string newDsmh = ""; if (tbxDSMH.Text != "") newDsmh = tbxDSMH.Text.Trim();
string newMapSize = ""; if (tbxMapSize.Text != "") newMapSize = tbxMapSize.Text.Trim();
string newSize = ""; if (tbxConfirmedSize.Text != "") newSize = tbxConfirmedSize.Text.Trim();
string newThickness = ""; if (ddlThickness.SelectedValue != "") newThickness = ddlThickness.SelectedValue;
string newMapLength = ""; if (tbxMapLength.Text != "") newMapLength = tbxMapLength.Text.Trim();
string newSteelTapeThroughSewer = "";
string newLength = "";
if (tbxM1DataSteelTapeThroughSewer.Text != "")
{
newSteelTapeThroughSewer = tbxM1DataSteelTapeThroughSewer.Text.Trim();
newLength = tbxM1DataSteelTapeThroughSewer.Text.Trim();
}
int? newLaterals = null; if (tbxLaterals.Text != "") newLaterals = Int32.Parse(tbxLaterals.Text.Trim());
int? newLiveLaterals = null; if (tbxLiveLaterals.Text != "") newLiveLaterals = Int32.Parse(tbxLiveLaterals.Text.Trim());
// Get m1 data
// ... assetSewerSection data
string newUsmhDepth = ""; if ((tbxM1DataUsmhDepth.Text != "") && (tbxUSMH.Text != "")) newUsmhDepth = tbxM1DataUsmhDepth.Text.Trim();
string newDsmhDepth = ""; if ((tbxM1DataDsmhDepth.Text != "") && (tbxDSMH.Text != "")) newDsmhDepth = tbxM1DataDsmhDepth.Text.Trim();
// ... lfsAssetSewerSection data
string newUsmhMouth12 = ""; if ((tbxM1DataUsmhMouth12.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth12 = tbxM1DataUsmhMouth12.Text.Trim();
string newUsmhMouth1 = ""; if ((tbxM1DataUsmhMouth1.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth1 = tbxM1DataUsmhMouth1.Text.Trim();
string newUsmhMouth2 = ""; if ((tbxM1DataUsmhMouth2.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth2 = tbxM1DataUsmhMouth2.Text.Trim();
string newUsmhMouth3 = ""; if ((tbxM1DataUsmhMouth3.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth3 = tbxM1DataUsmhMouth3.Text.Trim();
string newUsmhMouth4 = ""; if ((tbxM1DataUsmhMouth4.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth4 = tbxM1DataUsmhMouth4.Text.Trim();
string newUsmhMouth5 = ""; if ((tbxM1DataUsmhMouth5.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth5 = tbxM1DataUsmhMouth5.Text.Trim();
string newDsmhMouth12 = ""; if ((tbxM1DataDsmhMouth12.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth12 = tbxM1DataDsmhMouth12.Text.Trim();
string newDsmhMouth1 = ""; if ((tbxM1DataDsmhMouth1.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth1 = tbxM1DataDsmhMouth1.Text.Trim();
string newDsmhMouth2 = ""; if ((tbxM1DataDsmhMouth2.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth2 = tbxM1DataDsmhMouth2.Text.Trim();
string newDsmhMouth3 = ""; if ((tbxM1DataDsmhMouth3.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth3 = tbxM1DataDsmhMouth3.Text.Trim();
string newDsmhMouth4 = ""; if ((tbxM1DataDsmhMouth4.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth4 = tbxM1DataDsmhMouth4.Text.Trim();
string newDsmhMouth5 = ""; if ((tbxM1DataDsmhMouth5.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth5 = tbxM1DataDsmhMouth5.Text.Trim();
string newGeneralSubArea = ""; if (tbxGeneralSubArea.Text != "") newGeneralSubArea = tbxGeneralSubArea.Text.Trim();
// ... assetSewerMH data
string newUsmhAddress = ""; if (tbxM1DataUsmhAddress.Text != "") newUsmhAddress = tbxM1DataUsmhAddress.Text.Trim();
string newDsmhAddress = ""; if (tbxM1DataDsmhAddress.Text != "") newDsmhAddress = tbxM1DataDsmhAddress.Text.Trim();
// Update section details
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.Update(workId, assetId, newStreet, newMapSize, newSize, newMapLength, newLength, newLaterals, newLiveLaterals, newUsmhDepth, newDsmhDepth, newSteelTapeThroughSewer, newUsmhMouth12, newUsmhMouth1, newUsmhMouth2, newUsmhMouth3, newUsmhMouth4, newUsmhMouth5, newDsmhMouth12, newDsmhMouth1, newDsmhMouth2, newDsmhMouth3, newDsmhMouth4, newDsmhMouth5, newUsmh, newDsmh, newUsmhAddress, newDsmhAddress, newGeneralSubArea, newThickness);
// Get generalData
// ... Ra new data
DateTime? newPreFlushDate = null;
if (tkrdpGeneralPreFlushDate.Visible == true)
{
if (tkrdpGeneralPreFlushDate.SelectedDate.HasValue)
{
newPreFlushDate = tkrdpGeneralPreFlushDate.SelectedDate.Value;
}
}
else
{
if (tkrdpGeneralPreFlushDateReadOnly.SelectedDate.HasValue)
{
newPreFlushDate = tkrdpGeneralPreFlushDateReadOnly.SelectedDate.Value;
}
}
DateTime? newPreVideoDate = null;
if (tkrdpGeneralPreVideoDate.Visible == true)
{
if (tkrdpGeneralPreVideoDate.SelectedDate.HasValue)
{
newPreVideoDate = tkrdpGeneralPreVideoDate.SelectedDate.Value;
}
}
else
{
if (tkrdpGeneralPreVideoDateReadOnly.SelectedDate.HasValue)
{
newPreVideoDate = tkrdpGeneralPreVideoDateReadOnly.SelectedDate.Value; ;
}
}
// ... FullLengthLining data
string newGeneralClientId = ""; if (tbxGeneralClientId.Text != "") newGeneralClientId = tbxGeneralClientId.Text.Trim();
DateTime? newGeneralProposedLiningDate = null; if (tkrdpGeneralProposedLiningDate.SelectedDate.HasValue) newGeneralProposedLiningDate = tkrdpGeneralProposedLiningDate.SelectedDate.Value;
DateTime? newGeneralDeadlineLiningDate = null; if (tkrdpGeneralDeadlineLiningDate.SelectedDate.HasValue) newGeneralDeadlineLiningDate = tkrdpGeneralDeadlineLiningDate.SelectedDate.Value;
DateTime? newGeneralP1Date = null; if (tkrdpPrepDataP1Date.SelectedDate.HasValue) newGeneralP1Date = tkrdpPrepDataP1Date.SelectedDate.Value;
DateTime? newGeneralM1Date = null; if (tkrdpM1DataM1Date.SelectedDate.HasValue) newGeneralM1Date = tkrdpM1DataM1Date.SelectedDate.Value;
DateTime? newGeneralM2Date = null; if (tkrdpM2DataM2Date.SelectedDate.HasValue) newGeneralM2Date = tkrdpM2DataM2Date.SelectedDate.Value;
DateTime? newGeneralInstallDate = null; if (tkrdpInstallDataInstallDate.SelectedDate.HasValue) newGeneralInstallDate = tkrdpInstallDataInstallDate.SelectedDate.Value;
DateTime? newGeneralFinalVideo = null; if (tkrdpInstallDataFinalVideoDate.SelectedDate.HasValue) newGeneralFinalVideo = tkrdpInstallDataFinalVideoDate.SelectedDate.Value;
bool newGeneralIssueIdentified = ckbxGeneralIssueIdentified.Checked;
bool newGeneralLfsIssue = ckbxGeneralLfsIssue.Checked;
bool newGeneralClientIssue = ckbxGeneralClientIssue.Checked;
bool newGeneralSalesIssue = ckbxGeneralSalesIssue.Checked;
bool newGeneralIssueGivenToClient = ckbxGeneralIssueGivenToClient.Checked;
bool newGeneralIssueResolved = ckbxGeneralIssueResolved.Checked;
bool newGeneralIssueInvestigation = ckbxGeneralIssueInvestigation.Checked;
int? newPrepDataCXIsRemoved = null; if (tbxPrepDataCXIsRemoved.Text != "") newPrepDataCXIsRemoved = Int32.Parse(tbxPrepDataCXIsRemoved.Text.Trim());
bool newRoboticPrepCompleted = ckbxPrepDataRoboticPrepCompleted.Checked;
DateTime? newRoboticPrepCompletedDate = null; if (tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.HasValue) newRoboticPrepCompletedDate = tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.Value;
bool newP1Completed = ckbxPrepDataP1Completed.Checked;
// ... WorkFullLengthLiningM1 data
string newMeasurementsTakenBy = ""; if (tbxM1DataMeasurementsTakenBy.Text != "") newMeasurementsTakenBy = tbxM1DataMeasurementsTakenBy.Text.Trim();
string newMaterial = ddlM1DataMaterial.SelectedValue;
string newTrafficControl = ddlM1DataTrafficControl.SelectedValue;
string newSiteDetails = ""; if (ddlM1DataSiteDetails.SelectedValue != "(Select)") newSiteDetails = ddlM1DataSiteDetails.SelectedValue;
bool newPipeSizeChange = ckbxM1DataPipeSizeChange.Checked;
bool newStandardByPass = ckbxM1DataStandardBypass.Checked;
string newStandardBypassComments = ""; if (tbxM1DataStandardBypassComments.Text != "") newStandardBypassComments = tbxM1DataStandardBypassComments.Text.Trim();
string newTrafficControlDetails = ""; if (tbxM1DataTrafficControlDetails.Text != "") newTrafficControlDetails = tbxM1DataTrafficControlDetails.Text.Trim();
string newMeasurementType = ddlM1DataMeasurementType.SelectedValue;
string newMeasuredFromMh = ""; if (tbxM1DataMeasuredFromMh.Visible) newMeasuredFromMh = tbxM1DataMeasuredFromMh.Text; else newMeasuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue;
string newVideoDoneFromMh = ""; if (tbxM1DataVideoDoneFromMh.Visible) newVideoDoneFromMh = tbxM1DataVideoDoneFromMh.Text; else newVideoDoneFromMh = ddlM1DataVideoDoneFromMh.SelectedValue;
string newVideoDoneToMh = ""; if (tbxM1DataVideoDoneToMh.Visible) newVideoDoneToMh = tbxM1DataVideoDoneToMh.Text; else newVideoDoneToMh = ddlM1DataVideoDoneToMh.SelectedValue;
string newAccessType = ""; if (ddlM1DataAccessType.SelectedValue != "(Select)") newAccessType = ddlM1DataAccessType.SelectedValue;
// ... ... For header values
string newVideoLength = tbxVideoLength.Text.Trim();
// ... WorkFullLengthLiningM2 data
string newMeasurementTakenByM2 = tbxM2DataMeasurementsTakenBy.Text.Trim();
bool newDropPipe = ckbxM2DataDropPipe.Checked;
string newDropPipeInvertDepth = tbxM2DataDropPipeInvertdepth.Text.Trim();
int? newCappedLaterals = null; if (tbxM2DataCappedLaterals.Text != "") newCappedLaterals = Int32.Parse(tbxM2DataCappedLaterals.Text.Trim());
string newLineWidthId = ""; if (tbxM2DataLineWidthId.Text != "") newLineWidthId = tbxM2DataLineWidthId.Text.Trim();
string newHydrantAddress = ""; if (tbxM2DataHydrantAddress.Text != "") newHydrantAddress = tbxM2DataHydrantAddress.Text.Trim();
string newHydroWireWithin10FtOfInversionMH = ddlM2DataHydroWireWithin10FtOfInversionMh.SelectedValue.Trim();
string newDistanceToInversionMH = ""; if (tbxM2DataDistanceToInversionMH.Text != "") newDistanceToInversionMH = tbxM2DataDistanceToInversionMH.Text.Trim();
string newSurfaceGrade = ""; if (ddlM2DataSurfaceGrade.SelectedValue != "(Select)") newSurfaceGrade = ddlM2DataSurfaceGrade.SelectedValue;
bool newHydroPulley = cbxM2DataHydroPulley.Checked;
bool newFridgeCart = cbxM2DataFridgeCart.Checked;
bool newTwoPump = cbxM2DataTwoPump.Checked;
bool newSixBypass = cbxM2DataSixBypass.Checked;
bool newScaffolding = cbxM2DataScaffolding.Checked;
bool newWinchExtension = cbxM2DataWinchExtension.Checked;
bool newExtraGenerator = cbxM2DataExtraGenerator.Checked;
bool newGreyCableExtension = cbxM2DataGreyCableExtension.Checked;
bool newEasementMats = cbxM2DataEasementMats.Checked;
bool newRampsRequired = cbxM2DataRampsRequired.Checked;
bool newCameraSkid = cbxM2DataCameraSkid.Checked;
// ... Update work details
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
// ... ... If it doen's have wet out information
if (!ckbxWetOutDataIncludeWetOutInformation.Checked)
{
fullLengthLiningWorkDetails.Update(workId, newGeneralClientId, newGeneralProposedLiningDate, newGeneralDeadlineLiningDate, newGeneralP1Date, newGeneralM1Date, newGeneralM2Date, newGeneralInstallDate, newGeneralFinalVideo, newGeneralIssueIdentified, newGeneralLfsIssue, newGeneralClientIssue, newGeneralSalesIssue, newGeneralIssueGivenToClient, newGeneralIssueResolved, newGeneralIssueInvestigation, newPrepDataCXIsRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementsTakenBy, newMaterial, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardByPass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasuredFromMh, newVideoDoneFromMh, newVideoDoneToMh, newMeasurementTakenByM2, newDropPipe, newDropPipeInvertDepth, newCappedLaterals, newLineWidthId, newHydrantAddress, newHydroWireWithin10FtOfInversionMH, newDistanceToInversionMH, newSurfaceGrade, newHydroPulley, newFridgeCart, newTwoPump, newSixBypass, newScaffolding, newWinchExtension, newExtraGenerator, newGreyCableExtension, newEasementMats, newRampsRequired, newVideoLength, newPreFlushDate, newPreVideoDate, newCameraSkid, newAccessType, newP1Completed);
}
else
{
// Wet out data
string newLinerTuber = "";
int newResinId = 0;
decimal newExcessResin = 0;
string newPoundsDrums = "";
decimal newDrumDiameter = 0;
decimal newHoistMaximumHeight = 0;
decimal newHoistMinimumHeight = 0;
decimal newDownDropTubeLenght = 0;
decimal newPumpHeightAboveGround = 0;
int newTubeResinToFeltFactor = 0;
DateTime newDateOfSheet = DateTime.Now;
int newEmployeeID = 0;
string newRunDetails = "";
string newRunDetails2 = "";
DateTime newWetOutDate = DateTime.Now;
DateTime? newInstallDate = null;
string newInversionThickness = "";
Distance lengthToLine = new Distance("0");
decimal newLengthToLine = 0;
decimal newPlusExtra = 0;
decimal newForTurnOffset = 0;
decimal newLengthToWetOut = 0;
decimal newTubeMaxColdHead = 0;
decimal newTubeMaxColdHeadPsi = 0;
decimal newTubeMaxHotHead = 0;
decimal newTubeMaxHotHeadPsi = 0;
decimal newTubeIdealHead = 0;
decimal newTubeIdealHeadPsi = 0;
decimal newNetResinForTube = 0;
decimal newNetResinForTubeUsgals = 0;
string newNetResinForTubeDrumsIns = "";
decimal newNetResinForTubeLbsFt = 0;
decimal newNetResinForTubeUsgFt = 0;
int newExtraResinForMix = 0;
decimal newExtraLbsForMix = 0;
decimal newTotalMixQuantity = 0;
decimal newTotalMixQuantityUsgals = 0;
string newTotalMixQuantityDrumsIns = "";
string newInversionType = "";
decimal newDepthOfInversionMH = 0;
decimal newTubeForColumn = 0;
decimal newTubeForStartDry = 0;
decimal newTotalTube = 0;
string newDropTubeConnects = "";
decimal newAllowsHeadTo = 0;
decimal newRollerGap = 0;
decimal newHeightNeeded = 0;
string newAvailable = "";
string newHoistHeight = "";
string newCommentsCipp = "";
string newResinLabel = "";
string newDrumContainsLabel = "";
string newLinerTubeLabel = "";
string newForLbDrumsLabel = "";
string newNetResinLabel = "";
string newCatalystLabel = "";
if (ckbxWetOutDataIncludeWetOutInformation.Checked)
{
// .... ... Wet Out Sheet
newLinerTuber = ddlWetOutDataLinerTube.SelectedValue;
newResinId = Int32.Parse(ddlWetOutDataResins.SelectedValue);
newExcessResin = decimal.Round(decimal.Parse(tbxWetOutDataExcessResin.Text), 1);
newPoundsDrums = ddlWetOutDataPoundsDrums.SelectedValue;
newDrumDiameter = decimal.Round(decimal.Parse(tbxWetOutDataDrumDiameter.Text), 1);
newHoistMaximumHeight = decimal.Round(decimal.Parse(tbxWetOutDataHoistMaximumHeight.Text), 0);
newHoistMinimumHeight = decimal.Round(decimal.Parse(tbxWetOutDataHoistMinimumHeight.Text), 0);
newDownDropTubeLenght = decimal.Round(decimal.Parse(tbxWetOutDataDownDropTubeLength.Text), 0);
newPumpHeightAboveGround = decimal.Round(decimal.Parse(tbxWetOutDataPumpHeightAboveGround.Text), 2);
newTubeResinToFeltFactor = Int32.Parse(tbxWetOutDataTubeResinToFeltFactor.Text);
newDateOfSheet = DateTime.Parse(tbxWetOutDataDateOfSheet.Text);
newEmployeeID = Int32.Parse(ddlWetOutDataMadeBy.SelectedValue);
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
newRunDetails = newRunDetails + lst.Value + ">";
}
}
newRunDetails = newRunDetails.Substring(0, newRunDetails.Length - 1);
newRunDetails2 = ddlWetOutDataRunDetails2.SelectedValue;
newWetOutDate = (DateTime)tkrdpWetOutDataWetOutDate.SelectedDate;
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
newInstallDate = (DateTime)tkrdpInstallDataInstallDate.SelectedDate;
}
newInversionThickness = ddlThickness.SelectedValue;
lengthToLine = new Distance(tbxWetOutDataLengthToLine.Text);
newLengthToLine = decimal.Round(decimal.Parse(lengthToLine.ToStringInEng3()), 1);
newPlusExtra = decimal.Round(decimal.Parse(tbxWetOutDataPlusExtra.Text), 0);
newForTurnOffset = decimal.Round(decimal.Parse(tbxWetOutDataForTurnOffset.Text), 0);
newLengthToWetOut = decimal.Round(decimal.Parse(tbxWetOutDataLengthtToWetOut.Text), 1);
newTubeMaxColdHead = decimal.Round(decimal.Parse(tbxWetOutDataTubeMaxColdHead.Text), 1);
newTubeMaxColdHeadPsi = decimal.Round(decimal.Parse(tbxWetOutDataTubeMaxColdHeadPSI.Text), 1);
newTubeMaxHotHead = decimal.Round(decimal.Parse(tbxWetOutDataTubeMaxHotHead.Text), 1);
newTubeMaxHotHeadPsi = decimal.Round(decimal.Parse(tbxWetOutDataTubeMaxHotHeadPSI.Text), 1);
newTubeIdealHead = decimal.Round(decimal.Parse(tbxWetOutDataTubeIdealHead.Text), 1);
newTubeIdealHeadPsi = decimal.Round(decimal.Parse(tbxWetOutDataTubeIdealHeadPSI.Text), 1);
newNetResinForTube = decimal.Round(decimal.Parse(tbxWetOutDataNetResinForTube.Text), 0);
newNetResinForTubeUsgals = decimal.Round(decimal.Parse(tbxWetOutDataNetResinForTubeUsgals.Text), 1);
newNetResinForTubeDrumsIns = tbxWetOutDataNetResinForTubeDrumsIns.Text;
newNetResinForTubeLbsFt = decimal.Round(decimal.Parse(tbxWetOutDataNetResinForTubeLbsFt.Text), 2);
newNetResinForTubeUsgFt = decimal.Round(decimal.Parse(tbxWetOutDataNetResinForTubeUsgFt.Text), 3);
newExtraResinForMix = Int32.Parse(tbxWetOutDataExtraResinForMix.Text);
newExtraLbsForMix = decimal.Round(decimal.Parse(tbxWetOutDataExtraLbsForMix.Text), 2);
newTotalMixQuantity = decimal.Round(decimal.Parse(tbxWetOutDataTotalMixQuantity.Text), 0);
newTotalMixQuantityUsgals = decimal.Round(decimal.Parse(tbxWetOutDataTotalMixQuantityUsgals.Text), 1);
newTotalMixQuantityDrumsIns = tbxWetOutDataTotalMixQuantityDrumsIns.Text;
newInversionType = ddlWetOutDataInversionType.SelectedValue;
newDepthOfInversionMH = decimal.Round(decimal.Parse(tbxWetOutDataDepthOfInversionMH.Text), 0);
newTubeForColumn = decimal.Round(decimal.Parse(tbxWetOutDataTubeForColumn.Text), 0);
newTubeForStartDry = decimal.Round(decimal.Parse(tbxWetOutDataTubeForStartDry.Text), 0);
newTotalTube = decimal.Round(decimal.Parse(tbxWetOutDataTotalTube.Text), 1);
newDropTubeConnects = tbxWetOutDataDropTubeConnects.Text;
newAllowsHeadTo = decimal.Round(decimal.Parse(tbxWetOutDataAllowsHeadTo.Text), 0);
newRollerGap = decimal.Round(decimal.Parse(tbxWetOutDataRollerGap.Text), 0);
newHeightNeeded = decimal.Round(decimal.Parse(tbxWetOutDataHeightNeeded.Text), 0);
newAvailable = tbxWetOutDataAvailable.Text;
newHoistHeight = tbxWetOutDataHoistHeight.Text;
newCommentsCipp = tbxWetOutDataNotes.Text;
newResinLabel = lblWetOutDataResinGray.Text;
newDrumContainsLabel = lblWetOutDataDrumContainsGray.Text;
newLinerTubeLabel = lblWetOutDataLinerTubeGray.Text;
newForLbDrumsLabel = lblWetOutDataLbDrumsGrey.Text;
newNetResinLabel = lblWetOutDataNetResinGrey.Text;
newCatalystLabel = lblWetOutDataCatalystGrey.Text;
}
// Inversion data
string newInversionComment = "";
string newPipeType = "";
string newPipeCondition = "";
string newGroundMoisture = "";
decimal newBoilerSize = 0;
decimal newPumpTotalCapacity = 0;
decimal newLayFlatSize = 0;
decimal newLayFlatQuantityTotal = 0;
decimal newWaterStartTemp = 0;
decimal newTemp1 = 0;
decimal newHoldAtT1 = 0;
decimal newTempT2 = 0;
decimal newCookAtT2 = 0;
decimal newCoolDownFor = 0;
decimal newCoolToTemp = 0;
decimal newDropInPipeRun = 0;
decimal newPipeSlopOf = 0;
decimal newF45F120 = 0;
decimal newHold = 0;
decimal newF120F185 = 0;
decimal newCookTime = 0;
decimal newCoolTime = 0;
decimal newAproxTotal = 0;
decimal newWaterChangesPerHour = 0;
decimal newReturnWaterVelocity = 0;
decimal newLayflatBackPressure = 0;
decimal newPumpLiftAtIdealHead = 0;
decimal newWaterToFillLinerColumn = 0;
decimal newWaterPerFit = 0;
string newInstallationResults = "";
string newInversionLinerTubeLabel = "";
string newHeadsIdealLabel = "";
string newPumpingAndCirculationLabel = "";
if ((ckbxInversionDataIncludeInversionInformation.Checked) && (ckbxWetOutDataIncludeWetOutInformation.Checked))
{
// .... ... Inversion data
newInversionComment = tbxInversionDataCommentsEdit.Text;
newPipeType = ddlInversionDataInversionPipeType.SelectedValue;
newPipeCondition = ddlInversionDataPipeCondition.SelectedValue;
newGroundMoisture = ddlInversionDataGroundMoisture.SelectedValue;
newBoilerSize = decimal.Round(decimal.Parse(tbxInversionDataBoilerSize.Text), 0);
newPumpTotalCapacity = decimal.Round(decimal.Parse(tbxInversionDataPumpsTotalCapacity.Text), 0);
newLayFlatSize = decimal.Round(decimal.Parse(tbxInversionDataLayflatSize.Text), 0);
newLayFlatQuantityTotal = decimal.Round(decimal.Parse(tbxInversionDataLayflatQuantityTotal.Text), 0);
newWaterStartTemp = decimal.Round(decimal.Parse(tbxInversionDataWaterStartTempTs.Text), 0);
newTemp1 = decimal.Round(decimal.Parse(tbxInversionDataTempT1.Text), 0);
newHoldAtT1 = decimal.Round(decimal.Parse(tbxInversionDataHoldAtT1For.Text), 1);
newTempT2 = decimal.Round(decimal.Parse(tbxInversionDataTempT2.Text), 0);
newCookAtT2 = decimal.Round(decimal.Parse(tbxInversionDataCookAtT2For.Text), 0);
newCoolDownFor = decimal.Round(decimal.Parse(tbxInversionDataCoolDownFor.Text), 0);
newCoolToTemp = decimal.Round(decimal.Parse(tbxInversionDataCoolToTemp.Text), 0);
newDropInPipeRun = decimal.Round(decimal.Parse(tbxInversionDataDropInPipeRun.Text), 1);
newPipeSlopOf = decimal.Round(decimal.Parse(tbxInversionDataPipeSlopeOf.Text), 2);
newF45F120 = decimal.Round(decimal.Parse(tbxInversionData45F120F.Text), 1);
newHold = decimal.Round(decimal.Parse(tbxInversionDataHold.Text), 1);
newF120F185 = decimal.Round(decimal.Parse(tbxInversionData120F185F.Text), 1);
newCookTime = decimal.Round(decimal.Parse(tbxInversionDataCookTime.Text), 1);
newCoolTime = decimal.Round(decimal.Parse(tbxInversionDataCoolTime.Text), 1);
newAproxTotal = decimal.Round(decimal.Parse(tbxInversionDataAproxTotal.Text), 1);
newWaterChangesPerHour = decimal.Round(decimal.Parse(tbxInversionDataWaterChangesPerHour.Text), 2);
newReturnWaterVelocity = decimal.Round(decimal.Parse(tbxInversionDataReturnWaterVelocity.Text), 2);
newLayflatBackPressure = decimal.Round(decimal.Parse(tbxInversionDataLayflatBackPressure.Text), 1);
newPumpLiftAtIdealHead = decimal.Round(decimal.Parse(tbxInversionDataPumpLiftAtIdealHead.Text), 1);
newWaterToFillLinerColumn = decimal.Round(decimal.Parse(tbxInversionDataWaterToFillLinerColumn.Text), 0);
newWaterPerFit = decimal.Round(decimal.Parse(tbxInversionDataWaterPerFit.Text), 2);
newInstallationResults = tbxInversionDataNotesAndInstallationResults.Text;
newInversionLinerTubeLabel = lblInversionDataLinerInfoGrey.Text;
newHeadsIdealLabel = lblInversionDataHeadsGrey.Text;
newPumpingAndCirculationLabel = lblInversionDataPumpingCirculationSubtitle.Text;
}
// ... Update
fullLengthLiningWorkDetails.UpdateWithWetOutInformation(workId, newGeneralClientId, newGeneralProposedLiningDate, newGeneralDeadlineLiningDate, newGeneralP1Date, newGeneralM1Date, newGeneralM2Date, newGeneralInstallDate, newGeneralFinalVideo, newGeneralIssueIdentified, newGeneralLfsIssue, newGeneralClientIssue, newGeneralSalesIssue, newGeneralIssueGivenToClient, newGeneralIssueResolved, newGeneralIssueInvestigation, newPrepDataCXIsRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementsTakenBy, newMaterial, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardByPass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasuredFromMh, newVideoDoneFromMh, newVideoDoneToMh, newMeasurementTakenByM2, newDropPipe, newDropPipeInvertDepth, newCappedLaterals, newLineWidthId, newHydrantAddress, newHydroWireWithin10FtOfInversionMH, newDistanceToInversionMH, newSurfaceGrade, newHydroPulley, newFridgeCart, newTwoPump, newSixBypass, newScaffolding, newWinchExtension, newExtraGenerator, newGreyCableExtension, newEasementMats, newRampsRequired, newVideoLength, newPreFlushDate, newPreVideoDate, newCameraSkid, newLinerTuber, newResinId, newExcessResin, newPoundsDrums, newDrumDiameter, newHoistMaximumHeight, newHoistMinimumHeight, newDownDropTubeLenght, newPumpHeightAboveGround, newTubeResinToFeltFactor, newDateOfSheet, newEmployeeID, newRunDetails, newRunDetails2, newWetOutDate, newInstallDate, newInversionThickness, newLengthToLine, newPlusExtra, newForTurnOffset, newLengthToWetOut, newTubeMaxColdHead, newTubeMaxColdHeadPsi, newTubeMaxHotHead, newTubeMaxHotHeadPsi, newTubeIdealHead, newTubeIdealHeadPsi, newNetResinForTube, newNetResinForTubeUsgals, newNetResinForTubeDrumsIns, newNetResinForTubeLbsFt, newNetResinForTubeUsgFt, newExtraResinForMix, newExtraLbsForMix, newTotalMixQuantity, newTotalMixQuantityUsgals, newTotalMixQuantityDrumsIns, newInversionType, newDepthOfInversionMH, newTubeForColumn, newTubeForStartDry, newTotalTube, newDropTubeConnects, newAllowsHeadTo, newRollerGap, newHeightNeeded, newAvailable, newHoistHeight, newCommentsCipp, newResinLabel, newDrumContainsLabel, newLinerTubeLabel, newForLbDrumsLabel, newNetResinLabel, newCatalystLabel, newInversionComment, newPipeType, newPipeCondition, newGroundMoisture, newBoilerSize, newPumpTotalCapacity, newLayFlatSize, newLayFlatQuantityTotal, newWaterStartTemp, newTemp1, newHoldAtT1, newTempT2, newCookAtT2, newCoolDownFor, newCoolToTemp, newDropInPipeRun, newPipeSlopOf, newF45F120, newHold, newF120F185, newCookTime, newCoolTime, newAproxTotal, newWaterChangesPerHour, newReturnWaterVelocity, newLayflatBackPressure, newPumpLiftAtIdealHead, newWaterToFillLinerColumn, newWaterPerFit, newInstallationResults, newInversionLinerTubeLabel, newHeadsIdealLabel, newPumpingAndCirculationLabel, newAccessType, newP1Completed);
}
if (ddlM1DataMaterial.SelectedIndex > 0)
{
LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null);
if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(assetId, newMaterial, companyId))
{
MaterialInformation model = new MaterialInformation(materialInformationTDS);
model.Insert(assetId, newMaterial, DateTime.Now, false, companyId, false);
}
}
// Store datasets
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
Session["materialInformationTDS"] = materialInformationTDS;
// Update database
UpdateDatabase();
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
fullLengthLiningTDS.LateralDetails.Clear();
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
grdLaterals.DataBind();
fullLengthLiningTDS.WetOutCatalystsDetails.Clear();
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId);
grdCatalysts.DataBind();
// ... Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
ViewState["update"] = "yes";
}
return validData;
}
private string GetLateralIdIncrement()
{
// Get Measured From Mh value
int assetId = Int32.Parse(hdfAssetId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
string measuredFromMh = "";
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
if (flLateralDetails.Table.Rows.Count > 0)
{
measuredFromMh = "USMH";
}
else
{
measuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue;
}
// Generate increment
string lateralIdIncrement = "";
FullLengthLiningLateralDetails fullLengthLiningLateraldetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
if (measuredFromMh == "USMH" || measuredFromMh == "")
{
lateralIdIncrement = fullLengthLiningLateraldetails.GetMaxLateralId2();
}
else
{
if (measuredFromMh == "DSMH")
{
lateralIdIncrement = fullLengthLiningLateraldetails.GetMinLateralId2();
}
}
return "FL-"+lateralIdIncrement;
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm8 master = (mForm8)this.Master;
master.ActiveToolbar = "eSewers";
// For error message
hdfErrorFieldList.Value = "";
if ((tbxWetOutDataHoistHeight.Text == "OK")|| (tbxWetOutDataHoistHeight.Text == ""))
{
lblWetOutDataWarning.Visible = false;
}
else
{
lblWetOutDataWarning.Visible = true;
}
// For Video Done From MH and Measured From MH
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
// set visible VideoDoneFromMh and Measured From and To
FullLengthLiningWorkDetailsGateway flWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
flWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
if (Int32.Parse(tbxLaterals.Text) > 0)
{
ddlM1DataVideoDoneFromMh.Visible = false;
tbxM1DataVideoDoneFromMh.Visible = true;
tbxM1DataVideoDoneFromMh.Text = ddlM1DataVideoDoneFromMh.SelectedValue;
ddlM1DataVideoDoneToMh.Visible = false;
tbxM1DataVideoDoneToMh.Visible = true;
tbxM1DataVideoDoneToMh.Text = ddlM1DataVideoDoneToMh.SelectedValue;
ddlM1DataMeasuredFromMh.Visible = false;
tbxM1DataMeasuredFromMh.Visible = true;
tbxM1DataMeasuredFromMh.Text = ddlM1DataMeasuredFromMh.SelectedValue;
btnClear.Visible = false;
}
else
{
ddlM1DataVideoDoneFromMh.Visible = true;
tbxM1DataVideoDoneFromMh.Visible = false;
ddlM1DataVideoDoneToMh.Visible = true;
tbxM1DataVideoDoneToMh.Visible = false;
ddlM1DataMeasuredFromMh.Visible = true;
tbxM1DataMeasuredFromMh.Visible = false;
btnClear.Visible = true;
}
// For materials (m1)
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
ddlM1DataMaterial.SelectedValue = materialInformationGateway.GetLastMaterialType(assetId);
}
// For PreFlush Date and PreVideo Date
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, companyId);
int? raProjectId = fullLengthLiningWorkDetailsGateway.GetRaProjectId(workId);
if ((raProjectId.HasValue) && (raProjectId == projectId))
{
// ... if ra data is from the same project
tkrdpGeneralPreFlushDate.Visible = true;
tkrdpGeneralPreVideoDate.Visible = true;
tkrdpGeneralPreFlushDateReadOnly.Visible = false;
tkrdpGeneralPreVideoDateReadOnly.Visible = false;
}
else
{
tkrdpGeneralPreFlushDate.Visible = false;
tkrdpGeneralPreVideoDate.Visible = false;
tkrdpGeneralPreFlushDateReadOnly.Visible = true;
tkrdpGeneralPreVideoDateReadOnly.Visible = true;
}
// ... if there is no data
if (tkrdpGeneralPreFlushDate.SelectedDate.HasValue)
{
tkrdpGeneralPreFlushDate.Calendar.Enabled = false;
tkrdpGeneralPreFlushDate.DateInput.ReadOnly = true;
}
else
{
tkrdpGeneralPreFlushDate.Calendar.Enabled = true;
tkrdpGeneralPreFlushDate.DateInput.ReadOnly = false;
}
if (tkrdpGeneralPreVideoDate.SelectedDate.HasValue)
{
tkrdpGeneralPreVideoDate.Calendar.Enabled = false;
tkrdpGeneralPreVideoDate.DateInput.ReadOnly = true;
}
else
{
tkrdpGeneralPreVideoDate.Calendar.Enabled = true;
tkrdpGeneralPreVideoDate.DateInput.ReadOnly = false;
}
// Hide or show the Old CWP ID field
if (tbxOldCwpId.Text == "")
{
lblOldCwpId.Visible = false;
tbxOldCwpId.Visible = false;
}
if (tbxFlowSectionId.Text == "")
{
LoadFullLengthLiningData(currentProjectId, assetId, companyId);
}
// Validate tools
if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"]))
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = true; // Resins option
tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Catalyst option
tkrdpInstallDataInstallDate.Enabled = true;
tkrdpInstallDataFinalVideoDate.Enabled = true;
}
else
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Resins option
tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Catalyst option
tkrdpInstallDataInstallDate.Enabled = false;
tkrdpInstallDataFinalVideoDate.Enabled = false;
}
}
protected void tbxVideoLength_TextChanged(object sender, EventArgs e)
{
int workId = Int32.Parse(hdfWorkId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
string videoLength = tbxVideoLength.Text.Trim();
// Update distance from dsmh and reverse setup
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.UpdateLengthReverseSetup(workId, assetId, videoLength);
// Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
for (int i = 0; i < grdLaterals.Rows.Count; i++)
{
if ((grdLaterals.Rows[i].RowType == DataControlRowType.DataRow) && ((grdLaterals.Rows[i].RowState == DataControlRowState.Normal) || (grdLaterals.Rows[i].RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
// Reverse Setup calculation
string videoDistance = ((TextBox)grdLaterals.Rows[i].Cells[2].FindControl("tbxVideoDistance")).Text.Trim();
string reverseSetup = "";
if (videoDistance != "")
{
Distance videoLengthD = new Distance(tbxVideoLength.Text.Trim());
Distance videoDistanceD = new Distance(videoDistance);
Distance reverseSetupD = videoLengthD - videoDistanceD;
switch (videoDistanceD.DistanceType)
{
case 1:
reverseSetup = reverseSetupD.ToStringInEng1();
break;
case 2:
reverseSetup = reverseSetupD.ToStringInEng2();
break;
case 3:
reverseSetup = reverseSetupD.ToStringInEng3();
break;
case 4:
reverseSetup = reverseSetupD.ToStringInMet1();
break;
case 5:
reverseSetup = reverseSetupD.ToStringInMil1();
break;
}
}
reverseSetup = GetDistance(reverseSetup);
((TextBox)grdLaterals.Rows[i].Cells[2].FindControl("tbxReverseSetup")).Text = reverseSetup;
}
}
}
protected void grdLaterals_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("AddLateralsEdit");
if (Page.IsValid)
{
if (((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlLiveEdit")).Visible == true)
{
Page.Validate("AddLateralsEditSpecial");
}
if (Page.IsValid)
{
int lateral = int.Parse(((Label)grdLaterals.Rows[e.RowIndex].Cells[1].FindControl("lblLateral")).Text.Trim());
string lateralId = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxLateralIdEdit")).Text.Trim();
string clientLateralId = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxClientLateralIdEdit")).Text.Trim();
string size = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxSizeEdit")).Text.Trim();
// Load material
string material = "";
material = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlMaterialEdit")).SelectedValue;
// Load lateral state
string live = "";
if (((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxJlLive")).Visible == true)
{
live = "Live";
}
else
{
if (((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlLiveEdit")).Visible == true)
{
live = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlLiveEdit")).SelectedValue.Trim();
}
}
string videoDistance = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxVideoDistanceEdit")).Text.Trim();
string clockPosition = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxClockPositionEdit")).Text.Trim();
string distanceToCentre = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxDistanceToCentreEdit")).Text.Trim();
string timeOpened = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxTimeOpenedEdit")).Text.Trim();
// Reverse Setup calculation
string reverseSetup = "";
if (videoDistance != "")
{
Distance videoLength = new Distance(tbxVideoLength.Text.Trim());
Distance videoDistanceD = new Distance(videoDistance);
Distance reverseSetupD = videoLength - videoDistanceD;
switch (videoDistanceD.DistanceType)
{
case 1:
reverseSetup = reverseSetupD.ToStringInEng1();
break;
case 2:
reverseSetup = reverseSetupD.ToStringInEng2();
break;
case 3:
reverseSetup = reverseSetupD.ToStringInEng3();
break;
case 4:
reverseSetup = reverseSetupD.ToStringInMet1();
break;
case 5:
reverseSetup = reverseSetupD.ToStringInMil1();
break;
}
}
DateTime? reinstate = null;
if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpReinstateEdit")).SelectedDate.HasValue)
{
reinstate = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpReinstateEdit")).SelectedDate.Value;
}
string comments = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxCommentsEdit")).Text.Trim();
bool inProject = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[3].FindControl("cbxInProject")).Checked;
string connectionType = ""; connectionType = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlConnectionTypeEdit")).SelectedValue;
string mn = ""; mn = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxMnEdit")).Text.Trim();
string clientInspectionNo = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxclientInspectionNoEdit")).Text.Trim();
bool requiredRoboticPrep = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxRequiresRoboticPrepEdit")).Checked;
DateTime? requiredRoboticPrepDate = null;
if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpRequiresRoboticPrepDateEdit")).SelectedDate.HasValue)
{
requiredRoboticPrepDate = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpRequiresRoboticPrepDateEdit")).SelectedDate.Value;
}
bool holdClientIssue = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxHoldClientIssueEdit")).Checked;
bool holdLFSIssue = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxHoldLFSIssueEdit")).Checked;
string flange = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlFlangeEdit")).SelectedValue;
bool lineLateral = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("cbxJlEdit")).Checked; ;
bool dyeTestReq = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxDyeTestReqEdit")).Checked;
DateTime? dyeTestComplete = null;
if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpDyeTestCompleteEdit")).SelectedDate.HasValue)
{
dyeTestComplete = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpDyeTestCompleteEdit")).SelectedDate.Value;
}
// Update
FullLengthLiningLateralDetails lateralModel = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
lateralModel.Update(lateral, lateralId, size, material, live, videoDistance, clockPosition, distanceToCentre, timeOpened, reverseSetup, reinstate, comments, inProject, clientLateralId, connectionType, mn, clientInspectionNo, requiredRoboticPrep, requiredRoboticPrepDate, holdClientIssue, holdLFSIssue, lineLateral, flange, lineLateral, dyeTestReq, dyeTestComplete);
tbxLaterals.Text = lateralModel.GetTotalLaterals().ToString();
tbxLiveLaterals.Text = lateralModel.GetLiveLaterals().ToString();
// Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
// Update JL lateral issues
FLLateralsSave(lateralId, requiredRoboticPrep, requiredRoboticPrepDate, holdClientIssue, holdLFSIssue, dyeTestReq, dyeTestComplete);
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
bool isFromTabClick = false;
if (!IsPostBack)
{
if (!isFromTabClick)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_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_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in fl_edit.aspx");
}
// Tag Page
TagPage();
// Prepare initial data
Session.Remove("flAddLateralsNewDummy");
Session.Remove("wetOutCatalystsDetailsDummy");
Session.Remove("materialInformationTDS");
materialInformationTDS = new MaterialInformationTDS();
// ... for wet out section list
AssetSewerSectionList assetSewerSectionList = new AssetSewerSectionList();
assetSewerSectionList.LoadAndAddItem(Int32.Parse(hdfCurrentProjectId.Value), hdfWorkType.Value, "-1", "(All)", Int32.Parse(hdfCompanyId.Value));
cbxlSectionId.DataSource = assetSewerSectionList.Table;
cbxlSectionId.DataValueField = "SectionID";
cbxlSectionId.DataTextField = "FlowOrderID";
cbxlSectionId.DataBind();
cbxlInversionDataSectionId.DataSource = assetSewerSectionList.Table;
cbxlInversionDataSectionId.DataValueField = "SectionID";
cbxlInversionDataSectionId.DataTextField = "FlowOrderID";
cbxlInversionDataSectionId.DataBind();
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int workId = Int32.Parse(hdfWorkId.Value.Trim());
string workType = hdfWorkType.Value;
// ... fl_navigator2.aspx
if (Request.QueryString["source_page"] == "fl_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedFll"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
fullLengthLiningTDS = new FullLengthLiningTDS();
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabFll"];
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
}
// ... Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
// ... fl_summary.aspx or fl_edit.aspx
if ((Request.QueryString["source_page"] == "fl_summary.aspx") || (Request.QueryString["source_page"] == "fl_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Restore dataset
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedFll"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabFll"];
}
if (ViewState["update"].ToString().Trim() == "yes")
{
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId);
// ... Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
}
// Prepare initial data
lblMissingData.Visible = false;
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcFlDetails.ActiveTabIndex = activeTab;
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section";
// ... Data for current full length lining work
LoadFullLengthLiningData(currentProjectId, assetId, companyId);
// Databind
Page.DataBind();
// Especial load for Run details
string runDetails = hdfRunDetails.Value;
WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway();
workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId);
// ... Verify if work has cipp information to load run details
if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0)
{
string[] runDetailsList = runDetails.Split('>');
for (int i = 0; i < runDetailsList.Length; i++)
{
cbxlSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
cbxlInversionDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
}
}
else
{
if (cbxlSectionId.Items.Count > 1)
{
cbxlSectionId.Items.FindByValue(runDetails).Selected = true;
}
}
// SelectIndex for grids
((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedIndex = 0;
((DropDownList)grdCatalysts.FooterRow.FindControl("ddlNameFooter")).SelectedIndex = 0;
// For usmh, dsmh autocomplete
string provinceId_ = "0"; if (hdfProvinceId.Value != "") provinceId_ = hdfProvinceId.Value;
string countyId_ = "0"; if (hdfCountyId.Value != "") countyId_ = hdfCountyId.Value;
string cityId_ = "0"; if (hdfCityId.Value != "") cityId_ = hdfCityId.Value;
aceUsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value;
aceDsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value;
// Make Wetout tab visible
if (ckbxWetOutDataIncludeWetOutInformation.Checked)
{
pnlVisibleInformation.Visible = true;
upnlVisibleInformation.Update();
}
else
{
pnlVisibleInformation.Visible = false;
upnlVisibleInformation.Update();
}
// Make inversion tab visible
lblInversionDataInversionMissingData.Visible = false;
uplInversionDataInversionMissingData.Update();
if (ckbxInversionDataIncludeInversionInformation.Checked)
{
// ... ... visible only if wet out information is provided.
if (!ckbxWetOutDataIncludeWetOutInformation.Checked)
{
pnlInversionVisibleInformation.Visible = false;
upnlInversionVisibleInformation.Update();
}
else
{
pnlInversionVisibleInformation.Visible = true;
upnlInversionVisibleInformation.Update();
}
}
else
{
pnlInversionVisibleInformation.Visible = false;
upnlInversionVisibleInformation.Update();
}
// Load Materials
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS);
materialInformationGateway.LoadAllByAssetId(assetId, companyId);
materialInformation = materialInformationTDS.MaterialInformation;
Session["materialInformationTDS"] = materialInformationTDS;
}
}
else
{
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
flatSectionJlTDSForFLL = (FlatSectionJlTDS)Session["flatSectionJlTDSForFLL"];
materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"];
materialInformation = materialInformationTDS.MaterialInformation;
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcFlDetails.ActiveTabIndex = activeTab;
}
}
protected void cvMeasuredFromMH_ServerValidate(object source, ServerValidateEventArgs args)
{
int assetId = Int32.Parse(hdfAssetId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
if (flLateralDetails.Table.Rows.Count > 0)
{
args.IsValid = true;
}
else
{
if (ddlM1DataMeasuredFromMh.SelectedValue == "")
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
}
private void Delete()
{
Page.Validate();
if (Page.IsValid)
{
// Delete full length lining
int workId = Int32.Parse(hdfWorkId.Value);
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.Delete(workId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.DeleteAll(workId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.Delete(workId);
// Update databse
UpdateDatabase();
// Store datasets
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
// Redirect
string url = "";
url = "./fl_navigator2.aspx?source_page=fl_delete.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + GetNavigatorState() + "&update=yes";
Response.Redirect(url);
}
}
protected void cvLateralId_ServerValidate(object source, ServerValidateEventArgs args)
{
FullLengthLiningLateralDetails model = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
// Initialize
CustomValidator cvLateralId = (CustomValidator)source;
args.IsValid = true;
// Verify in this step
if (model.ExistsByLateralId(args.Value))
{
cvLateralId.Text = "Duplicated lateral. (you already have this lateral here)";
args.IsValid = false;
}
}
protected void cvLateralsMaxNumber_ServerValidate(object source, ServerValidateEventArgs args)
{
// Get Measured From Mh value
int assetId = Int32.Parse(hdfAssetId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
string measuredFromMh = "";
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
if (flLateralDetails.Table.Rows.Count > 0)
{
measuredFromMh = "USMH";
}
else
{
measuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue;
}
// Generate increment
FullLengthLiningLateralDetails fullLengthLiningLateraldetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
if (measuredFromMh == "USMH" || measuredFromMh == "")
{
if (fullLengthLiningLateraldetails.GetMaxLateralId2() == "A[") args.IsValid = false; else args.IsValid = true;
}
else
{
if (measuredFromMh == "DSMH")
{
if (fullLengthLiningLateraldetails.GetMinLateralId2() == "@") args.IsValid = false; else args.IsValid = true;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_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_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in fl_summary.aspx");
}
// Tag Page
TagPage();
Session.Remove("flAddLateralsNewDummy");
Session.Remove("wetOutCatalystsDetailsDummy");
// If comming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
string workType = hdfWorkType.Value;
int workId = Int32.Parse(hdfWorkId.Value);
// ... fl_navigator2.aspx
if (Request.QueryString["source_page"] == "fl_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// Set initial tab
if ((string)Session["dialogOpenedFll"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
fullLengthLiningTDS = new FullLengthLiningTDS();
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabFll"];
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
}
tcFlDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
// Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
// ... fl_delete.aspx or fl_edit.aspx
if ((Request.QueryString["source_page"] == "fl_delete.aspx") || (Request.QueryString["source_page"] == "fl_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedFll"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabFll"];
}
tcFlDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
}
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section";
// ... for wet out section list
AssetSewerSectionList assetSewerSectionList = new AssetSewerSectionList();
assetSewerSectionList.LoadAndAddItem(Int32.Parse(hdfCurrentProjectId.Value), hdfWorkType.Value, "-1", "(All)", Int32.Parse(hdfCompanyId.Value));
cbxlWetOutDataSectionId.DataSource = assetSewerSectionList.Table;
cbxlWetOutDataSectionId.DataValueField = "SectionID";
cbxlWetOutDataSectionId.DataTextField = "FlowOrderID";
cbxlWetOutDataSectionId.DataBind();
cbxlInversionDataSectionId.DataSource = assetSewerSectionList.Table;
cbxlInversionDataSectionId.DataValueField = "SectionID";
cbxlInversionDataSectionId.DataTextField = "FlowOrderID";
cbxlInversionDataSectionId.DataBind();
// ... Data for current full length lining work
LoadFullLengthLiningData(currentProjectId, assetId, companyId);
// Databind
Page.DataBind();
// Especial load for Run details
string runDetails = hdfRunDetails.Value;
WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway();
workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId);
// ... Verify if work has cipp information to load run details
if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0)
{
string[] runDetailsList = runDetails.Split('>');
for (int i = 0; i < runDetailsList.Length; i++)
{
cbxlWetOutDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
cbxlInversionDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
}
}
else
{
if (cbxlWetOutDataSectionId.Items.Count > 1)
{
cbxlWetOutDataSectionId.Items.FindByValue(hdfSectionId.Value).Selected = true;
}
}
}
else
{
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcFlDetails.ActiveTabIndex = activeTab;
// Load summary for inversionfield cure record
int companyId =Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
FlInversionFieldCureRecord FlInversionFieldCureRecordForSummary = new FlInversionFieldCureRecord();
FlInversionFieldCureRecordForSummary.Load(workId, companyId);
if (FlInversionFieldCureRecordForSummary.Table.Rows.Count > 0)
{
lblInversionDataFieldCureRecordSummary.Text = FlInversionFieldCureRecordForSummary.GetSummary();
}
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="projectId">projectId</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>
/// <param name="loginId">loginId</param>
public void Save(int projectId, Int64 countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int companyId, int loginId)
{
FullLengthLiningTDS fullLengthLiningTDS = new FullLengthLiningTDS();
foreach (WincapBulkUploadTDS.WincapBulkUploadRow row in (WincapBulkUploadTDS.WincapBulkUploadDataTable)Table)
{
string state = ""; if (!row.IsStateNull()) state = row.State;
string direction = ""; if (!row.IsDirectionNull()) direction = row.Direction;
string distance = ""; if (!row.IsDistanceNull()) distance = row.Distance;
string videoDistance = ""; if (!row.IsVideoDistanceNull()) videoDistance = row.VideoDistance;
string clockPosition = ""; if (!row.IsClockPositionNull()) clockPosition = row.ClockPosition;
string distanceToCentre = ""; if (!row.IsDistanceToCentreNull()) distanceToCentre = row.DistanceToCentre;
string reverseSetup = ""; if (!row.IsReverseSetupNull()) reverseSetup = row.ReverseSetup;
string comments = ""; if (!row.IsCommentsNull()) comments = row.Comments;
string measuredFromMh = "USMH";
if (row.Direction.Contains("D"))
{
measuredFromMh = "DSMH";
}
int section_assetId = SaveSection(row.SectionID, projectId, countryId, provinceId, countyId, cityId, companyId);
WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null);
int workId = workFullLengthLining.InsertDirectEmptyWorks(projectId, section_assetId, null, "", null, null, null, null, null, null, null, false, false, false, false, false, false, false, companyId, false, "", "");
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, section_assetId, companyId, projectId);
// Generate increment
string lateralIdIncrement = "";
if (measuredFromMh == "USMH" || measuredFromMh == "")
{
lateralIdIncrement = flLateralDetails.GetMaxLateralId2();
}
else
{
if (measuredFromMh == "DSMH")
{
lateralIdIncrement = flLateralDetails.GetMinLateralId2();
}
}
string videoLength = "";
string lateralId = "FL-" + lateralIdIncrement;
FullLengthLiningLateralDetails model = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
model.Insert(videoDistance, clockPosition, distanceToCentre, "", reverseSetup, null, comments, lateralId, "", "", false, companyId, true, state, "", "", "", "", null, false, null, false, false, false, "", false, false, null);
model.Save(workId, projectId, section_assetId, countryId, provinceId, countyId, cityId, videoLength, companyId, false, false, null);
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_DELETE"])))
{
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_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["asset_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in fl_delete.aspx");
}
// Tag Page
TagPage();
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section";
// If coming from
// ... fl_navigator2.aspx
if (Request.QueryString["source_page"] == "fl_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
fullLengthLiningTDS = new FullLengthLiningTDS();
int workId = Int32.Parse(hdfWorkId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadAllByWorkId(workId, companyId);
// Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
// ... fl_summary.aspx
if (Request.QueryString["source_page"] == "fl_summary.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
}
}
else
{
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
}
}
private void GrdFLAddLateralsNewAdd()
{
if (ValidateLateralFooter())
{
Page.Validate("AddLateralsAdd");
if (Page.IsValid)
{
string size = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewSize")).Text.Trim();
string material = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedValue.ToString().Trim();
string live = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewLive")).SelectedValue.Trim();
string videoDistance = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewVideoDistance")).Text.Trim();
string clockPosition = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewClockPosition")).Text.Trim();
string distanceToCentre = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewDistanceToCentre")).Text.Trim();
string timeOpened = "";
DateTime? reinstate = null;
string comments = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewComments")).Text.Trim();
// Reverse Setup calculation
string reverseSetup = "";
if (videoDistance != "")
{
Distance videoDistanceD = new Distance(videoDistance);
Distance videoLength = new Distance(tbxVideoLength.Text.Trim());
Distance reverseSetupD = videoLength - videoDistanceD;
switch (videoDistanceD.DistanceType)
{
case 1:
reverseSetup = reverseSetupD.ToStringInEng1();
break;
case 2:
reverseSetup = reverseSetupD.ToStringInEng2();
break;
case 3:
reverseSetup = reverseSetupD.ToStringInEng3();
break;
case 4:
reverseSetup = reverseSetupD.ToStringInMet1();
break;
case 5:
reverseSetup = reverseSetupD.ToStringInMil1();
break;
}
}
bool inProject = ((CheckBox)grdLaterals.FooterRow.FindControl("cbxInProject")).Checked;
int workId = Int32.Parse(hdfWorkId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
string lateralId = GetLateralIdIncrement();
string clientLateralId = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewClientLateralId")).Text.Trim();
string connectionType = ""; connectionType = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewConnectionType")).SelectedValue;
string mn = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewMn")).Text.Trim();
string clientInspectionNo = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewClientInspectionNo")).Text.Trim();
DateTime? v1Inspection = null;
bool requiresRoboticPrep = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxRequiresRoboticPrepNew")).Checked;
DateTime? requiresRoboticPrepDate = null;
if (((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpRequiresRoboticPrepDateNew")).SelectedDate.HasValue)
{
requiresRoboticPrepDate = ((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpRequiresRoboticPrepDateNew")).SelectedDate.Value;
}
bool holdClientIssue = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxHoldClientIssueNew")).Checked;
bool holdLFSIssue = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxHoldLFSIssueNew")).Checked;
bool lineLateral = ((CheckBox)grdLaterals.FooterRow.FindControl("cbxNewJl")).Checked;
string flange = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlFlangeNew")).SelectedValue;
bool dyeTestReq = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxDyeTestReqNew")).Checked;
DateTime? dyeTestComplete = null; if (((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpDyeTestCompleteNew")).SelectedDate.HasValue) dyeTestComplete = ((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpDyeTestCompleteNew")).SelectedDate.Value;
// Insert
FullLengthLiningLateralDetails model = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
model.Insert(videoDistance, clockPosition, distanceToCentre, timeOpened, reverseSetup, reinstate, comments, lateralId, size, material, false, companyId, inProject, live, clientLateralId, connectionType, mn, clientInspectionNo, v1Inspection, requiresRoboticPrep, requiresRoboticPrepDate, holdClientIssue, holdLFSIssue, lineLateral, flange, lineLateral, dyeTestReq, dyeTestComplete);
// Store datasets
Session.Remove("flAddLateralsNewDummy");
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
grdLaterals.DataBind();
grdLaterals.PageIndex = grdLaterals.PageCount - 1;
tbxLaterals.Text = model.GetTotalLaterals().ToString();
tbxLiveLaterals.Text = model.GetLiveLaterals().ToString();
}
}
}
protected void grdLaterals_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Laterals Gridview, if the gridview is edition mode
if (grdLaterals.EditIndex >= 0)
{
grdLaterals.UpdateRow(grdLaterals.EditIndex, true);
}
// Delete laterals
int lateral = int.Parse(((Label)grdLaterals.Rows[e.RowIndex].Cells[1].FindControl("lblLateral")).Text);
FullLengthLiningLateralDetails model = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
// Delete lateral
model.Delete(lateral);
tbxLaterals.Text = model.GetTotalLaterals().ToString();
tbxLiveLaterals.Text = model.GetLiveLaterals().ToString();
// Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
private void UpdateDatabase()
{
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
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);
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int sectionAssetId = Int32.Parse(hdfAssetId.Value);
bool isNewMeasuredFromDsmh = false;
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, sectionAssetId, companyId, projectId);
if (flLateralDetails.Table.Rows.Count == 0)
{
if (ddlM1DataMeasuredFromMh.SelectedValue == "DSMH")
{
isNewMeasuredFromDsmh = true;
FullLengthLiningLateralDetails fllLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fllLateralDetails.ModifyLateralId();
}
}
DB.Open();
DB.BeginTransaction();
try
{
// Save lateral details
// Save lateral details
bool roboticPrepCompleted = ckbxPrepDataRoboticPrepCompleted.Checked;
DateTime? roboticPrepCompletedCompleted = null; if (tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.HasValue) roboticPrepCompletedCompleted = tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.Value;
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.Save(workId, projectId, sectionAssetId, countryId, provinceId, countyId, cityId, tbxVideoLength.Text.Trim(), companyId, isNewMeasuredFromDsmh, roboticPrepCompleted, roboticPrepCompletedCompleted);
// Save catalyst details
string newRunDetails = "";
foreach (ListItem lst in cbxlSectionId.Items)
{
if (lst.Selected)
{
newRunDetails = newRunDetails + lst.Value + ">";
}
}
newRunDetails = newRunDetails.Substring(0, newRunDetails.Length - 1);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.Save(companyId, newRunDetails, projectId);
// Save section details
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.Save(countryId, provinceId, countyId, cityId, projectId, companyId);
// Save work details
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, sectionAssetId, companyId, ckbxWetOutDataIncludeWetOutInformation.Checked, ckbxInversionDataIncludeInversionInformation.Checked);
// Save material details
string newMaterial = ddlM1DataMaterial.SelectedValue;
if (ddlM1DataMaterial.SelectedIndex > 0)
{
LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null);
if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(sectionAssetId, newMaterial, companyId))
{
MaterialInformation materialInformation = new MaterialInformation(materialInformationTDS);
materialInformation.Save(companyId);
}
}
DB.CommitTransaction();
// Store datasets
fullLengthLiningTDS.AcceptChanges();
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
materialInformationTDS.AcceptChanges();
Session["materialInformationTDS"] = materialInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void UpdateDatabase()
{
try
{
TeamProjectTime2Gateway teamProjectTime2Gateway = new TeamProjectTime2Gateway(teamProjectTime2TDSToSave);
teamProjectTime2Gateway.Update(projectTime2TDS);
teamProjectTime2TDSToSave.AcceptChanges();
teamProjectTime2TDS.AcceptChanges();
projectTime2TDS.AcceptChanges();
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
}
catch (Exception ex)
{
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
DB.Open();
DB.BeginTransaction();
try
{
if (ddlTypeOfWork.SelectedValue == "MH Rehab")
{
int companyId = Int32.Parse(hdfCompanyId.Value);
// Get ids & location
int projectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
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);
manholeRehabilitationTDS = new ManholeRehabilitationTDS();
ManholeRehabilitationWorkDetails manholeRehabilitationWorkDetails = new ManholeRehabilitationWorkDetails(manholeRehabilitationTDS);
ManholeRehabilitationWorkDetailsGateway manholeRehabilitationWorkDetailsGateway = new ManholeRehabilitationWorkDetailsGateway(manholeRehabilitationTDS);
switch (ddlFunction.SelectedValue)
{
case "Prep":
foreach (GridViewRow row in grdManholesRehabPrep.Rows)
{
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
DateTime? prepDate = Convert.ToDateTime(((Label)row.FindControl("lblPrepDate")).Text);
if (selected)
{
int assetId = Convert.ToInt32(grdManholesRehabPrep.DataKeys[row.RowIndex].Values["AssetID"].ToString());
int workId = 0;
workId = GetWorkId(Int32.Parse(ddlProject.SelectedValue), assetId, "Manhole Rehabilitation", companyId);
manholeRehabilitationWorkDetails.LoadByWorkIdAssetId(workId, assetId, Int32.Parse(hdfCompanyId.Value));
if (manholeRehabilitationWorkDetailsGateway.Table.Rows.Count > 0)
{
int? batchId = manholeRehabilitationWorkDetailsGateway.GetBatchID(workId);
manholeRehabilitationWorkDetails.Update(workId, prepDate, manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId), batchId, manholeRehabilitationWorkDetailsGateway.GetDate(workId).Value, companyId);
}
else
{
manholeRehabilitationWorkDetails.Update(workId, prepDate, null, null, DateTime.Now, companyId);
}
manholeRehabilitationWorkDetails.Save2(countryId, provinceId, countyId, cityId, projectId, assetId, companyId, true);
}
}
break;
case "Spray":
foreach (GridViewRow row in grdManholesRehabSpray.Rows)
{
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
DateTime? sprayDate = Convert.ToDateTime(((Label)row.FindControl("lblSprayDate")).Text);
if (selected)
{
int assetId = Convert.ToInt32(grdManholesRehabSpray.DataKeys[row.RowIndex].Values["AssetID"].ToString());
int workId = 0;
workId = GetWorkId(Int32.Parse(ddlProject.SelectedValue), assetId, "Manhole Rehabilitation", companyId);
manholeRehabilitationWorkDetails.LoadByWorkIdAssetId(workId, assetId, Int32.Parse(hdfCompanyId.Value));
if (manholeRehabilitationWorkDetailsGateway.Table.Rows.Count > 0)
{
int? batchId = manholeRehabilitationWorkDetailsGateway.GetBatchID(workId);
manholeRehabilitationWorkDetails.Update(workId, manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId), sprayDate, batchId, manholeRehabilitationWorkDetailsGateway.GetDate(workId).Value, companyId);
}
else
{
manholeRehabilitationWorkDetails.Update(workId, null, sprayDate, null, DateTime.Now, companyId);
}
manholeRehabilitationWorkDetails.Save2(countryId, provinceId, countyId, cityId, projectId, assetId, companyId, true);
}
}
break;
}
DB.CommitTransaction();
// Store datasets
manholeRehabilitationTDS.AcceptChanges();
}
else
{
if (ddlTypeOfWork.SelectedValue == "Full Length")
{
fullLengthLiningTDS = new FullLengthLiningTDS();
AssetSewerSectionGateway aass = new AssetSewerSectionGateway();
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(fullLengthLiningTDS);
int assetId = 0;
int workId = 0;
// Get ids & location
int projectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
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);
int companyId = Int32.Parse(hdfCompanyId.Value);
switch (ddlFunction.SelectedValue)
{
case "Install":
foreach (GridViewRow row in grdSectionsInstall.Rows)
{
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
DateTime? installDate = Convert.ToDateTime(((Label)row.FindControl("lblInstallDate")).Text);
if (selected)
{
if (installDate != tkrdpDate_.SelectedDate.Value)
{
installDate = tkrdpDate_.SelectedDate.Value;
}
string sectionId = grdSectionsInstall.DataKeys[row.RowIndex].Values["SectionID"].ToString();
aass.LoadBySectionId(sectionId, companyId);
assetId = aass.GetAssetID(sectionId);
workId = GetWorkId(Int32.Parse(ddlProject.SelectedValue), assetId, "Full Length Lining", companyId);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, Int32.Parse(hdfCompanyId.Value));
fullLengthLiningWorkDetails.Update(workId, fullLengthLiningWorkDetailsGateway.GetP1Date(workId), fullLengthLiningWorkDetailsGateway.GetP1Completed(workId), installDate, fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId));
fullLengthLiningWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, assetId, companyId, false, false);
}
}
break;
case "Prep & Measure":
foreach (GridViewRow row in grdSections.Rows)
{
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
bool completed = ((CheckBox)row.FindControl("cbxCompleted")).Checked;
DateTime? prepDate = Convert.ToDateTime(((Label)row.FindControl("lblPrepDate")).Text);
if (selected)
{
if (completed)
{
if (prepDate != tkrdpDate_.SelectedDate.Value)
{
prepDate = tkrdpDate_.SelectedDate.Value;
}
}
else
{
prepDate = null;
}
string sectionId = grdSections.DataKeys[row.RowIndex].Values["SectionID"].ToString();
aass.LoadBySectionId(sectionId, companyId);
assetId = aass.GetAssetID(sectionId);
workId = GetWorkId(Int32.Parse(ddlProject.SelectedValue), assetId, "Full Length Lining", companyId);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, Int32.Parse(hdfCompanyId.Value));
fullLengthLiningWorkDetails.Update(workId, prepDate, completed, fullLengthLiningWorkDetailsGateway.GetInstallDate(workId), fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId));
fullLengthLiningWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, assetId, companyId, false, false);
}
}
break;
case "Reinstate & Post Video":
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
FullLengthLiningLateralDetailsGateway fullLengthLiningLateralDetailsGateway = new FullLengthLiningLateralDetailsGateway(fullLengthLiningTDS);
foreach (GridViewRow row in grdSectionsReinstatePostVideo.Rows)
{
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
bool completed = ((CheckBox)row.FindControl("cbxCompleted")).Checked;
DateTime? postVideo = Convert.ToDateTime(((Label)row.FindControl("lblPostVideo")).Text);
string sectionId = grdSectionsReinstatePostVideo.DataKeys[row.RowIndex].Values["SectionID"].ToString();
aass.LoadBySectionId(sectionId, companyId);
assetId = aass.GetAssetID(sectionId);
workId = GetWorkId(Int32.Parse(ddlProject.SelectedValue), assetId, "Full Length Lining", companyId);
if (selected)
{
if (completed)
{
if (postVideo != tkrdpDate_.SelectedDate.Value)
{
postVideo = tkrdpDate_.SelectedDate.Value;
}
}
else
{
postVideo = null;
}
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, Int32.Parse(hdfCompanyId.Value));
fullLengthLiningWorkDetails.Update(workId, fullLengthLiningWorkDetailsGateway.GetP1Date(workId), fullLengthLiningWorkDetailsGateway.GetP1Completed(workId), fullLengthLiningWorkDetailsGateway.GetInstallDate(workId), postVideo);
fullLengthLiningWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, assetId, companyId, false, false);
}
}
foreach (GridViewRow row in grdLaterals.Rows)
{
string sectionId = grdLaterals.DataKeys[row.RowIndex].Values["SectionID"].ToString();
int assetIdLateral = Convert.ToInt32(((Label)row.FindControl("lblAssetIDLateral")).Text);
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
DateTime? opened = null; if (((CheckBox)row.FindControl("cbxOpened")).Checked) opened = tkrdpDate_.SelectedDate;
DateTime? brushed = null; if (((CheckBox)row.FindControl("cbxBrushed")).Checked) brushed = tkrdpDate_.SelectedDate;
if (selected)
{
aass.LoadBySectionId(sectionId, companyId);
assetId = aass.GetAssetID(sectionId);
workId = GetWorkId(Int32.Parse(ddlProject.SelectedValue), assetId, "Full Length Lining", companyId);
fullLengthLiningLateralDetails.SaveFll(workId, assetIdLateral, companyId, opened, brushed);
}
}
break;
}
DB.CommitTransaction();
// Store datasets
fullLengthLiningTDS.AcceptChanges();
}
}
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
