// Get Quote type for Create or Edit
public async Task <QuoteMasterDto> QuoteDetailToEdit(GetJobInput input)
{
var output = new QuoteMasterDto();
var quote = _quotemasterrepository.FirstOrDefault(p => p.Id == input.id);
if (quote != null)
{
output = quote.MapTo <QuoteMasterDto>();
output.JobId = quote.JobId;
}
else
{
output.JobId = input.id; // jobId
}
var VehicleID = _jobsrrepository.FirstOrDefault(p => p.Id == quote.JobId);
if (VehicleID != null)
{
var vehicle = await _vehiclerrepository.GetAsync(VehicleID.VehicleID);
if (vehicle != null)
{
output.RegNo = vehicle.RegistrationNumber;
output.IsSpecialisedType = vehicle.IsSpecialisedType;
output.IsLuxury = vehicle.IsLuxury;
output.UnderWaranty = VehicleID.UnderWaranty;
output.PaintTypeId = vehicle.PaintTypeId;
output.vehicleId = VehicleID.VehicleID;
//output = vehicle.MapTo<QuoteMasterDto>();
}
}
return(output);
}
// Get Quote type for Create or Edit
public async Task <QuoteMasterDto> GetQuoteForNewQuotation(GetJobInput input)
{
var VehicleID = _jobsrrepository.FirstOrDefault(p => p.Id == input.id);
var vehicle = await _vehiclerrepository.GetAsync(VehicleID.VehicleID);
var output = new QuoteMasterDto();
output.JobId = input.id;
output.vehicleId = VehicleID.VehicleID;
output.RegNo = vehicle.RegistrationNumber;
output.IsSpecialisedType = vehicle.IsSpecialisedType;
output.IsLuxury = vehicle.IsLuxury;
output.UnderWaranty = VehicleID.UnderWaranty;
output.PaintTypeId = vehicle.PaintTypeId;
return(output);
}
// By jobstaticId
public async Task <JobstatusTenantDto> GetJobStatusForEdit(GetJobInput input)
{
var output = new JobstatusTenantDto();
var ifexist = _jobstatustenantRepository.FirstOrDefault(p => p.JobStatusID == input.id && p.Tenant == _abpSession.TenantId);
if (ifexist != null)//Job Static doesn't exist in tblJobstatusTenant
{
try
{
output = ifexist.MapTo <JobstatusTenantDto>();
}
catch (Exception c)
{
throw c;
}
}
var job = await _jobstatusRepository.GetAsync(input.id);
output.JobStatus = job.Description;
output.JobStatusID = job.Id;
return(output);
}
/// <summary>
/// Get the list of all JobPORangeAllocation based on PORangeAllocationId.
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <ListResultOutput <JobPORangeAllocationUnitDto> > GetJobPORangeAllocationByJobId(GetJobInput input)
{
var query = _jobPORangeAllocationUnitRepository.GetAll().Where(u => u.JobId == input.JobId);
var resultCount = await query.CountAsync();
var results = await query
.AsNoTracking()
.ToListAsync();
return(new ListResultOutput <JobPORangeAllocationUnitDto>(results.Select(item =>
{
var dto = item.MapTo <JobPORangeAllocationUnitDto>();
dto.PORangeAllocationId = item.Id;
return dto;
}).ToList()));
}
public async Task <PagedResultDto <JobListDto> > GetAll(GetJobInput input)
{
var query = _jobRepository.GetAllIncluding(e => e.Project).OrderBy(input.Sorting).PageBy(input);
var jobsCount = await query.CountAsync();
var jobs = await query.ToListAsync();
var dtos = new List <JobListDto>();
var hashtest = _hashRepository.GetAllList();
jobs.ForEach(j => {
var dto = ObjectMapper.Map <JobListDto>(j);
var hashsQuery = _hashRepository.GetAll();
hashsQuery = hashsQuery.Where(h => h.Key == $"{AppConsts.RecurringJobPrefix}:{j.Id}");
var hashs = hashsQuery.ToList();
if (hashs != null)
{
dto.Job = hashs.SingleOrDefault(e => e.Field == "Job")?.Value;
//dto.Cron = hashs.SingleOrDefault(e => e.Field == "Cron")?.Value;
dto.TimeZoneId = hashs.SingleOrDefault(e => e.Field == "TimeZoneId")?.Value;
dto.Queue = hashs.SingleOrDefault(e => e.Field == "Queue")?.Value;
if (hashs.SingleOrDefault(e => e.Field == "CreatedAt") != null)
{
dto.CreatedAt = DateTime.Parse(hashs.SingleOrDefault(e => e.Field == "CreatedAt").Value);
}
if (hashs.SingleOrDefault(e => e.Field == "LastExecution") != null)
{
dto.LastExecution = DateTime.Parse(hashs.SingleOrDefault(e => e.Field == "LastExecution").Value);
}
if (hashs.SingleOrDefault(e => e.Field == "LastJobId") != null)
{
dto.LastJobId = int.Parse(hashs.SingleOrDefault(e => e.Field == "LastJobId").Value);
}
if (hashs.SingleOrDefault(e => e.Field == "NextExecution") != null)
{
dto.NextExecution = DateTime.Parse(hashs.SingleOrDefault(e => e.Field == "NextExecution").Value);
}
if (!string.IsNullOrWhiteSpace(j.Cron))
{
CronExpressionDescriptor.Options opt = new CronExpressionDescriptor.Options()
{
DayOfWeekStartIndexZero = false,
ThrowExceptionOnParseError = false
};
dto.CronDescription = CronExpressionDescriptor.ExpressionDescriptor.GetDescription(dto.Cron, opt);
}
}
dto.ProjectName = j.Project.ProjectName;
dto.Enviroment = j.Project.Enviroment;
dtos.Add(dto);
});
return(new PagedResultDto <JobListDto>(jobsCount, dtos));
}
public JobDto GetJob(GetJobInput input)
{
return(Mapper.Map <JobDto>(_jobRepository.Get(input.JobId)));
}
public async Task <ListResultOutput <JobLocationUnitDto> > GetJobLocationUnitsByJobId(GetJobInput input)
{
var items = await(from joblocation in _jobLocationUnitRepository.GetAll()
join location in _subAccountUnitRepository.GetAll()
.Where(p => p.TypeofSubAccountId == TypeofSubAccount.Locations || p.TypeofSubAccountId == TypeofSubAccount.Sets)
on joblocation.LocationId equals location.Id
where joblocation.JobId == input.JobId
select new { JobLocation = joblocation, LocationName = location.Description }).ToListAsync();
return(new ListResultOutput <JobLocationUnitDto>(
items.Select(item =>
{
var dto = item.JobLocation.MapTo <JobLocationUnitDto>();
dto.JobLocationId = item.JobLocation.Id;
dto.LocationName = item.LocationName;
return dto;
}).ToList()));
}
