// ////////////////////////////////////////////////////////////////////////
 // PUBLIC METHODS
 //
 /// <summary>
 /// LoadByWorkId
 /// </summary>
 /// <param name="companyId">companyId</param>
 /// <param name="workId">workId</param>
 public void LoadByWorkId(int companyId, int workId)
 {
     FlWetOutCatalystsReportGateway flWetOutCatalystsReportGateway = new FlWetOutCatalystsReportGateway(Data);
     flWetOutCatalystsReportGateway.LoadByWorkId(companyId, workId);
 }
        // ////////////////////////////////////////////////////////////////////////
        // PRIVATE METHODS
        //
        /// <summary>
        /// UpdateForReport
        /// </summary>
        private void UpdateForReport()
        {
            // Load catalysts
            FlWetOutCatalystsReportGateway flWetOutCatalystsReportGateway = new FlWetOutCatalystsReportGateway();
            flWetOutCatalystsReportGateway.ClearBeforeFill = false;

            foreach (FlWetOutReportTDS.LFS_WORK_FULLLENGTHLINING_WETOUTRow row in (FlWetOutReportTDS.LFS_WORK_FULLLENGTHLINING_WETOUTDataTable)Table)
            {
                // Load catalysts
                flWetOutCatalystsReportGateway.LoadByWorkId(row.COMPANY_ID, row.WorkID);

                // Update comments
                if (!row.IsCommentsNull())
                {
                    row.Comments = row.Comments.Replace("<br>", "\n");
                }

                // Update tube size for report
                string[] confirmedSizeString = row.TubeSize.ToString().Split('\"');
                row.TubeSize = confirmedSizeString[0];

                // Run Details
                string runDetails = row.RunDetails;
                int companyId = row.COMPANY_ID;
                string[] runDetailsList = runDetails.Split('>');
                string flowOrderIds = "";
                for (int i = 0; i < runDetailsList.Length; i++)
                {
                    AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
                    string sectionId = runDetailsList[i].ToString();
                    assetSewerSectionGateway.LoadBySectionId(sectionId, companyId);
                    string flowOrderId = assetSewerSectionGateway.GetFlowOrderID(sectionId);
                    flowOrderIds = flowOrderIds + flowOrderId + '>';
                }
                flowOrderIds = flowOrderIds.Substring(0, flowOrderIds.Length - 1);
                row.RunDetails = flowOrderIds;
            }
            flWetOutCatalystsReportGateway.ClearBeforeFill = true;
        }