public IHttpActionResult GetJobsInProgressCount()
{
try
{
JobsInProgressCount jobsCount = new JobsInProgressCount();
jobsCount = new HsCodeJobRepository().GetJobsInProgressCount();
return(Ok(jobsCount));
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
return(BadRequest("Could not Complete the request."));
}
}
public JobsInProgressCount GetJobsInProgressCount()
{
JobsInProgressCount jobCount = new JobsInProgressCount();
try
{
var OperationZone = UtilityRepository.GetOperationZone();
var data = dbContext.eCommerceShipments
.Where(p => (p.CustomManifestId == null || p.CustomManifestId == 0) && p.ShipmentStatusId == (int)FrayteShipmentStatus.eCCurrent &&
p.OpearionZoneId == OperationZone.OperationZoneId).ToList();
if (data != null && data.Count > 0)
{
jobCount.TotalJobs = data.Count;
}
else
{
jobCount.TotalJobs = 0;
}
var mycount1 = (from cnt in dbContext.eCommerceShipmentDetails
join ec in dbContext.eCommerceShipments on cnt.eCommerceShipmentId equals ec.eCommerceShipmentId
where ec.OpearionZoneId == OperationZone.OperationZoneId && // ec.eCommerceShipmentId == 11 &&
ec.ShipmentStatusId == (int)FrayteShipmentStatus.eCCurrent && (ec.CustomManifestId == null || ec.CustomManifestId == 0) &&
ec.AssignedTo != null
group cnt by cnt.eCommerceShipmentId into g
select new
{
name = g.Key,
HSCode = g.Min(r => string.IsNullOrEmpty(r.HSCode) ? "" : r.HSCode),
count = g.Count()
}).ToList().Where(p => !string.IsNullOrEmpty(p.HSCode)).ToList();
var mycount = mycount1.Count;
jobCount.CompletedJobs = mycount;
return(jobCount);
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
return(jobCount);
}
}
