public async Task <IActionResult> AddProduct([FromBody] AppProduct model)
{
if (ModelState.IsValid)
{
try
{
var addedproduct = await productRepo.AddProduct(model);
if (addedproduct != null)
{
return(Ok(addedproduct));
}
else
{
return(NotFound());
}
}
catch (Exception excp)
{
return(BadRequest(excp));
}
}
return(BadRequest());
}
public void SetMachinePart(MachinePartsBase machinePart, AppProduct appProduct)
{
part = machinePart;
product = appProduct;
_partName.text = part.objName;
_partPrice.text = product.priceApp.ToString ();
}
public async Task <AppProduct> UpdateProduct(AppProduct product)
{
if (db != null)
{
//Delete that post
db.AppProduct.Update(product);
//Commit the transaction
await db.SaveChangesAsync();
}
return(product);
}
public async Task <AppProduct> AddProduct(AppProduct product)
{
if (db != null)
{
product.AppProductId = Guid.NewGuid();
product.CreatedDate = DateTime.Now;
await db.AppProduct.AddAsync(product);
await db.SaveChangesAsync();
return(product);
}
return(product);
}
public int UpdateQuantity(AppProduct appProduct, bool HasAddedQ) //action = ture => plus
{
SqlConnection con = null;
SqlCommand cmd;
try
{
con = connect(false);
string str = "";
if (HasAddedQ)
{
str = "update ProductInList " +
$"Set quantity = quantity + {appProduct.Quantity} " +
$"where product_barcode = '{appProduct.product_barcode}' " +
$"delete Notifications where notID = ${appProduct.NotID}";
}
else
{
str = "update ProductInList " +
$"Set quantity = quantity - {appProduct.Quantity} " +
$"where product_barcode = '{appProduct.product_barcode}'";
}
str += "UPDATE AppList SET listEstimatedPrice = ( " +
"select sum(A.estimatedProductPrice * P.quantity ) from AppProduct A inner join " +
$"ProductInList P on A.product_barcode = P.product_barcode where listID = {appProduct.ListID}) " +
$"WHERE listID = {appProduct.ListID};";
cmd = new SqlCommand(str, con);
return(cmd.ExecuteNonQuery());
}
catch (Exception ex)
{
return(0);
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public IEnumerable <AppProduct> GetProductCart(int listID)
{
List <AppProduct> productCart = new List <AppProduct>();
SqlConnection con = null;
try
{
con = connect(false);
string query = "select A.*, P.listID, p.quantity " +
"from AppProduct A inner join ProductInList P on A.product_barcode = P.product_barcode " +
$"where P.listID = {listID}";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
AppProduct ap = new AppProduct();
ap.product_barcode = (string)sdr["product_barcode"];
ap.product_name = (string)sdr["product_name"];
ap.product_description = Convert.ToString(sdr["product_description"]);
ap.product_image = Convert.ToString(sdr["product_image"]);;
ap.estimatedProductPrice = Convert.ToDouble(sdr["estimatedProductPrice"]);
ap.Quantity = (int)sdr["quantity"];
ap.ListID = (int)sdr["listID"];
productCart.Add(ap);
}
return(productCart);
}
catch (Exception exp)
{
throw (exp);
}
finally
{
con.Close();
}
}
public int PostAppProduct(AppProduct appProduct)
{
SqlConnection con = null;
SqlCommand cmd;
try
{
con = connect(false);
string str = $"BEGIN " +
$"if NOT exists( select product_barcode from AppProduct where product_barcode = '{appProduct.product_barcode}')" +
$"BEGIN " +
"SET QUOTED_IDENTIFIER OFF " +
"insert into AppProduct (product_barcode, product_name, product_description, product_image,estimatedProductPrice) " +
$"values(\'{appProduct.product_barcode}\',\'{appProduct.product_name}\',\'{appProduct.product_description}\',\'{appProduct.product_image}\',{appProduct.estimatedProductPrice}); " +
"END END " +
$"insert into ProductInList(product_barcode,listID,groupID,quantity) values (\'{appProduct.product_barcode}\',{appProduct.ListID},{appProduct.GroupId},{appProduct.Quantity}); " +
" UPDATE AppList SET listEstimatedPrice = ( " +
"select sum(A.estimatedProductPrice * P.quantity ) from AppProduct A inner join " +
$"ProductInList P on A.product_barcode = P.product_barcode where listID = {appProduct.ListID}) " +
$"WHERE listID = {appProduct.ListID}; " +
$"delete Notifications where notID = ${appProduct.NotID} " +
"SET QUOTED_IDENTIFIER ON";
cmd = new SqlCommand(str, con);
return(cmd.ExecuteNonQuery());
}
catch (Exception ex)
{
return(0);
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public async Task <IActionResult> UpdateProduct([FromBody] AppProduct product)
{
if (ModelState.IsValid)
{
try
{
await productRepo.UpdateProduct(product);
return(Ok());
}
catch (Exception excp)
{
if (excp.GetType().FullName ==
"Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
{
return(NotFound());
}
return(BadRequest(excp));
}
}
return(BadRequest());
}
public bool ProductExistsOnDB(AppProduct appProduct)
{
return(this._entities.Product.Where(item => item.Sku == appProduct.LogoKodu).FirstOrDefault() != null);
}
public bool ProductExistsOnDB(AppProduct appProduct)
{
return(_productRepository.ProductExistsOnDB(appProduct));
}
