/// <summary> /// Deprecated Method for adding a new object to the PROCESSING EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPROCESSING(PROCESSING pROCESSING) { base.AddObject("PROCESSING", pROCESSING); }
public bool SendToChicken(Guid order_id) { try { // Lấy dữ liệu order ORDER order = (from p in Context.ORDER where p.Id == order_id select p).SingleOrDefault(); if (order == null) return false; //Lấy dữ liệu order detail List<ORDER_DETAIL> orderdtl; orderdtl = (from p in Context.ORDER_DETAIL where p.ORDER_ID == order_id && p.STATUS=="Chờ làm" select p).ToList(); if (orderdtl.Count == 0) return false; //Đếm số lượng món đang làm int c; c = (from p in Context.PROCESSING where p.STATUS == "Đang làm" select p.Id).Count(); decimal m; m = (from p in Context.PROCESSING select (decimal?)p.PRIORITY).Max() ?? 0; for (int i = 0; i < orderdtl.Count; i++) { PROCESSING proccess = new PROCESSING(); proccess.Id = Guid.NewGuid(); proccess.AMOUNT = orderdtl[i].AMOUNT; proccess.CHEF_ID = orderdtl[i].CHEF_ID; proccess.DISH_ID = orderdtl[i].DISH_ID; proccess.TALBLE_ID = order.TABLE_ID; proccess.ORDERDTL_ID = orderdtl[i].Id; proccess.COMMENT = orderdtl[i].COMMENT; if (i + c < 10) { proccess.PRIORITY = i + c + 1; proccess.STATUS = "Đang làm"; } else { proccess.PRIORITY = i+(int)m+1; proccess.STATUS = "Chờ làm"; } Context.PROCESSING.AddObject(proccess); orderdtl[i].STATUS = "Đang làm"; } //Thay đổi trạng thái của order order.STATUS = "Đang làm"; //Commit change Context.SaveChanges(); return true; } catch (Exception ex) { throw ex; } }
/// <summary> /// Create a new PROCESSING object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="dISH_ID">Initial value of the DISH_ID property.</param> /// <param name="pRIORITY">Initial value of the PRIORITY property.</param> /// <param name="aMOUNT">Initial value of the AMOUNT property.</param> /// <param name="sTATUS">Initial value of the STATUS property.</param> /// <param name="tALBLE_ID">Initial value of the TALBLE_ID property.</param> /// <param name="oRDERDTL_ID">Initial value of the ORDERDTL_ID property.</param> public static PROCESSING CreatePROCESSING(global::System.Guid id, global::System.Guid dISH_ID, global::System.Int32 pRIORITY, global::System.Int32 aMOUNT, global::System.String sTATUS, global::System.Guid tALBLE_ID, global::System.Guid oRDERDTL_ID) { PROCESSING pROCESSING = new PROCESSING(); pROCESSING.Id = id; pROCESSING.DISH_ID = dISH_ID; pROCESSING.PRIORITY = pRIORITY; pROCESSING.AMOUNT = aMOUNT; pROCESSING.STATUS = sTATUS; pROCESSING.TALBLE_ID = tALBLE_ID; pROCESSING.ORDERDTL_ID = oRDERDTL_ID; return pROCESSING; }