public ActionResult SIndex(vmcopreserv vmr) { try { string UserIdcookie = ""; if (Request.Cookies.AllKeys.Contains("UserId")) { UserIdcookie = Request.Cookies["UserId"].Value; string _Id = UserIdcookie; long Id = Convert.ToInt16(CreatHash.Decrypt(_Id)); Users admin = db.Users.FirstOrDefault(p => p.Id == Id); if (admin == null) { return(RedirectToAction("Index", "LogIn")); } else { var result = SgetCopReserve(vmr); ViewBag.AllPage = 1; ViewBag.PageNumber = 1; return(View(result)); } } else { return(RedirectToAction("Index", "LogIn")); } } catch (Exception ee) { return(RedirectToAction("Index", "LogIn")); } }
private object SgetCopReserve(vmcopreserv vmr) { var list = db.CopsBooking.Where(p => p.StateDelete == 0 && p.RecordEntryCopsBooking.FirstOrDefault().Record_the_entry.ExitState != true).ToList() .Select(p => new { Id = p.Id, CustomerFullName = p.CustomerFullName, DateExpired = clsPersianDate.MiladiToShamsi(p.DateExpired), StoreMame = p.Store.Name, Reserved = p.RecordEntryCopsBooking.Where(q => q.IdCopsBooking == p.Id).Count() }).ToList(); if (vmr.DateExpired != null) { list = list.Where(p => p.DateExpired == vmr.DateExpired).ToList(); } if (vmr.CustomerFullName != null) { list = list.Where(p => p.CustomerFullName.Contains(vmr.CustomerFullName)).ToList(); } if (vmr.StoreMame != null) { list = list.Where(p => p.StoreMame.Contains(vmr.StoreMame)).ToList(); } if (vmr.Reserved != 0) { list = list.Where(p => p.Reserved == vmr.Reserved).ToList(); } return(list); }