public async Task <ActionResult> DeleteConfirmed(int id) { PastorBookingViewModel pastorBookingViewModel = await db.PastorVM.FindAsync(id); db.PastorVM.Remove(pastorBookingViewModel); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "PastorBookingVMId,PFirstName,PLastName,Description,Start_date,TimeStart,TimeEnd,BookAmount")] PastorBookingViewModel pastorBookingViewModel) { if (ModelState.IsValid) { db.Entry(pastorBookingViewModel).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(pastorBookingViewModel)); }
// GET: PastorBookingViewModels/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PastorBookingViewModel pastorBookingViewModel = await db.PastorVM.FindAsync(id); if (pastorBookingViewModel == null) { return(HttpNotFound()); } return(View(pastorBookingViewModel)); }
public ActionResult ViewModelAction() { List <PastorBookingViewModel> vm = new List <PastorBookingViewModel>(); var list = (from el in db.pastorsBooking join l in db.pastors on el.PastorID equals l.PastorID select new { el.PastorBookingID, l.PfirstName, l.PlastName, el.Start_date, el.TimeStart, el.TimeEnd, l.BookAmount, el.User.Email, el.Status // el.createdBy, // el.updateBy }).Where(x => x.Email.Equals(User.Identity.Name)).ToList(); foreach (var item in list) { PastorBookingViewModel lvm = new PastorBookingViewModel(); lvm.PastorBookingVMId = item.PastorBookingID; lvm.PFirstName = item.PfirstName; lvm.PLastName = item.PlastName; lvm.Start_date = item.Start_date; lvm.TimeStart = item.TimeStart; lvm.TimeEnd = item.TimeEnd; lvm.BookAmount = item.BookAmount; lvm.Email = item.Email; lvm.Status = item.Status; // lvm.updateBy = item.updateBy; vm.Add(lvm); } // var query = vm.ToList(); // int PageSize = 6; // int PageNumber = (page ?? 1); return(View(vm)); }