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))); }