public async Task <IActionResult> PutOnlineSale(int id, OnlineSale onlineSale) { if (id != onlineSale.OnlineSaleId) { return(BadRequest()); } _context.Entry(onlineSale).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OnlineSaleExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <OnlineSale> > PostOnlineSale(OnlineSale onlineSale) { _context.OnlineSales.Add(onlineSale); await _context.SaveChangesAsync(); return(CreatedAtAction("GetOnlineSale", new { id = onlineSale.OnlineSaleId }, onlineSale)); }
public async Task <IActionResult> Edit(int id, [Bind("ID,ClientID,StockID")] OnlineSale onlineSale) { if (id != onlineSale.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(onlineSale); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OnlineSaleExists(onlineSale.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["ClientID"] = new SelectList(_context.RegularClient, "ClientID", "ClientName", onlineSale.ClientID); ViewData["StockID"] = new SelectList(_context.AvalibleStock, "StockID", "Category", onlineSale.StockID); return(View(onlineSale)); }
public async Task <IActionResult> Edit(int id, [Bind("OnlineSaleId,SaleDate,InvNo,Amount,VoyagerInvoiceNo,VoygerDate,VoyagerAmount,ShippingMode,VendorFee,ProfitValue,Remarks,OnlineVendorId")] OnlineSale OnlineSales) { if (id != OnlineSales.OnlineSaleId) { return(NotFound()); } if (ModelState.IsValid) { try { // OnlineSales.UserName = User.Identity.Name; _context.Update(OnlineSales); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!OnlineSaleExists(OnlineSales.OnlineSaleId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["OnlineVendorId"] = new SelectList(_context.Set <OnlineVendor>(), "OnlineVendorId", "OnlineVendorId", OnlineSales.OnlineVendorId); return(PartialView(OnlineSales)); }
public ActionResult DeleteConfirmed(int id) { OnlineSale onlineSale = db.OnlineSales.Find(id); db.OnlineSales.Remove(onlineSale); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "OnlineSaleID,ItemID,Quantity,OnlineInvoiceID")] OnlineSale onlineSale) { if (ModelState.IsValid) { db.Entry(onlineSale).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ItemID = new SelectList(db.Items, "ItemID", "ItemID", onlineSale.ItemID); ViewBag.OnlineInvoiceID = new SelectList(db.OnlineInvoices, "OnlineInvoiceID", "InvoiceNumber", onlineSale.OnlineInvoiceID); return(View(onlineSale)); }
public async Task <IActionResult> Create([Bind("ID,ClientID,StockID")] OnlineSale onlineSale) { if (ModelState.IsValid) { _context.Add(onlineSale); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["ClientID"] = new SelectList(_context.RegularClient, "ClientID", "ClientID", onlineSale.ClientID); ViewData["StockID"] = new SelectList(_context.AvalibleStock, "StockID", "StockID", onlineSale.StockID); return(View(onlineSale)); }
public async Task <IActionResult> Create([Bind("OnlineSaleId,SaleDate,InvNo,Amount,VoyagerInvoiceNo,VoygerDate,VoyagerAmount,ShippingMode,VendorFee,ProfitValue,Remarks,OnlineVendorId")] OnlineSale OnlineSales) { if (ModelState.IsValid) { OnlineSales.UserId = User.Identity.Name; _context.Add(OnlineSales); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["OnlineVendorId"] = new SelectList(_context.Set <OnlineVendor>(), "OnlineVendorId", "OnlineVendorId", OnlineSales.OnlineVendorId); return(PartialView(OnlineSales)); }
// GET: OnlineSale/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OnlineSale onlineSale = db.OnlineSales.Find(id); if (onlineSale == null) { return(HttpNotFound()); } return(View(onlineSale)); }
// GET: OnlineSale/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OnlineSale onlineSale = db.OnlineSales.Find(id); if (onlineSale == null) { return(HttpNotFound()); } ViewBag.ItemID = new SelectList(db.Items, "ItemID", "ItemID", onlineSale.ItemID); ViewBag.OnlineInvoiceID = new SelectList(db.OnlineInvoices, "OnlineInvoiceID", "InvoiceNumber", onlineSale.OnlineInvoiceID); return(View(onlineSale)); }
public JsonResult Create(string order, string PaymentType, int Outlet, string PayerNumber, string TransNumber, string PaymentMethod, int City, string Address, string ContactNumber, string FullName) { bool result = false; int transID = db.OnlineInvoices.Where(t => t.TransNumber.Trim() == TransNumber.Trim()).Count(); if (Request.IsAuthenticated && transID == 0) { var lastInv = db.OnlineInvoices.OrderByDescending(p => p.OnlineInvoiceID).FirstOrDefault(); string year = DateTime.Now.Year.ToString(); ShippingAddress sa = new ShippingAddress(); sa.FullName = FullName; sa.Address = Address; sa.CityID = City; sa.ContactNumber = ContactNumber; db.ShippingAddresses.Add(sa); db.SaveChanges(); int lastShipID = sa.ShippingAddressID; OnlineInvoice pmnt = new OnlineInvoice(); pmnt.PaymentMethod = PaymentMethod; pmnt.TransNumber = TransNumber; pmnt.UserName = HttpContext.User.Identity.Name; pmnt.PayerNumber = PayerNumber; pmnt.PaymentType = PaymentType; pmnt.OutletID = Outlet; pmnt.ShippingAddressID = lastShipID; pmnt.IsPaid = false; pmnt.IsDeleted = false; pmnt.OrderDate = DateTime.Now; if (lastInv == null) { pmnt.InvoiceNumber = "ONINV" + year + "00001"; } else { string invoiceNo = "ONINV" + year + (Convert.ToInt32(lastInv.InvoiceNumber.Substring(9, lastInv.InvoiceNumber.Length - 9)) + 1).ToString("D5"); if (lastInv.InvoiceNumber != invoiceNo) { pmnt.InvoiceNumber = invoiceNo; } else { ShippingAddress s = db.ShippingAddresses.Find(lastShipID); db.ShippingAddresses.Remove(s); db.SaveChanges(); return(Json(result = false, JsonRequestBehavior.AllowGet)); } } db.OnlineInvoices.Add(pmnt); db.SaveChanges(); int lastPmntID = pmnt.OnlineInvoiceID; OnlineSale[] a = JsonConvert.DeserializeObject <OnlineSale[]>(order); foreach (var item in a) { OnlineSale os = new OnlineSale(); os.ItemID = item.ItemID; os.Quantity = item.Quantity; os.OnlineInvoiceID = lastPmntID; os.ItemSize = item.ItemSize; os.ItemPrice = item.ItemPrice; db.OnlineSales.Add(os); db.SaveChanges(); } result = true; return(Json(result, JsonRequestBehavior.AllowGet)); } else { result = false; return(Json(result, JsonRequestBehavior.AllowGet)); } }