public int Create(order_return product) { if (!UpdateDatabase) { var first = GetAll().OrderByDescending(e => e.id).FirstOrDefault(); var id = (first != null) ? first.id : 0; product.id = id + 1; entities.order_return.Add(product); entities.SaveChanges(); } else { var entity = new order_return(); entity.oid = product.oid; entity.dt = product.dt; entity.user_id = product.user_id; entities.order_return.Add(entity); entities.SaveChanges(); product.id = entity.id; } return(product.id); }
public void Update(order_return product) { if (!UpdateDatabase) { var target = One(e => e.id == product.id); if (target != null) { target.oid = product.oid; target.user_id = product.user_id; target.dt = product.dt; } entities.SaveChanges(); } else { var entity = new order_return(); entity.oid = product.oid; entity.user_id = product.user_id; entity.dt = product.dt; entities.order_return.Attach(entity); entities.Entry(entity).State = EntityState.Modified; entities.SaveChanges(); } }
public IHttpActionResult Return_item([FromUri] int item_id, [FromUri] int qty, [FromUri] int oid) { order o = new orderModel().GetAll().Where(x => x.id == oid).ToList()[0]; order_items oi = new order_itemsModel().GetAll().Where(x => x.oid == o.id && x.item_id == item_id).ToList()[0]; oi.qty = oi.qty - qty; oi.total = oi.total - oi.item.retail_price * qty; oi.profit = oi.profit - (oi.item.retail_price - oi.item.original_price) * qty; //oi.disc = oi.disc - oi.item.discount_price * qty; new order_itemsModel().Update(oi); o.total_amount = o.total_amount - (oi.item.retail_price * qty); o.total_profit = o.total_profit - (oi.item.retail_price - oi.item.original_price) * qty; new orderModel().Update(o); order_return or = new order_return(); or.oid = oid; or.dt = DateTime.Now; or.user_id = User.Identity.GetUserId(); int id = new order_returnModel().Create(or); order_return_items ori = new order_return_items(); ori.orid = id; ori.item_id = item_id; ori.qty = qty; new order_return_itemModel().Create(ori); item i = new itemModel().GetAll().Where(x => x.id == item_id).ToList()[0]; i.qty = i.qty + qty; new itemModel().Update(i); return(Ok()); }
public void Destroy(order_return or) { }