public PartialViewResult IndexPartialView(DateTime?fromdate, DateTime?todate, int?customerId, string customerName, int?salerId, string salerName, int?accountantId, string accountantName, int?status, int?areaId, string areaName, int?currentPageIndex) { if (string.IsNullOrEmpty(areaName)) { areaId = 0; } if (string.IsNullOrEmpty(customerName)) { customerId = 0; } if (string.IsNullOrEmpty(salerName)) { salerId = 0; } if (string.IsNullOrEmpty(accountantName)) { accountantId = 0; } if (fromdate == null) { fromdate = SystemConstant.MIN_DATE; } else { ViewBag.FromDate = DateTime.Parse(fromdate.ToString()).ToString("dd/MM/yyyy"); } if (todate == null) { todate = SystemConstant.MAX_DATE; } else { ViewBag.toDate = DateTime.Parse(todate.ToString()).ToString("dd/MM/yyyy"); } if (!(bool)Session["IsAdmin"] && !(bool)Session["IsAccounting"]) { salerId = Convert.ToInt32(Session["UserId"]); } if (!(bool)Session["IsAdmin"] && !(bool)Session["IsAccounting"]) { accountantId = Convert.ToInt32(Session["UserId"]); } var ctx = new SmsContext(); var list = ctx.SP_GET_HOA_DON_BH(fromdate, todate, Convert.ToInt32(customerId), customerName, Convert.ToInt32(salerId), salerName, Convert.ToInt32(accountantId), accountantName, Convert.ToInt32(status), Convert.ToInt32(areaId), areaName).OrderByDescending(uh => uh.NGAY_BAN).Take(SystemConstant.MAX_ROWS).ToList <SP_GET_HOA_DON_BH_Result>(); var AllValue = ctx.SP_GET_VALUE_ALL_HOA_DON(fromdate, todate, Convert.ToInt32(customerId), customerName, Convert.ToInt32(salerId), salerName, Convert.ToInt32(accountantId), accountantName, Convert.ToInt32(status), Convert.ToInt32(areaId), areaName).FirstOrDefault(); HoaDonBHModel model = new HoaDonBHModel(); int pageSize = SystemConstant.ROWS; int pageIndex = currentPageIndex == null ? 1 : (int)currentPageIndex; model.HoaDonList = list.ToPagedList(pageIndex, pageSize); model.PageCount = list.Count; model.AllValue = AllValue; ViewBag.customerName = customerName; ViewBag.salerName = salerName; ViewBag.accountantName = accountantName; ctx.Dispose(); return(PartialView("IndexPartialView", model)); }