// GET: Order public ActionResult Show(int?page, string OrderCode = "", string DateFrom = "", string DateTo = "", string StaffCode = "", string ProcessId = "process", string StatusId = "", string SalePlace = "", string C1Code = "") { int permit = Utitl.CheckRoleShowInfo(db, User.Identity.Name); int pageSize = 30; int pageNumber = (page ?? 1); var current = DateTime.Now; DateTime dFrom; DateTime dTo; if (String.IsNullOrEmpty(DateFrom) || String.IsNullOrEmpty(DateTo)) { dTo = current; dFrom = current.AddMonths(-1); } else { dFrom = DateTime.ParseExact(DateFrom, "d/M/yyyy", null); dTo = DateTime.ParseExact(DateTo, "d/MM/yyyy", null); } ViewBag.DateFrom = dFrom.ToString("dd/MM/yyyy"); ViewBag.DateTo = dTo.ToString("dd/MM/yyyy"); ViewBag.StaffCode = StaffCode; ViewBag.ProcessId = ProcessId; ViewBag.StatusId = StatusId; ViewBag.SalePlace = SalePlace; ViewBag.C1Code = C1Code; List <get_list_orders_Result> data = new List <get_list_orders_Result>(); if (!String.IsNullOrEmpty(OrderCode)) { data = db.get_list_orders_by_code("%" + OrderCode + "%").ToList(); } else { data = db.get_list_orders(dFrom.ToString("yyyy-MM-dd"), dTo.ToString("yyyy-MM-dd"), "%" + ProcessId + "%", "%" + StatusId + "%", "%" + StaffCode + "%", "%" + C1Code + "%").ToList(); } data = data.Where(p => p.SalePlace.Contains(SalePlace)).ToList(); if (permit == 2) { // get list cn var branchPermit = db.UserBranchPermisses.Where(p => p.UserName == User.Identity.Name).Select(p => p.BranchCode).ToList(); data = data.Where(p => branchPermit.Contains(p.BrachCode)).ToList(); } return(View(data.OrderByDescending(p => p.CreateDate).ToPagedList(pageNumber, pageSize))); }