//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult postdata(bool status, string id)
//{
// var resId = _db.Reservations.FirstOrDefault(a => a.Id == id);
// resId.Status = status;
// _db.SaveChanges();
// return RedirectToAction(nameof(Index));
//}
public ActionResult Filter(DateTime filtr, ReservApprenantViewModel viewModel)
{
if (filtr.Year == 0001)
{
return(RedirectToAction(nameof(Index)));
}
else
{
var Result = (from r in _db.Reservations
join a in _db.Apprenants
on r.Apprenant.Id equals a.Id
join tr in _db.TypeReservations
on r.TypeReservation.Id equals tr.Id
where r.Date == filtr
select new ReservApprenantViewModel
{
Id = r.Id,
UserName = a.UserName,
Email = a.Email,
Date = r.Date,
Cause = r.Cause,
Status = r.Status,
TypeReservationId = tr.Id,
Name = tr.Name,
ResCount = a.ResCount
}).ToList();
return(View("Index", Result));
}
}
public async Task <IActionResult> Create(ReservApprenantViewModel viewModel, Apprenant apprenant)
{
Reservation resarvation = new Reservation()
{
Date = viewModel.Date,
//Status = viewModel.Status,
Cause = viewModel.Cause
};
var usId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var type = _db.TypeReservations.Single(t => t.Id == viewModel.TypeReservationId);
resarvation.ApprenantId = usId;
resarvation.TypeReservation = type;
_db.Reservations.Add(resarvation);
await _db.SaveChangesAsync();
ViewData["type"] = new SelectList(_db.TypeReservations, "Id", "Name", viewModel.TypeReservationId);
if (User.IsInRole("admin"))
{
return(RedirectToAction(nameof(Index)));
}
return(RedirectToAction(nameof(History)));
}
public ActionResult Edit(ReservApprenantViewModel viewModel)
{
var res = _db.TypeReservations.Where(t => t.Id == viewModel.Id).FirstOrDefault();
res.Id = viewModel.TypeReservationId;
res.Name = viewModel.Name;
//_db.Entry(res).State = EntityState.Modified;
_db.SaveChanges();
ViewData["type"] = new SelectList(_db.TypeReservations, "Id", "Name", viewModel.TypeReservationId);
return(RedirectToAction(nameof(Index)));
}
// GET: ReservationController/Edit/5
public ActionResult Edit(string id, ReservApprenantViewModel viewModel)
{
var res = _db.TypeReservations.Where(t => t.Id == viewModel.Id).FirstOrDefault();
if (res != null)
{
var vm = new ReservApprenantViewModel {
Id = res.Id
};
if (vm.Reservation != null)
{
res.Id = vm.TypeReservationId;
}
}
ViewData["type"] = new SelectList(_db.TypeReservations, "Id", "Name");
return(View(res));
}
public async Task <IActionResult> Index()
{
var users = await _userManager.Users.ToListAsync();
var viewModel = new List <ReservApprenantViewModel>();
foreach (IdentityUser user in users)
{
var Vmodel = new ReservApprenantViewModel();
Vmodel.Email = user.Email;
Vmodel.UserName = user.UserName;
Vmodel.Roles = await roleUser(user);
viewModel.Add(Vmodel);
}
//var res = _db.Apprenants.ToList();
//ViewBag.Data = res;
//return View();
return(View(viewModel));
}
