public void DeleteClientOrder(int Id) { Client_Order dbEntry = _context.CLIENT_ORDERS.FirstOrDefault(o => o.ID == Id); if (dbEntry != null) { _context.CLIENT_ORDERS.Remove(dbEntry); _context.SaveChanges(); } }
// PUT: api/CustomerOrder/5 public string Put(int id, HttpRequestMessage value) { try { Client_Order co = new Client_Order(); co = (from p in db.Client_Order where p.Client_Order_ID == id select p).First(); string message = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5); JObject json = JObject.Parse(message); co.Client_Order_Status_ID = (int)json["status_ID"]; co.Client_Order_Type_ID = (int)json["order_type"]; co.Delivery_Method_ID = (int)json["delivery_method"]; co.Reference_ID = (string)json["reference"]; co.VAT_Inclu = Convert.ToBoolean((string)json["vat"]); co.Comment = (string)json["comment"]; co.Contact_ID = (int)json["Contact_ID"]; string errorString = "false|"; bool error = false; if ((from t in db.Client_Order where t.Reference_ID == co.Reference_ID && t.Client_Order_ID != id select t).Count() != 0) { error = true; errorString += "The Customer Order Reference entered already exists on the system. "; } if (error) { return(errorString); } db.SaveChanges(); return("true|Customer Order successfully updated."); } catch (Exception e) { ExceptionLog.LogException(e, "CustomerOrderController PUT"); return("false|An error has occured updating the Customer Order on the system."); } }
public void SaveClientOrder(Client_Order order) { if (order.ID == 0) { _context.CLIENT_ORDERS.Add(order); } else { Client_Order dbEntry = _context.CLIENT_ORDERS.FirstOrDefault(c => c.ID == order.ID); if (dbEntry != null) { dbEntry.ID_CLIENT = order.ID_CLIENT; dbEntry.ID_PAYMENT_METHOD = order.ID_PAYMENT_METHOD; dbEntry.ID_PAYMENT_STATUS = order.ID_PAYMENT_STATUS; dbEntry.ORDER_DATE = order.ORDER_DATE; dbEntry.STATUS = order.STATUS; dbEntry.TOTAL = order.TOTAL; dbEntry.CUR = order.CUR; } }; _context.SaveChanges(); }
void SaveClientOrder(Client_Order order) => _repo.SaveClientOrder(order);