public List <FrayteUnAssignedJob> GetUnAssignedJobs(TrackHSCodeJob obj)
{
List <FrayteUnAssignedJob> list = new List <FrayteUnAssignedJob>();
try
{
int SkipRows = 0;
SkipRows = (obj.CurrentPage - 1) * obj.TakeRows;
var OperationZone = UtilityRepository.GetOperationZone();
// To Do : Get ETD Date And Time in the list
var jobs = dbContext.TrackUnAssignedJob(obj.FromDate, obj.ToDate, SkipRows, obj.TakeRows, OperationZone.OperationZoneId).ToList();
var d = jobs.Where(p => p.EstimatedDateOfDelivery.HasValue).ToList();
if (jobs != null && jobs.Count > 0)
{
foreach (var data in jobs)
{
FrayteUnAssignedJob job = new FrayteUnAssignedJob();
job.CourierCompany = data.LogisticCompany;
job.CourierCompanyDisplay = data.LogisticCompanyDisplay;
job.Customer = data.ContactName;
job.DisplayStatus = data.StatusName;
job.ShippedFromCompany = data.FromCompany;
job.ShippedToCompany = data.ToCompany;
job.ShippingDate = data.CreatedOn;
job.TotalRows = data.TotalRows.HasValue ? data.TotalRows.Value : 0;
job.TrackingNo = data.TrackingNo;
job.EstimatedDateOfDeparture = data.EstimatedDateOfDelivery;
job.EstimatedTimeOfDeparture = UtilityRepository.GetTimeZoneTime(data.EstimatedTimeofDelivery);
job.EstimatedDateOfArrival = data.EstimatedDateofArrival;
job.EstimatedTimeOfArrival = UtilityRepository.GetTimeZoneTime(data.EstimatedTimeofArrival);
job.ShipmentId = data.DirectShipmentId;
job.ShipmentDescription = data.ContentDescription;
job.Reference1 = data.Reference1;
job.FrayteNumber = data.FrayteNumber;
job.FromCountry = data.FromCountry;
job.ToCountry = data.ToCountry;
list.Add(job);
}
}
// To Do : OrderBy on ETD date and then ETD Time
var collection = list.OrderByDescending(p => p.EstimatedDateOfDeparture).ThenByDescending(p => UtilityRepository.GetTimeFromString(p.EstimatedTimeOfDeparture)).ToList();
return(collection);
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
return(list);
}
}