/// <summary> /// Create a new Pending_Detail object. /// </summary> /// <param name="pending_DetailID">Initial value of the Pending_DetailID property.</param> /// <param name="pendingID">Initial value of the PendingID 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 Pending_Detail CreatePending_Detail(global::System.Int32 pending_DetailID, global::System.Int32 pendingID, global::System.String item_Code, global::System.Int32 quantity) { Pending_Detail pending_Detail = new Pending_Detail(); pending_Detail.Pending_DetailID = pending_DetailID; pending_Detail.PendingID = pendingID; pending_Detail.Item_Code = item_Code; pending_Detail.Quantity = quantity; return pending_Detail; }
public void pendingQuantityDisburse() { bool success = false; using (TransactionScope transaction = new TransactionScope()) { try { var data = (from m in team.Disbursements where m.Dispatch_Status == "pending" select m).ToList<Disbursement>(); foreach (var z in data) { Pending pd = new Pending() { DisbursementID = z.DisbursementID, Dept_Code = z.Department, Status = "UnFullFilled", Date = DateTime.Now, Pending_Status = "current" }; team.Pendings.AddObject(pd); team.SaveChanges(); int pendingId = pd.PendingID; int disburseID = pd.DisbursementID; string deptcode = pd.Dept_Code; //var y = (from o in team.Pending_Items // where o.Department == deptcode // select o).AsEnumerable<Pending_Items>(); var y = (from o in team.DisbursementDetails where o.DisbursementID == disburseID && o.Outstanding_Type == "pending" select o).ToList<DisbursementDetail>(); foreach (var bike in y) { Pending_Detail pending = new Pending_Detail() { PendingID = pendingId, Item_Code = bike.Item_Code, Quantity = bike.Pending_Qty, Status = "UnFullFilled" }; team.Pending_Detail.AddObject(pending); team.SaveChanges(); } } team.SaveChanges(); transaction.Complete(); success = true; } catch (TransactionAbortedException e) { e.Message.ToString(); } } if (success) { team.AcceptAllChanges(); } else { team.Dispose(); } }
/// <summary> /// Deprecated Method for adding a new object to the Pending_Detail EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPending_Detail(Pending_Detail pending_Detail) { base.AddObject("Pending_Detail", pending_Detail); }