/// <summary> /// Deprecated Method for adding a new object to the RetrievalMasters EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToRetrievalMasters(RetrievalMaster retrievalMaster) { base.AddObject("RetrievalMasters", retrievalMaster); }
/// <summary> /// Create a new RetrievalMaster object. /// </summary> /// <param name="retrievalID">Initial value of the RetrievalID property.</param> public static RetrievalMaster CreateRetrievalMaster(global::System.Int32 retrievalID) { RetrievalMaster retrievalMaster = new RetrievalMaster(); retrievalMaster.RetrievalID = retrievalID; return retrievalMaster; }
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(); } }