public List <SPKViewModel> SearchSPKPending()
{
List <SPK> result = _spkRepository.GetMany(spk =>
(spk.StatusApprovalId == (int)DbConstant.ApprovalStatus.Pending || spk.StatusPrintId == (int)DbConstant.SPKPrintStatus.Pending) &&
spk.Status == (int)DbConstant.DefaultDataStatus.Active
).OrderByDescending(c => c.Id).ToList();
List <SPKViewModel> mappedResult = new List <SPKViewModel>();
return(Map(result, mappedResult));
}
public List <SPKViewModel> LoadSPK()
{
List <SPK> result = _SPKRepository.GetMany(s => s.Status == (int)DbConstant.DefaultDataStatus.Active &&
s.StatusCompletedId == (int)DbConstant.SPKCompletionStatus.InProgress &&
s.StatusApprovalId == (int)DbConstant.ApprovalStatus.Approved &&
!s.isContractWork
//&& DbFunctions.TruncateTime(s.DueDate) <= DbFunctions.TruncateTime(DateTime.Now)
).ToList();
List <SPKViewModel> mappedResult = new List <SPKViewModel>();
return(Map(result, mappedResult));
}
public List <SPKViewModel> SearchSPKSales(DateTime?dateFrom, DateTime?dateTo)
{
List <SPK> result = _spkRepository.GetMany(spk => spk.CategoryReference.Code == DbConstant.REF_SPK_CATEGORY_SALE).OrderBy(c => c.CreateDate).ToList();
if (dateFrom.HasValue && dateTo.HasValue)
{
result = result.Where(spk => spk.CreateDate.Date >= dateFrom && spk.CreateDate.Date <= dateTo).ToList();
}
List <SPKViewModel> mappedResult = new List <SPKViewModel>();
return(Map(result, mappedResult));
}
public List <SPKViewModel> SearchSPK(string LicenseNumber, string code, int category, DateTime?dateFrom, DateTime?dateTo,
int isContractWork, int customer)
{
List <SPK> result = _SPKRepository.GetMany(spk => spk.Status == (int)DbConstant.DefaultDataStatus.Active && spk.StatusCompletedId == (int)DbConstant.SPKCompletionStatus.Completed && spk.CategoryReference.Code != DbConstant.REF_SPK_CATEGORY_SALE).ToList();
if (dateFrom.HasValue && dateTo.HasValue)
{
dateFrom = dateFrom.Value.Date;
dateTo = dateTo.Value.Date.AddDays(1).AddSeconds(-1);
result = result.Where(spk => spk.CreateDate >= dateFrom && spk.CreateDate <= dateTo).ToList();
}
if (!string.IsNullOrEmpty(LicenseNumber))
{
VehicleDetail vehicleDetail = _vehicleDetailRepository.GetMany(v => string.Compare(v.LicenseNumber, LicenseNumber, true) == 1 &&
v.Status == (int)DbConstant.DefaultDataStatus.Active).FirstOrDefault();
if (vehicleDetail != null)
{
result = result.Where(spk => spk.VehicleId == vehicleDetail.VehicleId).ToList();
}
}
if (customer > 0)
{
result = result.Where(spk => spk.Vehicle.CustomerId == customer).ToList();
}
if (!string.IsNullOrEmpty(code))
{
result = result.Where(spk => string.Compare(spk.Code, code, true) == 0).ToList();
}
if (category > 0)
{
result = result.Where(spk => spk.CategoryReferenceId == category).ToList();
}
if (isContractWork == 0)
{
result = result.Where(spk => spk.isContractWork == false).ToList();
}
if (isContractWork == 1)
{
result = result.Where(spk => spk.isContractWork == true).ToList();
}
List <SPKViewModel> mappedResult = new List <SPKViewModel>();
return(Map(result, mappedResult));
}
public List <SPKViewModel> SearchSPK(DateTime from, DateTime to, string LicenseNumber, string code, int category, DbConstant.ApprovalStatus approvalStatus,
DbConstant.SPKPrintStatus printStatus, DbConstant.SPKCompletionStatus completedStatus, int isContractWork)
{
List <SPK> result = _SPKRepository.GetMany(spk =>
DbFunctions.TruncateTime(spk.CreateDate) >= DbFunctions.TruncateTime(from) &&
DbFunctions.TruncateTime(spk.CreateDate) <= DbFunctions.TruncateTime(to) &&
spk.Status == (int)DbConstant.DefaultDataStatus.Active).ToList();
if ((int)completedStatus != 9)
{
result = result.Where(spk => spk.StatusCompletedId == (int)completedStatus).ToList();
}
if ((int)printStatus != 9)
{
result = result.Where(spk => spk.StatusPrintId == (int)printStatus).ToList();
}
if ((int)approvalStatus != 9)
{
result = result.Where(spk => spk.StatusApprovalId == (int)approvalStatus).ToList();
}
if (!string.IsNullOrEmpty(LicenseNumber))
{
IEnumerable <int> vehicleDetails = _vehicleDetailRepository.GetMany(v => v.LicenseNumber.Contains(LicenseNumber)).Select(v => v.Id).DefaultIfEmpty(0);
if (vehicleDetails != null)
{
result = result.Where(spk => vehicleDetails.Contains(spk.VehicleId)).ToList();
}
}
if (!string.IsNullOrEmpty(code))
{
result = result.Where(spk => string.Compare(spk.Code, code, true) == 0).ToList();
}
if (category > 0)
{
result = result.Where(spk => spk.CategoryReferenceId == category).ToList();
}
if (isContractWork == 0)
{
result = result.Where(spk => spk.isContractWork == false).ToList();
}
if (isContractWork == 1)
{
result = result.Where(spk => spk.isContractWork == true).ToList();
}
List <SPKViewModel> mappedResult = new List <SPKViewModel>();
if (result == null)
{
result = new List <SPK>();
}
return(Map(result, mappedResult));
}
