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