/// <summary> /// Creates the room reservation. /// </summary> /// <param name = "userId">The user id.</param> /// <param name = "roomId">The room id.</param> /// <param name = "comments">The comments.</param> /// <returns></returns> public static int CreateRoomReservation(int userId, int roomId, string comments, List<ReserveRoomTempObject> timeList) { if (timeList.Count <= 0) return -1; var db = new UrbanDataContext(); var reservation = new RoomReservation { Approved = null, ReserverUserID = userId, RoomID = roomId, RequestedDate = DateTime.Now }; db.RoomReservation.InsertOnSubmit(reservation); db.SubmitChanges(); //Insert Dates foreach (var rTime in timeList.Select(r => new RoomReservationDates { AllDay = false, EndDate = r.Date.Add(r.End), StartDate = r.Date.Add(r.Start), RoomReservationID = reservation.Id })) { db.RoomReservationDates.InsertOnSubmit(rTime); } if (comments.Trim() != string.Empty) { var revComments = new RoomReservationComments { Comments = comments.Trim(), DateSent = DateTime.Now, RoomReservationID = reservation.Id, UserID = userId }; db.RoomReservationComments.InsertOnSubmit(revComments); } db.SubmitChanges(); var room = db.Manager.Room.GetByKey(roomId); var user = db.Manager.User.GetByKey(room.UserID); RoomReservationEmailUtilities.InitiateRoomReservationRequest(room, user, reservation.Id, comments); return 1; }
private void OnRoomReservationCommentsListRemove(RoomReservationComments entity) { SendPropertyChanging(null); entity.User = null; SendPropertyChanged(null); }
private void OnRoomReservationCommentsListAdd(RoomReservationComments entity) { SendPropertyChanging(null); entity.User = this; SendPropertyChanged(null); }
private void OnRoomReservationCommentsListRemove(RoomReservationComments entity) { SendPropertyChanging(null); entity.RoomReservation = null; SendPropertyChanged(null); }
private void OnRoomReservationCommentsListAdd(RoomReservationComments entity) { SendPropertyChanging(null); entity.RoomReservation = this; SendPropertyChanged(null); }
/// <summary> /// Handles the Click event of the _btnSubmitComments control. /// </summary> /// <param name = "sender">The source of the event.</param> /// <param name = "e">The <see cref = "System.EventArgs" /> instance containing the event data.</param> protected void _btnSubmitComments_Click(object sender, EventArgs e) { if (_rContent.Content.Trim() == String.Empty) { WriteFeedBackMaster(FeedbackType.Info, "Please enter comments to send"); return; } //Create new Reservation Comments var db = new UrbanDataContext(); var revComments = new RoomReservationComments { Comments = _rContent.Content.Trim(), DateSent = DateTime.Now, RoomReservationID = RoomReservationId, UserID = Cu.Id }; db.RoomReservationComments.InsertOnSubmit(revComments); db.SubmitChanges(); var roomReservation = db.Manager.RoomReservation.GetByKey(RoomReservationId); var user = db.Manager.User.GetByKey(Cu.Id); //Emails based on who is the poster switch (RoomPosterMode) { case (int) PosterModeEnum.RoomPoster: RoomReservationEmailUtilities.RoomReservationCommentsSentRoomPoster(roomReservation.Room, user, roomReservation.Id, _rContent.Content); break; case (int) PosterModeEnum.RoomRequestor: RoomReservationEmailUtilities.RoomReservationCommentsSentRoomRequestor(roomReservation.Room, user, roomReservation.Id, _rContent.Content); break; } _rContent.Content = String.Empty; WriteFeedBackMaster(FeedbackType.Success, "Comments sent"); }