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];
}