private void AddNonInvoiceSellingDispatcherExpenses(int bookingId, string containerNo)
{
// Search for expenses that matches dispatcher id.
DispatcherRequestLibrary dispathcerRequestLib = new DispatcherRequestLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <DispatcherRequest> dispatcherReqs = dispathcerRequestLib.GetDispatcherByBookingAndContainerNo(bookingId, containerNo, new string[] { "Booking_Ref_No", "Container" });
foreach (DispatcherRequest dispatcherReq in dispatcherReqs)
{
ExpensesRequestLibrary lib = new ExpensesRequestLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
string refTableName = new Model.DispatcherRequest().GetType().Name;
IEnumerable <ExpensesRequest> expenses = lib.GetAllPurchasingExepneseByRefTableAndRefId(dispatcherReq.ID, refTableName, new[] { "Payment", "Paid_Party_To", "Invoice" });
foreach (var item in expenses)
{
// If expense already exists.
if (TempEntityList.FirstOrDefault(m => m.ID == item.ID) == null)
{
// If party is null.
if (item.Paid_Party_To == null)
{
item.Paid_Party_To = new Party();
}
// Add to TempList.
TempEntityList.Add(item);
}
}
}
}
private void AddUnPaidPurchaseDispatcherExpenses(int dispathcerId)
{
// Search for expenses that matches dispatcher id.
ExpensesRequestLibrary lib = new ExpensesRequestLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
string refTableName = new Model.DispatcherRequest().GetType().Name;
IEnumerable <ExpensesRequest> expenses = lib.GetAllPurchasingExepneseByRefTableAndRefId(dispathcerId, refTableName, new[] { "Payment", "Paid_Party_To" });
foreach (var item in expenses)
{
// If expense already exists.
if (TempEntityList.FirstOrDefault(m => m.ID == item.ID) == null)
{
// If party is null.
if (item.Paid_Party_To == null)
{
item.Paid_Party_To = new Party();
}
// Add to TempList.
TempEntityList.Add(item);
}
}
}
