public IEnumerable<DayViewJobDTO> GetUnplannedDayViewJobs(DateTime day)
{
IEnumerable<DayViewJobDTO> records = null;
using (var ds = new DataService(this.connectionString, this.consumerInfo))
{
TimeSpan zeroTimeSpan = new TimeSpan(0, 0, 0);
List<CrmtJob> jobList = ds.CrmtJob.GetAll().Where(j => j.dRepairDate == day && (!(j.tStartTime.HasValue && j.tEndTime.HasValue) || (j.tStartTime == zeroTimeSpan || j.tEndTime == zeroTimeSpan))).ToList();
records = (from j in jobList
where j.isCompleted == false
orderby j.dCreateDate
select new DayViewJobDTO
{
nID = j.nID,
sCustomerCode = j.sCustomerCode,
sCustomerName = j.sCustomerName,
dRepairDate = j.dRepairDate,
tStartTime = j.tStartTime,
tEndTime = j.tEndTime,
nStatus = j.jobStatus,
nTechnician1ID = j.nTechnician1ID,
nTechnician2ID = j.nTechnician2ID,
nTechnician3ID = j.nTechnician3ID,
nTechnician4ID = j.nTechnician4ID,
bIsEcall = j.bIsEcall
}).ToList();
foreach (DayViewJobDTO job in records)
{
#region Get Technician
job.technicians = new List<JobTechnicianDTO>();
JobTechnicianDTO technician = new JobTechnicianDTO();
if (job.nTechnician1ID.HasValue)
{
technician.nID = job.nTechnician1ID.Value;
job.technicians.Add(technician);
}
if (job.nTechnician2ID.HasValue)
{
technician = new JobTechnicianDTO();
technician.nID = job.nTechnician2ID.Value;
job.technicians.Add(technician);
}
if (job.nTechnician3ID.HasValue)
{
technician = new JobTechnicianDTO();
technician.nID = job.nTechnician3ID.Value;
job.technicians.Add(technician);
}
if (job.nTechnician4ID.HasValue)
{
technician = new JobTechnicianDTO();
technician.nID = job.nTechnician4ID.Value;
job.technicians.Add(technician);
}
foreach (JobTechnicianDTO jobTechnician in job.technicians)
{
CrmmTechnician crmmTechnician = (from t in ds.CrmmTechnician.GetAll()
where t.nID == jobTechnician.nID
select t).FirstOrDefault();
if (crmmTechnician != null)
{
jobTechnician.sName = crmmTechnician.sName;
jobTechnician.bIsLeave = crmmTechnician.isLeave(job.dRepairDate, job.tStartTime, job.tEndTime);
}
}
#endregion Get Technician
}
return records.ToList();
}
}
public IEnumerable<DayViewJobDTO> GetPlannedDayViewJobs(DateTime day, DayViewJobSearchDTO searchModel)
{
IEnumerable<DayViewJobDTO> records = null;
using (var ds = new DataService(this.connectionString, this.consumerInfo))
{
TimeSpan zeroTimeSpan = new TimeSpan(0, 0, 0);
List<CrmtJob> jobList = (from j in ds.CrmtJob.GetAll()
where (j.dCompletionDate.HasValue && j.tActualStartTime.HasValue && j.tActualEndTime.HasValue && j.dCompletionDate == day) ||
(!(j.dCompletionDate.HasValue && j.tActualStartTime.HasValue && j.tActualEndTime.HasValue) && j.dRepairDate == day && j.tStartTime.HasValue && j.tEndTime.HasValue && (j.tStartTime != zeroTimeSpan && j.tEndTime != zeroTimeSpan))
select j).ToList();
records = (from j in jobList
//orderby j.tStartTime, j.tEndTime
select new DayViewJobDTO
{
nID = j.nID,
sCustomerCode = j.sCustomerCode,
sCustomerName = j.sCustomerName,
dRepairDate = j.isCompleted ? j.dCompletionDate : j.dRepairDate,
tStartTime = j.isCompleted ? j.tActualStartTime : j.tStartTime,
tEndTime = j.isCompleted ? j.tActualEndTime : j.tEndTime,
nStatus = j.jobStatus,
bIsEcall = j.bIsEcall,
nTechnician1ID = j.nTechnician1ID,
nTechnician2ID = j.nTechnician2ID,
nTechnician3ID = j.nTechnician3ID,
nTechnician4ID = j.nTechnician4ID
}).ToList();
records = records.OrderBy(r => r.tStartTime).ThenBy(r => r.tEndTime).ToList();
foreach (DayViewJobDTO job in records)
{
#region Get Technician
job.technicians = new List<JobTechnicianDTO>();
JobTechnicianDTO technician = new JobTechnicianDTO();
if (job.nTechnician1ID.HasValue)
{
technician.nID = job.nTechnician1ID.Value;
job.technicians.Add(technician);
}
if (job.nTechnician2ID.HasValue)
{
technician = new JobTechnicianDTO();
technician.nID = job.nTechnician2ID.Value;
job.technicians.Add(technician);
}
if (job.nTechnician3ID.HasValue)
{
technician = new JobTechnicianDTO();
technician.nID = job.nTechnician3ID.Value;
job.technicians.Add(technician);
}
if (job.nTechnician4ID.HasValue)
{
technician = new JobTechnicianDTO();
technician.nID = job.nTechnician4ID.Value;
job.technicians.Add(technician);
}
foreach (JobTechnicianDTO jobTechnician in job.technicians)
{
CrmmTechnician crmmTechnician = (from t in ds.CrmmTechnician.GetAll()
where t.nID == jobTechnician.nID
select t).FirstOrDefault();
if (crmmTechnician != null)
{
jobTechnician.sName = crmmTechnician.sName;
jobTechnician.bIsLeave = crmmTechnician.isLeave(job.dRepairDate, job.tStartTime, job.tEndTime);
}
}
#endregion Get Technician
}
#region Filtering
if (searchModel != null)
{
if (!string.IsNullOrWhiteSpace(searchModel.sCustomerCodeFilter))
{
records = records.Where(j => j.sCustomerCode.ToLower().Contains(searchModel.sCustomerCodeFilter.ToLower().Trim()));
}
if (!string.IsNullOrWhiteSpace(searchModel.sTechnicianNameFilter))
{
records = records.Where(j => j.technicians.Any(t => t.sName.ToLower().Contains(searchModel.sTechnicianNameFilter.ToLower().Trim())));
}
if (searchModel.nIsEcallFilter == 1) records = records.Where(j => j.bIsEcall == true);
else if (searchModel.nIsEcallFilter == 0) records = records.Where(j => j.bIsEcall == false);
}
#endregion Filtering
foreach (DayViewJobDTO job in records)
{
#region Get column index
job.calculatedStartTime = job.tStartTime;
job.calculatedEndTime = job.tEndTime;
if (job.tStartTime < TimeSpan.FromHours(8))
{
job.calculatedStartTime = new TimeSpan(8, 0, 0);
}
else if (job.tStartTime >= TimeSpan.FromHours(18))
{
job.calculatedStartTime = new TimeSpan(18, 0, 0);
job.calculatedEndTime = new TimeSpan(19, 0, 0);
}
if (job.tEndTime > TimeSpan.FromHours(18))
{
job.calculatedEndTime = new TimeSpan(19, 0, 0);
}
var previousJobs = records.Where(r => r.calculatedStartTime.HasValue && r.calculatedEndTime.HasValue && job.calculatedEndTime > r.calculatedStartTime && job.calculatedStartTime < r.calculatedEndTime && r.column.HasValue).OrderBy(r => r.column).ToList();
int jobCount = previousJobs.Count();
if (jobCount > 0)
{
int lastColumnIndex = 0;
for (int i = 0; i < jobCount; i++)
{
int columnIndex = previousJobs.ElementAt(i).column.Value;
if (i == 0 && columnIndex != 0)
{
job.column = 0;
break;
}
if (i != 0)
{
if (lastColumnIndex + 1 != columnIndex)
{
job.column = lastColumnIndex + 1;
break;
}
}
lastColumnIndex = columnIndex;
continue;
}
if (!job.column.HasValue) job.column = lastColumnIndex + 1;
}
else
{
job.column = 0;
}
#endregion Get column index
#region Get height and top
double minuteDiff = job.calculatedEndTime.Value.Subtract(job.calculatedStartTime.Value).TotalMinutes;
job.height = (int)(minuteDiff / 60 * 61);
job.top = (int)(job.calculatedStartTime.Value.Subtract(TimeSpan.FromHours(8)).TotalMinutes / 60 * 61);
#endregion Get height and top
}
return records.ToList();
}
}
