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);
}
}
}
}
protected override void ChildGrid_OnModified(Container entity)
{
if (entity.ID > 0 && entity.TransferBooking != null && entity.TransferBooking.ID > 0 && entity.Booking.ID != entity.TransferBooking.ID)
{
// Update dispatcher booking Id
DispatcherRequestLibrary dispathLib = new DispatcherRequestLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <DispatcherRequest> dispatcherReqs = dispathLib.GetDispatcherByBookingAndContainerNo(entity.TransferBooking.ID, entity.Container_No,
new string[] { "TruckingCompany", "Driver", "Booking_Ref_No", "Purchase_Order_No", "Party", "Location", "Shipper", "Sales_Order_No", "Asset", "Container" });
DispatcherRequest dispatcherReq = dispatcherReqs.FirstOrDefault();
if (dispatcherReq != null)
{
dispatcherReq.Booking_Ref_No.ID = entity.Booking.ID;
dispathLib.Modify(dispatcherReq, new string[] { "TruckingCompany", "Driver", "Booking_Ref_No", "Purchase_Order_No", "Party", "Location", "Shipper", "Sales_Order_No", "Asset" });
}
entity.Booking.ID = entity.TransferBooking.ID;
}
}
