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