public IHttpActionResult PutC_Order(long id, C_Order c_Order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != c_Order.OrderID)
{
return(BadRequest());
}
db.Entry(c_Order).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!C_OrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
C_Order c_Order = db.C_Order.Find(id);
db.C_Order.Remove(c_Order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
C_Order c_Order = await db.C_Order.FindAsync(id);
db.C_Order.Remove(c_Order);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,User_Id,Order_date")] C_Order c_Order)
{
if (ModelState.IsValid)
{
db.Entry(c_Order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.User_Id = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.User_Id);
return(View(c_Order));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,OwerId,Available,CreateBy,EditBy,CreateDate,EditDate,TableNumber,Payed")] C_Order c_Order)
{
if (ModelState.IsValid)
{
db.Entry(c_Order).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.OwerId = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.OwerId);
return(View(c_Order));
}
public ActionResult Create([Bind(Include = "Id,User_Id,Order_date")] C_Order c_Order)
{
if (ModelState.IsValid)
{
db.C_Order.Add(c_Order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.User_Id = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.User_Id);
return(View(c_Order));
}
// GET: DefaultOrder/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
C_Order c_Order = await db.C_Order.FindAsync(id);
if (c_Order == null)
{
return(HttpNotFound());
}
return(View(c_Order));
}
public async Task <IHttpActionResult> DeleteC_Order(int id)
{
C_Order c_Order = await db.C_Order.FindAsync(id);
if (c_Order == null)
{
return(NotFound());
}
db.C_Order.Remove(c_Order);
await db.SaveChangesAsync();
return(Ok(c_Order));
}
// GET: C_Order/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
C_Order c_Order = db.C_Order.Find(id);
if (c_Order == null)
{
return(HttpNotFound());
}
return(View(c_Order));
}
// GET: DefaultOrder/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
C_Order c_Order = await db.C_Order.FindAsync(id);
if (c_Order == null)
{
return(HttpNotFound());
}
ViewBag.OwerId = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.OwerId);
return(View(c_Order));
}
// GET: C_Order/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
C_Order c_Order = db.C_Order.Find(id);
if (c_Order == null)
{
return(HttpNotFound());
}
ViewBag.User_Id = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.User_Id);
return(View(c_Order));
}
public IHttpActionResult DeleteC_Order(long id)
{
C_Order c_Order = db.C_Order.Include(y => y.OrderItems)
.SingleOrDefault(x => x.OrderID == id);
//delete from orderItem table
foreach (var item in c_Order.OrderItems.ToList())
{
db.OrderItems.Remove(item);
}
db.C_Order.Remove(c_Order);
db.SaveChanges();
return(Ok(c_Order));
}
public async Task <ActionResult> Create([Bind(Include = "Id,OwerId,Available,CreateBy,EditBy,CreateDate,EditDate,TableNumber,Payed")] C_Order c_Order)
{
c_Order.CreateBy = User.Identity.Name;
c_Order.EditBy = User.Identity.Name;
c_Order.CreateDate = DateTime.Now;
c_Order.EditDate = DateTime.Now;
c_Order.Available = true;
if (ModelState.IsValid)
{
db.C_Order.Add(c_Order);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.OwerId = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.OwerId);
return(View(c_Order));
}
public ActionResult Payment(FormCollection values)
{
var order = new C_Order();
TryUpdateModel(order);
var user = db.AspNetUsers.Single(
u => u.Id == User.Identity.GetUserId() &&
u.Credit_Card != null);
try
{
if (user.Credit_Card != null)
{
order.User_Id = User.Identity.GetUserId();
order.Order_date = DateTime.Now;
order.Cart_Id = Cart.GetCartId(this.HttpContext);
db.C_Order.Add(order);
db.SaveChanges();
var cart = Cart.GetCart(this.HttpContext);
return(RedirectToAction(actionName: "Complete", routeValues: new { id = order.Id }));
}
else
{
return(RedirectToAction(actionName: "Create", controllerName: "Credit_Card", routeValues: null));
}
}
catch
{
//Invalid - redisplay with errors
return(View(order));
}
}
public async Task <IHttpActionResult> PostC_Order(C_Order c_Order)
{
c_Order.Available = true;
c_Order.CreateBy = User.Identity.Name;
c_Order.EditBy = User.Identity.Name;
c_Order.CreateDate = DateTime.Now;
c_Order.EditDate = DateTime.Now;
c_Order.OwerId = User.Identity.GetUserId();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.C_Order.Add(c_Order);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (C_OrderExists(c_Order.Id))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = c_Order.Id }, c_Order));
}
public IHttpActionResult PostC_Order(C_Order c_Order)
{
#region post or save data without update
//try
//{
// //order table
// db.C_Order.Add(c_Order);
// //orderItem table
// foreach (var item in c_Order.OrderItems)
// {
// db.OrderItems.Add(item);
// }
// db.SaveChanges();
// return Ok();
//}
//catch (Exception ex)
//{
// throw ex;
//}
#endregion
//this code about save data and update data in database
try
{
//order table
//post
if (c_Order.OrderID == 0)
{
db.C_Order.Add(c_Order);
}
//orderItem table (ICollection<OrderItem> orderItem)
//update
else
{
db.Entry(c_Order).State = EntityState.Modified;
}
//orderItem table
foreach (var item in c_Order.OrderItems)
{
if (item.OrderItemID == 0)
{
db.OrderItems.Add(item);
}
else
{
db.Entry(item).State = EntityState.Modified;
}
}
//delete rrecord from arr
foreach (var id in c_Order.DeleteOrderItemIDs.Split(',').Where(x => x != ""))
{
OrderItem record = db.OrderItems.Find(Convert.ToInt64(id));
db.OrderItems.Remove(record);
}
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
throw ex;
}
}
