public ActionResult BindVoucherList(VoucherSearchViewModel obj, int companyId, int financialYear) { int processId = 0; int levelId = 0; string urlData = Request.UrlReferrer.Query; string[] array = urlData.Split('='); if (array.Length > 0) { processId = Convert.ToInt32(array[1]); levelId = Convert.ToInt32(array[2]); } //var list = ""; try { DataTable dt = _cmnApprovalProcessLevelService.GetByCompanyModuleApprovalProcessId(companyId, processId); var records = dt.DataTableToList<CmnApprovalProcessLevelMappingViewModel>(); Collection<CmnProcessLevel> collection = new Collection<CmnProcessLevel>(); foreach (CmnApprovalProcessLevelMappingViewModel objModel in records) { CmnProcessLevel objLevel = new CmnProcessLevel(); objLevel.Id = objModel.ProcessLevelId; objLevel.Name = objModel.Name; collection.Add(objLevel); } Collection<AnFVoucher> list = _IAnFVoucherService.GetForApproval(companyId, financialYear, processId, levelId, obj.DateFrom, obj.ToDate, obj.BusinessId, obj.ProjectId, collection); Collection<VoucherSearchResultViewModel> collections = new Collection<VoucherSearchResultViewModel>(); if (list != null) { foreach (AnFVoucher objVoucher in list) { VoucherSearchResultViewModel objValue = new VoucherSearchResultViewModel(); objValue.id = objVoucher.Id; objValue.VoucherNumber = objVoucher.VoucherNumber; objValue.DateString = objVoucher.Date.ToString(); collections.Add(objValue); } } return Json(collections, JsonRequestBehavior.AllowGet); } catch (Exception ex) { throw; } //Get the vouchers that are waiting for levels(check/pass/arrove) }
public ActionResult SearchAnFVoucher(VoucherSearchViewModel objVoucherSearchViewModel) { if (ModelState.IsValid) { int companyId = Convert.ToInt32(Session["companyId"].ToString()); int financialYearId = Convert.ToInt32(Session["financialYear"].ToString()); DataTable dt = null; dt = _anfVoucherService.GetAnfVoucherList(financialYearId, companyId, objVoucherSearchViewModel.VoucherTypeId, objVoucherSearchViewModel.DateFrom, objVoucherSearchViewModel.ToDate, objVoucherSearchViewModel.CostcenterId); List<ReportVoucherListViewModel> list = dt.DataTableToList<ReportVoucherListViewModel>(); return Json(list, JsonRequestBehavior.AllowGet); } else { return RedirectToAction("Voucher"); } }
public ActionResult GetAnfVoucherList(VoucherSearchViewModel objVoucherSearchViewModel) { if (ModelState.IsValid) { DataTable dt = null; string filepath = string.Empty; //string projectName = string.Empty; string costCenterName = string.Empty; string dateFrom = string.Empty; string dateTo = string.Empty; int companyId = Convert.ToInt32(Session["companyId"]); int financialYearId = Convert.ToInt32(Session["financialYear"]); SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId); string companyName = objCmnCompany.Name; string companyAddress = objCmnCompany.Address; List<ReportParameter> paramList = new List<ReportParameter>(); if (objVoucherSearchViewModel.CostcenterId != null) { costCenterName = _ccService.GetById(objVoucherSearchViewModel.CostcenterId.GetValueOrDefault()).Name; } dateFrom = objVoucherSearchViewModel.DateFrom.GetValueOrDefault().ToString("dd/MM/yyyy", CultureInfo.InvariantCulture); dateTo = objVoucherSearchViewModel.ToDate.GetValueOrDefault().ToString("dd/MM/yyyy", CultureInfo.InvariantCulture); #region ParameterListPreperation ReportParameter objcmpName = new ReportParameter(); objcmpName.Name = "Company"; objcmpName.Value = companyName; paramList.Add(objcmpName); ReportParameter objcmpAddress = new ReportParameter(); objcmpAddress.Name = "CompanyAddress"; objcmpAddress.Value = companyAddress; paramList.Add(objcmpAddress); ReportParameter objCostCenter = new ReportParameter(); objCostCenter.Name = "CostCenter"; objCostCenter.Value = costCenterName; paramList.Add(objCostCenter); ReportParameter objDateFrom = new ReportParameter(); objDateFrom.Name = "DateFrom"; objDateFrom.Value = dateFrom; paramList.Add(objDateFrom); ReportParameter objDateTo = new ReportParameter(); objDateTo.Name = "DateTo"; objDateTo.Value = dateTo; paramList.Add(objDateTo); #endregion ParameterListPreperation if (objVoucherSearchViewModel.ReportType == 2) { dt = _anfVoucherService.GetAnfVoucherList(financialYearId, companyId, objVoucherSearchViewModel.VoucherTypeId, objVoucherSearchViewModel.DateFrom, objVoucherSearchViewModel.ToDate, objVoucherSearchViewModel.CostcenterId); filepath = GetReportPath("AnFVoucherList.rpt"); } if (objVoucherSearchViewModel.ReportType == 3) { dt = _anfVoucherService.GetShortDetailAnFVoucherList(financialYearId, companyId, objVoucherSearchViewModel.VoucherTypeId, objVoucherSearchViewModel.DateFrom, objVoucherSearchViewModel.ToDate, objVoucherSearchViewModel.CostcenterId); filepath = GetReportPath("AnFShortVouchersList.rpt"); } if (objVoucherSearchViewModel.ReportType == 4) { dt = _anfVoucherService.GetShortDetailAnFVoucherList(financialYearId, companyId, objVoucherSearchViewModel.VoucherTypeId, objVoucherSearchViewModel.DateFrom, objVoucherSearchViewModel.ToDate, objVoucherSearchViewModel.CostcenterId); filepath = GetReportPath("AnFDetailVouchers.rpt"); } if (objVoucherSearchViewModel.ReportType == 5) { //Payment dt = _anfVoucherService.GetPaymentVouchers(financialYearId, companyId, objVoucherSearchViewModel.VoucherTypeId, objVoucherSearchViewModel.DateFrom, objVoucherSearchViewModel.ToDate, objVoucherSearchViewModel.CostcenterId); ReportParameter PaymentOrRecieve = new ReportParameter(); PaymentOrRecieve.Name = "PaymentOrRecieve"; PaymentOrRecieve.Value = "Payment Report"; paramList.Add(PaymentOrRecieve); //PaymentOrRecieve filepath = GetReportPath("AnFPayment.rpt"); } if (objVoucherSearchViewModel.ReportType == 6) { //Receipt dt = _anfVoucherService.GetPaymentVouchers(financialYearId, companyId, objVoucherSearchViewModel.VoucherTypeId, objVoucherSearchViewModel.DateFrom, objVoucherSearchViewModel.ToDate, objVoucherSearchViewModel.CostcenterId); ReportParameter PaymentOrRecieve = new ReportParameter(); PaymentOrRecieve.Name = "PaymentOrRecieve"; PaymentOrRecieve.Value = "Receive Report"; paramList.Add(PaymentOrRecieve); //PaymentOrRecieve filepath = GetReportPath("AnFPayment.rpt"); } if (dt != null && filepath != string.Empty) { return new CrystalReportResult(filepath, dt, paramList); } else { return RedirectToAction("Voucher"); } } else { return RedirectToAction("Voucher"); } }