public Product[] GetAllFreeProducts() { using (var db = new RentThingsContext()) { return(db.Products.Where(m => m.IsDeleted == false && m.IsTaken == false).Include(m => m.Category).ToArray()); } }
public Product GetProductById(int id) { using (var db = new RentThingsContext()) { return(db.Products.FirstOrDefault(m => m.Id == id)); } }
public User GetUserById(int id) { using (var db = new RentThingsContext()) { return(db.Users.FirstOrDefault(m => m.Id == id)); } }
public User[] GetAllUsers() { using (var db = new RentThingsContext()) { return(db.Users.Where(m => m.IsDeleted == false).ToArray()); } }
public bool updateUser(User updateUser) { using (var db = new RentThingsContext()) { db.Users.AddOrUpdate(updateUser); db.SaveChanges(); return(true); } }
public bool VerifyUserByLoginAndPassword(LoginTag loginModel) { using (var db = new RentThingsContext()) { var user = db.Users.FirstOrDefault(m => m.Login == loginModel.Login && m.Password == loginModel.Password); if (user != null) { return(true); } return(false); } }
public bool RemoveUserById(int id) { using (var db = new RentThingsContext()) { var user = GetUserById(id); if (user == null) { return(false); } user.IsDeleted = true; db.Users.AddOrUpdate(user); db.SaveChanges(); return(true); } }