/// <summary> /// Deprecated Method for adding a new object to the RetrievalDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToRetrievalDetails(RetrievalDetail retrievalDetail) { base.AddObject("RetrievalDetails", retrievalDetail); }
/// <summary> /// Create a new RetrievalDetail object. /// </summary> /// <param name="detailID">Initial value of the DetailID property.</param> /// <param name="retrievalID">Initial value of the RetrievalID property.</param> /// <param name="item_Code">Initial value of the Item_Code property.</param> /// <param name="quantity">Initial value of the Quantity property.</param> public static RetrievalDetail CreateRetrievalDetail(global::System.Int32 detailID, global::System.Int32 retrievalID, global::System.String item_Code, global::System.Int32 quantity) { RetrievalDetail retrievalDetail = new RetrievalDetail(); retrievalDetail.DetailID = detailID; retrievalDetail.RetrievalID = retrievalID; retrievalDetail.Item_Code = item_Code; retrievalDetail.Quantity = quantity; return retrievalDetail; }
public void getRequests() { bool flag = false; using (TransactionScope trans = new TransactionScope()) { try { int id, ret_quant, pend_quant, avail_quant, quant; RetrievalMaster rm = new RetrievalMaster { Retrieval_Date = DateTime.Now, Status_Check = "current" }; cntxt.RetrievalMasters.AddObject(rm); cntxt.SaveChanges(); id = rm.RetrievalID; var x = (from m in cntxt.ItemRequesteds select m).AsEnumerable<ItemRequested>(); foreach (var ir in x) { var y = cntxt.Stock_Item.FirstOrDefault(m => m.Item_Code == ir.Item_Code); quant = Convert.ToInt32(ir.Requested_Quantity); avail_quant = y.Quantity; if (quant > avail_quant) { ret_quant = avail_quant; pend_quant = quant - avail_quant; } else { ret_quant = quant; pend_quant = 0; } RetrievalDetail rd = new RetrievalDetail { RetrievalID = id, Item_Code = ir.Item_Code, Quantity = quant, Pending_Quantity = pend_quant, Retrieved_Quantity = ret_quant }; UpdateStock(ir.Item_Code, ret_quant); cntxt.RetrievalDetails.AddObject(rd); cntxt.SaveChanges(); } trans.Complete(); flag = true; } catch (TransactionException e) { e.Message.ToString(); } } if (flag) { cntxt.AcceptAllChanges(); } else { cntxt.Dispose(); } }