/// <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);
}
