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