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