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