public List <Product> GetProducts()
{
using (var db = new GodDbContext())
{
return(db.Products.ToList());
}
}
public List <House> GetHouses()
{
using (var db = new GodDbContext())
{
return(db.Houses.ToList());
}
}
public List <Category> GetCategoriesWithProducts()
{
using (var db = new GodDbContext())
{
var listOfCatgories = db.Categories.Include(x => x.Products).ToList();
return(listOfCatgories);
}
}
public List <Category> GetCategories()
{
using (var db = new GodDbContext())
{
var listOfCatgories = db.Categories.ToList();
return(listOfCatgories);
}
}
public Product GetProduct(string ProductName)
{
using (var db = new GodDbContext())
{
var Product = db.Products.FirstOrDefault(Product => Product.Name == ProductName);
return(Product);
}
}
public void AddProduct(Product Product)
{
using (var db = new GodDbContext())
{
db.Products.Add(Product);
db.SaveChanges();
}
}
public House GetHouse(string houseName)
{
using (var db = new GodDbContext())
{
var house = db.Houses.FirstOrDefault(house => house.Name == houseName);
return(house);
}
}
public void AddHouse(House house)
{
using (var db = new GodDbContext())
{
db.Houses.Add(house);
db.SaveChanges();
}
}
public Category AddCategory(Category category)
{
using (var db = new GodDbContext())
{
db.Categories.Add(category);
db.SaveChanges();
return(category);
}
}
public void DeleteProductById(int ProductId)
{
using (var db = new GodDbContext())
{
var ProductToDelete = db.Products.FirstOrDefault(Product => Product.Id == ProductId);
db.Products.Remove(ProductToDelete);
db.SaveChanges();
}
}
public void DeleteHouseById(int houseId)
{
using (var db = new GodDbContext())
{
var houseToDelete = db.Houses.FirstOrDefault(house => house.Id == houseId);
db.Houses.Remove(houseToDelete);
db.SaveChanges();
}
}
public Product UpDateProductById(int ProductIdToEdit, Product ProductEditValues)
{
using (var db = new GodDbContext())
{
var ProductToEdit = db.Products.First(Product => Product.Id == ProductIdToEdit);
ProductToEdit.Price = ProductEditValues.Price;
ProductToEdit.CategoryId = ProductEditValues.CategoryId;
ProductToEdit.Name = ProductEditValues.Name;
db.Products.Update(ProductToEdit);
db.SaveChanges();
return(ProductToEdit);
}
}
public House UpDateHouseById(int houseIdToEdit, House houseEditValues)
{
using (var db = new GodDbContext())
{
var houseToEdit = db.Houses.First(house => house.Id == houseIdToEdit);
houseToEdit.Price = houseEditValues.Price;
houseToEdit.Area = houseEditValues.Area;
houseToEdit.Name = houseEditValues.Name;
db.Houses.Update(houseToEdit);
db.SaveChanges();
return(houseToEdit);
}
}
