/// <summary>
/// Create a new Disbursement object.
/// </summary>
/// <param name="disbursementID">Initial value of the DisbursementID property.</param>
/// <param name="disburse_Date">Initial value of the Disburse_Date property.</param>
/// <param name="status">Initial value of the Status property.</param>
/// <param name="department_ReqID">Initial value of the Department_ReqID property.</param>
/// <param name="department">Initial value of the Department property.</param>
public static Disbursement CreateDisbursement(global::System.Int32 disbursementID, global::System.DateTime disburse_Date, global::System.String status, global::System.Int32 department_ReqID, global::System.String department)
{
Disbursement disbursement = new Disbursement();
disbursement.DisbursementID = disbursementID;
disbursement.Disburse_Date = disburse_Date;
disbursement.Status = status;
disbursement.Department_ReqID = department_ReqID;
disbursement.Department = department;
return disbursement;
}
/// <summary>
/// Deprecated Method for adding a new object to the Disbursements EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToDisbursements(Disbursement disbursement)
{
base.AddObject("Disbursements", disbursement);
}
public void Disburse()
{
bool flag = false;
using (TransactionScope trans = new TransactionScope())
{
int id;
List<int> disb_id = new List<int>();
try
{
var x = (from m in cntxt.DeptRequisitions where m.Status_Check == "current" select m).AsEnumerable<DeptRequisition>();
foreach (var d in x)
{
disb_id.Add(d.Dept_ReqID);
var p = (from m in cntxt.Departments
where m.Department_Code == d.Department_Code
select m).First<Department>();
Disbursement db = new Disbursement
{
Disburse_Date = DateTime.Now,
Status = "current",
Department_ReqID = d.Dept_ReqID,
Department = p.Department_Name,
Dispatch_Status = "pending"
};
cntxt.Disbursements.AddObject(db);
cntxt.SaveChanges();
id = db.DisbursementID;
var s = from m in cntxt.DepartmentViews
where m.Department_Code == p.Department_Code
select m;
foreach (var item in s)
{
DisbursementDetail dbd = new DisbursementDetail
{
DisbursementID = id,
Quantity = Convert.ToInt32(item.Requested_Quantity),
Item_Code = item.Item_Code,
Outstanding_Type = "pending",
Alloted = 0
};
cntxt.DisbursementDetails.AddObject(dbd);
cntxt.SaveChanges();
}
}
trans.Complete();
flag = true;
}
catch (TransactionException e)
{
e.Message.ToString();
}
}
if (flag)
{
cntxt.AcceptAllChanges();
}
else
{
cntxt.Dispose();
}
}