public Room Find(int id)
{
using (ReservContext db = new ReservContext())
{
Room r = (Room)Find(id, "Rooms");
return(r);
}
}
public User Find(int id)
{
using (ReservContext db = new ReservContext())
{
User u = (User)Find(id, "Users");
return(u);
}
}
public void Delete(int id)
{
using (ReservContext db = new ReservContext())
{
var user = db.Users.FirstOrDefault <User>(u => u.Id == id);
db.Users.Remove(user);
db.SaveChanges();
}
}
public void Edit(UserModel model)
{
using (ReservContext db = new ReservContext())
{
var user_edit = db.Users.Where(i => i.Id == model._Id).FirstOrDefault();
user_edit.Name = model._FirstName;
user_edit.LastName = model._LastName;
db.SaveChanges();
}
}
public IQueryable GetUsersWithChar(char firstInitial)
{
using (ReservContext db = new ReservContext())
{
var user = db.Users.Where <User>
(u => u.Name.Contains(firstInitial));
db.SaveChanges();
return(user);
}
}
public void Edit(RoomModel model)
{
using (ReservContext db = new ReservContext())
{
var room_edit = db.Rooms.Where(i => i.Id == model._Id).FirstOrDefault();
room_edit.Price = model._Price;
room_edit.RoomId = model._InnerId;
db.SaveChanges();
//db.Entry(room_edit).State = EntityState.Modified;
}
}
public void Add(User user)
{
if (user.Name.Length >= 3 && user.LastName.Length >= 3)
{
using (ReservContext db = new ReservContext())
{
db.Users.Add(user);
db.SaveChanges();
}
}
}
public void Add(UserModel model)
{
using (ReservContext db = new ReservContext())
{
var user = db.Users.Add(new User
{
Name = model._FirstName,
LastName = model._LastName
});
}
}
public int GetCost(int id)
{
using (ReservContext db = new ReservContext())
{
var roomFurCost = (from rf in db.RoomFurnitures
join f in db.Rooms
on rf.FurnitureId equals f.Id
where f.RoomId == id
group rf by f into gr
select gr.Key.Price + gr.Sum(i => i.Count * i.Furniture.HourlyCost)
).FirstOrDefault();
return(roomFurCost);
}
}
public UserModel[] GetUsers()
{
using (ReservContext db = new ReservContext())
{
var users = (from u in db.Users
select new UserModel
{
_Id = u.Id,
_FirstName = u.Name,
_LastName = u.LastName
}).ToArray();
return(users);
}
}
public void ChangeName(string fName, string lName, int id)
{
if (fName.Length >= 3 && lName.Length >= 3)
{
using (ReservContext db = new ReservContext())
{
var user = db.Users.FirstOrDefault <User>(u => u.Id == id);
if (user != null)
{
user.Name = fName;
user.LastName = lName;
}
db.SaveChanges();
}
}
}
public void Add(RoomModel model)
{
using (ReservContext db = new ReservContext())
{
Room room = new Room
{
Price = model._Price,
RoomId = model._InnerId
};
var room_furn = model._FurList.Select(i => new RoomFurniture
{
Room = room,
FurnitureId = i._Id,
Count = i._Count
});
db.RoomFurnitures.AddRange(room_furn);
db.Rooms.Add(room);
}
}
public RoomModel[] GetRooms()
{
using (ReservContext db = new ReservContext())
{
var rm = (from r in db.Rooms
join rf in db.RoomFurnitures
on r.Id equals rf.FurnitureId
group rf by r into gr
select new RoomModel
{
_Id = gr.Key.Id,
_Price = gr.Key.Price,
_FurList = gr.Select(i => new FurnitureModel
{
_Id = i.FurnitureId,
_Count = i.Count
})
}).ToArray();
return(rm);
}
}
public PersonInfo[] GetUserReservations()
{
using (ReservContext db = new ReservContext())
{
var personinfo = from user in db.Users
join booking in db.BookingUsers on user.Id equals booking.UserId
group booking by user into gr
select new PersonInfo
{
_Name = gr.Key.Name,
_Balance = gr.Key.Balance,
_ReservInfo = gr.Select(i => new ReservationInfo
{
_RoomId = i.Booking.RoomId,
_ReservStart = i.Booking.StartTime
})
};
return(personinfo.ToArray <PersonInfo>());
}
}
