public void CreateRoom(RoomModel room)
{
using (BookingContextModel db = new BookingContextModel())
{
db.Rooms.Add(room);
db.SaveChanges();
}
}
public void CreateUser(UserModel user)
{
using (BookingContextModel db = new BookingContextModel())
{
db.Users.Add(user);
db.SaveChanges();
}
}
public List <RoomModel> GetAllRooms()
{
using (var db = new BookingContextModel())
{
var rooms = from r in db.Rooms orderby r.Name select r;
return(rooms.ToList());
}
}
internal UserModel GetUserById(string id)
{
using (var db = new BookingContextModel())
{
var user = db.Users.Find(id);
return(user);
}
}
internal List <UserModel> GetAllUsers()
{
using (var db = new BookingContextModel())
{
var users = from u in db.Users select u;
return(users.ToList());
}
}
public RoomModel GetRoomById(string id)
{
using (var db = new BookingContextModel())
{
var room = db.Rooms.Find(id);
return(room);
}
}
internal void UpdateUser(UserModel user)
{
using (BookingContextModel db = new BookingContextModel())
{
var result = db.Users.Find(user.Id);
result.Username = user.Username;
result.Password = user.Password;
result.IsAdmin = user.IsAdmin;
db.SaveChanges();
}
}
public void UpdateRoom(RoomModel room)
{
using (BookingContextModel db = new BookingContextModel())
{
var result = db.Rooms.Find(room.Id);
result.BookedUntil = room.BookedUntil;
result.IsAvailable = room.IsAvailable;
result.Name = room.Name;
db.SaveChanges();
}
}
