public IActionResult DeleteConfirmed(string id, int seq) { TicketDtlModel ticketDtl = _context.TicketDtls.Find(id, seq); _context.TicketDtls.Remove(ticketDtl); _context.SaveChanges(); return(RedirectToAction("Edit", "Ticket", new { id = ticketDtl.TicketDtlNo })); }
public IActionResult DeleteConfirmed2(string id, int seq) { TicketDtlModel ticketDtl = _context.TicketDtls.Find(id, seq); _context.TicketDtls.Remove(ticketDtl); _context.SaveChanges(); return(Ok()); }
public IActionResult Edit2([Bind("TicketDtlNo,SeqNo,ObjName,Qty,Unite,Price,Cost")] TicketDtlModel ticketDtl) { if (ModelState.IsValid) { _context.Entry(ticketDtl).State = EntityState.Modified; _context.SaveChanges(); return(Ok(ticketDtl)); } return(BadRequest()); }
public IActionResult Edit([Bind("TicketDtlNo,SeqNo,ObjName,Qty,Unite,Price,Cost")] TicketDtlModel ticketDtl) { if (ModelState.IsValid) { _context.Entry(ticketDtl).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Edit", "Ticket", new { id = ticketDtl.TicketDtlNo })); } return(View(ticketDtl)); }
public IActionResult Create2([Bind("TicketDtlNo,SeqNo,ObjName,Qty,Unite,Price,Cost")] TicketDtlModel ticketDtl) { if (ModelState.IsValid) { _context.TicketDtls.Add(ticketDtl); _context.SaveChanges(); return(Ok(ticketDtl)); } return(BadRequest()); }
public IActionResult Create([Bind("TicketDtlNo,SeqNo,ObjName,Qty,Unite,Price,Cost")] TicketDtlModel ticketDtl) { if (ModelState.IsValid) { _context.TicketDtls.Add(ticketDtl); _context.SaveChanges(); return(RedirectToAction("Edit", "Ticket", new { id = ticketDtl.TicketDtlNo })); } return(View(ticketDtl)); }
// GET: Admin/TicketDtl/Delete2/5 public IActionResult Delete2(string id, int seq) { if (id == null) { return(BadRequest()); } TicketDtlModel ticketDtl = _context.TicketDtls.Find(id, seq); if (ticketDtl == null) { return(StatusCode(404)); } return(View(ticketDtl)); }
// GET: Admin/TicketDtl/Create public IActionResult Create(string id) { var lastDtl = _context.TicketDtls.Where(t => t.TicketDtlNo == id).OrderBy(t => t.SeqNo).LastOrDefault(); TicketDtlModel ticketDtl = new TicketDtlModel(); if (lastDtl != null) { ticketDtl.TicketDtlNo = lastDtl.TicketDtlNo; ticketDtl.SeqNo = lastDtl.SeqNo + 1; } else { ticketDtl.TicketDtlNo = id; ticketDtl.SeqNo = 1; } return(View(ticketDtl)); }
// GET: Admin/TicketDtl/Details/5 public IActionResult Details(string id, int seq) { if (id == null) { return(BadRequest()); } TicketDtlModel ticketDtl = _context.TicketDtls.Find(id, seq); if (ticketDtl == null) { return(StatusCode(404)); } var rc = _context.RepairCosts.Where(r => r.TicketDtl.TicketDtlNo == ticketDtl.TicketDtlNo && r.TicketDtl.SeqNo == ticketDtl.SeqNo).FirstOrDefault(); if (rc != null) { ticketDtl.DocId = rc.DocId; } return(View(ticketDtl)); }
public IActionResult Edit2(RepairCostModel repairCost) { var ur = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault(); if (repairCost.TicketDtl.TicketDtlNo != null) { repairCost.TicketDtl.TicketDtlNo = repairCost.TicketDtl.TicketDtlNo.ToUpper(); } if (repairCost.SignNo != null) { repairCost.SignNo = repairCost.SignNo.ToUpper(); } if (repairCost.StockType == "3") { ModelState.Remove("TicketDtl.SeqNo"); } if (ModelState.IsValid) { if (repairCost.StockType != "3") { TicketModel t = _context.Tickets.Find(repairCost.TicketDtl.TicketDtlNo); if (t == null) { t = new TicketModel(); t.TicketNo = repairCost.TicketDtl.TicketDtlNo; t.TicDate = repairCost.AccountDate; t.ApplyDate = null; t.CancelDate = null; t.VendorId = repairCost.VendorId; t.VendorName = repairCost.VendorName; repairCost.TicketDtl.Ticket = t; _context.Tickets.Add(t); } TicketDtlModel ticketDtl = _context.TicketDtls.Find(repairCost.TicketDtl.TicketDtlNo, repairCost.TicketDtl.SeqNo); if (ticketDtl == null) { int i = _context.TicketDtls.Where(d => d.TicketDtlNo == repairCost.TicketDtl.TicketDtlNo) .Select(d => d.SeqNo).DefaultIfEmpty().Max(); repairCost.TicketDtl.SeqNo = i + 1; repairCost.TicketDtl.ObjName = repairCost.PartName; repairCost.TicketDtl.Qty = repairCost.Qty; repairCost.TicketDtl.Unite = repairCost.Unite; repairCost.TicketDtl.Price = repairCost.Price; repairCost.TicketDtl.Cost = repairCost.TotalCost; _context.TicketDtls.Add(repairCost.TicketDtl); } else { ticketDtl.ObjName = repairCost.PartName; ticketDtl.Qty = repairCost.Qty; ticketDtl.Unite = repairCost.Unite; ticketDtl.Price = repairCost.Price; ticketDtl.Cost = repairCost.TotalCost; _context.Entry(ticketDtl).State = EntityState.Modified; } } repairCost.Rtp = ur.Id; repairCost.Rtt = DateTime.Now; _context.Entry(repairCost).State = EntityState.Modified; _context.SaveChanges(); RepairDtlModel dtl = _context.RepairDtls.Where(d => d.DocId == repairCost.DocId) .FirstOrDefault(); if (dtl != null) { dtl.Cost = _context.RepairCosts.Where(k => k.DocId == repairCost.DocId) .Select(k => k.TotalCost) .DefaultIfEmpty(0).Sum(); _context.Entry(dtl).State = EntityState.Modified; _context.SaveChanges(); } return(RedirectToAction("Edit", "Repair", new { Area = "", id = repairCost.DocId, page = 4 })); } if (repairCost.StockType == "0") { ViewData["StockType"] = "庫存"; } else if (repairCost.StockType == "2") { ViewData["StockType"] = "發票(含收據)"; } else if (repairCost.StockType == "4") { ViewData["StockType"] = "零用金"; } else { ViewData["StockType"] = "簽單"; } return(View(repairCost)); }