public ActionResult Create([Bind(Include = "BookingId,Username,CruiseName,StartDate,EndDate,NumberOfPeople,TotalPrice")] Booking booking) { booking.CruiseName = Request["CruiseName"].ToString(); if (DateTime.Compare(booking.StartDate, DateTime.UtcNow) < 0) { TempData["ErrorMessageDate"] = "Please check the date and retry!"; return(RedirectToAction("Create")); } if (booking.NumberOfPeople < 1 || booking.NumberOfPeople > 10) { TempData["ErrorMessagePeople"] = "Enter people between 1-10!"; return(RedirectToAction("Create")); } var context = new Cruise_Models(); var tempDuration = (from c in context.Cruises where c.CruiseName == booking.CruiseName select c.Duration).Single(); var tempCostNight = (from c in context.Cruises where c.CruiseName == booking.CruiseName select c.CostPerNight).Single(); booking.Username = User.Identity.GetUserName(); booking.EndDate = booking.StartDate.AddDays(Convert.ToDouble(tempDuration)); booking.TotalPrice = booking.NumberOfPeople * Convert.ToInt32(tempCostNight); if (ModelState.IsValid) { db.Bookings.Add(booking); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(booking)); }
// GET: Bookings/Create public ActionResult Create() { var context = new Cruise_Models(); var cruiseName = (from c in context.Cruises select c.CruiseName).ToList(); ViewBag.CruiseNames = new SelectList(cruiseName); return(View()); }
// GET: Ratings/Create public ActionResult Create() { var context = new Cruise_Models(); var userName = User.Identity.GetUserName(); var bookingId = (from c in context.Bookings where c.Username == userName select c.BookingId).ToList(); ViewBag.BookingId = new SelectList(bookingId); return(View()); }
// GET: Ratings public ActionResult Index() { if (User.IsInRole("Customer")) { var userName = User.Identity.GetUserName(); var context = new Cruise_Models(); var bookingId = (from c in context.Bookings join r in context.Ratings on c.BookingId equals r.BookingId where c.Username == userName select r.BookingId).ToList(); return(View(bookingId)); } else { return(View(db.Ratings.ToList())); } }