private void deleteInvoice_Product(Invoice invoice)
{
List <Invoice_Product> invoiceProductList = BLInvoice_Product.GetInvoice_ProductByInvoiceId(APCContext, invoice.Id);
for (int i = 0; i < invoiceProductList.Count(); i++)
{
int invoiceProductId = 0;
int.TryParse(invoiceProductList[i].Id.ToString(), out invoiceProductId);
Invoice_Product currentInvoice_Product = BLInvoice_Product.GetInvoice_ProductById(APCContext, invoiceProductId);
if (currentInvoice_Product != null)
{
APCContext.DeleteObject(currentInvoice_Product);
APCContext.SaveChanges();
}
}
}
public static bool insertInvoice_Product(APCEntities APCContext, Invoice invoice, Category category, string description, int quantity, string unit, decimal price, Kurs kurs, decimal serviceCharge, decimal totalPrice, bool subcon)
{
Invoice_Product invoice_product = new Invoice_Product();
invoice_product.Invoice = invoice;
invoice_product.Category = category;
invoice_product.Description = description;
invoice_product.Quantity = quantity;
invoice_product.Unit = unit;
invoice_product.Price = price;
invoice_product.Kurs = kurs;
invoice_product.ServiceCharge = serviceCharge;
invoice_product.PriceTotal = totalPrice;
invoice_product.SubCon = subcon;
APCContext.AddToInvoice_Product(invoice_product);
APCContext.SaveChanges();
return true;
}
public static bool insertInvoice_Product(APCEntities APCContext, Invoice invoice, Category category, string description, int quantity, string unit, decimal price, Kurs kurs, decimal serviceCharge, decimal totalPrice, bool subcon)
{
Invoice_Product invoice_product = new Invoice_Product();
invoice_product.Invoice = invoice;
invoice_product.Category = category;
invoice_product.Description = description;
invoice_product.Quantity = quantity;
invoice_product.Unit = unit;
invoice_product.Price = price;
invoice_product.Kurs = kurs;
invoice_product.ServiceCharge = serviceCharge;
invoice_product.PriceTotal = totalPrice;
invoice_product.SubCon = subcon;
APCContext.AddToInvoice_Product(invoice_product);
APCContext.SaveChanges();
return(true);
}
public RedirectToActionResult CreateIncomingInvoice([Bind("Id,Date,StorageId")] IncomingInvoice incomingInvoice)
{
CartClassForInvoice cartClassForInvoice = new CartClassForInvoice("Product_in_InomingInvoice", _context, HttpContext);
incomingInvoice.Date = DateTime.Now;
incomingInvoice.UserId = _context.Users.FirstOrDefault(s => s.Login == User.Identity.Name).Id;
_context.IncomingInvoices.Add(incomingInvoice);
_context.SaveChanges();
var e = cartClassForInvoice.GetCart().Lines;
foreach (var el in e)
{
el.InvoiceId = incomingInvoice.Id;
Invoice_Product newInvo = new Invoice_Product {
InvoiceId = incomingInvoice.Id, ProductId = el.ProductId, Quantity = el.Quantity
};
_context.Invoice_Products.Add(newInvo);
}
_context.SaveChanges();
cartClassForInvoice.Clear();
return(RedirectToAction("Index"));
}
public void AddInvoice_Product(Invoice_Product ip)
{
ctx.Add(ip);
Save();
}
/// <summary>
/// There are no comments for Invoice_Product in the schema.
/// </summary>
public void AddToInvoice_Product(Invoice_Product invoice_Product)
{
base.AddObject("Invoice_Product", invoice_Product);
}
/// <summary>
/// Create a new Invoice_Product object.
/// </summary>
/// <param name="id">Initial value of Id.</param>
public static Invoice_Product CreateInvoice_Product(int id)
{
Invoice_Product invoice_Product = new Invoice_Product();
invoice_Product.Id = id;
return invoice_Product;
}
