public ActionResult DeleteConfirmed(int id)
{
VenueBooking venueBooking = db.VenueBookings.Find(id);
db.VenueBookings.Remove(venueBooking);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
VenueBooking venueBooking = await db.venueBooking.FindAsync(id);
db.venueBooking.Remove(venueBooking);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "VenueBookingID,Vstart_date,StartTime,EndTime,Venue_Status,ReserveVenue,UserId,DescriptionID,VenueID,NumberInUse")] VenueBooking venueBooking)
{
if (ModelState.IsValid)
{
db.Entry(venueBooking).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.VenueID = new SelectList(db.venues, "VenueID", "Venue_Name", venueBooking.VenueID);
ViewBag.DescriptionID = new SelectList(db.venueBookingDescription, "DescriptionID", "booking_Description", venueBooking.DescriptionID);
return(View(venueBooking));
}
// GET: VenueBookings/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VenueBooking venueBooking = db.VenueBookings.Find(id);
if (venueBooking == null)
{
return(HttpNotFound());
}
return(View(venueBooking));
}
public ActionResult Edit([Bind(Include = "BookEventId,VenueId,VenueName,ClassId,ClassName,GradeId,GradeName,RefNum,DateBookinFor,StartTime,EndTime,BookingReason")] VenueBooking venueBooking)
{
if (ModelState.IsValid)
{
venueBooking.ClassName = db.Venues.Find(venueBooking.ClassId).venueName;
db.Entry(venueBooking).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ClassId = new SelectList(db.Classes, "ClassId", "ClassName", venueBooking.ClassId);
ViewBag.GradeId = new SelectList(db.Grades, "GradeId", "GradeName", venueBooking.GradeId);
ViewBag.VenueId = new SelectList(db.Venues, "venueId", "venueName", venueBooking.VenueId);
return(View(venueBooking));
}
// GET: VenueBookings/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VenueBooking venueBooking = await db.venueBooking.FindAsync(id);
if (venueBooking == null)
{
return(HttpNotFound());
}
return(View(venueBooking));
}
public ActionResult Acknowledgement(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VenueBooking venueBooking = db.venueBooking.Find(id);
if (venueBooking == null)
{
return(HttpNotFound());
}
return(View(venueBooking));
}
//============================= ApproveBooking =================================
// GET: PastorBookings/Edit/5
public ActionResult ApproveVenueBooking(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VenueBooking venueBookings = db.venueBooking.Find(id);
return(View(new ApprovalVenueVM
{
VenueBookingID = venueBookings.VenueBookingID,
// updateBy = e.updateBy,
Venue_Status = venueBookings.Venue_Status,
}));
}
//======================================== Payment ================================================================
// GET: VenueBookings/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VenueBooking venueBooking = await db.venueBooking.FindAsync(id);
if (venueBooking == null)
{
return(HttpNotFound());
}
ViewBag.VenueID = new SelectList(db.venues, "VenueID", "Venue_Name", venueBooking.VenueID);
ViewBag.DescriptionID = new SelectList(db.venueBookingDescription, "DescriptionID", "booking_Description", venueBooking.DescriptionID);
return(View(venueBooking));
}
// GET: VenueBookings/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VenueBooking venueBooking = db.VenueBookings.Find(id);
if (venueBooking == null)
{
return(HttpNotFound());
}
ViewBag.ClassId = new SelectList(db.Classes, "ClassId", "ClassName", venueBooking.ClassId);
ViewBag.GradeId = new SelectList(db.Grades, "GradeId", "GradeName", venueBooking.GradeId);
ViewBag.VenueId = new SelectList(db.Venues, "venueId", "venueName", venueBooking.VenueId);
return(View(venueBooking));
}
public async Task <ActionResult> Create([Bind(Include = "VenueBookingID,Vstart_date,StartTime,EndTime,Venue_Status,UserId,DescriptionID,VenueID,BookedBy,Email,Venue_Status")] VenueBooking venueBooking)
{
UserManager <ApplicationUser> usermanager = new UserManager <ApplicationUser>(new Microsoft.AspNet.Identity.EntityFramework.UserStore <ApplicationUser>(db));
//Venue venue = new Venue();
//venue = db.venues.Find(venueBooking.VenueID);
////pastorBooking.BookingAmount = pastor.BookAmount;
//var desc = db.venueBookingDescription.Find(venueBooking.VenueBookingDescription);
//var transaction = new Transactions()
//{
// //transId = 1,
// date = venueBooking.Vstart_date,
// // pastorBooking.BookingAmount = pastor.BookAmount,
// amount = venue.Price,
// transCode = "BOOK102",
// description = desc.booking_Description,
//};
//db.Transactions.Add(transaction);
//db.SaveChanges();
int result = DateTime.Compare(DateTime.Now, venueBooking.Vstart_date);
DateTime sDate = db.venueBooking.Where(p => p.Vstart_date == venueBooking.Vstart_date).Select(p => p.Vstart_date).FirstOrDefault();
if (ModelState.IsValid == true && venueBooking.CheckedDate() == true && (venueBooking.Vstart_date == sDate) == false)
{
var venue = db.venues.Find(venueBooking.VenueID);
venueBooking.V_Price = venue.Price;
venueBooking.Venue_Status = "Waiting for Approval";
string Amount = venueBooking.V_Price.ToString();
venueBooking.User = usermanager.FindByEmail(User.Identity.Name);
venueBooking.BookedBy = venueBooking.User.fullName;
db.venueBooking.Add(venueBooking);
await db.SaveChangesAsync();
return(RedirectToAction("Payfast", new { Amount, venueBooking.VenueBookingID, venueBooking.DescriptionID }));
}
ViewBag.VenueID = new SelectList(db.venues, "VenueID", "Venue_Name", venueBooking.VenueID);
ViewBag.DescriptionID = new SelectList(db.venueBookingDescription, "DescriptionID", "booking_Description", venueBooking.DescriptionID);
return(View(venueBooking));
}
public ActionResult Create([Bind(Include = "BookEventId,VenueId,VenueName,ClassId,ClassName,GradeId,GradeName,RefNum,DateBookinFor,StartTime,EndTime,BookingReason")] VenueBooking venueBooking)
{
if (ModelState.IsValid)
{
var getClassName = db.Classes.Find(venueBooking.ClassId);
var venue = db.Venues.Find(venueBooking.VenueId);
var studentsToEmail = db.Students.Where(x => x.ClassName == getClassName.ClassName).ToList();
venueBooking.VenueName = venue.venueName;
venueBooking.ClassName = getClassName.ClassName;
db.VenueBookings.Add(venueBooking);
db.SaveChanges();
foreach (var s in studentsToEmail)
{
var message = $@"Dear {s.StudentName},
Please note the { venue.venueName} has been booked for the { venueBooking.DateBookinFor.Date.ToString("dd-MM-yyyy")}. During { venueBooking.StartTime.TimeOfDay} and { venueBooking.EndTime.TimeOfDay}.
For {venueBooking.BookingReason}.
This is an automated message genarated by DGHS.
Thank you
";
SendEmailReminders(s.StudentEmail, message, s.ClassName);
}
return(RedirectToAction("Index"));
}
ViewBag.ClassId = new SelectList(db.Classes, "ClassId", "ClassName", venueBooking.ClassId);
ViewBag.GradeId = new SelectList(db.Grades, "GradeId", "GradeName", venueBooking.GradeId);
ViewBag.VenueId = new SelectList(db.Venues, "venueId", "venueName", venueBooking.VenueId);
return(View(venueBooking));
}
