/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="workId">workId</param>
/// <param name="companyId">companyId</param>
public void DeleteDirect(int workId, int companyId)
{
// delete field cure records
WorkFullLengthLiningInversionFieldCureRecordGateway workFullLengthLiningInversionFieldCureRecordGateway = new WorkFullLengthLiningInversionFieldCureRecordGateway();
workFullLengthLiningInversionFieldCureRecordGateway.LoadByWorkId(workId, companyId);
if (workFullLengthLiningInversionFieldCureRecordGateway.Table.Rows.Count > 0)
{
WorkFullLengthLiningInversionFieldCureRecord workFullLengthLiningInversionFieldCureRecord = new WorkFullLengthLiningInversionFieldCureRecord(null);
workFullLengthLiningInversionFieldCureRecord.DeleteAllDirect(workId, companyId);
}
// Delete inversion
WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway(Data);
workFullLengthLiningInversionGateway.Delete(workId, companyId);
}
private void LoadWorkData(int workId, int assetId)
{
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(fullLengthLiningTDS);
if (fullLengthLiningWorkDetailsGateway.Table.Rows.Count > 0)
{
// For Header
tbxVideoLength.Text = fullLengthLiningWorkDetailsGateway.GetVideoLength(workId);
// Load full length lining general data
tbxGeneralClientId.Text = fullLengthLiningWorkDetailsGateway.GetClientId(workId);
ckbxGeneralIssueIdentified.Checked = fullLengthLiningWorkDetailsGateway.GetIssueIdentified(workId);
ckbxGeneralLfsIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueLFS(workId);
ckbxGeneralClientIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueClient(workId);
ckbxGeneralSalesIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueSales(workId);
ckbxGeneralIssueGivenToClient.Checked = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClient(workId);
ckbxGeneralIssueResolved.Checked = fullLengthLiningWorkDetailsGateway.GetIssueResolved(workId);
ckbxGeneralIssueInvestigation.Checked = fullLengthLiningWorkDetailsGateway.GetIssueInvestigation(workId);
// ... Load Dates
if (fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId).HasValue)
{
tkrdpGeneralProposedLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId).HasValue)
{
tkrdpGeneralDeadlineLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetP1Date(workId).HasValue)
{
tkrdpPrepDataP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId);
tkrdpGeneralP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetM1Date(workId).HasValue)
{
tkrdpM1DataM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId);
tkrdpGeneralM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetM2Date(workId).HasValue)
{
tkrdpGeneralM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId);
tkrdpM2DataM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetInstallDate(workId).HasValue)
{
tkrdpGeneralInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId);
tkrdpInstallDataInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId).HasValue)
{
tkrdpGeneralFinalVideo.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId);
tkrdpInstallDataFinalVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId);
}
// ... for RA data
if (fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId).HasValue)
{
tkrdpGeneralPreFlushDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId);
tkrdpGeneralPreFlushDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId);
}
if (fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId).HasValue)
{
tkrdpGeneralPreVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId);
tkrdpGeneralPreVideoDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId);
}
// For FullLengthLiningP1 data
tbxPrepDataCXIsRemoved.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).HasValue) tbxPrepDataCXIsRemoved.Text = fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).ToString();
ckbxPrepDataRoboticPrepCompleted.Checked = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workId);
if (fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId).HasValue)
{
tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
}
ckbxPrepDataP1Completed.Checked = fullLengthLiningWorkDetailsGateway.GetP1Completed(workId);
// For FullLengthLiningM1 data
// ... for material
ddlM1DataMaterial.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMaterial(workId);
// ... form m1 data
tbxM1DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workId);
ddlM1DataTrafficControl.SelectedValue = fullLengthLiningWorkDetailsGateway.GetTrafficControl(workId);
if(fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId) == "") ddlM1DataSiteDetails.SelectedIndex = 0; else ddlM1DataSiteDetails.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId);
if (fullLengthLiningWorkDetailsGateway.GetAccessType(workId) == "") ddlM1DataAccessType.SelectedIndex = 0; else ddlM1DataAccessType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetAccessType(workId);
ckbxM1DataPipeSizeChange.Checked = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workId);
ckbxM1DataStandardBypass.Checked = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workId);
tbxM1DataStandardBypassComments.Text = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workId);
tbxM1DataTrafficControlDetails.Text = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workId);
ddlM1DataMeasurementType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workId);
ddlM1DataMeasuredFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
tbxM1DataMeasuredFromMh.Text = ""; fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
ddlM1DataVideoDoneFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
tbxM1DataVideoDoneFromMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId);
ddlM1DataVideoDoneToMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
tbxM1DataVideoDoneToMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId);
// For FullLengthLiningM2 data
tbxM2DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workId);
ckbxM2DataDropPipe.Checked = fullLengthLiningWorkDetailsGateway.GetDropPipe(workId);
tbxM2DataDropPipeInvertdepth.Text = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workId);
tbxM2DataCappedLaterals.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).HasValue) tbxM2DataCappedLaterals.Text = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).ToString();
tbxM2DataLineWidthId.Text = fullLengthLiningWorkDetailsGateway.GetLineWithId(workId);
tbxM2DataHydrantAddress.Text = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workId);
ddlM2DataHydroWireWithin10FtOfInversionMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workId);
tbxM2DataDistanceToInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workId);
if (fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId) == "") ddlM2DataSurfaceGrade.SelectedIndex = 0; else ddlM2DataSurfaceGrade.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId);
cbxM2DataHydroPulley.Checked = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workId);
cbxM2DataFridgeCart.Checked = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workId);
cbxM2DataTwoPump.Checked = fullLengthLiningWorkDetailsGateway.GetTwoPump(workId);
cbxM2DataSixBypass.Checked = fullLengthLiningWorkDetailsGateway.GetSixBypass(workId);
cbxM2DataScaffolding.Checked = fullLengthLiningWorkDetailsGateway.GetScaffolding(workId);
cbxM2DataWinchExtension.Checked = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workId);
cbxM2DataExtraGenerator.Checked = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workId);
cbxM2DataGreyCableExtension.Checked = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workId);
cbxM2DataEasementMats.Checked = fullLengthLiningWorkDetailsGateway.GetEasementMats(workId);
cbxM2DataRampsRequired.Checked = fullLengthLiningWorkDetailsGateway.GetRampRequired(workId);
cbxM2DataCameraSkid.Checked = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workId);
// For FullLengthLiningWetOut data
int companyId = Int32.Parse(hdfCompanyId.Value);
// ... ... tube size = confirmed Size
Distance confirmedSizeDistance = new Distance(tbxConfirmedSize.Text);
double confirmedSize = 0;
string[] confirmedSizeString = confirmedSizeDistance.ToStringInEng1().Split('\"');
if (!confirmedSizeDistance.ToStringInEng1().Contains("'"))
{
if (Validator.IsValidDouble(tbxConfirmedSize.Text))
{
confirmedSize = double.Parse(tbxConfirmedSize.Text);
}
else
{
confirmedSize = double.Parse(confirmedSizeString[0]);
}
}
else
{
confirmedSize = Math.Ceiling(confirmedSizeDistance.ToDoubleInEng3()*12);
tbxConfirmedSize.Text = confirmedSize.ToString();
}
// ... Verify if work has wet out information
WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway();
workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId);
if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0)
{
// ... setup data
ddlWetOutDataLinerTube.SelectedValue = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId);
if (ddlWetOutDataLinerTube.SelectedValue != "(Select)")
{
ckbxWetOutDataIncludeWetOutInformation.Checked = true;
}
else
{
ckbxWetOutDataIncludeWetOutInformation.Checked = false;
}
ddlWetOutDataResins.SelectedValue = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString();
tbxWetOutDataExcessResin.Text = fullLengthLiningWorkDetailsGateway.GetExcessResin(workId).ToString();
ddlWetOutDataPoundsDrums.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPoundsDrums(workId);
tbxWetOutDataDrumDiameter.Text = fullLengthLiningWorkDetailsGateway.GetDrumDiameter(workId).ToString();
tbxWetOutDataHoistMaximumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMaximumHeight(workId).ToString();
tbxWetOutDataHoistMinimumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMinimumHeight(workId).ToString();
tbxWetOutDataDownDropTubeLength.Text = fullLengthLiningWorkDetailsGateway.GetDownDropTubeLenght(workId).ToString();
tbxWetOutDataPumpHeightAboveGround.Text = fullLengthLiningWorkDetailsGateway.GetPumpHeightAboveGround(workId).ToString();
tbxWetOutDataTubeResinToFeltFactor.Text = fullLengthLiningWorkDetailsGateway.GetTubeResinToFeltFactor(workId).ToString();
// ... wet out sheet
DateTime wetOutDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId);
tbxWetOutDataDateOfSheet.Text = wetOutDataDateOfSheet.Month.ToString() + "/" + wetOutDataDateOfSheet.Day.ToString() + "/" + wetOutDataDateOfSheet.Year.ToString();
ddlWetOutDataMadeBy.SelectedValue = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString();
hdfRunDetails.Value = fullLengthLiningWorkDetailsGateway.GetRunDetails(workId);
ddlWetOutDataRunDetails2.SelectedValue = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId);
tkrdpWetOutDataWetOutDate.SelectedDate = fullLengthLiningWorkDetailsGateway.GetWetOutDate(workId);
tbxWetOutDataInstallDate.Text = "";
if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue)
{
DateTime? wetOutDataInstallDate = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId);
DateTime wetOutDataInstallDateDateTime = (DateTime)wetOutDataInstallDate;
tbxWetOutDataInstallDate.Text = wetOutDataInstallDateDateTime.Month.ToString() + "/" + wetOutDataInstallDateDateTime.Day.ToString() + "/" + wetOutDataInstallDateDateTime.Year.ToString();
}
tbxWetOutDataTubeThickness.Text = fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId);
tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString();
tbxWetOutDataPlusExtra.Text = fullLengthLiningWorkDetailsGateway.GetPlusExtra(workId).ToString();
tbxWetOutDataForTurnOffset.Text = fullLengthLiningWorkDetailsGateway.GetForTurnOffset(workId).ToString();
tbxWetOutDataLengthtToWetOut.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString();
tbxWetOutDataTubeMaxColdHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHead(workId).ToString();
tbxWetOutDataTubeMaxColdHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHeadPsi(workId).ToString();
tbxWetOutDataTubeMaxHotHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHead(workId).ToString();
tbxWetOutDataTubeMaxHotHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHeadPsi(workId).ToString();
tbxWetOutDataTubeIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHead(workId).ToString();
tbxWetOutDataTubeIdealHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHeadPsi(workId).ToString();
tbxWetOutDataNetResinForTube.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTube(workId).ToString();
tbxWetOutDataNetResinForTubeUsgals.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgals(workId).ToString();
tbxWetOutDataNetResinForTubeDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeDrumsIns(workId);
tbxWetOutDataNetResinForTubeLbsFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeLbsFt(workId).ToString();
tbxWetOutDataNetResinForTubeUsgFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgFt(workId).ToString();
tbxWetOutDataExtraResinForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraResinForMix(workId).ToString();
tbxWetOutDataExtraLbsForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraLbsForMix(workId).ToString();
tbxWetOutDataTotalMixQuantity.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantity(workId).ToString();
tbxWetOutDataTotalMixQuantityUsgals.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityUsgals(workId).ToString();
tbxWetOutDataTotalMixQuantityDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityDrumsIns(workId);
ddlWetOutDataInversionType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetInversionType(workId);
tbxWetOutDataDepthOfInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDepthOfInversionMH(workId).ToString();
tbxWetOutDataTubeForColumn.Text = fullLengthLiningWorkDetailsGateway.GetTubeForColumn(workId).ToString();
tbxWetOutDataTubeForStartDry.Text = fullLengthLiningWorkDetailsGateway.GetTubeForStartDry(workId).ToString();
tbxWetOutDataTotalTube.Text = fullLengthLiningWorkDetailsGateway.GetTotalTube(workId).ToString();
tbxWetOutDataDropTubeConnects.Text = fullLengthLiningWorkDetailsGateway.GetDropTubeConnects(workId);
tbxWetOutDataAllowsHeadTo.Text = fullLengthLiningWorkDetailsGateway.GetAllowsHeadTo(workId).ToString();
tbxWetOutDataRollerGap.Text = fullLengthLiningWorkDetailsGateway.GetRollerGap(workId).ToString();
tbxWetOutDataHeightNeeded.Text = fullLengthLiningWorkDetailsGateway.GetHeightNeeded(workId).ToString();
tbxWetOutDataAvailable.Text = fullLengthLiningWorkDetailsGateway.GetAvailable(workId);
tbxWetOutDataHoistHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistHeight(workId);
hdfResinId.Value = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString();
hdfMadeBy.Value = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString();
tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId);
lblWetOutDataResinGray.Text = fullLengthLiningWorkDetailsGateway.GetResinsLabel(workId);
lblWetOutDataDrumContainsGray.Text = fullLengthLiningWorkDetailsGateway.GetDrumContainsLabel(workId);
lblWetOutDataLinerTubeGray.Text = fullLengthLiningWorkDetailsGateway.GetLinerTubeLabel(workId);
lblWetOutDataLbDrumsGrey.Text = fullLengthLiningWorkDetailsGateway.GetForLbDrumsLabel(workId);
lblWetOutDataNetResinGrey.Text = fullLengthLiningWorkDetailsGateway.GetNetResinLabel(workId);
lblWetOutDataCatalystGrey.Text = fullLengthLiningWorkDetailsGateway.GetCatalystLabel(workId);
// ... ... graphic labels
lblWetOutDataDimensionLabel.Text = confirmedSize + " ins x " + ddlThickness.SelectedValue + " mm Tube";
lblWetOutDataTotalTubeLengthlabel.Text = "Total Tube Length " + tbxWetOutDataTotalTube.Text + " ft";
lblWetOutDataForColumnLabel.Text = tbxWetOutDataTubeForColumn.Text + " ft for Column";
lblWetOutDataDryFtLabel.Text = "Dry " + tbxWetOutDataTubeForStartDry.Text + " ft";
lblWetOutDataWetOutLengthlabel.Text = "Wet-Out Length " + tbxWetOutDataLengthtToWetOut.Text + " ft";
lblWetOutDataDryFtEndLabel.Text = "Dry " + tbxWetOutDataTubeForColumn.Text + " ft";
lblWetOutDataTailEndlabel.Text = "Tail End";
lblWetOutDataColumnEndlabel.Text = "Column End";
lblWetOutDataRollerGapLabel.Text = "Roller Gap " + tbxWetOutDataRollerGap.Text + " mm";
}
else
{
// Wet Out Data
// ... Show current day for new sheets
DateTime sheetDate = DateTime.Now;
tbxWetOutDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString();
// Set default values.
tbxWetOutDataExcessResin.Text = "0.0";
ddlWetOutDataPoundsDrums.SelectedIndex = 1;
tbxWetOutDataDrumDiameter.Text = "22.5";
tbxWetOutDataHoistMaximumHeight.Text = "24";
tbxWetOutDataHoistMinimumHeight.Text = "5";
tbxWetOutDataDownDropTubeLength.Text = "19";
tbxWetOutDataPumpHeightAboveGround.Text = "6";
tbxWetOutDataTubeResinToFeltFactor.Text = "87";
tbxWetOutDataPlusExtra.Text = "3";
tbxWetOutDataForTurnOffset.Text = "0";
tbxWetOutDataExtraResinForMix.Text = "0";
tbxWetOutDataTubeForColumn.Text = "16";
tbxWetOutDataTubeForStartDry.Text = "3";
if (ddlWetOutDataInversionType.SelectedValue == "Top")
{
Distance usmhDepthDistance = new Distance(tbxM1DataUsmhDepth.Text);
tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(usmhDepthDistance.ToStringInEng3()), 1).ToString();
}
else
{
if (ddlWetOutDataInversionType.SelectedValue == "Bottom")
{
Distance dsmhDepthDistance = new Distance(tbxM1DataDsmhDepth.Text);
tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(dsmhDepthDistance.ToStringInEng3()), 1).ToString();
}
else
{
tbxWetOutDataDepthOfInversionMH.Text = "0";
}
}
tbxWetOutDataRollerGap.Text = "13";
tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId);
// ...Section values
// ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin
Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text);
tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString();
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()),1).ToString();
double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3());
// ... Run details
if (cbxlSectionId.Items.Count > 1)
{
hdfRunDetails.Value = hdfSectionId.Value;
}
// .... Install Date
tbxWetOutDataInstallDate.Text = "";
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate;
DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn;
tbxWetOutDataInstallDate.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString();
}
}
// ... Verify if work has inversion information
WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway();
workFullLengthLiningInversionGateway.LoadByWorkId(workId, companyId);
// ... Verify if work has inversion information
if (workFullLengthLiningInversionGateway.Table.Rows.Count > 0)
{
// ... Inversion data
lblInversionDataSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId);
DateTime inversionDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId);
tbxInversionDataDateOfSheet.Text = inversionDataDateOfSheet.Month.ToString() + "/" + inversionDataDateOfSheet.Day.ToString() + "/" + inversionDataDateOfSheet.Year.ToString();
int employeeId = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId);
EmployeeGateway employeeGateway = new EmployeeGateway();
employeeGateway.LoadByEmployeeId(employeeId);
tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId);
tbxInversionDataInstalledOn.Text = "";
if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue)
{
DateTime? inversionDataInstalledOn = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId);
DateTime inversionDataInstalledOnDateTime = (DateTime)inversionDataInstalledOn;
tbxInversionDataInstalledOn.Text = inversionDataInstalledOnDateTime.Month.ToString() + "/" + inversionDataInstalledOnDateTime.Day.ToString() + "/" + inversionDataInstalledOnDateTime.Year.ToString();
}
tbxInversionDataRunDetails2.Text = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId);
tbxInversionDataCommentsEdit.Text = fullLengthLiningWorkDetailsGateway.GetInversionComment(workId);
tbxInversionDataLinerSize.Text = confirmedSizeString + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId);
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString();
tbxInversionDataWetOutLenght.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString();
ddlInversionDataInversionPipeType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeType(workId);
if (ddlInversionDataInversionPipeType.SelectedValue != "(Select)")
{
ckbxInversionDataIncludeInversionInformation.Checked = true;
}
else
{
ckbxInversionDataIncludeInversionInformation.Checked = false;
}
ddlInversionDataPipeCondition.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeCondition(workId);
ddlInversionDataGroundMoisture.SelectedValue = fullLengthLiningWorkDetailsGateway.GetGroundMoisture(workId);
tbxInversionDataBoilerSize.Text = fullLengthLiningWorkDetailsGateway.GetBoilerSize(workId).ToString();
tbxInversionDataPumpsTotalCapacity.Text = fullLengthLiningWorkDetailsGateway.GetPumpTotalCapacity(workId).ToString();
tbxInversionDataLayflatSize.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatSize(workId).ToString();
tbxInversionDataLayflatQuantityTotal.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatQuantityTotal(workId).ToString();
tbxInversionDataWaterStartTempTs.Text = fullLengthLiningWorkDetailsGateway.GetWaterStartTemp(workId).ToString();
tbxInversionDataTempT1.Text = fullLengthLiningWorkDetailsGateway.GetTemp1(workId).ToString();
tbxInversionDataHoldAtT1For.Text = fullLengthLiningWorkDetailsGateway.GetHoldAtT1(workId).ToString();
tbxInversionDataTempT2.Text = fullLengthLiningWorkDetailsGateway.GetTempT2(workId).ToString();
tbxInversionDataCookAtT2For.Text = fullLengthLiningWorkDetailsGateway.GetCookAtT2(workId).ToString();
tbxInversionDataCoolDownFor.Text = fullLengthLiningWorkDetailsGateway.GetCoolDownFor(workId).ToString();
tbxInversionDataCoolToTemp.Text = fullLengthLiningWorkDetailsGateway.GetCoolToTemp(workId).ToString();
tbxInversionDataDropInPipeRun.Text = fullLengthLiningWorkDetailsGateway.GetDropInPipeRun(workId).ToString();
tbxInversionDataPipeSlopeOf.Text = fullLengthLiningWorkDetailsGateway.GetPipeSlopOf(workId).ToString();
lblInversionData45F120F.Text = tbxInversionDataWaterStartTempTs.Text + "°F-" + tbxInversionDataTempT1.Text + "°F (hr)";
tbxInversionData45F120F.Text = fullLengthLiningWorkDetailsGateway.GetF45F120(workId).ToString();
tbxInversionDataHold.Text = fullLengthLiningWorkDetailsGateway.GetHold(workId).ToString();
lblInversionData120F185F.Text = tbxInversionDataTempT1.Text + "°F-" + tbxInversionDataTempT2.Text + "°F (hr)";
tbxInversionData120F185F.Text = fullLengthLiningWorkDetailsGateway.GetF120F185(workId).ToString();
tbxInversionDataCookTime.Text = fullLengthLiningWorkDetailsGateway.GetCookTime(workId).ToString();
tbxInversionDataCoolTime.Text = fullLengthLiningWorkDetailsGateway.GetCoolTime(workId).ToString();
tbxInversionDataAproxTotal.Text = fullLengthLiningWorkDetailsGateway.GetAproxTotal(workId).ToString();
tbxInversionDataWaterChangesPerHour.Text = fullLengthLiningWorkDetailsGateway.GetWaterChangesPerHour(workId).ToString();
tbxInversionDataReturnWaterVelocity.Text = fullLengthLiningWorkDetailsGateway.GetReturnWaterVelocity(workId).ToString();
tbxInversionDataLayflatBackPressure.Text = fullLengthLiningWorkDetailsGateway.GetLayflatBackPressure(workId).ToString();
tbxInversionDataPumpLiftAtIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetPumpLiftAtIdealHead(workId).ToString();
tbxInversionDataWaterToFillLinerColumn.Text = fullLengthLiningWorkDetailsGateway.GetWaterToFillLinerColumn(workId).ToString();
tbxInversionDataWaterPerFit.Text = fullLengthLiningWorkDetailsGateway.GetWaterPerFit(workId).ToString();
tbxInversionDataNotesAndInstallationResults.Text = fullLengthLiningWorkDetailsGateway.GetInstallationResults(workId);
lblInversionDataLinerInfoGrey.Text = fullLengthLiningWorkDetailsGateway.GetInversionLinerTubeLabel(workId);
lblInversionDataHeadsGrey.Text = fullLengthLiningWorkDetailsGateway.GetHeadsIdealLabel(workId);
lblInversionDataPumpingCirculationSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetPumpingAndCirculationLabel(workId);
// ... ... graphic labels
lblInversionDataMaxColdForTubeLabel.Text = tbxWetOutDataTubeMaxColdHead.Text + " ft = Max Cold for tube";
lblInversionDataMaxHotForTubeLabel.Text = tbxWetOutDataTubeMaxHotHead.Text + " ft = Max Hot for tube";
lblInversionDataIdelForTubeLabel.Text = tbxWetOutDataTubeIdealHead.Text + " ft = Ideal for tube";
double maxColdForTubeEnd = double.Parse(tbxWetOutDataTubeMaxColdHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataMaxColdForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxColdForTubeEnd.ToString()), 1).ToString() + " ft";
double maxHotForTubeEnd = double.Parse(tbxWetOutDataTubeMaxHotHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataMaxHotForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxHotForTubeEnd.ToString()), 1).ToString() + " ft";
double idealForTubeEnd = double.Parse(tbxWetOutDataTubeIdealHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text);
lblInversionDataIdelForTubeEndLabel.Text = decimal.Round(decimal.Parse(idealForTubeEnd.ToString()), 1).ToString() + " ft";
lblInversionDataPumpHeightLabel.Text = " " + tbxWetOutDataPumpHeightAboveGround.Text + " ft";
lblInversionDataLinerSizeLabel.Text = confirmedSize.ToString() + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId) + " Liner";
lblInversionDataRunLengthLabel.Text = "Run Length: " + tbxInversionDataRunLength.Text + " ft; Fall: " + tbxInversionDataDropInPipeRun.Text + " ft";
lblInversionDataDepthOfInversionMHLabel.Text = " " + tbxWetOutDataDepthOfInversionMH.Text + " ft";
lblInversionDataEndLabel.Text = "End";
}
else
{
// Wet Out Data
// ... Show current day for new sheets
DateTime sheetDate = DateTime.Now;
tbxInversionDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString();
// Set default values.
lblInversionData45F120F.Text = "";
lblInversionData120F185F.Text = "";
tbxInversionDataBoilerSize.Text = "7000000";
tbxInversionDataPumpsTotalCapacity.Text = "300";
tbxInversionDataLayflatSize.Text = "4";
tbxInversionDataLayflatQuantityTotal.Text = "1";
tbxInversionDataWaterStartTempTs.Text = "45";
tbxInversionDataTempT1.Text = "120";
tbxInversionDataHoldAtT1For.Text = "0.5";
tbxInversionDataTempT2.Text = "185";
tbxInversionDataCookAtT2For.Text = "2";
tbxInversionDataCoolDownFor.Text = "1";
tbxInversionDataCoolToTemp.Text = "85";
// ...Section values
// ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin
Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text);
tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString();
double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3());
// ... Run details
if (cbxlSectionId.Items.Count > 1)
{
hdfRunDetails.Value = hdfSectionId.Value;
}
// .... Install Date
tbxInversionDataInstalledOn.Text = "";
if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "")
{
DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate;
DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn;
tbxInversionDataInstalledOn.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString();
}
}
// ... Show FLL Comments + RA Comments
int flWorkId = workId;
// ... ... Get raWorkId
int raWorkId = 0;
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Rehab Assessment", companyId);
if (workGateway.Table.Rows.Count > 0)
{
raWorkId = workGateway.GetWorkId(assetId, "Rehab Assessment", projectId);
}
// ... ... Get comments
FullLengthLiningAllComments fullLengthLiningAllComments = new FullLengthLiningAllComments(fullLengthLiningTDS);
fullLengthLiningAllComments.LoadAllByFlWorkIdRaWorkId(flWorkId, raWorkId, companyId);
// ... ... Store datasets
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
// ... ... Show comments
tbxCommentsDataComments.Text = fullLengthLiningAllComments.GetFLOrRAComments(companyId, fullLengthLiningAllComments.Table.Rows.Count, "\n");
}
}
/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="originalWorkId">originalWorkId</param>
/// <param name="originalComment">originalComment</param>
/// <param name="originalPipeType">originalPipeType</param>
/// <param name="originalPipeCondition">originalPipeCondition</param>
/// <param name="originalGroundMoisture">originalGroundMoisture</param>
/// <param name="originalBoilerSize">originalBoilerSize</param>
/// <param name="originalPumpTotalCapacity">originalPumpTotalCapacity</param>
/// <param name="originalLayFlatSize">originalLayFlatSize</param>
/// <param name="originalLayFlatQuantityTotal">originalLayFlatQuantityTotal</param>
/// <param name="originalWaterStartTemp">originalWaterStartTemp</param>
/// <param name="originalTemp1">originalTemp1</param>
/// <param name="originalHoldAtT1">originalHoldAtT1</param>
/// <param name="originalTempT2">originalTempT2</param>
/// <param name="originalCookAtT2">originalCookAtT2</param>
/// <param name="originalCoolDownFor">originalCoolDownFor</param>
/// <param name="originalCoolToTemp">originalCoolToTemp</param>
/// <param name="originalDropInPipeRun">originalDropInPipeRun</param>
/// <param name="originalPipeSlopOf">originalPipeSlopOf</param>
/// <param name="originalF45F120">originalF45F120</param>
/// <param name="originalHold">originalHold</param>
/// <param name="originalF120F185">originalF120F185</param>
/// <param name="originalCookTime">originalCookTime</param>
/// <param name="originalCoolTime">originalCoolTime</param>
/// <param name="originalAproxTotal">originalAproxTotal</param>
/// <param name="originalWaterChangesPerHour">originalWaterChangesPerHour</param>
/// <param name="originalReturnWaterVelocity">originalReturnWaterVelocity</param>
/// <param name="originalLayflatBackPressure">originalLayflatBackPressure</param>
/// <param name="originalPumpLiftAtIdealHead">originalPumpLiftAtIdealHead</param>
/// <param name="originalWaterToFillLinerColumn">originalWaterToFillLinerColumn</param>
/// <param name="originalWaterPerFit">originalWaterPerFit</param>
/// <param name="originalInstallationResults">originalInstallationResults</param>
/// <param name="originalLinerTubeLabel">originalLinerTubeLabel</param>
/// <param name="originalHeadsIdealLabel">originalHeadsIdealLabel</param>
/// <param name="originalPumpingAndCirculationLabel">originalPumpingAndCirculationLabel</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
///
/// <param name="newWorkId">newWorkId</param>
/// <param name="newComment">newComment</param>
/// <param name="newPipeType">newPipeType</param>
/// <param name="newPipeCondition">newPipeCondition</param>
/// <param name="newGroundMoisture">newGroundMoisture</param>
/// <param name="newBoilerSize">newBoilerSize</param>
/// <param name="newPumpTotalCapacity">newPumpTotalCapacity</param>
/// <param name="newLayFlatSize">newLayFlatSize</param>
/// <param name="newLayFlatQuantityTotal">newLayFlatQuantityTotal</param>
/// <param name="newWaterStartTemp">newWaterStartTemp</param>
/// <param name="newTemp1">newTemp1</param>
/// <param name="newHoldAtT1">newHoldAtT1</param>
/// <param name="newTempT2">newTempT2</param>
/// <param name="newCookAtT2">newCookAtT2</param>
/// <param name="newCoolDownFor">newCoolDownFor</param>
/// <param name="newCoolToTemp">newCoolToTemp</param>
/// <param name="newDropInPipeRun">newDropInPipeRun</param>
/// <param name="newPipeSlopOf">newPipeSlopOf</param>
/// <param name="newF45F120">newF45F120</param>
/// <param name="newHold">newHold</param>
/// <param name="newF120F185">newF120F185</param>
/// <param name="newCookTime">newCookTime</param>
/// <param name="newCoolTime">newCoolTime</param>
/// <param name="newAproxTotal">newAproxTotal</param>
/// <param name="newWaterChangesPerHour">newWaterChangesPerHour</param>
/// <param name="newReturnWaterVelocity">newReturnWaterVelocity</param>
/// <param name="newLayflatBackPressure">newLayflatBackPressure</param>
/// <param name="newPumpLiftAtIdealHead">newPumpLiftAtIdealHead</param>
/// <param name="newWaterToFillLinerColumn">newWaterToFillLinerColumn</param>
/// <param name="newWaterPerFit">newWaterPerFit</param>
/// <param name="newInstallationResults">newInstallationResults</param>
/// <param name="newLinerTubeLabel">newLinerTubeLabel</param>
/// <param name="newHeadsIdealLabel">newHeadsIdealLabel</param>
/// <param name="newPumpingAndCirculationLabel">newPumpingAndCirculationLabel</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
public void UpdateDirect(int originalWorkId, string originalComment, string originalPipeType, string originalPipeCondition, string originalGroundMoisture, decimal originalBoilerSize, decimal originalPumpTotalCapacity, decimal originalLayFlatSize, decimal originalLayFlatQuantityTotal, decimal originalWaterStartTemp, decimal originalTemp1, decimal originalHoldAtT1, decimal originalTempT2, decimal originalCookAtT2, decimal originalCoolDownFor, decimal originalCoolToTemp, decimal originalDropInPipeRun, decimal originalPipeSlopOf, decimal originalF45F120, decimal originalHold, decimal originalF120F185, decimal originalCookTime, decimal originalCoolTime, decimal originalAproxTotal, decimal originalWaterChangesPerHour, decimal originalReturnWaterVelocity, decimal originalLayflatBackPressure, decimal originalPumpLiftAtIdealHead, decimal originalWaterToFillLinerColumn, decimal originalWaterPerFit, string originalInstallationResults, string originalLinerTubeLabel, string originalHeadsIdealLabel, string originalPumpingAndCirculationLabel, bool originalDeleted, int originalCompanyId, int newWorkId, string newComment, string newPipeType, string newPipeCondition, string newGroundMoisture, decimal newBoilerSize, decimal newPumpTotalCapacity, decimal newLayFlatSize, decimal newLayFlatQuantityTotal, decimal newWaterStartTemp, decimal newTemp1, decimal newHoldAtT1, decimal newTempT2, decimal newCookAtT2, decimal newCoolDownFor, decimal newCoolToTemp, decimal newDropInPipeRun, decimal newPipeSlopOf, decimal newF45F120, decimal newHold, decimal newF120F185, decimal newCookTime, decimal newCoolTime, decimal newAproxTotal, decimal newWaterChangesPerHour, decimal newReturnWaterVelocity, decimal newLayflatBackPressure, decimal newPumpLiftAtIdealHead, decimal newWaterToFillLinerColumn, decimal newWaterPerFit, string newInstallationResults, string newLinerTubeLabel, string newHeadsIdealLabel, string newPumpingAndCirculationLabel, bool newDeleted, int newCompanyId)
{
WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway(null);
workFullLengthLiningInversionGateway.Update(originalWorkId, originalComment, originalPipeType, originalPipeCondition, originalGroundMoisture, originalBoilerSize, originalPumpTotalCapacity, originalLayFlatSize, originalLayFlatQuantityTotal, originalWaterStartTemp, originalTemp1, originalHoldAtT1, originalTempT2, originalCookAtT2, originalCoolDownFor, originalCoolToTemp, originalDropInPipeRun, originalPipeSlopOf, originalF45F120, originalHold, originalF120F185, originalCookTime, originalCoolTime, originalAproxTotal, originalWaterChangesPerHour, originalReturnWaterVelocity, originalLayflatBackPressure, originalPumpLiftAtIdealHead, originalWaterToFillLinerColumn, originalWaterPerFit, originalInstallationResults, originalLinerTubeLabel, originalHeadsIdealLabel, originalPumpingAndCirculationLabel, originalDeleted, originalCompanyId, newWorkId, newComment, 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, newLinerTubeLabel, newHeadsIdealLabel, newPumpingAndCirculationLabel, newDeleted, newCompanyId);
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// InsertDirect
/// </summary>
/// <param name="workId">workId</param>
/// <param name="comment">comment</param>
/// <param name="pipeType">pipeType</param>
/// <param name="pipeCondition">pipeCondition</param>
/// <param name="groundMoisture">groundMoisture</param>
/// <param name="boilerSize">boilerSize</param>
/// <param name="pumpTotalCapacity">pumpTotalCapacity</param>
/// <param name="layFlatSize">layFlatSize</param>
/// <param name="layFlatQuantityTotal">layFlatQuantityTotal</param>
/// <param name="waterStartTemp">waterStartTemp</param>
/// <param name="temp1">temp1</param>
/// <param name="holdAtT1">holdAtT1</param>
/// <param name="temp2">temp2</param>
/// <param name="cookAt2">cookAt2</param>
/// <param name="coolDownFor">coolDownFor</param>
/// <param name="coolToTemp">coolToTemp</param>
/// <param name="dropInPipeRun">dropInPipeRun</param>
/// <param name="pipeSlopOf">pipeSlopOf</param>
/// <param name="f45F120">f45F120</param>
/// <param name="hold">hold</param>
/// <param name="f120F185">f120F185</param>
/// <param name="cookTime">cookTime</param>
/// <param name="coolTime">coolTime</param>
/// <param name="aproxTotal">aproxTotal</param>
/// <param name="waterChangesPerHour">waterChangesPerHour</param>
/// <param name="returnWaterVelocity">returnWaterVelocity</param>
/// <param name="layflatBackPressure">layflatBackPressure</param>
/// <param name="pumpLiftAtIdealHead">pumpLiftAtIdealHead</param>
/// <param name="waterToFillLinerColumn">waterToFillLinerColumn</param>
/// <param name="waterPerFit">waterPerFit</param>
/// <param name="installationResults">installationResults</param>
/// <param name="linerTubeLabel">inerTubeLabel</param>
/// <param name="headsIdealLabel">headsIdealLabel</param>
/// <param name="pumpingAndCirculationLabel">pumpingAndCirculationLabel</param>,
/// <param name="deleted">deleted</param>
/// <param name="companyId">companyId</param>
public void InsertDirect(int workId, string comment, string pipeType, string pipeCondition, string groundMoisture, decimal boilerSize, decimal pumpTotalCapacity, decimal layFlatSize, decimal layFlatQuantityTotal, decimal waterStartTemp, decimal temp1, decimal holdAtT1, decimal temp2, decimal cookAt2, decimal coolDownFor, decimal coolToTemp, decimal dropInPipeRun, decimal pipeSlopOf, decimal f45F120, decimal hold, decimal f120F185, decimal cookTime, decimal coolTime, decimal aproxTotal, decimal waterChangesPerHour, decimal returnWaterVelocity, decimal layflatBackPressure, decimal pumpLiftAtIdealHead, decimal waterToFillLinerColumn, decimal waterPerFit, string installationResults, string linerTubeLabel, string headsIdealLabel, string pumpingAndCirculationLabel, bool deleted, int companyId)
{
WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway(Data);
workFullLengthLiningInversionGateway.Insert(workId, comment, pipeType, pipeCondition, groundMoisture, boilerSize, pumpTotalCapacity, layFlatSize, layFlatQuantityTotal, waterStartTemp, temp1, holdAtT1, temp2, cookAt2, coolDownFor, coolToTemp, dropInPipeRun, pipeSlopOf, f45F120, hold, f120F185, cookTime, coolTime, aproxTotal, waterChangesPerHour, returnWaterVelocity, layflatBackPressure, pumpLiftAtIdealHead, waterToFillLinerColumn, waterPerFit, installationResults, linerTubeLabel, headsIdealLabel, pumpingAndCirculationLabel, deleted, companyId);
}
