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); } }
public IHttpActionResult GetUnAssignedJobs(TrackHSCodeJob obj) { try { List <FrayteUnAssignedJob> list = new List <FrayteUnAssignedJob>(); list = new HsCodeJobRepository().GetUnAssignedJobs(obj); return(Ok(list)); } catch (Exception ex) { return(BadRequest("Request can not be completed.")); } }