public static void Add(PRODUCTS_PURCHASES p_ProductPurchase)
{
var invoice = InvoicePurchase.Get((int)p_ProductPurchase.ID_INVOICES_PURCHASES);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
_db.PRODUCTS_PURCHASES.Add(p_ProductPurchase);
_db.SaveChanges();
}
public static void Delete(int p_id_ProductPurchase)
{
var ps = Get(p_id_ProductPurchase);
var invoice = InvoicePurchase.Get((int)ps.ID_INVOICES_PURCHASES);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
_db.PRODUCTS_PURCHASES.Remove(ps);
_db.SaveChanges();
}
public static void EditQuantityOfProductPurchase(double p_Quantity, int id_ProductPurchase)
{
if (p_Quantity < 0)
{
DialogError.Error(); return;
}
var ps = Get(id_ProductPurchase);
var invoice = InvoicePurchase.Get((int)ps.ID_INVOICES_PURCHASES);
var p = product.Get((int)ps.ID_PRODUCTS);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
ps.QUANTITY = p_Quantity;
_db.SaveChanges();
}
public static void EditStampOfProductPurchase(double p_Stamp, int id_ProductPurchase)
{
if (p_Stamp < 0)
{
DialogError.Error(); return;
}
var ps = Get(id_ProductPurchase);
var invoice = InvoicePurchase.Get((int)ps.ID_INVOICES_PURCHASES);
//var p = product.Get((int)ps.ID_PRODUCTS);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
ps.STAMP = p_Stamp;
_db.SaveChanges();
}
public static void AddProductPurchase(int p_id_product, int p_id_invoice, double p_quantity = 1)
{
var invoice = InvoicePurchase.Get(p_id_invoice);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
if (IsExistProductInInvoice(p_id_product, p_id_invoice))
{
DialogError.Error(); return;
}
if (p_quantity < 0)
{
DialogError.Error(); return;
}
var p = product.Get(p_id_product);
double p_MONEY = p.MONEY_PURCHASE;
double p_QUANTITY = p_quantity;
double p_TAX_PERCE = p.TAX_PERCE;
double p_STAMP = 0;
double p_TAX_VALUE = p.TAX_PERCE / 100 * p.MONEY_PURCHASE;
double MONEY_PAID = (p_MONEY + p_TAX_VALUE + p_STAMP) * p_QUANTITY;
PRODUCTS_PURCHASES ps = new PRODUCTS_PURCHASES
{
ID = NewId(),
ID_PRODUCTS = p_id_product,
ID_INVOICES_PURCHASES = p_id_invoice,
QUANTITY = p_QUANTITY,
MONEY_UNIT = p_MONEY,
TAX_PERCE = p_TAX_PERCE,
STAMP = 0
};
Add(ps);
}
public static void EditMoneyUnitOfProductPurchase(double p_MoneyUnit, int id_ProductPurchase)
{
if (p_MoneyUnit < 0)
{
DialogError.Error(); return;
}
var ps = Get(id_ProductPurchase);
var invoice = InvoicePurchase.Get((int)ps.ID_INVOICES_PURCHASES);
var p = product.Get((int)ps.ID_PRODUCTS);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
if (p_MoneyUnit < p.MONEY_PURCHASE)
{
DialogError.Error(); return;
}
ps.MONEY_UNIT = p_MoneyUnit;
_db.SaveChanges();
}
public static void EditTaxPerceOfProductPurchase(double p_TaxPerce, int id_ProductPurchase)
{
if (p_TaxPerce < 0)
{
DialogError.Error(); return;
}
if (p_TaxPerce > 100)
{
DialogError.Error(); return;
}
var ps = Get(id_ProductPurchase);
var invoice = InvoicePurchase.Get((int)ps.ID_INVOICES_PURCHASES);
//var p = product.Get((int)ps.ID_PRODUCTS);
if (invoice.VALIDATION == 1)
{
DialogError.Error(); return;
}
ps.TAX_PERCE = p_TaxPerce;
_db.SaveChanges();
}