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