// ////////////////////////////////////////////////////////////////////////
        // PUBLIC METHODS
        //
        /// <summary>
        /// LoadByAssetIdWorkIdProjectIdMeasuredFrom
        /// </summary>
        /// <param name="assetId">assetId</param>
        /// <param name="workId">workId</param>
        /// <param name="projectId">projectId</param>
        /// <param name="measuredFrom">measuredFrom</param>
        /// /// <param name="companyId">companyId</param>
        public int LoadByAssetIdWorkIdProjectIdMeasuredFrom(int assetId, int workId, int projectId, string measuredFrom, int companyId)
        {
            LateralLocationSheetReportGateway lateralLocationSheetReportGateway = new LateralLocationSheetReportGateway(Data);
            lateralLocationSheetReportGateway.LoadByAssetId(assetId, companyId);

            return UpdateForReport(assetId, workId, projectId, measuredFrom, companyId);
        }
        /// <summary>
        /// LoadByProjectIdJlNavigatorTDS
        /// </summary>
        /// <param name="projectId">projectId</param>
        /// <param name="jlNavigatorTDS">jlNavigatorTDS</param>
        /// <param name="companyId">companyId</param>
        public void LoadByProjectIdJlNavigatorTDS(int projectId, JlNavigatorTDS jlNavigatorTDS, int companyId)
        {
            ArrayList sections = new ArrayList();
            LateralLocationSheetReportGateway lateralLocationSheetReportGateway = new LateralLocationSheetReportGateway(Data);

            lateralLocationSheetReportGateway.ClearBeforeFill = false;

            foreach (JlNavigatorTDS.JlNavigatorRow jlNavigatorRow in jlNavigatorTDS.JlNavigator)
            {
                if (jlNavigatorRow.Selected)
                {
                    if (!sections.Contains(jlNavigatorRow.AssetID))
                    {
                        sections.Add(jlNavigatorRow.AssetID);
                        int assetId = jlNavigatorRow.AssetID;

                        int workIdFll = GetWorkId(projectId, assetId, "Full Length Lining", companyId);
                        string measuredFrom = "USMH";
                        if (workIdFll > 0)
                        {
                            FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
                            fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workIdFll, assetId, companyId);
                            measuredFrom = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll);
                        }

                        // Get Data
                        lateralLocationSheetReportGateway.LoadByAssetId(assetId, companyId);
                        UpdateForReportForJunctionLining(assetId, workIdFll, projectId, measuredFrom, companyId);
                    }
                }
            }

            lateralLocationSheetReportGateway.ClearBeforeFill = true;
        }