public async Task <IActionResult> Edit(string id, [Bind("vendorInvoiceLineId,itemId,description,quantity,price,taxId,taxAmount,amount,totalAmount,vendorInvoiceId,createdAt")] VendorInvoiceLine vendorInvoiceLine)
{
if (id != vendorInvoiceLine.vendorInvoiceLineId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vendorInvoiceLine);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendorInvoiceLineExists(vendorInvoiceLine.vendorInvoiceLineId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["itemId"] = new SelectList(_context.Item, "itemId", "itemName", vendorInvoiceLine.itemId);
ViewData["vendorInvoiceId"] = new SelectList(_context.VendorInvoice, "vendorInvoiceId", "invoiceNumber", vendorInvoiceLine.vendorInvoiceId);
return(View(vendorInvoiceLine));
}
public async Task <IActionResult> PostVendorInvoiceLine([FromBody] VendorInvoiceLine vendorInvoiceLine)
{
Item item = await _context.Item.Include(x => x.tax).SingleOrDefaultAsync(x => x.itemId.Equals(vendorInvoiceLine.itemId));
vendorInvoiceLine.taxId = item.taxId;
if (vendorInvoiceLine.vendorInvoiceLineId == string.Empty)
{
vendorInvoiceLine.vendorInvoiceLineId = Guid.NewGuid().ToString();
if (vendorInvoiceLine.price.Equals(0m))
{
vendorInvoiceLine.price = item.price;
}
vendorInvoiceLine.amount = (decimal)vendorInvoiceLine.quantity * vendorInvoiceLine.price;
vendorInvoiceLine.taxAmount = (decimal)(item.tax.taxRate / 100.0) * vendorInvoiceLine.amount;
vendorInvoiceLine.totalAmount = vendorInvoiceLine.amount + vendorInvoiceLine.taxAmount;
_context.VendorInvoiceLine.Add(vendorInvoiceLine);
VendorInvoice vi = await _context.VendorInvoice.Include(x => x.vendorInvoiceLine).SingleOrDefaultAsync(x => x.vendorInvoiceId.Equals(vendorInvoiceLine.vendorInvoiceId));
vi.subTotal = vi.vendorInvoiceLine.Sum(x => x.amount);
vi.taxAmount = vi.vendorInvoiceLine.Sum(x => x.taxAmount);
vi.grandTotal = vi.subTotal + vi.taxAmount - vi.discount + vi.shipping;
_context.VendorInvoice.Update(vi);
_context.VendorInvoiceLine.Add(vendorInvoiceLine);
await _context.SaveChangesAsync();
return(Json(new { success = true, message = "Add new data success." }));
}
else
{
if (vendorInvoiceLine.price.Equals(0m))
{
vendorInvoiceLine.price = item.price;
}
vendorInvoiceLine.amount = (decimal)vendorInvoiceLine.quantity * vendorInvoiceLine.price;
vendorInvoiceLine.taxAmount = (decimal)(item.tax.taxRate / 100.0) * vendorInvoiceLine.amount;
vendorInvoiceLine.totalAmount = vendorInvoiceLine.amount + vendorInvoiceLine.taxAmount;
_context.Update(vendorInvoiceLine);
VendorInvoice vi = await _context.VendorInvoice.Include(x => x.vendorInvoiceLine).SingleOrDefaultAsync(x => x.vendorInvoiceId.Equals(vendorInvoiceLine.vendorInvoiceId));
vi.subTotal = vi.vendorInvoiceLine.Sum(x => x.amount);
vi.taxAmount = vi.vendorInvoiceLine.Sum(x => x.taxAmount);
vi.grandTotal = vi.subTotal + vi.taxAmount - vi.discount + vi.shipping;
_context.VendorInvoice.Update(vi);
_context.Update(vendorInvoiceLine);
await _context.SaveChangesAsync();
return(Json(new { success = true, message = "Edit data success." }));
}
}
public async Task <IActionResult> Create([Bind("vendorInvoiceLineId,itemId,description,quantity,price,taxId,taxAmount,amount,totalAmount,vendorInvoiceId,createdAt")] VendorInvoiceLine vendorInvoiceLine)
{
if (ModelState.IsValid)
{
_context.Add(vendorInvoiceLine);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["itemId"] = new SelectList(_context.Item, "itemId", "itemName", vendorInvoiceLine.itemId);
ViewData["vendorInvoiceId"] = new SelectList(_context.VendorInvoice, "vendorInvoiceId", "invoiceNumber", vendorInvoiceLine.vendorInvoiceId);
return(View(vendorInvoiceLine));
}
public async Task <IActionResult> GetVendorInvoiceLineById(Int64 VendorInvoiceLineId)
{
VendorInvoiceLine Items = new VendorInvoiceLine();
try
{
Items = await _context.VendorInvoiceLine.Where(q => q.VendorInvoiceLineId == VendorInvoiceLineId).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public async Task <ActionResult <VendorInvoiceLine> > Insert([FromBody] VendorInvoiceLine _VendorInvoiceLine)
{
VendorInvoiceLine _VendorInvoiceLineq = new VendorInvoiceLine();
try
{
_VendorInvoiceLineq = _VendorInvoiceLine;
_context.VendorInvoiceLine.Add(_VendorInvoiceLineq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_VendorInvoiceLineq)));
}
// GET: VendorInvoiceLine/Create
public IActionResult Create(string masterid, string id)
{
var check = _context.VendorInvoiceLine.SingleOrDefault(m => m.vendorInvoiceLineId == id);
var selected = _context.VendorInvoice.SingleOrDefault(m => m.vendorInvoiceId == masterid);
ViewData["itemId"] = new SelectList(_context.Item, "itemId", "itemName");
ViewData["vendorInvoiceId"] = new SelectList(_context.VendorInvoice, "vendorInvoiceId", "invoiceNumber");
if (check == null)
{
VendorInvoiceLine objline = new VendorInvoiceLine();
objline.vendorInvoice = selected;
objline.vendorInvoiceId = masterid;
return(View(objline));
}
else
{
return(View(check));
}
}
public async Task <IActionResult> Delete([FromBody] VendorInvoiceLine _VendorInvoiceLine)
{
VendorInvoiceLine _VendorInvoiceLineq = new VendorInvoiceLine();
try
{
_VendorInvoiceLineq = _context.VendorInvoiceLine
.Where(x => x.VendorInvoiceLineId == (Int64)_VendorInvoiceLine.VendorInvoiceLineId)
.FirstOrDefault();
_context.VendorInvoiceLine.Remove(_VendorInvoiceLineq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_VendorInvoiceLineq)));
}
public async Task <ActionResult <VendorInvoiceLine> > Update([FromBody] VendorInvoiceLine _VendorInvoiceLine)
{
VendorInvoiceLine _VendorInvoiceLineq = _VendorInvoiceLine;
try
{
_VendorInvoiceLineq = await(from c in _context.VendorInvoiceLine
.Where(q => q.VendorInvoiceLineId == _VendorInvoiceLine.VendorInvoiceLineId)
select c
).FirstOrDefaultAsync();
_context.Entry(_VendorInvoiceLineq).CurrentValues.SetValues((_VendorInvoiceLine));
//_context.VendorInvoiceLine.Update(_VendorInvoiceLineq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_VendorInvoiceLineq)));
}
