public void Add(Product product)
{
using (MimariContext mimariContext = new MimariContext())
{
string sorgu = "Insert Into Product (ProductName,UnitPrice,QuantityPerUnit) Values (@ProductName,@UnitPrice,@QuantityPerUnit)";
Dictionary <string, object> dictList = new Dictionary <string, object>();
dictList.Add("@ProductName", product.ProductName);
dictList.Add("@UnitPrice", product.UnitPrice);
dictList.Add("@QuantityPerUnit", product.UnitsInStock);
mimariContext.ExecNonQueryProc(sorgu, dictList);
}
}
public void Update(Product product)
{
using (MimariContext mimariContext = new MimariContext())
{
string sorgu = "Update Product SET ProductName=@ProductName,UnitPrice=@UnitPrice,QuantityPerUnit=@QuantityPerUnit WHERE id=@id";
Dictionary <string, object> dictList = new Dictionary <string, object>();
dictList.Add("@ProductName", product.ProductName);
dictList.Add("@UnitPrice", product.UnitPrice);
dictList.Add("@QuantityPerUnit", product.UnitsInStock);
dictList.Add("@id", product.ProductId);
mimariContext.ExecNonQueryProc(sorgu, dictList);
}
}