public int DuplicateProduct(int productId, string code)
{
_database = new MySQLDatabase(connectionString);
var list = GetProduct();
foreach (var i in list)
{
if (i.code == code)
{
return(0);
}
}
var dupliecatedProductId = new DA_Product(_database).DuplicateProduct(productId, code);
var lstDetail = GetProductDetailByProductId(productId);
if (lstDetail.Count() > 0)
{
foreach (var detail in lstDetail)
{
detail.productId = dupliecatedProductId;
CreateProductDetail(detail);
}
}
return(dupliecatedProductId);
}
public BE_Product UpdateProduct(BE_Product bE_Product)
{
_database = new MySQLDatabase(connectionString);
var list = GetProduct();
foreach (var i in list)
{
if (i.code == bE_Product.code && i.productId != bE_Product.productId)
{
return(null);
}
}
var updatedProduct = new DA_Product(_database).UpdateProduct(bE_Product);
if (updatedProduct.detail != null)
{
DeleteProductDetailByProductId(updatedProduct.productId);
foreach (var detail in updatedProduct.detail)
{
detail.productId = updatedProduct.productId;
CreateProductDetail(detail);
}
}
return(updatedProduct);
}
public int DeleteProduct(int productId)
{
_database = new MySQLDatabase(connectionString);
var deletedProductId = new DA_Product(_database).DeleteProduct(productId);
DeleteProductDetailByProductId(deletedProductId);
return(deletedProductId);
}
public BE_Product CreateProduct(BE_Product bE_Product)
{
bool bOk = true;
_database = new MySQLDatabase(connectionString);
BL_Invoice bL_Invoice = new BL_Invoice();
bL_Invoice.connectionString = connectionString;
int filas = GetProductByCode(bE_Product.code).Count;
if (filas > 0)
{
return(null);
}
if (filas != 0)
{
bOk = false;
}
if (bOk)
{
BE_InvoiceItem BE_InvoiceItem = bL_Invoice.AddInvoiceItem(new BE_InvoiceItem()
{
companyCode = bE_Product.CompanyCode
,
igvAffected = true
,
IsEnabled = true
,
invoiceItemType = "P"
,
name = bE_Product.code + "-" + bE_Product.name
});
bE_Product.invoiceItemId = BE_InvoiceItem.invoiceItemId;
}
var newProduct = new DA_Product(_database).CreateProduct(bE_Product);
if (bOk && newProduct.detail != null)
{
foreach (var detail in newProduct.detail)
{
detail.productId = newProduct.productId;
CreateProductDetail(detail);
}
}
return(newProduct);
}
public static async Task <List <Product> > GetProductsAsync()
{
return(await DA_Product.GetProductsAsync());
}
public static bool DeleteProduct(int ProductID)
{
return(DA_Product.DeleteProduct(ProductID));
}
public static bool InsertUpdateProduct(Product product)
{
return(DA_Product.SetProduct(product));
}
