public static string ManageBudgetAnalysisHO(NameValueCollection querystring, NameValueCollection formdata)
        {
            int intParser;

            UserProfile userProfile = WebCommon.GetUserProfile();

            var BudHODetail = new List <BudgetHODetail>();

            BudHODetail = (List <BudgetHODetail>)BudHODetail.ToClass(formdata["Data"]);

            var BudHOHead = new BudgetHOHead
            {
                intID               = int.TryParse(querystring.Get("TransNo"), out intParser) ? intParser : 0,
                intIDDepartment     = int.TryParse(querystring.Get("DepartmentID"), out intParser) ? intParser : 0,
                intYear             = int.TryParse(querystring.Get("YearBudget"), out intParser) ? intParser : 0,
                intIDMasCOASuppType = int.TryParse(querystring.Get("SuppType"), out intParser) ? intParser : 0,
                intIDSecUser        = userProfile.UserId,
                lstBudgetHODetail   = BudHODetail
            };


            string strMode   = querystring.Get("strMode");
            string paramHead = WebCommon.ToXML(BudHOHead);

            return(BudgetAnalysisHODAL.ManageBudgetAnalysisHO(paramHead, strMode));
        }// END : ManageBudgetAnalysisHO
        } // END : LoadBudgetHODetail

        public static string DeleteFailedUpload(NameValueCollection querystring)
        {
            int intParser;

            int intIDBudgetUpload = int.TryParse(querystring.Get("intIDBudgetUpload"), out intParser) ? intParser : 0;

            return(BudgetAnalysisHODAL.DeleteFailedUpload(intIDBudgetUpload));
        } // End DeleteFailedUpload
        } // END : SearchExistingRecords

        public static List <BudgetHODetail> LoadBudgetHODetail(NameValueCollection strQuerystring)
        {
            int intParser;
            int TransNo;

            TransNo = int.TryParse(strQuerystring.Get("intTransNo"), out intParser) ? intParser : 0;
            return(BudgetAnalysisHODAL.LoadBudgetHODetail(TransNo));
        } // END : LoadBudgetHODetail
        } // End DeleteFailedUpload

        public static List <BudgetHOUploadStatus> LoadUploadStatus(NameValueCollection strQuerystring)
        {
            int intParser;

            int    intIDDepartment = int.TryParse(strQuerystring.Get("intIDDepartment"), out intParser) ? intParser : 0;
            string strFileName     = strQuerystring.Get("strFileName");

            return(BudgetAnalysisHODAL.LoadUploadStatus(intIDDepartment, strFileName));
        } // END : LoadUploadStatus
        } // END : SearchCOA

        public static List <BudgetHOSearchExisting> SearchExistingRecords(NameValueCollection strQuerystring)
        {
            int intParser;
            int intIDDepartment;
            int intYear;

            intIDDepartment = int.TryParse(strQuerystring.Get("intIDDepartment"), out intParser) ? intParser : 0;
            intYear         = int.TryParse(strQuerystring.Get("intYear"), out intParser) ? intParser : 0;
            return(BudgetAnalysisHODAL.SearchExistingRecords(intIDDepartment, intYear));
        } // END : SearchExistingRecords
        } // END : LoadUploadStatus

        public static string UploadExcel(NameValueCollection querystring)
        {
            int intParser;

            UserProfile userProfile = WebCommon.GetUserProfile();

            var clsUpload = new BudgetHOUpload
            {
                intIDDepartment  = int.TryParse(querystring.Get("DepartmentID"), out intParser) ? intParser : 0,
                intYear          = int.TryParse(querystring.Get("YearBudget"), out intParser) ? intParser : 0,
                intIDSecUser     = userProfile.UserId,
                strExcelFileName = querystring.Get("ExcelFileName"),
                strSheetName     = querystring.Get("SheetName")
            };

            string paramUpload = WebCommon.ToXML(clsUpload);

            return(BudgetAnalysisHODAL.UploadExcel(paramUpload));
        } // End UploadExcel
        }// END : ManageBudgetAnalysisHO

        public static List <BudgetHOSearchCOA> SearchCOA(NameValueCollection strQuerystring)
        {
            string strParam = strQuerystring.Get("strParam");

            return(BudgetAnalysisHODAL.SearchCOA(strParam));
        } // END : SearchCOA
 public static List <BudgetHOSuppType> GetSuppType()
 {
     return(BudgetAnalysisHODAL.GetSuppType());
 }
        public static List <BudgetHODepartments> GetDepartments()
        {
            UserProfile userProfile = WebCommon.GetUserProfile();

            return(BudgetAnalysisHODAL.GetDepartments(userProfile.UserId));
        }