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