public ActionResult Review1(Review rev) { if (ModelState.IsValid) { using (var db = new HolidayPlanner.Models.InfoData()) { var newReview = db.Reviews.Create(); int lastReviewId = db.Reviews.Max(item => item.ReviewId); //added by Sandy for ID Auto-Increment rev.ReviewId = lastReviewId + 1; newReview.ReviewId = rev.ReviewId; newReview.ReviewDetails = rev.ReviewDetails; newReview.Rating = rev.Rating; newReview.HotelId = rev.HotelId; newReview.UserId = rev.UserId; db.Reviews.Add(newReview); db.SaveChanges(); ViewBag.DataExists = true; //TempData["AlertMessage"] = "Review Successfully Send "; return RedirectToAction("First", "Home"); } } else { ModelState.AddModelError("", "Data is not correct"); } return View(); }
public ActionResult bookingform(FormCollection Collection) { Random ran= new Random(); DateTime dt1, dt2; var db= new HolidayPlanner.Models.InfoData(); Booking buk= new Booking(); DateTime.TryParse(Collection[5], out dt1); DateTime.TryParse(Collection[6], out dt2); buk.BookingId="B"+ran.Next(); buk.UserId = Convert.ToInt32(Collection[1]); buk.ClientMobileNumber = Collection[2]; buk.ClientEmailId = Collection[3]; buk.HotelId = Convert.ToInt32(Collection[4]); buk.CheckInDate = dt1; buk.CheckOutDate = dt2; buk.NoOfAdults = Convert.ToInt32(Collection[7]); buk.NoOfChildren = Convert.ToInt32(Collection[8]); buk.Message = Collection[9]; //buk.TotalAmount = Convert.ToDecimal(Collection[10]); db.Bookings.Add(buk); if (ModelState.IsValid) { db.SaveChanges(); return RedirectToAction("Success"); } else { return RedirectToAction("Failed"); } //var newrec = from c in db.Bookings // select c; //buk.UserId= Collection[0]; }