// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="companyId">companyId</param>
public void DeleteDirect(int viewId, int companyId)
{
WorkViewDisplay workViewDisplay = new WorkViewDisplay(null);
workViewDisplay.DeleteDirect(viewId, companyId);
WorkViewCondition workViewCondition = new WorkViewCondition(null);
workViewCondition.DeleteDirect(viewId, companyId);
WorkViewSort workViewSort = new WorkViewSort(null);
workViewSort.DeleteDirect(viewId, companyId);
WorkViewGateway workViewGateway = new WorkViewGateway(null);
workViewGateway.Delete(viewId, companyId);
}
private string GetColumnsToDisplay()
{
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value.Trim();
string columnsToDisplay = "&columns_to_display=";
string columnsToDisplay2 = "&columns_to_display2=";
columnsToDisplay2 = columnsToDisplay2 + (cbxIdManhole.Checked ? "MHID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxStreet.Checked ? "Address," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLatitude.Checked ? "Latitud," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLongitude.Checked ? "Longitude," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxShape.Checked ? "ManholeShape," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLocation.Checked ? "Location," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxConditionRaiting.Checked ? "ConditionRating," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPreppedDate.Checked ? "PreppedDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSprayedDate.Checked ? "SprayedDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxBatchDate.Checked ? "Date," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxComments.Checked ? "Comments," : "");
if (hdfBtnOrigin.Value == "Search")
{
columnsToDisplay = columnsToDisplay + (cbxIdManhole.Checked ? "MHID," : "");
columnsToDisplay = columnsToDisplay + (cbxStreet.Checked ? "Address," : "");
columnsToDisplay = columnsToDisplay + (cbxLatitude.Checked ? "Latitud," : "");
columnsToDisplay = columnsToDisplay + (cbxLongitude.Checked ? "Longitude," : "");
columnsToDisplay = columnsToDisplay + (cbxShape.Checked ? "ManholeShape," : "");
columnsToDisplay = columnsToDisplay + (cbxLocation.Checked ? "Location," : "");
columnsToDisplay = columnsToDisplay + (cbxConditionRaiting.Checked ? "ConditionRating," : "");
columnsToDisplay = columnsToDisplay + (cbxPreppedDate.Checked ? "PreppedDate," : "");
columnsToDisplay = columnsToDisplay + (cbxSprayedDate.Checked ? "SprayedDate," : "");
columnsToDisplay = columnsToDisplay + (cbxBatchDate.Checked ? "Date," : "");
columnsToDisplay = columnsToDisplay + (cbxComments.Checked ? "Comments," : "");
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
columnsToDisplay = columnsToDisplay + workViewDisplay.GetColumnsToDisplayForViews(viewId, workType, companyId);
}
}
return columnsToDisplay + columnsToDisplay2;
}
private string GetColumnsToDisplay()
{
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value.Trim();
string columnsToDisplay = "&columns_to_display=";
string columnsToDisplay2 = "&columns_to_display2=";
columnsToDisplay2 = columnsToDisplay2 + (cbxIdSection.Checked ? "FlowOrderID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIdRepair.Checked ? "RepairPointID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSubArea.Checked ? "SubArea," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxStreet.Checked ? "Street," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUsmh.Checked ? " USMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUsmhAddress.Checked ? "USMHAddress," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDsmh.Checked ? " DSMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDsmhAddress.Checked ? "DSMHAddress," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMapSize.Checked ? "MapSize," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxConfirmedSize.Checked ? "Size_," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMapLength.Checked ? "MapLength," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSteelTapeLength.Checked ? "Length," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVideoLength.Checked ? "VideoLength," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLaterals.Checked ? "Laterals," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLiveLaterals.Checked ? "LiveLaterals," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxClientId.Checked ? "ClientID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMeasurementsTakenBy.Checked ? "MeasurementTakenBy," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPreFlushDate.Checked ? "PreFlushDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPreVideoDate.Checked ? "PreVideoDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxP1Date.Checked ? "P1Date," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRepairConfirmationDate.Checked ? "RepairConfirmationDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxTrafficControl.Checked ? "TrafficControl," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMaterial.Checked ? "MaterialType," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxBypassRequired.Checked ? "BypassRequired," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRoboticPrepRequired.Checked ? "RoboticPrepRequired," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCXIsRemoved.Checked ? "CXIsRemoved," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRoboticDistances.Checked ? "RoboticDistances," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxProposedLiningDate.Checked ? "ProposedLiningDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDeadlineLiningDate.Checked ? "DeadlineLiningDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxGroutDate.Checked ? "GroutDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxFinalVideo.Checked ? "FinalVideoDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxEstimatedJoints.Checked ? "EstimatedJoints," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxJointsTestSealed.Checked ? "JointsTestSealed," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueIdentified.Checked ? "IssueIdentified," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLFSIssue.Checked ? "IssueLFS," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxClientIssue.Checked ? "IssueClient," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSalesIssue.Checked ? "IssueSales," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueGivenToClient.Checked ? "IssueGivenToClient," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueInvestigation.Checked ? "IssueInvestigation," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueResolved.Checked ? "IssueResolved," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxComments.Checked ? "Comments," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRepairType.Checked ? "Type," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDefectQualifier.Checked ? "DefectQualifier," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDefectDetails.Checked ? "DefectDetails," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxExtraRepair.Checked ? "ExtraRepair," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCancelled.Checked ? "Cancelled," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxApproval.Checked ? "Approval," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRepairComments.Checked ? "Comments," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxReamDistance.Checked ? "ReamDistance," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxReamDate.Checked ? "ReamDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLinerDistance.Checked ? "LinerDistance," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDirection.Checked ? "Direction," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxReinstates.Checked ? "Reinstates," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLtMh.Checked ? "LTMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVtMh.Checked ? "VTMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDistance.Checked ? "Distance," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRepairSize.Checked ? "Size_," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRepairLength.Checked ? "Length," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxInstallDate.Checked ? "InstallDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMhShot.Checked ? "MHShot," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxGroutDistance.Checked ? "GroutDistance," : "");
if (hdfBtnOrigin.Value == "Search")
{
columnsToDisplay = columnsToDisplay + (cbxIdSection.Checked ? "FlowOrderID," : "");
columnsToDisplay = columnsToDisplay + (cbxIdRepair.Checked ? "RepairPointID," : "");
columnsToDisplay = columnsToDisplay + (cbxSubArea.Checked ? "SubArea," : "");
columnsToDisplay = columnsToDisplay + (cbxStreet.Checked ? "Street," : "");
columnsToDisplay = columnsToDisplay + (cbxUsmh.Checked ? " USMH," : "");
columnsToDisplay = columnsToDisplay + (cbxUsmhAddress.Checked ? "USMHAddress," : "");
columnsToDisplay = columnsToDisplay + (cbxDsmh.Checked ? " DSMH," : "");
columnsToDisplay = columnsToDisplay + (cbxDsmhAddress.Checked ? "DSMHAddress," : "");
columnsToDisplay = columnsToDisplay + (cbxMapSize.Checked ? "MapSize," : "");
columnsToDisplay = columnsToDisplay + (cbxConfirmedSize.Checked ? "Size_," : "");
columnsToDisplay = columnsToDisplay + (cbxMapLength.Checked ? "MapLength," : "");
columnsToDisplay = columnsToDisplay + (cbxSteelTapeLength.Checked ? "Length," : "");
columnsToDisplay = columnsToDisplay + (cbxVideoLength.Checked ? "VideoLength," : "");
columnsToDisplay = columnsToDisplay + (cbxLaterals.Checked ? "Laterals," : "");
columnsToDisplay = columnsToDisplay + (cbxLiveLaterals.Checked ? "LiveLaterals," : "");
columnsToDisplay = columnsToDisplay + (cbxClientId.Checked ? "ClientID," : "");
columnsToDisplay = columnsToDisplay + (cbxMeasurementsTakenBy.Checked ? "MeasurementTakenBy," : "");
columnsToDisplay = columnsToDisplay + (cbxPreFlushDate.Checked ? "PreFlushDate," : "");
columnsToDisplay = columnsToDisplay + (cbxPreVideoDate.Checked ? "PreVideoDate," : "");
columnsToDisplay = columnsToDisplay + (cbxP1Date.Checked ? "P1Date," : "");
columnsToDisplay = columnsToDisplay + (cbxRepairConfirmationDate.Checked ? "RepairConfirmationDate," : "");
columnsToDisplay = columnsToDisplay + (cbxTrafficControl.Checked ? "TrafficControl," : "");
columnsToDisplay = columnsToDisplay + (cbxMaterial.Checked ? "MaterialType," : "");
columnsToDisplay = columnsToDisplay + (cbxBypassRequired.Checked ? "BypassRequired," : "");
columnsToDisplay = columnsToDisplay + (cbxRoboticPrepRequired.Checked ? "RoboticPrepRequired," : "");
columnsToDisplay = columnsToDisplay + (cbxCXIsRemoved.Checked ? "CXIsRemoved," : "");
columnsToDisplay = columnsToDisplay + (cbxRoboticDistances.Checked ? "RoboticDistances," : "");
columnsToDisplay = columnsToDisplay + (cbxProposedLiningDate.Checked ? "ProposedLiningDate," : "");
columnsToDisplay = columnsToDisplay + (cbxDeadlineLiningDate.Checked ? "DeadlineLiningDate," : "");
columnsToDisplay = columnsToDisplay + (cbxGroutDate.Checked ? "GroutDate," : "");
columnsToDisplay = columnsToDisplay + (cbxFinalVideo.Checked ? "FinalVideoDate," : "");
columnsToDisplay = columnsToDisplay + (cbxEstimatedJoints.Checked ? "EstimatedJoints," : "");
columnsToDisplay = columnsToDisplay + (cbxJointsTestSealed.Checked ? "JointsTestSealed," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueIdentified.Checked ? "IssueIdentified," : "");
columnsToDisplay = columnsToDisplay + (cbxLFSIssue.Checked ? "IssueLFS," : "");
columnsToDisplay = columnsToDisplay + (cbxClientIssue.Checked ? "IssueClient," : "");
columnsToDisplay = columnsToDisplay + (cbxSalesIssue.Checked ? "IssueSales," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueGivenToClient.Checked ? "IssueGivenToClient," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueInvestigation.Checked ? "IssueInvestigation," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueResolved.Checked ? "IssueResolved," : "");
columnsToDisplay = columnsToDisplay + (cbxComments.Checked ? "Comments," : "");
columnsToDisplay = columnsToDisplay + (cbxRepairType.Checked ? "Type," : "");
columnsToDisplay = columnsToDisplay + (cbxDefectQualifier.Checked ? "DefectQualifier," : "");
columnsToDisplay = columnsToDisplay + (cbxDefectDetails.Checked ? "DefectDetails," : "");
columnsToDisplay = columnsToDisplay + (cbxExtraRepair.Checked ? "ExtraRepair," : "");
columnsToDisplay = columnsToDisplay + (cbxCancelled.Checked ? "Cancelled," : "");
columnsToDisplay = columnsToDisplay + (cbxApproval.Checked ? "Approval," : "");
columnsToDisplay = columnsToDisplay + (cbxRepairComments.Checked ? "Comments," : "");
columnsToDisplay = columnsToDisplay + (cbxReamDistance.Checked ? "ReamDistance," : "");
columnsToDisplay = columnsToDisplay + (cbxReamDate.Checked ? "ReamDate," : "");
columnsToDisplay = columnsToDisplay + (cbxLinerDistance.Checked ? "LinerDistance," : "");
columnsToDisplay = columnsToDisplay + (cbxDirection.Checked ? "Direction," : "");
columnsToDisplay = columnsToDisplay + (cbxReinstates.Checked ? "Reinstates," : "");
columnsToDisplay = columnsToDisplay + (cbxLtMh.Checked ? "LTMH," : "");
columnsToDisplay = columnsToDisplay + (cbxVtMh.Checked ? "VTMH," : "");
columnsToDisplay = columnsToDisplay + (cbxDistance.Checked ? "Distance," : "");
columnsToDisplay = columnsToDisplay + (cbxRepairSize.Checked ? "Size_," : "");
columnsToDisplay = columnsToDisplay + (cbxRepairLength.Checked ? "Length," : "");
columnsToDisplay = columnsToDisplay + (cbxInstallDate.Checked ? "InstallDate," : "");
columnsToDisplay = columnsToDisplay + (cbxMhShot.Checked ? "MHShot," : "");
columnsToDisplay = columnsToDisplay + (cbxGroutDistance.Checked ? "GroutDistance," : "");
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
columnsToDisplay = columnsToDisplay + workViewDisplay.GetColumnsToDisplayForViews(viewId, workType, companyId);
}
}
return columnsToDisplay + columnsToDisplay2;
}
private string GetColumnsToDisplay()
{
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value.Trim();
string columnsToDisplay = "&columns_to_display=SectionID,";
string columnsToDisplay2 = "&columns_to_display2=SectionID,";
columnsToDisplay2 = columnsToDisplay2 + (cbxOldCwpId.Checked ? "OriginalSectionID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxClientLateralId.Checked ? "ClientLateralId," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHamiltonInspectionNumber.Checked ? "HamiltonInspectionNumber," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxStreet.Checked ? "Street," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxAddress.Checked ? "MN," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMH.Checked ? "U_SMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMH.Checked ? "D_SMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVideoInspection.Checked ? "VideoInspection," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVideoLengthToPropertyLine.Checked ? "VideoLengthToPropertyLine," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDepthOfLocated.Checked ? "DepthOfLocated," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPipeLocated.Checked ? "PipeLocated," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxServicesLocated.Checked ? "ServicesLocated," : "");
//columnsToDisplay2 = columnsToDisplay2 + (cbxCoRequired.Checked ? "CoRequired," : "");
//columnsToDisplay2 = columnsToDisplay2 + (cbxPitRequired.Checked ? "PitRequired," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPrepType.Checked ? "PrepType," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCoPitLocation.Checked ? "CoPitLocation," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCoInstalled.Checked ? "CoInstalled," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxBackfilledConcrete.Checked ? "BackfilledConcrete," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxBackfilledSoil.Checked ? "BackfilledSoil," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxGrouted.Checked ? "Grouted," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCored.Checked ? "Cored," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPrepped.Checked ? "Prepped," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPreVideo.Checked ? "PreVideo," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMeasured.Checked ? "Measured," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxConnectionType.Checked ? "ConnectionType," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLinerType.Checked ? "LinerType," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxFlange.Checked ? "Flange," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxGasket.Checked ? "Gasket," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMainSize.Checked ? "MainSize," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLinerSize.Checked ? "LinerSize," : "");
//columnsToDisplay2 = columnsToDisplay2 + (cbxLiningThruCo.Checked ? "LiningThruCo," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxNoticeDelivered.Checked ? "NoticeD_elivered," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxInProcess.Checked ? "InProcess," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxInStock.Checked ? "InStock," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDelivered.Checked ? "Delivered," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLinerInstalled.Checked ? "LinerInstalled," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxFinalVideo.Checked ? "FinalVideo," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDistanceFromUSMH.Checked ? "DistanceFromUSMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDistanceFromDSMH.Checked ? "DistanceFromDSMH," : "");
//columnsToDisplay2 = columnsToDisplay2 + (cbxPostContractDigRequired.Checked ? "PostContractDigRequired," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCoCutDown.Checked ? "CoCutDown," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxFinalRestoration.Checked ? "FinalRestoration," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCost.Checked ? "Cost," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxBuidRebuid.Checked ? "BuildRebuild," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxComments.Checked ? "Comments," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHistory.Checked ? "History," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDigRequiredPriorToLining.Checked ? "DigRequiredPriorToLining," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDigRequiredPriorToLiningCompleted.Checked ? "DigRequiredPriorToLiningCompleted," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDigRequiredAfterLining.Checked ? "DigRequiredAfterLining," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDigRequiredAfterLiningCompleted.Checked ? "DigRequiredAfterLiningCompleted," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxOutOfScope.Checked ? "OutOfScope," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHoldClientIssue.Checked ? "HoldClientIssue," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHoldClientIssueResolved.Checked ? "HoldClientIssueResolved," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHoldLFSIssue.Checked ? "HoldLFSIssue," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHoldLFSIssueResolved.Checked ? "HoldLFSIssueResolved," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRequiresRoboticPrep.Checked ? "LateralRequiresRoboticPrep," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxRequiresRoboticPrepCompleted.Checked ? "LateralRequiresRoboticPrepCompleted," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDyeTestReq.Checked ? "DyeTestReq," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDyeTestComplete.Checked ? "DyeTestComplete," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxContractYear.Checked ? "ContractYear," : "");
columnsToDisplay2 = columnsToDisplay2.Substring(0, columnsToDisplay2.Length - 1);
if (hdfBtnOrigin.Value == "Search")
{
columnsToDisplay = columnsToDisplay + (cbxOldCwpId.Checked ? "OriginalSectionID," : "");
columnsToDisplay = columnsToDisplay + (cbxClientLateralId.Checked ? "ClientLateralId," : "");
columnsToDisplay = columnsToDisplay + (cbxHamiltonInspectionNumber.Checked ? "HamiltonInspectionNumber," : "");
columnsToDisplay = columnsToDisplay + (cbxStreet.Checked ? "Street," : "");
columnsToDisplay = columnsToDisplay + (cbxAddress.Checked ? "MN," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMH.Checked ? "U_SMH," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMH.Checked ? "D_SMH," : "");
columnsToDisplay = columnsToDisplay + (cbxVideoInspection.Checked ? "VideoInspection," : "");
columnsToDisplay = columnsToDisplay + (cbxVideoLengthToPropertyLine.Checked ? "VideoLengthToPropertyLine," : "");
columnsToDisplay = columnsToDisplay + (cbxDepthOfLocated.Checked ? "DepthOfLocated," : "");
columnsToDisplay = columnsToDisplay + (cbxPipeLocated.Checked ? "PipeLocated," : "");
columnsToDisplay = columnsToDisplay + (cbxServicesLocated.Checked ? "ServicesLocated," : "");
//columnsToDisplay = columnsToDisplay + (cbxCoRequired.Checked ? "CoRequired," : "");
//columnsToDisplay = columnsToDisplay + (cbxPitRequired.Checked ? "PitRequired," : "");
columnsToDisplay = columnsToDisplay + (cbxPrepType.Checked ? "PrepType," : "");
columnsToDisplay = columnsToDisplay + (cbxCoPitLocation.Checked ? "CoPitLocation," : "");
columnsToDisplay = columnsToDisplay + (cbxCoInstalled.Checked ? "CoInstalled," : "");
columnsToDisplay = columnsToDisplay + (cbxBackfilledConcrete.Checked ? "BackfilledConcrete," : "");
columnsToDisplay = columnsToDisplay + (cbxBackfilledSoil.Checked ? "BackfilledSoil," : "");
columnsToDisplay = columnsToDisplay + (cbxGrouted.Checked ? "Grouted," : "");
columnsToDisplay = columnsToDisplay + (cbxCored.Checked ? "Cored," : "");
columnsToDisplay = columnsToDisplay + (cbxPrepped.Checked ? "Prepped," : "");
columnsToDisplay = columnsToDisplay + (cbxPreVideo.Checked ? "PreVideo," : "");
columnsToDisplay = columnsToDisplay + (cbxMeasured.Checked ? "Measured," : "");
columnsToDisplay = columnsToDisplay + (cbxConnectionType.Checked ? "ConnectionType," : "");
columnsToDisplay = columnsToDisplay + (cbxLinerType.Checked ? "LinerType," : "");
columnsToDisplay = columnsToDisplay + (cbxFlange.Checked ? "Flange," : "");
columnsToDisplay = columnsToDisplay + (cbxGasket.Checked ? "Gasket," : "");
columnsToDisplay = columnsToDisplay + (cbxMainSize.Checked ? "MainSize," : "");
columnsToDisplay = columnsToDisplay + (cbxLinerSize.Checked ? "LinerSize," : "");
//columnsToDisplay = columnsToDisplay + (cbxLiningThruCo.Checked ? "LiningThruCo," : "");
columnsToDisplay = columnsToDisplay + (cbxNoticeDelivered.Checked ? "NoticeD_elivered," : "");
columnsToDisplay = columnsToDisplay + (cbxInProcess.Checked ? "InProcess," : "");
columnsToDisplay = columnsToDisplay + (cbxInStock.Checked ? "InStock," : "");
columnsToDisplay = columnsToDisplay + (cbxDelivered.Checked ? "Delivered," : "");
columnsToDisplay = columnsToDisplay + (cbxLinerInstalled.Checked ? "LinerInstalled," : "");
columnsToDisplay = columnsToDisplay + (cbxFinalVideo.Checked ? "FinalVideo," : "");
columnsToDisplay = columnsToDisplay + (cbxDistanceFromUSMH.Checked ? "DistanceFromUSMH," : "");
columnsToDisplay = columnsToDisplay + (cbxDistanceFromDSMH.Checked ? "DistanceFromDSMH," : "");
//columnsToDisplay = columnsToDisplay + (cbxPostContractDigRequired.Checked ? "PostContractDigRequired," : "");
columnsToDisplay = columnsToDisplay + (cbxCoCutDown.Checked ? "CoCutDown," : "");
columnsToDisplay = columnsToDisplay + (cbxFinalRestoration.Checked ? "FinalRestoration," : "");
columnsToDisplay = columnsToDisplay + (cbxCost.Checked ? "Cost," : "");
columnsToDisplay = columnsToDisplay + (cbxBuidRebuid.Checked ? "BuildRebuild," : "");
columnsToDisplay = columnsToDisplay + (cbxComments.Checked ? "Comments," : "");
columnsToDisplay = columnsToDisplay + (cbxHistory.Checked ? "History," : "");
columnsToDisplay = columnsToDisplay + (cbxDigRequiredPriorToLining.Checked ? "DigRequiredPriorToLining," : "");
columnsToDisplay = columnsToDisplay + (cbxDigRequiredPriorToLiningCompleted.Checked ? "DigRequiredPriorToLiningCompleted," : "");
columnsToDisplay = columnsToDisplay + (cbxDigRequiredAfterLining.Checked ? "DigRequiredAfterLining," : "");
columnsToDisplay = columnsToDisplay + (cbxDigRequiredAfterLiningCompleted.Checked ? "DigRequiredAfterLiningCompleted," : "");
columnsToDisplay = columnsToDisplay + (cbxOutOfScope.Checked ? "OutOfScope," : "");
columnsToDisplay = columnsToDisplay + (cbxHoldClientIssue.Checked ? "HoldClientIssue," : "");
columnsToDisplay = columnsToDisplay + (cbxHoldClientIssueResolved.Checked ? "HoldClientIssueResolved," : "");
columnsToDisplay = columnsToDisplay + (cbxHoldLFSIssue.Checked ? "HoldLFSIssue," : "");
columnsToDisplay = columnsToDisplay + (cbxHoldLFSIssueResolved.Checked ? "HoldLFSIssueResolved," : "");
columnsToDisplay = columnsToDisplay + (cbxRequiresRoboticPrep.Checked ? "LateralRequiresRoboticPrep," : "");
columnsToDisplay = columnsToDisplay + (cbxRequiresRoboticPrepCompleted.Checked ? "LateralRequiresRoboticPrepCompleted," : "");
columnsToDisplay = columnsToDisplay + (cbxDyeTestReq.Checked ? "DyeTestReq," : "");
columnsToDisplay = columnsToDisplay + (cbxDyeTestComplete.Checked ? "DyeTestComplete," : "");
columnsToDisplay = columnsToDisplay + (cbxContractYear.Checked ? "ContractYear," : "");
columnsToDisplay = columnsToDisplay.Substring(0, columnsToDisplay.Length - 1);
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
columnsToDisplay = columnsToDisplay + workViewDisplay.GetColumnsToDisplayForViews(viewId, workType, companyId);
}
}
return columnsToDisplay + columnsToDisplay2;
}
private string GetColumnsToDisplay()
{
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value.Trim();
string columnsToDisplay = "&columns_to_display=";
if (hdfBtnOrigin.Value == "Search")
{
WorkTypeViewDisplay workTypeViewDisplay = new WorkTypeViewDisplay();
columnsToDisplay = columnsToDisplay + workTypeViewDisplay.GetColumnsByDefault(workType, companyId, true);
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
columnsToDisplay = columnsToDisplay + workViewDisplay.GetColumnsToDisplayForViews(viewId, workType, companyId);
}
}
return columnsToDisplay;
}
private string GetColumnsToDisplay()
{
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value.Trim();
string columnsToDisplay = "&columns_to_display=";
string columnsToDisplay2 = "&columns_to_display2=";
columnsToDisplay2 = columnsToDisplay2 + (cbxIdSection.Checked ? " SectionID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxOldCWPID.Checked ? "OriginalSectionID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSubArea.Checked ? "SubArea," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxStreet.Checked ? "Street," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUsmh.Checked ? " USMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMH.Checked ? " DSMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxProposedLiningDate.Checked ? "ProposedLiningDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDeadlineLiningDate.Checked ? "DeadlineLiningDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxP1Date.Checked ? "P1Date," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxM1Date.Checked ? "M1Date," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxM2Date.Checked ? "M2Date," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxInstallDate.Checked ? "InstallDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxFinalVideoDate.Checked ? "FinalVideoDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxConfirmedSize.Checked ? "Size_," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxActualLength.Checked ? "ActualLength," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxComments.Checked ? " Comments," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMapSize.Checked ? "MapSize," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMapLength.Checked ? "MapLength," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVideoLength.Checked ? "VideoLength," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLaterals.Checked ? " Laterals," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLiveLaterals.Checked ? "LiveLaterals," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxClientID.Checked ? "ClientID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPreFlushDate.Checked ? "PreFlushDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPreVideoDate.Checked ? "PreVideoDate," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueIdentified.Checked ? "IssueIdentified," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLFSIssue.Checked ? "IssueLFS," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxClientIssue.Checked ? "IssueClient," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSalesIssue.Checked ? "IssueSales," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueGivenToClient.Checked ? "IssueGivenToClient," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueInvestigation.Checked ? "IssueInvestigation," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxIssueResolved.Checked ? "IssueResolved," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCXIsRemoved.Checked ? "CXIsRemoved," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMaterial.Checked ? "MaterialType," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHAddress.Checked ? "USMHAddress," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHDepth.Checked ? "USMHDepth," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHMouth12.Checked ? "USMHMouth12," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHMouth1.Checked ? "USMHMouth1," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHMouth2.Checked ? "USMHMouth2," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHMouth3.Checked ? "USMHMouth3," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHMouth4.Checked ? "USMHMouth4," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxUSMHMouth5.Checked ? "USMHMouth5," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHAddress.Checked ? "DSMHAddress," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHDepth.Checked ? "DSMHDepth," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHMouth12.Checked ? "DSMHMouth12," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHMouth1.Checked ? "DSMHMouth1," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHMouth2.Checked ? "DSMHMouth2," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHMouth3.Checked ? "DSMHMouth3," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHMouth4.Checked ? "DSMHMouth4," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDSMHMouth5.Checked ? "DSMHMouth5," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxTrafficControl.Checked ? "TrafficControl," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSiteDetails.Checked ? "SiteDetails," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxPipeSizeChange.Checked ? "PipeSizeChange," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxStandardBypass.Checked ? "StandardBypass," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxStandardBypassComments.Checked ? "StandardBypassComments," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxTrafficControlDetails.Checked ? "TrafficControlDetails," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMeasurementType.Checked ? "MeasurementType," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxMeasuredFromMH.Checked ? "MeasurementFromMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVideoDoneFromMH.Checked ? "VideoDoneFromMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxVideoDoneToMH.Checked ? "VideoDoneToMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxM1MeasurementsTakenBy.Checked ? "M1MeasurementTakenBy," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxM2MeasurementsTakenBy.Checked ? "M2MeasurementTakenBy," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDropPipe.Checked ? "DropPipe," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxDropPipeInvertDepth.Checked ? "DropPipeInvertDepth," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxCappedLaterals.Checked ? "CappedLaterals," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxLineWidthID.Checked ? "LineWithID," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHydrantAddress.Checked ? "HydrantAddress," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHydrantDistanceToInversionMH.Checked ? "DistanceToInversionMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHydroWireWithin10FtOfInversionMH.Checked ? "HydroWireWithin10FtOfInversionMH," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxSurfaceGrade.Checked ? "SurfaceGrade," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxHydroPulley.Checked ? "HydroPulley," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbxFridgeCart.Checked ? "FridgeCart," : "");
columnsToDisplay2 = columnsToDisplay2 + (cbx2InchPump.Checked ? "TwoPump," : "");
if (hdfBtnOrigin.Value == "Search")
{
columnsToDisplay = columnsToDisplay + (cbxIdSection.Checked ? " SectionID," : "");
columnsToDisplay = columnsToDisplay + (cbxOldCWPID.Checked ? "OriginalSectionID," : "");
columnsToDisplay = columnsToDisplay + (cbxSubArea.Checked ? "SubArea," : "");
columnsToDisplay = columnsToDisplay + (cbxStreet.Checked ? "Street," : "");
columnsToDisplay = columnsToDisplay + (cbxUsmh.Checked ? " USMH," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMH.Checked ? " DSMH," : "");
columnsToDisplay = columnsToDisplay + (cbxProposedLiningDate.Checked ? "ProposedLiningDate," : "");
columnsToDisplay = columnsToDisplay + (cbxDeadlineLiningDate.Checked ? "DeadlineLiningDate," : "");
columnsToDisplay = columnsToDisplay + (cbxP1Date.Checked ? "P1Date," : "");
columnsToDisplay = columnsToDisplay + (cbxM1Date.Checked ? "M1Date," : "");
columnsToDisplay = columnsToDisplay + (cbxM2Date.Checked ? "M2Date," : "");
columnsToDisplay = columnsToDisplay + (cbxInstallDate.Checked ? "InstallDate," : "");
columnsToDisplay = columnsToDisplay + (cbxFinalVideoDate.Checked ? "FinalVideoDate," : "");
columnsToDisplay = columnsToDisplay + (cbxConfirmedSize.Checked ? "Size_," : "");
columnsToDisplay = columnsToDisplay + (cbxActualLength.Checked ? "ActualLength," : "");
columnsToDisplay = columnsToDisplay + (cbxComments.Checked ? " Comments," : "");
columnsToDisplay = columnsToDisplay + (cbxMapSize.Checked ? "MapSize," : "");
columnsToDisplay = columnsToDisplay + (cbxMapLength.Checked ? "MapLength," : "");
columnsToDisplay = columnsToDisplay + (cbxVideoLength.Checked ? "VideoLength," : "");
columnsToDisplay = columnsToDisplay + (cbxLaterals.Checked ? " Laterals," : "");
columnsToDisplay = columnsToDisplay + (cbxLiveLaterals.Checked ? "LiveLaterals," : "");
columnsToDisplay = columnsToDisplay + (cbxClientID.Checked ? "ClientID," : "");
columnsToDisplay = columnsToDisplay + (cbxPreFlushDate.Checked ? "PreFlushDate," : "");
columnsToDisplay = columnsToDisplay + (cbxPreVideoDate.Checked ? "PreVideoDate," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueIdentified.Checked ? "IssueIdentified," : "");
columnsToDisplay = columnsToDisplay + (cbxLFSIssue.Checked ? "IssueLFS," : "");
columnsToDisplay = columnsToDisplay + (cbxClientIssue.Checked ? "IssueClient," : "");
columnsToDisplay = columnsToDisplay + (cbxSalesIssue.Checked ? "IssueSales," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueGivenToClient.Checked ? "IssueGivenToClient," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueInvestigation.Checked ? "IssueInvestigation," : "");
columnsToDisplay = columnsToDisplay + (cbxIssueResolved.Checked ? "IssueResolved," : "");
columnsToDisplay = columnsToDisplay + (cbxCXIsRemoved.Checked ? "CXIsRemoved," : "");
columnsToDisplay = columnsToDisplay + (cbxMaterial.Checked ? "MaterialType," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHAddress.Checked ? "USMHAddress," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHDepth.Checked ? "USMHDepth," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHMouth12.Checked ? "USMHMouth12," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHMouth1.Checked ? "USMHMouth1," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHMouth2.Checked ? "USMHMouth2," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHMouth3.Checked ? "USMHMouth3," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHMouth4.Checked ? "USMHMouth4," : "");
columnsToDisplay = columnsToDisplay + (cbxUSMHMouth5.Checked ? "USMHMouth5," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHAddress.Checked ? "DSMHAddress," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHDepth.Checked ? "DSMHDepth," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHMouth12.Checked ? "DSMHMouth12," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHMouth1.Checked ? "DSMHMouth1," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHMouth2.Checked ? "DSMHMouth2," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHMouth3.Checked ? "DSMHMouth3," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHMouth4.Checked ? "DSMHMouth4," : "");
columnsToDisplay = columnsToDisplay + (cbxDSMHMouth5.Checked ? "DSMHMouth5," : "");
columnsToDisplay = columnsToDisplay + (cbxTrafficControl.Checked ? "TrafficControl," : "");
columnsToDisplay = columnsToDisplay + (cbxSiteDetails.Checked ? "SiteDetails," : "");
columnsToDisplay = columnsToDisplay + (cbxPipeSizeChange.Checked ? "PipeSizeChange," : "");
columnsToDisplay = columnsToDisplay + (cbxStandardBypass.Checked ? "StandardBypass," : "");
columnsToDisplay = columnsToDisplay + (cbxStandardBypassComments.Checked ? "StandardBypassComments," : "");
columnsToDisplay = columnsToDisplay + (cbxTrafficControlDetails.Checked ? "TrafficControlDetails," : "");
columnsToDisplay = columnsToDisplay + (cbxMeasurementType.Checked ? "MeasurementType," : "");
columnsToDisplay = columnsToDisplay + (cbxMeasuredFromMH.Checked ? "MeasurementFromMH," : "");
columnsToDisplay = columnsToDisplay + (cbxVideoDoneFromMH.Checked ? "VideoDoneFromMH," : "");
columnsToDisplay = columnsToDisplay + (cbxVideoDoneToMH.Checked ? "VideoDoneToMH," : "");
columnsToDisplay = columnsToDisplay + (cbxM1MeasurementsTakenBy.Checked ? "M1MeasurementTakenBy," : "");
columnsToDisplay = columnsToDisplay + (cbxM2MeasurementsTakenBy.Checked ? "M2MeasurementTakenBy," : "");
columnsToDisplay = columnsToDisplay + (cbxDropPipe.Checked ? "DropPipe," : "");
columnsToDisplay = columnsToDisplay + (cbxDropPipeInvertDepth.Checked ? "DropPipeInvertDepth," : "");
columnsToDisplay = columnsToDisplay + (cbxCappedLaterals.Checked ? "CappedLaterals," : "");
columnsToDisplay = columnsToDisplay + (cbxLineWidthID.Checked ? "LineWithID," : "");
columnsToDisplay = columnsToDisplay + (cbxHydrantAddress.Checked ? "HydrantAddress," : "");
columnsToDisplay = columnsToDisplay + (cbxHydrantDistanceToInversionMH.Checked ? "DistanceToInversionMH," : "");
columnsToDisplay = columnsToDisplay + (cbxHydroWireWithin10FtOfInversionMH.Checked ? "HydroWireWithin10FtOfInversionMH," : "");
columnsToDisplay = columnsToDisplay + (cbxSurfaceGrade.Checked ? "SurfaceGrade," : "");
columnsToDisplay = columnsToDisplay + (cbxHydroPulley.Checked ? "HydroPulley," : "");
columnsToDisplay = columnsToDisplay + (cbxFridgeCart.Checked ? "FridgeCart," : "");
columnsToDisplay = columnsToDisplay + (cbx2InchPump.Checked ? "TwoPump," : "");
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
columnsToDisplay = columnsToDisplay + workViewDisplay.GetColumnsToDisplayForViews(viewId, workType, companyId);
}
}
return columnsToDisplay + columnsToDisplay2;
}
/// <summary>
/// UpdateForEdit
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
public void UpdateForEdit(int viewId, string workType, int companyId)
{
foreach (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYRow row in (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)Table)
{
if ((row.WorkType == workType) && (row.COMPANY_ID == companyId))
{
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
workViewDisplay.LoadByViewIdWorkTypeDisplayId(viewId, workType, companyId, row.DisplayID);
if (workViewDisplay.ExistsByViewIDWorkTypeDisplayId(viewId, workType, companyId, row.DisplayID))
{
row.Selected = true;
}
else
{
row.Selected = false;
}
}
}
}
/// <summary>
/// SaveForEdit
/// </summary>
public void SaveForEdit()
{
foreach (WorkViewTDS.WorkViewDisplayTempRow rowViewDisplay in (WorkViewTDS.WorkViewDisplayTempDataTable)Data.Tables["WorkViewDisplayTemp"])
{
WorkViewDisplay workViewDisplay = new WorkViewDisplay(null);
if (!rowViewDisplay.Deleted && !rowViewDisplay.InDatabase && rowViewDisplay.Selected)
{
workViewDisplay.InsertDirect(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID, rowViewDisplay.Deleted);
}
if (!rowViewDisplay.Deleted && rowViewDisplay.InDatabase && rowViewDisplay.Selected)
{
WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway();
workViewDisplayGateway.LoadAllByViewIdWorkTypeDisplayId(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID);
int originalViewId = rowViewDisplay.ViewID;
string originalWorkType = rowViewDisplay.WorkType;
int originalCompanyId = rowViewDisplay.COMPANY_ID;
int originalDisplayId = rowViewDisplay.DisplayID;
bool originalDeleted = workViewDisplayGateway.GetDeleted(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID);
workViewDisplay.UpdateDirect(originalViewId, originalWorkType, originalCompanyId, originalDisplayId, originalDeleted, rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID, rowViewDisplay.Deleted);
}
if (rowViewDisplay.Deleted && rowViewDisplay.InDatabase && !rowViewDisplay.Selected)
{
workViewDisplay.DeleteDirectForEditView(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID);
}
}
}
/// <summary>
/// Save
/// </summary>
public void Save()
{
foreach (WorkViewTDS.WorkViewDisplayTempRow rowViewDisplay in (WorkViewTDS.WorkViewDisplayTempDataTable)Data.Tables["WorkViewDisplayTemp"])
{
if (!rowViewDisplay.Deleted)
{
int displayId = rowViewDisplay.DisplayID;
WorkViewDisplay workViewDisplay = new WorkViewDisplay(null);
workViewDisplay.InsertDirect(rowViewDisplay.ViewID, rowViewDisplay.WorkType, rowViewDisplay.COMPANY_ID, rowViewDisplay.DisplayID, rowViewDisplay.Deleted);
}
}
}
/// <summary>
/// ProcessForEdit
/// </summary>
/// <param name="viewId"></param>
/// <param name="workType"></param>
/// <param name="companyId"></param>
public void ProcessForEdit(int viewId, string workType, int companyId)
{
foreach (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYRow rowViewDisplay in (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)Data.Tables["LFS_WORK_TYPE_VIEW_DISPLAY"])
{
WorkViewDisplay workViewDisplay = new WorkViewDisplay();
workViewDisplay.LoadAllByViewIdWorkTypeDisplayId(viewId, workType, companyId, rowViewDisplay.DisplayID);
WorkViewDisplayGateway workViewDisplayGateway = new WorkViewDisplayGateway(workViewDisplay.Data);
if (workViewDisplay.ExistsByViewIDWorkTypeDisplayId(viewId, workType, companyId, rowViewDisplay.DisplayID))
{
if (rowViewDisplay.Selected)
{
// Set Deleted in 0
Insert(viewId, workType, companyId, rowViewDisplay.DisplayID, true, true, false);
}
else
{
// Set Deleted in 1
Insert(viewId, workType, companyId, rowViewDisplay.DisplayID, false, true, true);
}
}
else
{
if (rowViewDisplay.Selected)
{
// Insert
Insert(viewId, workType, companyId, rowViewDisplay.DisplayID, true, false, false);
}
}
}
}
