public void AddProduct(Product Product) { using (var db = new GodDbContext()) { db.Products.Add(Product); db.SaveChanges(); } }
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); } }