public List <ProjectIncome> GetAllProjectIncome(string pageNumber, string searchTerm, string fromDate, string toDate)
        {
            ProjectDataAccess obj = new ProjectDataAccess();
            var result            = obj.GetAllProjectIncome(pageNumber, searchTerm, fromDate, toDate);

            return(MapProjectIncome(result));
        }
        public byte[] GetProjectIncomeExcel(string pageNumber, string searchTerm, string fromDate, string toDate)
        {
            ProjectDataAccess obj = new ProjectDataAccess();
            var result            = obj.GetAllProjectIncome(pageNumber, searchTerm, fromDate, toDate);

            string[] columns = { Convert.ToString(result.Rows[0]["TotalIncome"]) };
            return(EnquiryBusinessLogic.ExportExcel(MapDataTableForProjectIncome(result), "Project Income", false, columns));
        }