public void DeleteProduct(int value)
{
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
Product _deleteProduct = new Product();
var _choiseProduct = db.Products;
bool _checker = false;
foreach (var i in _choiseProduct)
{
if (i.Id == value)
{
_checker = true;
}
}
if (_checker == true)
{
_deleteProduct = _choiseProduct.Find(value);
db.Products.Remove(_deleteProduct);
db.SaveChanges();
}
else
{
Console.WriteLine("Product was not found.");
}
}
}
public void DeleteUser(int value)
{
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
User _deleteUser = new User();
var _choiseUser = db.Users;
bool _checker = false;
foreach (var i in _choiseUser)
{
if (i.Id == value)
{
_checker = true;
}
}
if (_checker == true)
{
_deleteUser = _choiseUser.Find(value);
db.Users.Remove(_deleteUser);
db.SaveChanges();
}
else
{
Console.WriteLine("User was not found.");
}
}
}
public void Create(Order order)
{
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
db.Orders.Add(order);
db.SaveChanges();
}
}
public void Create(CashRegister cash)
{
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
db.CashRegisters.Add(cash);
db.SaveChanges();
}
}
public void Create(Product product)
{
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
db.Products.Add(product);
db.SaveChanges();
}
}
public void Create(User user)
{
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
db.Users.Add(user);
db.SaveChanges();
}
}
public void UpdateUser(int _userID, User userUser)
{
User user = new User();
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
user = db.Users.Find(_userID);
user.Name = userUser.Name;
user.Surname = userUser.Surname;
db.SaveChanges();
}
}
public void UpdateCashRegister(int _cashID, CashRegister cashRegister)
{
{
CashRegister cash = new CashRegister();
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
cash = db.CashRegisters.Find(_cashID);
cash.CashValue = cash.CashValue + cashRegister.CashValue;
db.SaveChanges();
}
}
}
public void UpdateProduct(int _productID, Product userProduct)
{
Product product = new Product();
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
product = db.Products.Find(_productID);
product.Name = userProduct.Name;
product.Price = userProduct.Price;
product.Amount = userProduct.Amount;
db.SaveChanges();
}
}
public List <User> ReadUser()
{
List <User> _listOfUsers = new List <User>();
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
var _user = db.Users;
foreach (var i in _user)
{
//Console.WriteLine($"ID: {i.Id} Name: {i.Name} Price: {i.Price} Amount: {i.Amount}");
_listOfUsers.Add(i);
}
}
return(_listOfUsers);
}
public List <Product> ReadProduct()
{
List <Product> _listOfProducts = new List <Product>();
using (CoffeeStoreContext db = new CoffeeStoreContext())
{
var _product = db.Products;
foreach (var i in _product)
{
//Console.WriteLine($"ID: {i.Id} Name: {i.Name} Price: {i.Price} Amount: {i.Amount}");
_listOfProducts.Add(i);
}
}
return(_listOfProducts);
}
