public ActionResult ReserveAction(DateTime Date, string Reason, string User, string Phone, int LocationReserved)
{
var check = db.ReservationsModels.Where(s => s.Date == Date).Take(1).SingleOrDefault();
LocationsModels locationsModels = db.LocationsModels.Find(LocationReserved);
if (check != null)
{
ViewBag.Message = "This Date is already booked";
return(View());
}
else
{
if ((LocationReserved != null) && (User.Length > 3) && (Phone.Length > 9) && (Date != null))
{
var Reservation = new ReservationsModels();
Reservation.Date = Date;
Reservation.Reason = Reason;
Reservation.LocationReserved = LocationReserved;
Reservation.User = User;
Reservation.Phone = Phone;
db.ReservationsModels.Add(Reservation);
db.SaveChanges();
string redirectUrl = "/Home/Index/";
return(Redirect(redirectUrl));
}
ViewBag.Name = locationsModels.Name;
ViewBag.Message = "Invalid Form";
return(View());
}
}
public ActionResult DeleteConfirmed(int id)
{
ReservationsModels reservationsModels = db.ReservationsModels.Find(id);
db.ReservationsModels.Remove(reservationsModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Approve(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReservationsModels reservationsModels = db.ReservationsModels.Find(id);
if (reservationsModels.approved == false)
{
reservationsModels.approved = true;
db.SaveChanges();
var newApprovedReservation = new ApprovedReservationsModels();
newApprovedReservation.User = reservationsModels.User;
newApprovedReservation.Date = reservationsModels.Date;
newApprovedReservation.Reason = reservationsModels.Reason;
newApprovedReservation.Phone = reservationsModels.Phone;
newApprovedReservation.LocationReserved = reservationsModels.LocationReserved;
db.ApprovedReservationsModels.Add(newApprovedReservation);
db.SaveChanges();
var newCostsModels = new CostsModels();
newCostsModels.UserName = reservationsModels.User;
newCostsModels.Date = reservationsModels.Date;
newCostsModels.Amount = 200;
newCostsModels.Month = reservationsModels.Date;
newCostsModels.EventId = 0;
newCostsModels.EventName = reservationsModels.Reason;
db.CostsModels.Add(newCostsModels);
db.SaveChanges();
var newPaymentsModelss = new PaymentsModels();
newPaymentsModelss.UserName = reservationsModels.User;
newPaymentsModelss.Date = DateTime.Now;
newPaymentsModelss.Amount = 400;
newPaymentsModelss.Month = DateTime.Now;
newPaymentsModelss.Member = false;
db.PaymentsModels.Add(newPaymentsModelss);
db.SaveChanges();
string redirectUrlInside = "/Reservations/Index/";
return(Redirect(redirectUrlInside));
}
string redirectUrl = "/Reservations/Index/";
return(Redirect(redirectUrl));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReservationsModels reservationsModels = db.ReservationsModels.Find(id);
if (reservationsModels == null)
{
return(HttpNotFound());
}
return(View(reservationsModels));
}
