public ActionResult BookEvent(Booking_Events ev, String Name) { Booking_Events bv = new Booking_Events(); Registration r = db.Registrations.Where(x => x.Email_ID == ev.email).Single(); Event e = db.Events.Where(x => x.Event_Type == ev.Event_Type).Single(); bv.Venue = ev.Venue; bv.Event_Date = ev.Event_Date; bv.Event_time = ev.Event_time; bv.Guest_Number = ev.Guest_Number; bv.email = ev.email; bv.Event_Type = Name; bv.Approval = "Wait"; if (r != null) { bv.User_ID = r.User_ID; bv.User_Name = r.User_Name; } if (e != null) { bv.Event_ID = e.Event_ID; } db.Booking_Events.Add(bv); db.SaveChanges(); ModelState.Clear(); return(View("Thanks")); }
public ActionResult AdminApproval(int?page, int id = 0) { bi = id; int pagesize = 9, pageindex = 1; pageindex = page.HasValue ? Convert.ToInt32(page) : 1; var list = db.Booking_Events.Where(x => x.Approval == "wait").OrderByDescending(x => x.Event_ID).ToList(); IPagedList <Booking_Events> stu = list.ToPagedList(pageindex, pagesize); if (bi != 0) { Booking_Events e = db.Booking_Events.Where(x => x.Book_ID == bi).Single(); e.Approval = "confir"; db.Booking_Events.Add(e); db.SaveChanges(); Booking_Events ei = db.Booking_Events.Where(x => x.Book_ID == bi).Single(); db.Booking_Events.Remove(ei); db.SaveChanges(); } return(View(stu)); }
public ActionResult Add_Package(String Name) { int uid = Convert.ToInt32(Session["User_ID"]); var list = db.Booking_Events.Where(x => x.User_ID == uid).ToList(); var list2 = list.Find(x => x.Approval == "confir" && x.package_name == null); list2.package_name = Name; int biid = list2.Book_ID; db.Booking_Events.Add(list2); db.SaveChanges(); Booking_Events ev = db.Booking_Events.Where(x => x.Book_ID == biid).Single(); db.Booking_Events.Remove(ev); db.SaveChanges(); return(RedirectToAction("Profile")); }