public ActionResult UserInfoByEmpId(string empId) { string userName = ""; string branchCode = ""; string branchName = ""; try { WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); DataTable dt = oblApp.GetByUserID(empId); if (dt.Rows.Count > 0) { foreach (DataRow dataRow in dt.Rows) { userName = (string)dataRow[3]; branchCode = (string)dataRow[22]; branchName = (string)dataRow[21]; } long branchId = db.BRANCHINFO.Where(x => x.BRANCHCODE == branchCode).Select(x => x.ID).FirstOrDefault(); //return Json(new { userName = "******", branchId = 5, branchName = "Khatungonj" }, JsonRequestBehavior.AllowGet); return(Json(new { flag = 0, userName, branchId, branchName }, JsonRequestBehavior.AllowGet)); } return(Json(new{ flag = 1 }, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { flag = 2, msg = exception.Message }, JsonRequestBehavior.DenyGet)); } }
public ActionResult Index() { try { OCCUSER user = (OCCUSER)Session["User"]; AuthorizerDashboardVM aVm = new AuthorizerDashboardVM(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList(); var pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.Take(5).ToList(); var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList(); var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList(); var authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); return(View(aVm)); } catch (Exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } // return View(); }
public ActionResult Index() { try { OCCUSER user = (OCCUSER)Session["User"]; TellerDashBoardVM aVm = new TellerDashBoardVM(); var visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).Where(x => x.CREATEDBY == user.ID).OrderByDescending(x => x.ID).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); visaList = visaList.Take(5).ToList(); var requisitionList = db.CARDCHEREUISITION.Where(x => x.CREATEDBY == user.ID).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; requisitionList = requisitionList.Take(5).ToList(); var cardchtanList = db.CARDCHTRAN.Where(x => x.CREATEDBY == user.ID).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; cardchtanList = cardchtanList.Take(5).ToList(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } //var visaPaymentList = db.DEPOSIT.Where(x => x.CREATEDBY == user.ID).ToList(); aVm.Deposits = visaList; aVm.Requisitions = requisitionList; aVm.ChequeTrans = cardchtanList; // aVm.TotalVisaPayment = visaPaymentList.Count; // aVm.TotalVisaPaymentCollection = (decimal)visaPaymentList.Sum(x => x.AMOUNT); return(View(aVm)); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Index() { try { OCCUSER user = (OCCUSER)Session["User"]; TellerDashBoardVM aVm = new TellerDashBoardVM(); var visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).Where(x => x.CREATEDBY == user.ID).OrderByDescending(x => x.ID).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); visaList = visaList.Take(5).ToList(); var requisitionList = db.CARDCHEREUISITION.Where(x => x.CREATEDBY == user.ID).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; requisitionList = requisitionList.Take(5).ToList(); var cardchtanList = db.CARDCHTRAN.Where(x => x.CREATEDBY == user.ID).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; cardchtanList = cardchtanList.Take(5).ToList(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } //var visaPaymentList = db.DEPOSIT.Where(x => x.CREATEDBY == user.ID).ToList(); aVm.Deposits = visaList; aVm.Requisitions = requisitionList; aVm.ChequeTrans = cardchtanList; // aVm.TotalVisaPayment = visaPaymentList.Count; // aVm.TotalVisaPaymentCollection = (decimal)visaPaymentList.Sum(x => x.AMOUNT); return View(aVm); } catch (Exception exception) { return RedirectToAction("Error", "Home", new { Area = "" }); } }
public ActionResult LogIn(OCCUSER aUser, string PASSWORD) { WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); try { var isValid = oblApp.GetByUserIDCheck(aUser.EMPLOYEEID, PASSWORD); if (isValid == "Valid") { ViewBag.flag = ""; if (IsUserInSystem(aUser.EMPLOYEEID)) { var user = GetByEmpId(aUser.EMPLOYEEID); if (user != null) { FormsAuthentication.SetAuthCookie(Convert.ToString(user.ID), false); Session["User"] = user; if (user.TYPE == 1) { return(RedirectToAction("Index", "Home", new { Area = "Admin" })); } if (user.TYPE == 3) { return(RedirectToAction("Index", "Home", new { Area = "Authorizer" })); } if (user.TYPE == 2) { return(RedirectToAction("Index", "Home", new { Area = "Teller" })); } if (user.TYPE == 9) { return(RedirectToAction("Index", "Home", new { Area = "Establishment" })); } if (user.TYPE == 15) { return(RedirectToAction("Index", "Home", new { Area = "CallCenter" })); } if (user.TYPE == 17) { return(RedirectToAction("Index", "Home", new { Area = "Dispatcher" })); } } } else { ViewBag.flag = "User is not in the system"; } } else if (isValid == "Invalid") { ViewBag.flag = "Invalid User"; return(View()); } else if (isValid == "NotFound") { ViewBag.flag = "User Not Found"; return(View()); } return(View()); } catch (Exception exception) { ViewBag.flag = "Something is wrong " + exception.Message; return(View()); } }
public ActionResult Index(DateTime?startDate, DateTime?endDate, string btnName) { try { if (startDate != null || endDate != null) { OCCUSER user = (OCCUSER)Session["User"]; AdminDashboardVM aVm = new AdminDashboardVM(); var visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).OrderByDescending(x => x.ID).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); visaList = visaList.Take(5).ToList(); var requisitionList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; requisitionList = requisitionList.Take(5).ToList(); var cardchtanList = db.CARDCHTRAN.Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; cardchtanList = cardchtanList.Take(5).ToList(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } if (btnName == "visa") { visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).Where(x => x.CREATEDON.Value.Date >= startDate.Value.Date).Where(x => x.CREATEDON.Value.Date <= endDate.Value.Date).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); //aVm.Deposits = List; } else if (btnName == "requisition") { requisitionList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.CREATEDON.Date >= startDate.Value.Date).Where(x => x.CREATEDON.Date <= endDate.Value.Date).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; } else if (btnName == "cardcheque") { cardchtanList = db.CARDCHTRAN.Where(x => x.ISDELETE != true).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; } aVm.Deposits = visaList; aVm.Requisitions = requisitionList; aVm.ChequeTrans = cardchtanList; return(View(aVm)); } return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } // return View(); }
public ActionResult LogIn(OCCUSER aUser, string PASSWORD) { WebRef.OBLAPP oblApp=new WebRef.OBLAPP(); try { var isValid = oblApp.GetByUserIDCheck(aUser.EMPLOYEEID, PASSWORD); if (isValid == "Valid") { ViewBag.flag = ""; if (IsUserInSystem(aUser.EMPLOYEEID)) { var user = GetByEmpId(aUser.EMPLOYEEID); if (user != null) { FormsAuthentication.SetAuthCookie(Convert.ToString(user.ID), false); Session["User"] = user; if (user.TYPE == 1) { return RedirectToAction("Index", "Home", new { Area = "Admin" }); } if (user.TYPE == 3) { return RedirectToAction("Index", "Home", new { Area = "Authorizer" }); } if (user.TYPE == 2) { return RedirectToAction("Index", "Home", new { Area = "Teller" }); } if (user.TYPE == 9) { return RedirectToAction("Index", "Home",new {Area="Establishment"}); } if (user.TYPE == 15) { return RedirectToAction("Index", "Home", new { Area = "CallCenter" }); } if (user.TYPE == 17) { return RedirectToAction("Index", "Home", new { Area = "Dispatcher" }); } } } else { ViewBag.flag = "User is not in the system"; } } else if (isValid == "Invalid") { ViewBag.flag = "Invalid User"; return View(); } else if (isValid == "NotFound") { ViewBag.flag = "User Not Found"; return View(); } return View(); } catch (Exception exception) { ViewBag.flag = "Something is wrong "+exception.Message; return View(); } }
public ActionResult Index(DateTime? startDate, DateTime? endDate, string btnName) { try { if (startDate != null || endDate != null) { OCCUSER user = (OCCUSER)Session["User"]; AuthorizerDashboardVM aVm = new AuthorizerDashboardVM(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE == false).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList(); var pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.Take(5).ToList(); var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList(); var pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList(); var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList(); var authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList(); var authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); if (btnName == "pendingreq") { pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.ToList(); //aVm.Deposits = List; } else if (btnName == "pendingcc") { pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x=>x.ISDELETE!=true).ToList(); pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.ToList(); } else if (btnName == "authreq") { authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); } else if (btnName == "authcc") { authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x=>x.ISDELETE!=true).ToList(); authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); } return View(aVm); } return RedirectToAction("Index"); } catch (Exception exception) { return RedirectToAction("Error", "Home", new { Area = "" }); } }
public ActionResult Index() { try { OCCUSER user = (OCCUSER)Session["User"]; AuthorizerDashboardVM aVm = new AuthorizerDashboardVM(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList(); var pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.Take(5).ToList(); var pendingChequeList = db.CARDCHTRAN.Where(x=>x.STATUS==13).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList(); var pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList(); var authReqList = db.CARDCHEREUISITION.Where(x=>x.ISDELETE!=true).Where(x => x.STATUS ==5).OrderByDescending(x => x.ID).ToList(); var authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList(); var authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); return View(aVm); } catch (Exception) { return RedirectToAction("Error", "Home", new { Area = "" }); } // return View(); }
public ActionResult Index(DateTime?startDate, DateTime?endDate, string btnName) { try { if (startDate != null || endDate != null) { OCCUSER user = (OCCUSER)Session["User"]; AuthorizerDashboardVM aVm = new AuthorizerDashboardVM(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE == false).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList(); var pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.Take(5).ToList(); var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList(); var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList(); var authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); if (btnName == "pendingreq") { pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.ToList(); //aVm.Deposits = List; } else if (btnName == "pendingcc") { pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.ISDELETE != true).ToList(); pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.ToList(); } else if (btnName == "authreq") { authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); } else if (btnName == "authcc") { authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.ISDELETE != true).ToList(); authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); } return(View(aVm)); } return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }