public ActionResult AddTaxReturns(HttpPostedFileBase employeeExcelSheet, TaxReturnView taxReturnView) { if (taxReturnView.IncomeTypeId < 1) { this.ModelState.AddModelError("", "Please specify Income Type"); } if (taxReturnView.BranchId < 1) { this.ModelState.AddModelError("", "Please specify Branch"); var view = this.agentOfDeductionService.GetTaxreturnsView(""); return(this.View("AddTaxReturns", view)); } var returnInfo = this.agentOfDeductionService.ProcessUploadExcel(employeeExcelSheet, taxReturnView.IncomeTypeId, taxReturnView.BranchId); if (!string.IsNullOrEmpty(returnInfo)) { var returnModel = this.agentOfDeductionService.GetTaxreturnsView(returnInfo); return(this.View("AddTaxReturns", returnModel)); } var returnView = this.agentOfDeductionService.GetTaxreturnsView("File Uploaded Successfully"); return(this.View("AddTaxReturns", returnView)); }
/// <summary> /// Processes the upload excel department. /// </summary> /// <param name="departmentExcelFile">The department excel file.</param> /// <param name="userId">The user identifier.</param> /// <param name="incomeTypeId">The income type identifier.</param> /// <param name="branchId">The branch identifier.</param> /// <returns></returns> /// <exception cref="System.ArgumentNullException">departmentExcelFile</exception> public string ProcessUploadExcel(HttpPostedFileBase departmentExcelFile, int incomeTypeId, int branchId) { if (departmentExcelFile == null) { throw new ArgumentNullException(nameof(departmentExcelFile)); } var result = string.Empty; var userId = (int)session.GetSessionValue(SessionKey.UserId); var jurisidiction = this.generalRepository.GetJurisdictionByBranchId(branchId); var agentOfdeduction = this.agentOfDeductionRepository.GetAgentOfdeductionBranchByranchId(branchId); var taxreturnCollection = this.agentOfDeductionRepository.ExcelUpload(departmentExcelFile); try { foreach (DataRow r in taxreturnCollection.Rows) { var taxReturnView = new TaxReturnView() { BeneficiaryTin = r.ItemArray[8].ToString(), BeneficiaryName = r.ItemArray[9].ToString(), BVN = r.ItemArray[0].ToString(), BeneficiaryAddress = r.ItemArray[1].ToString(), InvoiceNo = r.ItemArray[2].ToString(), ContractDate = r.ItemArray[3].ToString(), //3 ContractDescription = r.ItemArray[4].ToString(), ContractAmount = r.ItemArray[5].ToString(), WHT_Rate = r.ItemArray[6].ToString(), WHT_Amount = r.ItemArray[7].ToString(), IncomeTypeId = incomeTypeId, UserRegistrationId = userId, BranchId = branchId, IsActive = true, DateCreated = DateTime.Now, JurisdictionId = jurisidiction.JurisdictionId, AgentOfDeductionId = agentOfdeduction.AgentOfDeductionId }; result = this.agentOfDeductionRepository.SaveTaxReturnInfo(taxReturnView); } } catch { var ErrorFormat = "Invalid File Type"; return(ErrorFormat); } return(result); }