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);
}
