public ActionResult captureDetails()
{
//assign session variables and cast
var venue = (Venue)Session["venueSelect"];
var details = (DiscussionRoomBooking)Session["details"];
//create instance of new Venue_Booking object
Venue_Booking vb = new Venue_Booking();
Venue_Booking_Person vbp = new Venue_Booking_Person();
//get booking seq of discussion room
var BookingTypeSeq = (from a in db.Booking_Type
where a.Booking_Type_Name.Equals("Discussion Room")
select a.Booking_Type_Seq).FirstOrDefault();
//set properties of venue_booking object to submitted properties
vb.Venue_Booking_Name = "null"; //not sure what this value represents
vb.DateTime_From = details.date;
vb.DateTime_To = details.endDate;
vb.Send_Email_To_Topic_Person_Ind = 0; //no email
vb.Max_Bookings = 0; //doesn't apply to discussion room bookings
vb.Exclusive_ind = 0; //discussion room sessions cant be exclusive
vb.Description = "Discussion Room Session";
vb.Booking_Type_Seq = BookingTypeSeq;
vb.Topic_Seq = 1;
vb.Booking_Status = "Active";
vb.Venue_ID = venue.Venue_ID;
vb.Building_Floor_ID = venue.Building_Floor_ID;
vb.Building_ID = venue.Building_ID;
vb.Campus_ID = venue.Campus_ID;
//add new venue booking to database
db.Venue_Booking.Add(vb);
//record action
global.addAudit("Bookings", "Booking: Discussion Room Booking", "Create", User.Identity.Name);
db.SaveChanges();
//get booking seq of booking just created
var bookingSeq = vb.Venue_Booking_Seq;
//set properties of venue booking person object
vbp.Venue_Booking_Seq = bookingSeq;
vbp.Person_ID = details.person_id;
vbp.Attendee_Type = "Student";
vbp.Attendee_Status = "Active";
//add new venue booking person object to database
db.Venue_Booking_Person.Add(vbp);
db.SaveChanges();
//get return url
var site = Url.Action("ViewBookings", "Booking");
return(Content(site));
}
public void captureStudentTraining()
{
var id = (int)Session["studentSelectedSess"];
Venue_Booking_Person a = new Venue_Booking_Person
{
Person_ID = User.Identity.Name,
Venue_Booking_Seq = id,
Attendee_Type = "Student",
Attendee_Status = "Active",
};
db.Venue_Booking_Person.Add(a);
db.SaveChanges();
//record action
global.addAudit("Bookings", "Bookings: Book Training Session", "Create", User.Identity.Name);
}
