} // END : LoadUploadStatusBranch

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

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

            return(BudgetAnalysisBranchDAL.DeleteFailedUploadBranch(intIDBudgetUpload));
        } // End DeleteFailedUploadBranch
        } // End UploadExcelBranch

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

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

            return(BudgetAnalysisBranchDAL.LoadUploadStatusBranch(intIDMasLocation, strFileName));
        } // END : LoadUploadStatusBranch
        public static string UploadExcelBranch(NameValueCollection querystring)
        {
            int intParser;

            UserProfile userProfile = WebCommon.GetUserProfile();

            var clsUpload = new BudgetBranchUpload
            {
                intIDMasLocation = int.TryParse(querystring.Get("intIDMasLocation"), 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(BudgetAnalysisBranchDAL.UploadExcelBranch(paramUpload));
        } // End UploadExcelBranch