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>()); } }