protected void btnPrintLateralLocationSheet_Click(object sender, EventArgs e)
{
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
int assetId = GetAssetId();
if (assetId > 0)
{
int workIdRa = GetWorkId(Int32.Parse(hdfCurrentProjectId.Value), assetId, "Rehab Assessment", Int32.Parse(hdfCompanyId.Value));
int workIdFll = GetWorkId(Int32.Parse(hdfCurrentProjectId.Value), assetId, "Full Length Lining", Int32.Parse(hdfCompanyId.Value));
RehabAssessmentWorkDetailsGateway rehabAssessmentWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway();
rehabAssessmentWorkDetailsGateway.LoadByWorkId(workIdRa, Int32.Parse(hdfCompanyId.Value));
string measuredFrom = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMh(workIdRa);
Response.Write("<script language='javascript'> {window.open('./../../CWP/Common/lateral_location_sheet_report.aspx?source_page=lm&project_id=" + hdfCurrentProjectId.Value + "&client_id=" + hdfCurrentClientId.Value + "&work_id=" + workIdFll.ToString() + "&measured_from=" + measuredFrom + "&asset_id=" + assetId.ToString() + "', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
else
{
cvSelection.IsValid = false;
}
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="projectId">projectId</param>
/// <param name="companyId">companyId</param>
/// <param name="sectionAssetId">sectionAssetId</param>
public void Save(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int projectId, int companyId, int sectionAssetId)
{
RehabAssessmentTDS rehabAssessmentChanges = (RehabAssessmentTDS)Data.GetChanges();
if (rehabAssessmentChanges.WorkDetails.Rows.Count > 0)
{
RehabAssessmentWorkDetailsGateway rehabAssessmentWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway(rehabAssessmentChanges);
// Update sections
foreach (RehabAssessmentTDS.WorkDetailsRow workDetailsRow in (RehabAssessmentTDS.WorkDetailsDataTable)rehabAssessmentChanges.WorkDetails)
{
// Unchanged values
int workId = workDetailsRow.WorkID;
// Original values
// ... General
string originalClientId = rehabAssessmentWorkDetailsGateway.GetClientIdOriginal(workId);
DateTime? originalPreFlushDate = rehabAssessmentWorkDetailsGateway.GetPreFlushDateOriginal(workId);
DateTime? originalPreVideoDate = rehabAssessmentWorkDetailsGateway.GetPreVideoDateOriginal(workId);
// ... P1
DateTime? originalP1Date = rehabAssessmentWorkDetailsGateway.GetP1DateOriginal(workId);
int? originalCxisRemoved = rehabAssessmentWorkDetailsGateway.GetCxisRemovedOriginal(workId);
bool originalRoboticPrepCompleted = rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedOriginal(workId);
DateTime? originalRoboticPrepCompletedDate = rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedDateOriginal(workId);
bool originalP1Completed = rehabAssessmentWorkDetailsGateway.GetP1CompletedOriginal(workId);
// ... M1
DateTime? originalM1Date = rehabAssessmentWorkDetailsGateway.GetM1DateOriginal(workId);
string originalMeasurementTakenBy = rehabAssessmentWorkDetailsGateway.GetMeasurementTakenByOriginal(workId);
string originalTrafficControl = rehabAssessmentWorkDetailsGateway.GetTrafficControlOriginal(workId);
string originalSiteDetails = rehabAssessmentWorkDetailsGateway.GetSiteDetailsOriginal(workId);
bool originalPipeSizeChange = rehabAssessmentWorkDetailsGateway.GetPipeSizeChange(workId);
bool originalStandardBypass = rehabAssessmentWorkDetailsGateway.GetStandardBypass(workId);
string originalStandardBypassComments = rehabAssessmentWorkDetailsGateway.GetStandardBypassCommentsOriginal(workId);
string originalTrafficControlDetails = rehabAssessmentWorkDetailsGateway.GetTrafficControlDetailsOriginal(workId);
string originalMeasurementType = rehabAssessmentWorkDetailsGateway.GetMeasurementTypeOriginal(workId);
string originalMeasurementFromMh = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMhOriginal(workId);
string originalVideoDoneFromMh = rehabAssessmentWorkDetailsGateway.GetVideoDoneFromMhOriginal(workId);
string originalVideoDoneToMh = rehabAssessmentWorkDetailsGateway.GetVideoDoneToMhOriginal(workId);
string originalMaterial = rehabAssessmentWorkDetailsGateway.GetMaterialOriginal(workId);
string originalAccessType = rehabAssessmentWorkDetailsGateway.GetAccessTypeOriginal(workId);
// ... Comments
string originalComments = rehabAssessmentWorkDetailsGateway.GetCommentsOriginal(workId);
// ... M2
string originalVideoDistance = rehabAssessmentWorkDetailsGateway.GetVideoDistanceOriginal(workId);
// New variables
// ... General
string newClientId = rehabAssessmentWorkDetailsGateway.GetClientId(workId);
// ... P1
DateTime? newP1Date = rehabAssessmentWorkDetailsGateway.GetP1Date(workId);
int? newCxisRemoved = rehabAssessmentWorkDetailsGateway.GetCxisRemoved(workId);
bool newRoboticPrepCompleted = rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompleted(workId);
DateTime? newRoboticPrepCompletedDate = rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
bool newP1Completed = rehabAssessmentWorkDetailsGateway.GetP1Completed(workId);
// ... M1
DateTime? newM1Date = rehabAssessmentWorkDetailsGateway.GetM1Date(workId);
string newMeasurementTakenBy = rehabAssessmentWorkDetailsGateway.GetMeasurementTakenBy(workId);
string newTrafficControl = rehabAssessmentWorkDetailsGateway.GetTrafficControl(workId);
string newSiteDetails = rehabAssessmentWorkDetailsGateway.GetSiteDetails(workId);
bool newPipeSizeChange = rehabAssessmentWorkDetailsGateway.GetPipeSizeChange(workId);
bool newStandardBypass = rehabAssessmentWorkDetailsGateway.GetStandardBypass(workId);
string newStandardBypassComments = rehabAssessmentWorkDetailsGateway.GetStandardBypassComments(workId);
string newTrafficControlDetails = rehabAssessmentWorkDetailsGateway.GetTrafficControlDetails(workId);
string newMeasurementType = rehabAssessmentWorkDetailsGateway.GetMeasurementType(workId);
string newMeasurementFromMh = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMh(workId);
string newVideoDoneFromMh = rehabAssessmentWorkDetailsGateway.GetVideoDoneFromMh(workId);
string newVideoDoneToMh = rehabAssessmentWorkDetailsGateway.GetVideoDoneToMh(workId);
string newMaterial = rehabAssessmentWorkDetailsGateway.GetMaterial(workId);
string newAccessType = rehabAssessmentWorkDetailsGateway.GetAccessType(workId);
// ... M2
string newVideoDistance = rehabAssessmentWorkDetailsGateway.GetVideoDistance(workId);
// ... Comments
string newComments = rehabAssessmentWorkDetailsGateway.GetComments(workId);
// ... RA
DateTime? newPreFlushDate = rehabAssessmentWorkDetailsGateway.GetPreFlushDate(workId);
DateTime? newPreVideoDate = rehabAssessmentWorkDetailsGateway.GetPreVideoDate(workId);
// ... FLL WorkID
int workIdFll = 0; if (!workDetailsRow.IsWorkIDFllNull()) workIdFll = workDetailsRow.WorkIDFll;
if (workIdFll != 0) // ... Has Fll work
{
WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway();
workFullLengthLiningGateway.LoadByWorkId(workIdFll, companyId);
DateTime? originalProposedLiningDate = workFullLengthLiningGateway.GetProposedLiningDate(workIdFll);
DateTime? originalDeadlineLiningDate = workFullLengthLiningGateway.GetDeadlineLiningDate(workIdFll);
DateTime? originalM2Date = workFullLengthLiningGateway.GetM2Date(workIdFll);
DateTime? originalInstallDate = workFullLengthLiningGateway.GetInstallDate(workIdFll);
DateTime? originalFinalVideoDate = workFullLengthLiningGateway.GetFinalVideoDate(workIdFll);
bool originalIssueIdentified = workFullLengthLiningGateway.GetIssueIdentified(workIdFll);
bool originalIssueLFS = workFullLengthLiningGateway.GetIssueLFS(workIdFll);
bool originalIssueClient = workFullLengthLiningGateway.GetIssueClient(workIdFll);
bool originalIssueSales = workFullLengthLiningGateway.GetIssueSales(workIdFll);
bool originalIssueGivenToClient = workFullLengthLiningGateway.GetIssueGivenToClient(workIdFll);
bool originalIssueResolved = workFullLengthLiningGateway.GetIssueResolved(workIdFll);
bool originalIssueInvestigation = workFullLengthLiningGateway.GetIssueInvestigation(workIdFll);
// ... Update work
UpdateFllWork(sectionAssetId, countryId, provinceId, countyId, cityId, workIdFll, originalClientId, originalProposedLiningDate, originalDeadlineLiningDate, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideoDate, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalIssueInvestigation, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalMeasurementTakenBy, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalVideoDistance, originalComments, false, companyId, originalMaterial, originalAccessType, originalP1Completed, newClientId, originalProposedLiningDate, originalDeadlineLiningDate, newP1Date, newM1Date, originalM2Date, originalInstallDate, originalFinalVideoDate, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalIssueInvestigation, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementTakenBy, newMaterial, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newVideoDistance, newComments, false, companyId, newAccessType, newP1Completed);
UpdateRaWork(workId, originalPreFlushDate, originalPreVideoDate, newPreFlushDate, newPreVideoDate, companyId);
}
else
{
if (newClientId != "" || newP1Date.HasValue || newCxisRemoved.HasValue || newM1Date.HasValue || newMeasurementTakenBy != "" || newMaterial != "" || newTrafficControl != "" || newMeasurementType != "" || newMeasurementFromMh != "" || newVideoDoneFromMh != "" || newVideoDoneToMh != "" || newStandardBypassComments != "" || newTrafficControlDetails != "" || newVideoDistance != "") // Insert Fll work
{
WorkFullLengthLining workFullLengthLining = new WorkFullLengthLining(null);
workIdFll = workFullLengthLining.InsertDirectEmptyWorks(projectId, sectionAssetId, null, "", null, null, null, null, null, null, null, false, false, false, false, false, false, false, companyId, false, "", "");
WorkFullLengthLiningGateway workFullLengthLiningGateway = new WorkFullLengthLiningGateway();
workFullLengthLiningGateway.LoadByWorkId(workIdFll, companyId);
DateTime? originalProposedLiningDate = workFullLengthLiningGateway.GetProposedLiningDate(workIdFll);
DateTime? originalDeadlineLiningDate = workFullLengthLiningGateway.GetDeadlineLiningDate(workIdFll);
DateTime? originalM2Date = workFullLengthLiningGateway.GetM2Date(workIdFll);
DateTime? originalInstallDate = workFullLengthLiningGateway.GetInstallDate(workIdFll);
DateTime? originalFinalVideoDate = workFullLengthLiningGateway.GetFinalVideoDate(workIdFll);
bool originalIssueIdentified = workFullLengthLiningGateway.GetIssueIdentified(workIdFll);
bool originalIssueLFS = workFullLengthLiningGateway.GetIssueLFS(workIdFll);
bool originalIssueClient = workFullLengthLiningGateway.GetIssueClient(workIdFll);
bool originalIssueSales = workFullLengthLiningGateway.GetIssueSales(workIdFll);
bool originalIssueGivenToClient = workFullLengthLiningGateway.GetIssueGivenToClient(workIdFll);
bool originalIssueResolved = workFullLengthLiningGateway.GetIssueResolved(workIdFll);
bool originalIssueInvestigation = workFullLengthLiningGateway.GetIssueInvestigation(workIdFll);
// ... Update work
UpdateFllWork(sectionAssetId, countryId, provinceId, countyId, cityId, workIdFll, originalClientId, originalProposedLiningDate, originalDeadlineLiningDate, originalP1Date, originalM1Date, originalM2Date, originalInstallDate, originalFinalVideoDate, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalIssueInvestigation, originalCxisRemoved, originalRoboticPrepCompleted, originalRoboticPrepCompletedDate, originalMeasurementTakenBy, originalTrafficControl, originalSiteDetails, originalPipeSizeChange, originalStandardBypass, originalStandardBypassComments, originalTrafficControlDetails, originalMeasurementType, originalMeasurementFromMh, originalVideoDoneFromMh, originalVideoDoneToMh, originalVideoDistance, originalComments, false, companyId, originalMaterial, originalAccessType, originalP1Completed, newClientId, originalProposedLiningDate, originalDeadlineLiningDate, newP1Date, newM1Date, originalM2Date, originalInstallDate, originalFinalVideoDate, originalIssueIdentified, originalIssueLFS, originalIssueClient, originalIssueSales, originalIssueGivenToClient, originalIssueResolved, originalIssueInvestigation, newCxisRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementTakenBy, newMaterial, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardBypass, newStandardBypassComments, newTrafficControlDetails, newMeasurementType, newMeasurementFromMh, newVideoDoneFromMh, newVideoDoneToMh, newVideoDistance, newComments, false, companyId, newAccessType, newP1Completed);
UpdateRaWork(workId, originalPreFlushDate, originalPreVideoDate, newPreFlushDate, newPreVideoDate, companyId);
}
else // ... Do not have Fll work
{
UpdateRaWork(workId, originalPreFlushDate, originalPreVideoDate, newPreFlushDate, newPreVideoDate, companyId);
}
}
// JL Section WorkID
int sectionWorkId = 0;
WorkGateway workGatewayForJL = new WorkGateway();
workGatewayForJL.LoadByProjectIdAssetIdWorkType(projectId, sectionAssetId, "Junction Lining Section", companyId);
if (workGatewayForJL.Table.Rows.Count > 0)
{
sectionWorkId = workGatewayForJL.GetWorkId(sectionAssetId, "Junction Lining Section", projectId);
WorkJunctionLiningSectionGateway workJunctionLiningSectionGateway = new WorkJunctionLiningSectionGateway();
workJunctionLiningSectionGateway.LoadByWorkId(sectionWorkId, companyId);
// get old values of section
int numLats = workJunctionLiningSectionGateway.GetNumLats(sectionWorkId);
int notLinedYet = workJunctionLiningSectionGateway.GetNotLinedYet(sectionWorkId);
bool allMeasured = workJunctionLiningSectionGateway.GetAllMeasured(sectionWorkId);
bool deleted = workJunctionLiningSectionGateway.GetDeleted(sectionWorkId);
string issueWithLaterals = workJunctionLiningSectionGateway.GetIssueWithLaterals(sectionWorkId);
int notMeasuredYet = workJunctionLiningSectionGateway.GetNotMeasuredYet(sectionWorkId);
int notDeliveredYet = workJunctionLiningSectionGateway.GetNotDeliveredYet(sectionWorkId);
string trafficControl = workJunctionLiningSectionGateway.GetTrafficControl(sectionWorkId);
string trafficControlDetails = workJunctionLiningSectionGateway.GetTrafficControlDetails(sectionWorkId);
bool standardBypass = workJunctionLiningSectionGateway.GetStandardBypass(sectionWorkId);
string standardBypassComments = workJunctionLiningSectionGateway.GetStandardBypassComments(sectionWorkId);
int availableToLine = workJunctionLiningSectionGateway.GetAvailableToLine(sectionWorkId);
WorkJunctionLiningSection workJunctionLiningSection = new WorkJunctionLiningSection(null);
workJunctionLiningSection.UpdateDirect(sectionWorkId, numLats, notLinedYet, allMeasured, deleted, issueWithLaterals, notMeasuredYet, notDeliveredYet, companyId, trafficControl, trafficControlDetails, standardBypass, standardBypassComments, availableToLine, numLats, notLinedYet, allMeasured, issueWithLaterals, notMeasuredYet, notDeliveredYet, newTrafficControl, newTrafficControlDetails, newStandardBypass, newStandardBypassComments, availableToLine);
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadByWorkId
/// </summary>
/// <param name="workId">workId</param>
/// <param name="companyId">companyId</param>
public void LoadByWorkId(int workId, int companyId)
{
RehabAssessmentWorkDetailsGateway rehabAssessmentWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway(Data);
rehabAssessmentWorkDetailsGateway.LoadByWorkId(workId, companyId);
}
private void LoadWorkData(int workId, int assetId)
{
RehabAssessmentWorkDetailsGateway rehabAssessmentWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway(rehabAssessmentTDS);
if (rehabAssessmentWorkDetailsGateway.Table.Rows.Count > 0)
{
// For Header
tbxVideoLength.Text = rehabAssessmentWorkDetailsGateway.GetVideoDistance(workId);
// Load general data
tbxGeneralClientId.Text = rehabAssessmentWorkDetailsGateway.GetClientId(workId);
if (rehabAssessmentWorkDetailsGateway.GetP1Date(workId).HasValue)
{
tkrdpPrepDataP1Date.SelectedDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetP1Date(workId);
}
if (rehabAssessmentWorkDetailsGateway.GetM1Date(workId).HasValue)
{
tkrdpM1DataM1Date.SelectedDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetM1Date(workId);
}
// for RA data
if (rehabAssessmentWorkDetailsGateway.GetPreFlushDate(workId).HasValue)
{
tkrdpGeneralPreFlushDate.SelectedDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetPreFlushDate(workId);
}
if (rehabAssessmentWorkDetailsGateway.GetPreVideoDate(workId).HasValue)
{
tkrdpGeneralPreVideoDate.SelectedDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetPreVideoDate(workId);
}
// For FullLengthLiningP1 data
tbxPrepDataCXIsRemoved.Text = ""; if (rehabAssessmentWorkDetailsGateway.GetCxisRemoved(workId).HasValue) tbxPrepDataCXIsRemoved.Text = rehabAssessmentWorkDetailsGateway.GetCxisRemoved(workId).ToString();
ckbxPrepDataRoboticPrepCompleted.Checked = rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompleted(workId);
if (rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedDate(workId).HasValue)
{
tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
}
ckbxPrepDataP1Completed.Checked = rehabAssessmentWorkDetailsGateway.GetP1Completed(workId);
// For FullLengthLiningM1 data
// ... for material
ddlM1DataMaterial.SelectedValue = rehabAssessmentWorkDetailsGateway.GetMaterial(workId);
// ... For m1 data
tbxM1DataMeasurementsTakenBy.Text = rehabAssessmentWorkDetailsGateway.GetMeasurementTakenBy(workId);
ddlM1DataTrafficControl.SelectedValue = rehabAssessmentWorkDetailsGateway.GetTrafficControl(workId);
if (rehabAssessmentWorkDetailsGateway.GetSiteDetails(workId) == "") ddlM1DataSiteDetails.SelectedIndex = 0; else ddlM1DataSiteDetails.SelectedValue = rehabAssessmentWorkDetailsGateway.GetSiteDetails(workId);
if (rehabAssessmentWorkDetailsGateway.GetAccessType(workId) == "") ddlM1DataAccessType.SelectedIndex = 0; else ddlM1DataAccessType.SelectedValue = rehabAssessmentWorkDetailsGateway.GetAccessType(workId);
ckbxM1DataPipeSizeChange.Checked = rehabAssessmentWorkDetailsGateway.GetPipeSizeChange(workId);
ckbxM1DataStandardBypass.Checked = rehabAssessmentWorkDetailsGateway.GetStandardBypass(workId);
tbxM1DataStandardBypassComments.Text = rehabAssessmentWorkDetailsGateway.GetStandardBypassComments(workId);
tbxM1DataTrafficControlDetails.Text = rehabAssessmentWorkDetailsGateway.GetTrafficControlDetails(workId);
ddlM1DataMeasurementType.SelectedValue = rehabAssessmentWorkDetailsGateway.GetMeasurementType(workId);
ddlM1DataMeasuredFromMh.SelectedValue = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMh(workId);
ddlM1DataVideoDoneFromMh.SelectedValue = rehabAssessmentWorkDetailsGateway.GetVideoDoneFromMh(workId);
tbxM1DataMeasuredFromMh.Text = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMh(workId);
tbxM1DataVideoDoneFromMh.Text = rehabAssessmentWorkDetailsGateway.GetVideoDoneFromMh(workId);
ddlM1DataVideoDoneToMh.SelectedValue = rehabAssessmentWorkDetailsGateway.GetVideoDoneToMh(workId);
// For comments
tbxCommentsDataComments.Text = rehabAssessmentWorkDetailsGateway.GetComments(workId);
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm8 master = (mForm8)this.Master;
master.ActiveToolbar = "eSewers";
// For error message
hdfErrorFieldList.Value = "";
// 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 workIdFll = Int32.Parse(hdfWorkIdFll.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
RehabAssessmentWorkDetailsGateway raWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway();
raWorkDetailsGateway.LoadByWorkId(workId, companyId);
RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails();
raLateralDetails.LoadForEdit(workIdFll, 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
// ... Load material for m1
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
ddlM1DataMaterial.SelectedValue = materialInformationGateway.GetLastMaterialType(assetId);
}
// Hide or show the Old CWP ID field
if (tbxOldCwpId.Text == "")
{
lblOldCwpId.Visible = false;
tbxOldCwpId.Visible = false;
}
if (tbxFlowOrderId.Text == "")
{
LoadRehabAssessmentData(currentProjectId, assetId, companyId);
}
}
private void LoadWorkData(int workId, int assetId)
{
RehabAssessmentWorkDetailsGateway rehabAssessmentWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway(rehabAssessmentTDS);
if (rehabAssessmentWorkDetailsGateway.Table.Rows.Count > 0)
{
// For Header
tbxVideoLength.Text = rehabAssessmentWorkDetailsGateway.GetVideoDistance(workId);
// Load general data
tbxGeneralClientId.Text = rehabAssessmentWorkDetailsGateway.GetClientId(workId);
tbxPrepDataP1Date.Text = "";
if (rehabAssessmentWorkDetailsGateway.GetP1Date(workId).HasValue)
{
DateTime p1Date = (DateTime)rehabAssessmentWorkDetailsGateway.GetP1Date(workId);
tbxPrepDataP1Date.Text = p1Date.Month.ToString() + "/" + p1Date.Day.ToString() + "/" + p1Date.Year.ToString();
}
tbxM1DataM1Date.Text = "";
if (rehabAssessmentWorkDetailsGateway.GetM1Date(workId).HasValue)
{
DateTime m1Date = (DateTime)rehabAssessmentWorkDetailsGateway.GetM1Date(workId);
tbxM1DataM1Date.Text = m1Date.Month.ToString() + "/" + m1Date.Day.ToString() + "/" + m1Date.Year.ToString();
}
// ... for RA data
tbxGeneralPreFlushDate.Text = "";
if (rehabAssessmentWorkDetailsGateway.GetPreFlushDate(workId).HasValue)
{
DateTime preFlushDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetPreFlushDate(workId);
tbxGeneralPreFlushDate.Text = preFlushDate.Month.ToString() + "/" + preFlushDate.Day.ToString() + "/" + preFlushDate.Year.ToString();
}
tbxGeneralPreVideoDate.Text = "";
if (rehabAssessmentWorkDetailsGateway.GetPreVideoDate(workId).HasValue)
{
DateTime preVideoDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetPreVideoDate(workId);
tbxGeneralPreVideoDate.Text = preVideoDate.Month.ToString() + "/" + preVideoDate.Day.ToString() + "/" + preVideoDate.Year.ToString();
}
// For FullLengthLiningP1 data
tbxPrepDataCXIsRemoved.Text = ""; if (rehabAssessmentWorkDetailsGateway.GetCxisRemoved(workId).HasValue) tbxPrepDataCXIsRemoved.Text = rehabAssessmentWorkDetailsGateway.GetCxisRemoved(workId).ToString();
ckbxPrepDataRoboticPrepCompleted.Checked = rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompleted(workId);
tbxPrepDataRoboticPrepCompletedDate.Text = "";
if (rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedDate(workId).HasValue)
{
DateTime prePrepDataRoboticPrepCompletedDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetRoboticPrepCompletedDate(workId);
tbxPrepDataRoboticPrepCompletedDate.Text = prePrepDataRoboticPrepCompletedDate.Month.ToString() + "/" + prePrepDataRoboticPrepCompletedDate.Day.ToString() + "/" + prePrepDataRoboticPrepCompletedDate.Year.ToString();
}
ckbxPrepDataP1Completed.Checked = rehabAssessmentWorkDetailsGateway.GetP1Completed(workId);
// For FullLengthLiningM1 data
// ... for material
tbxM1DataMaterial.Text = rehabAssessmentWorkDetailsGateway.GetMaterial(workId);
// ... For m1 data
tbxM1DataMeasurementsTakenBy.Text = rehabAssessmentWorkDetailsGateway.GetMeasurementTakenBy(workId);
tbxM1DataTrafficControl.Text = rehabAssessmentWorkDetailsGateway.GetTrafficControl(workId);
tbxM1DataSiteDetails.Text = rehabAssessmentWorkDetailsGateway.GetSiteDetails(workId);
tbxM1DataAccessType.Text = rehabAssessmentWorkDetailsGateway.GetAccessType(workId);
ckbxM1DataPipeSizeChange.Checked = rehabAssessmentWorkDetailsGateway.GetPipeSizeChange(workId);
ckbxM1DataStandardBypass.Checked = rehabAssessmentWorkDetailsGateway.GetStandardBypass(workId);
//tbxM1DataIssue.Text = GetIssueSelected (rehabAssessmentWorkDetailsGateway.GetIssue(workId));
tbxM1DataStandardBypassComments.Text = rehabAssessmentWorkDetailsGateway.GetStandardBypassComments(workId);
tbxM1DataTrafficControlDetails.Text = rehabAssessmentWorkDetailsGateway.GetTrafficControlDetails(workId);
tbxM1DataMeasurementType.Text = rehabAssessmentWorkDetailsGateway.GetMeasurementType(workId);
tbxM1DataMeasuredFromMH.Text = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMh(workId);
hdfMeasuredFrom.Value = rehabAssessmentWorkDetailsGateway.GetMeasurementFromMh(workId);
tbxM1DataVideoDoneFromMH.Text = rehabAssessmentWorkDetailsGateway.GetVideoDoneFromMh(workId);
tbxM1DataToMH.Text = rehabAssessmentWorkDetailsGateway.GetVideoDoneToMh(workId);
//tbxM1DataRoboticPrepDate.Text = "";
//if (rehabAssessmentWorkDetailsGateway.GetRoboticPrepDate(workId).HasValue)
//{
// DateTime roboticPrepDate = (DateTime)rehabAssessmentWorkDetailsGateway.GetRoboticPrepDate(workId);
// tbxM1DataRoboticPrepDate.Text = roboticPrepDate.Month.ToString() + "/" + roboticPrepDate.Day.ToString() + "/" + roboticPrepDate.Year.ToString();
//}
// For comments
tbxCommentsDataComments.Text = rehabAssessmentWorkDetailsGateway.GetComments(workId);
}
}
