示例#1
0
        public ActionResult Edit(Models.VenueBooking booking)
        {
            try
            {
                var db = new CodeFirst.CodeFirst();

                var adjBooking = db.Venue_Booking_Line.Where(v => v.BookingID == booking.BookingID).FirstOrDefault();
                adjBooking.EndTime   = booking.EndTime;
                adjBooking.UserID    = booking.UserID;
                adjBooking.ProjectID = booking.ProjectID;

                db.SaveChanges();

                return(Json(new
                {
                    ResultValue = "Success"
                }));
            }
            catch
            {
                return(Json(new
                {
                    ResultValue = "Error"
                }));
            }
        }
示例#2
0
        public ActionResult Add(Models.VenueBooking booking)
        {
            try
            {
                var db = new CodeFirst.CodeFirst();

                db.Venue_Booking.Add(new CodeFirst.Venue_Booking
                {
                    VenueBookingID = booking.BookingID
                });

                db.Venue_Booking_Line.Add(new CodeFirst.Venue_Booking_Line
                {
                    BookingID      = booking.BookingID,
                    VenueBookingID = booking.BookingID,
                    VenueID        = globalVenueID,
                    NumberofPeople = booking.NumberofPeople,
                    DateBooked     = DateTime.ParseExact(booking.DateBooked, "MM/dd/yyyy", CultureInfo.InvariantCulture),
                    StartTime      = booking.StartTime,
                    EndTime        = booking.EndTime,
                    UserID         = booking.UserID,
                    BuildingID     = db.Venues.Where(v => v.VenueID == globalVenueID).FirstOrDefault().BuildingID,
                    ProjectID      = booking.ProjectID
                });
                db.SaveChanges();

                return(Json(new
                {
                    ResultValue = "Success"
                }));
            }
            catch
            {
                return(Json(new
                {
                    ResultValue = "Error"
                }));
            }
        }