public void UpdateProduct(ProductGoodsViewModel product)
{
var exitPaper = _db.Product.FirstOrDefault(s => s.ProductName == product.ProductName);
if (exitPaper == null)
{
var storeProcedureName = "[dbo].[Add_Product]";
var Result = _dbContext.Database.SqlQuery <ProductGoodsViewModel>(
$"{storeProcedureName} @ProductID,@ProductName,@eachPrice,@Ccount",
new SqlParameter("@ProductID", product.ProductID),
new SqlParameter("@ProductName", product.ProductName),
new SqlParameter("@eachPrice", product.eachPrice),
new SqlParameter("@CCount", product.CCOunt)
).SingleOrDefault();
}
else
{
var storeProcedureName = "[dbo].[Update_Product]";
var Result = _dbContext.Database.SqlQuery <ProductGoodsViewModel>(
$"{storeProcedureName} @ProductID,@ProductName,@eachPrice,@Ccount",
new SqlParameter("@ProductID", product.ProductID),
new SqlParameter("@ProductName", product.ProductName),
new SqlParameter("@eachPrice", product.eachPrice),
new SqlParameter("@CCount", product.CCOunt)
).SingleOrDefault();
}
}
public void EditProduct(ProductGoodsViewModel product)
{
var db = new PrinteryContext();
var exitProduct = db.Product.FirstOrDefault(s => s.ProductID == product.ProductID);
if (exitProduct != null)
{
db.Set <Product>().Attach(exitProduct);
db.Entry(exitProduct).State = EntityState.Modified;
exitProduct.ProductName = product.ProductName;
exitProduct.eachPrice = product.eachPrice;
db.SaveChanges();
}
}
public async Task <List <ProductGoodsViewModel> > GetAllProduct()
{
var productList = new List <ProductGoodsViewModel>();
var productlist = new List <Product>();
productlist = await _db.Product.ToListAsync();
foreach (var item in productlist)
{
ProductGoodsViewModel product = new ProductGoodsViewModel();
product.ProductID = item.ProductID;
product.ProductName = item.ProductName;
product.eachPrice = item.eachPrice;
product.CCOunt = item.CCOunt;
productList.Add(product);
}
return(productList);
}
public List <ProductGoodsViewModel> GetProductByProductName(string ProductName)
{
var proList = new List <ProductGoodsViewModel>();
var prolist = from u in _db.Product
where u.ProductName == ProductName
select u;
foreach (var item in prolist)
{
ProductGoodsViewModel product = new ProductGoodsViewModel();
product.ProductID = item.ProductID;
product.ProductName = item.ProductName;
product.eachPrice = item.eachPrice;
product.CCOunt = item.CCOunt;
proList.Add(product);
}
return(proList);
}
public void UpdateProduct(ProductGoodsViewModel product)
{
_productRespository.UpdateProduct(product);
}
public void EditProduct(ProductGoodsViewModel product)
{
_productRespository.EditProduct(product);
}
