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