public HttpResponseMessage Post([FromBody] JObject value)
{
int orderpid = 0;
int qnum = 0;
Order order = new Order();
Group_Order_Binding group_Order_Binding = new Group_Order_Binding();
if (order != null)
{
group_Order_Binding.GroupdID = Convert.ToInt32(value["newordergroupid"].ToString());
group_Order_Binding.Order = order;
order.GroupID = group_Order_Binding.GroupdID;
order.productID = Convert.ToInt32(value["neworderproductid"].ToString());
orderpid = Convert.ToInt32(order.productID);
order.quantity = Convert.ToInt32(value["neworderquantity"].ToString());
qnum = Convert.ToInt32(order.quantity);
order.orderdate = value["neworderdate"].ToString();
order.orderstate = Convert.ToInt32(value["neworderstate"].ToString());
order.followmember_id = Convert.ToInt32(value["newordermemberid"].ToString());
db.Group_Order_Binding.Add(group_Order_Binding);
db.Order.Add(order);
db.SaveChanges();
}
//-----------------------------------------更改currrentnum
pProductdb ppdb = db.pProductdb.FirstOrDefault(p => p.Product_ID == orderpid);
ppdb.Product_currentnum += qnum;
db.SaveChanges();
//-----------------------------------
//var q = from f in db.pProductdb
// where f.Product_ID == orderpid
// select f;
//foreach(var item in q)
//{
// item.Product_currentnum += qnum;
// db.SaveChanges();
//}
//--------------------------------------------
var result = new
{
STATUS = true,
MSG = "成功",
};
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage Delete(int id)
{
pProductdb pProductdb = db.pProductdb.FirstOrDefault(p => p.Product_ID == id);
Group_Product_Binding group_Product_Binding = db.Group_Product_Binding.FirstOrDefault(p => p.Productid == id);
if (pProductdb != null)
{
db.Group_Product_Binding.Remove(group_Product_Binding);
db.SaveChanges();
db.pProductdb.Remove(pProductdb);
db.SaveChanges();
}
var result = new
{
STATUS = true,
MSG = "刪除成功",
};
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage Put(int id, [FromBody] JObject value)
{
pProductdb pProductdb = db.pProductdb.FirstOrDefault(p => p.Product_ID == id);
if (pProductdb != null)
{
pProductdb.Product_name = value["productname"].ToString();
pProductdb.Product_Price = Convert.ToInt32(value["productprice"].ToString());
pProductdb.Product_restnumber = Convert.ToInt32(value["productcurrentnum"].ToString());
pProductdb.Product_currentnum = Convert.ToInt32(value["productrestnumber"].ToString());
pProductdb.Product_description = value["productdescription"].ToString();
//pProductdb.PictureURL = value["productpictureurl"].ToString();
pProductdb.Picturebyte = value["productpictureurl"].ToString();
db.SaveChanges();
}
var result = new
{
STATUS = true,
MSG = "成功",
};
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
// POST: api/gpproduct
public HttpResponseMessage Post([FromBody] JObject value)
{
string controllerName = ControllerContext.RouteData.Values["controller"].ToString();
Group_Product_Binding group_Product_Binding = new Group_Product_Binding();
pProductdb pProductdb = new pProductdb();
var newproductname = value["newproductname"].ToString();
var newproductprice = value["newproductprice"].ToString();
var newproductcurrentnum = value["newproductcurrentnum"].ToString();
var newproductrestnumber = value["newproductrestnumber"].ToString();
var newproductdescription = value["newproductdescription"].ToString();
var newgroupid = value["newgroupid"].ToString();
pProductdb.Product_name = newproductname;
pProductdb.Product_Price = Convert.ToInt32(newproductprice);
pProductdb.Product_currentnum = Convert.ToInt32(newproductcurrentnum);
pProductdb.Product_restnumber = Convert.ToInt32(newproductrestnumber);
pProductdb.Product_description = newproductdescription;
group_Product_Binding.Groupid = Convert.ToInt32(newgroupid);
group_Product_Binding.Productid = pProductdb.Product_ID;
group_Product_Binding.pProductdb = pProductdb;
db.Group_Product_Binding.Add(group_Product_Binding);
// pProductdb.PictureURL = value["newproductpictureurl"].ToString();
pProductdb.Picturebyte = value["newproductpictureurl"].ToString();
db.pProductdb.Add(group_Product_Binding.pProductdb);
db.SaveChanges();
var result = new
{
STATUS = true,
MSG = "成功",
};
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
