// ////////////////////////////////////////////////////////////////////////
        // PUBLIC METHODS
        //
        /// <summary>
        /// LoadAll
        /// </summary>
        /// <param name="projectId">projectId</param>
        /// <param name="startDate">startDate</param>
        /// <param name="endDate">endDate</param>
        /// <param name="companyId">companyId</param>
        public void LoadAll(int companyId)
        {
            ProjectCostingSheetTemplateInformationGateway projectCostingSheetAddTemplateGateway = new ProjectCostingSheetTemplateInformationGateway(Data);
            projectCostingSheetAddTemplateGateway.LoadAll(companyId);

            if (projectCostingSheetAddTemplateGateway.Table.Rows.Count > 0)
            {
                foreach (ProjectCostingSheetAddTDS.TemplateInformationRow row in (ProjectCostingSheetAddTDS.TemplateInformationDataTable)Table)
                {
                    string typeOfWork = "";
                    if (row.RAData) typeOfWork = "RA";
                    if (row.FLLData) { if (typeOfWork.Length > 0) typeOfWork = typeOfWork + "- FLL"; else typeOfWork = "FLL"; }
                    if (row.PRData) { if (typeOfWork.Length > 0) typeOfWork = typeOfWork + "- PR"; else typeOfWork = "PR"; }
                    if (row.JLData) { if (typeOfWork.Length > 0) typeOfWork = typeOfWork + "- JL"; else typeOfWork = "JL"; }
                    if (row.MRData) { if (typeOfWork.Length > 0) typeOfWork = typeOfWork + "- MR"; else typeOfWork = "MR"; }
                    if (row.MOBData) { if (typeOfWork.Length > 0) typeOfWork = typeOfWork + "- MOB"; else typeOfWork = "MOB"; }
                    if (row.OtherData) { if (typeOfWork.Length > 0) typeOfWork = typeOfWork + "- Other"; else typeOfWork = "Other"; }
                    row.TypeOfWork = typeOfWork;

                    string costingArea = "";
                    if (row.LabourHourData) costingArea = "Labour Hour";
                    if (row.UnitData) { if (costingArea.Length > 0) costingArea = costingArea + "- Unit"; else costingArea = "Unit"; }
                    if (row.MaterialData) { if (costingArea.Length > 0) costingArea = costingArea + "- Material"; else costingArea = "Material"; }
                    if (row.SubcontractorData) { if (costingArea.Length > 0) costingArea = costingArea + "- Subcontractor"; else costingArea = "Subcontractor"; }
                    if (row.MiscData) { if (costingArea.Length > 0) costingArea = costingArea + "- Misc."; else costingArea = "Misc."; }
                    row.CostingArea = costingArea;
                }
            }
        }