public int CancelBooking(int id) { var bookingToDelete = RoomTime.SingleOrDefault(b => b.Id == id); RoomTime.Remove(bookingToDelete); return(SaveChanges()); }
public int UpdateBooking(UpdateEventVM viewModel) { var bookingToUpdate = RoomTime.SingleOrDefault(b => b.Id == viewModel.BId); bookingToUpdate.RId = viewModel.RoomId; bookingToUpdate.StartTime = viewModel.Start; bookingToUpdate.EndTime = viewModel.End; bookingToUpdate.Description = viewModel.Description; return(SaveChanges()); }
public int DeleteRoom(int id) { var roomToDelete = Room.SingleOrDefault(b => b.Id == id); foreach (var booking in RoomTime.Where(rt => rt.RId == id)) { RoomTime.Remove(booking); } Room.Remove(roomToDelete); return(SaveChanges()); }
public async Task BookRoom(CreateEventVM viewModel, string userName) { var user = await userManager.FindByNameAsync(userName); var userId = user.Id; var newRoomTime = new RoomTime { RId = viewModel.RoomId, UId = userId, StartTime = viewModel.Start, EndTime = viewModel.End, Description = viewModel.Description }; this.RoomTime.Add(newRoomTime); await this.SaveChangesAsync(); }
public ShowBookingVM[] GetBooking(string id) { var bookings = Room .Join(RoomTime.Where(c => c.UId == id && c.EndTime > DateTime.Now), r => r.Id, rt => rt.RId, (r, rt) => new ShowBookingVM { Id = rt.Id, RoomName = r.Name, Start = rt.StartTime, End = rt.EndTime, Description = rt.Description }); return(bookings.ToArray());; }
public int DeleteUser(string id) { var userToDelete = Users.Include(p => p.RoomTime).SingleOrDefault(b => b.Id == id); if (userToDelete != null) { foreach (var booking in userToDelete.RoomTime) { RoomTime.Remove(booking); } Users.Remove(userToDelete); return(SaveChanges()); } else { return(0); } }
public List <EventObject> GetRoomVM(int id) { var events = new List <EventObject>(); var newRoomVM = new RoomVM(); /* Hitta rummet med parameter id i tabellen Room i db */ var room = Room.SingleOrDefault(r => r.Id == id); if (room != null) { newRoomVM.RoomName = room.Name; newRoomVM.Capacity = room.Capacity; newRoomVM.HasProjector = room.HasProjector; newRoomVM.HasTvScreen = room.HasTvScreen; newRoomVM.HasWhiteBoard = room.HasWhiteBoard; newRoomVM.RoomTimeAndUser = RoomTime .Join( Users, rt => rt.UId, u => u.Id, (rt, u) => new RoomTimeAndUser { RId = rt.RId, UId = u.Id, FirstName = u.FirstName, LastName = u.LastName, StartTime = rt.StartTime, EndTime = rt.EndTime, Description = rt.Description }) .Where(x => x.RId == id /*&& x.EndTime >= DateTime.Now*/) .ToList(); foreach (var item in newRoomVM.RoomTimeAndUser) { events.Add(new EventObject(item.FirstName + " " + item.LastName, item.StartTime, item.EndTime, item.Description)); } } return(events); }