public ActionResult UnExportReceiptVoucherCash() { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); var CompanyTransactionKindObj = _unitOfWork.NativeSql.GetReceiptVoucherCashFromTransactionKind(UserInfo.fCompanyId); var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId); DateTime Today = DateTime.Now; DateTime FromDate = DateTime.Now; DateTime ToDate = DateTime.Now; int CurrentYear = Today.Year; if (CurrentYear == UserInfo.CurrYear) { FromDate = DateTime.Now; ToDate = DateTime.Now; } else if (CurrentYear < UserInfo.CurrYear || CurrentYear > UserInfo.CurrYear) { FromDate = new DateTime(UserInfo.CurrYear, 1, 1); ToDate = new DateTime(UserInfo.CurrYear, 1, 1); } var ReceiptCashFilter = new ReceiptCashFilterVM { FromDate = FromDate, ToDate = ToDate, CompanyTransactionKind = CompanyTransactionKindObj, Currency = _unitOfWork.Currency.GetAllCurrency(UserInfo.fCompanyId), TheDecimalPointForTheForeignCurrency = Company.TheDecimalPointForTheForeignCurrency, TheDecimalPointForTheLocalCurrency = Company.TheDecimalPointForTheLocalCurrency }; return(View(ReceiptCashFilter)); }
public JsonResult GetAllReceiptVoucherCashMultiAccount(ReceiptCashFilterVM Obj) { try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); var AllReceiptCashMultiAccount = _unitOfWork.NativeSql.GetAllReceiptCashMultiAccountFromHeader(UserInfo.fCompanyId, Obj.FromDate, Obj.ToDate); if (AllReceiptCashMultiAccount == null) { return(Json(new List <ReceiptCashFilterVM>(), JsonRequestBehavior.AllowGet)); } if (!String.IsNullOrEmpty(Obj.VoucherNumber)) { AllReceiptCashMultiAccount = AllReceiptCashMultiAccount.Where(m => m.VoucherNumber == Obj.VoucherNumber).ToList(); } if (Obj.CurrencyID != 0) { AllReceiptCashMultiAccount = AllReceiptCashMultiAccount.Where(m => m.CurrencyID == Obj.CurrencyID).ToList(); } if (Obj.CompanyTransactionKindNo != 0) { AllReceiptCashMultiAccount = AllReceiptCashMultiAccount.Where(m => m.CompanyTransactionKindNo == Obj.CompanyTransactionKindNo).ToList(); } if (!String.IsNullOrEmpty(Obj.FundAccountNumber)) { AllReceiptCashMultiAccount = AllReceiptCashMultiAccount.Where(m => m.FundAccountNumber == Obj.FundAccountNumber).ToList(); } return(Json(AllReceiptCashMultiAccount, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(Json(new List <ReceiptCashFilterVM>(), JsonRequestBehavior.AllowGet)); } }