public IActionResult Insert_Product([FromQuery] ProductAddandEditParam model) // done
{
string status;
status = repository_product.Insert_Product(model);
return(Json(status));
}
public string Update_Product(ProductAddandEditParam product)
{
string status;
using (var transaction = context.Database.BeginTransaction())
{
try
{
var count_row_product = (from b in context.Product
where b.IdProduct != product.IdProduct && b.ProductName.ToLower().Contains(product.ProductName.ToLower()) && b.IdUnit == product.IdUnit
select b.IdProduct).Count();
if (count_row_product == 0)
{
var result = context.Product.SingleOrDefault(b => b.IdProduct == product.IdProduct);
if (result != null)
{
result.ProductName = product.ProductName;
result.ProductPrice = product.ProductPrice;
result.IdUnit = product.IdUnit;
context.SaveChanges();
status = constant.SUCCEES;
}
else
{
status = constant.NULL;
}
}
else
{
status = constant.DUPLICATE;
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
status = constant.ERROR;
}
}
return(status);
}
public string Insert_Product(ProductAddandEditParam product)
{
string status;
using (var transaction = context.Database.BeginTransaction())
{
try
{
var id_product = (from b in context.Product
where b.ProductName.ToLower().Contains(product.ProductName.ToLower()) && b.IdUnit == product.IdUnit
select b.IdProduct).Count();
if (id_product == 0)
{
var product1 = new Product()
{
ProductName = product.ProductName,
ProductPrice = product.ProductPrice,
IdUnit = product.IdUnit
};
context.Product.Add(product1);
context.SaveChanges();
status = constant.SUCCEES;
}
else
{
status = constant.DUPLICATE;
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
status = constant.ERROR;
}
}
return(status);
}
