public ActionResult <IResult> GetEmployees(SearchSortModel search)
{
_logger.LogInformation("get All Employees");
var result = _employeeService.GetEmployeeList(search);
return(StatusCode((int)result.StatusCode, result));
}
public ActionResult <IResult> GetDeclarationsByUserId([FromBody] SearchSortModel search)
{
_logger.LogInformation("get all declarations by UserId");
var result = _healthTrackService.GetDeclarationsByUserId(search);
return(StatusCode((int)result.StatusCode, result));
}
public ActionResult <IResult> GetAllDeclarations(SearchSortModel search)
{
_logger.LogInformation("get all declarations");
var result = _healthTrackService.GetAllDeclarations(search);
return(StatusCode((int)result.StatusCode, result));
}
/// <summary>
/// Get all Locations.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IResult GetAllLocations(SearchSortModel search)
{
if (string.IsNullOrEmpty(search.SortColumn))
{
search.SortColumn = "LocationName";
}
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
var locationViewModels = new List <LocationViewModel>();
var locations = _locationRepository.GetAllLocations(search);
if (locations != null && locations.Any())
{
search.SearchResult = locationViewModels.MapFromModel <Location, LocationViewModel>(locations);
}
else
{
search.SearchResult = locationViewModels;
result.Message = CommonErrorMessages.NoResultFound;
}
result.Body = search;
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
public ActionResult <IResult> GetAllRequestsByUserId(SearchSortModel search)
{
_logger.LogInformation("Get all requests by userId");
var result = _requestService.GetRequestsListByUserId(search);
return(StatusCode((int)result.StatusCode, result));
}
/// <summary>
/// Get All Partners.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IResult GetAllPartners(SearchSortModel search)
{
if (string.IsNullOrEmpty(search.SortColumn))
{
search.SortColumn = Constants.CreatedDate;
}
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
var partnerViewModels = new List <PartnerViewModel>();
var allPartner = _partnerRepository.GetAllPartners(search);
if (allPartner != null && allPartner.Any())
{
search.SearchResult = partnerViewModels.MapFromModel <Partner, PartnerViewModel>(allPartner);
}
else
{
search.SearchResult = partnerViewModels;
result.Message = CommonErrorMessages.NoResultFound;
}
result.Body = search;
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
public ActionResult <IResult> GetAllRequests([FromBody] SearchSortModel search)
{
_logger.LogInformation("Get all requests");
var result = _requestService.GetRequestsList(search);
return(StatusCode((int)result.StatusCode, result));
}
/// <summary>
/// Get All Request Info
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IResult GetRequests(SearchSortModel search)
{
if (string.IsNullOrEmpty(search.SortColumn))
{
search.SortColumn = "RequestedBy";
}
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
var requestViewModels = new List <RequestViewModel>();
var allRequest = _requestRepository.GetAllRequests(search);
if (allRequest != null && allRequest.Any())
{
requestViewModels = allRequest.Select(t =>
{
var requestViewModel = new RequestViewModel();
requestViewModel.MapFromModel(t);
if (t.Files != null && t.Files.Any())
{
requestViewModel.Files = new List <string>();
t.Files.ForEach(x => requestViewModel.Files.Add(x.ToString()));
}
if (t.MailUsers != null && t.MailUsers.Any())
{
var mailUsers = new List <MailUserDetails>();
requestViewModel.MailUsers = mailUsers.MapFromModel <MailUserDetails, MailUser>(t.MailUsers);
}
return(requestViewModel);
}).ToList();
search.SearchResult = requestViewModels;
}
else
{
search.SearchResult = requestViewModels;
result.Message = CommonErrorMessages.NoResultFound;
}
result.Body = search;
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
/// <summary>
/// Returns employees
/// </summary>
/// <returns></returns>
public IResult GetEmployeeList(SearchSortModel search)
{
var employeeViewModels = new List <EmployeeViewModel>();
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success,
StatusCode = HttpStatusCode.OK
};
try
{
var employees = _employeeRepository.GetAllEmployees(search);
if (employees.Any())
{
employeeViewModels = employees.Select(t =>
{
var employeeViewModel = new EmployeeViewModel();
employeeViewModel.MapFromModel(t);
var roles = new List <EmployeeRoleViewModel>();
roles = t.EmployeeRoles.Select(r =>
{
var role = new EmployeeRoleViewModel();
role.Id = r.Id;
role.RoleId = r.RoleId;
role.RoleName = r.Role.Name;
role.EmployeeId = r.EmployeeId;
return(role);
}).ToList();
employeeViewModel.Roles = roles;
return(employeeViewModel);
}).ToList();
}
else
{
result.Message = "No records found";
}
search.SearchResult = employeeViewModels;
result.Body = search;
}
catch (Exception ex)
{
result.Status = Status.Error;
result.Message = ex.Message;
result.StatusCode = HttpStatusCode.InternalServerError;
}
return(result);
}
/// <summary>
/// Get All Locations.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <Location> GetAllLocations(SearchSortModel search)
{
var query = from location in Query
select location;
if (!string.IsNullOrEmpty(search.SearchString))
{
query = query.Where(t => t.LocationName.ToLower().Contains(search.SearchString));
}
query = Sort(query, search.SortColumn, search.SortDirection.ToString());
var data = Page(query, search.Page, search.PageSize).ToList();
return(data);
}
/// <summary>
/// Get All Partners.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <Partner> GetAllPartners(SearchSortModel search)
{
var query = from partner in Query
select partner;
if (!string.IsNullOrEmpty(search.SearchString))
{
query = query.Where(t => t.Name.ToLower().Contains(search.SearchString) ||
t.Email.ToLower().Contains(search.SearchString)
);
}
query = Sort(query, search.SortColumn, search.SortDirection.ToString());
var data = Page(query, search.Page, search.PageSize).ToList();
return(data);
}
/// <summary>
/// Get All Materials
/// </summary>
/// <returns></returns>
public IResult GetAllMaterials(SearchSortModel search)
{
if (string.IsNullOrEmpty(search.SortColumn))
{
search.SortColumn = Constants.CreatedDate;
}
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
List <MaterialViewModel> materialViewModels = new List <MaterialViewModel>();
var allMaterial = _materialRepository.GetAllMaterials(search);
if (allMaterial != null && allMaterial.Any())
{
materialViewModels = allMaterial.Select(t =>
{
var materialViewModel = new MaterialViewModel();
materialViewModel.MapFromModel(t);
if (t.TechnicalSpecifications == null || !t.TechnicalSpecifications.Any())
{
return(materialViewModel);
}
var techSpecs = new List <TechSpecsViewModel>();
materialViewModel.TechnicalSpecifications = techSpecs.MapFromModel <TechnicalSpecification, TechSpecsViewModel>(t.TechnicalSpecifications);
return(materialViewModel);
}).ToList();
search.SearchResult = materialViewModels;
}
else
{
search.SearchResult = materialViewModels;
result.Message = CommonErrorMessages.NoResultFound;
}
result.Body = search;
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IResult GetCovidDeclarations(SearchSortModel search)
{
var covidHealthViewModelList = new List <CovidHealthTrackViewModel>();
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success,
StatusCode = HttpStatusCode.OK
};
try
{
var declarationList = _healthTrackRepository.GetCovidDeclarations(search);
if (declarationList.Any())
{
covidHealthViewModelList = declarationList.Select(declaration =>
{
var healthViewModel = new CovidHealthTrackViewModel();
healthViewModel.MapFromModel(declaration);
var employeeVm = new EmployeeViewModel();
employeeVm.MapFromModel(declaration.Employee);
healthViewModel.Employee = employeeVm;
return(healthViewModel);
}).ToList();
search.SearchResult = covidHealthViewModelList;
result.Body = search;
}
else
{
result.Status = Status.Fail;
result.StatusCode = HttpStatusCode.NotFound;
result.Message = "No declaration exists";
}
}
catch (Exception ex)
{
_logger.LogError(ex, ex.Message);
result.Status = Status.Error;
result.Message = ex.Message;
result.StatusCode = HttpStatusCode.InternalServerError;
}
return(result);
}
public IResult GetStats()
{
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
var latestSearchModel = new SearchSortModel
{
SortColumn = Constants.CreatedDate,
SortDirection = SortDirection.Desc,
Page = 1,
PageSize = 5
};
result.Body = new Statistics
{
NumBoms = _billOfMaterialsManagerService.CountNumBillOfMaterial(),
NumBomsCompleted = _billOfMaterialsManagerService.CountBOMNumCompleted(),
NumBomsInProgress = _billOfMaterialsManagerService.CountBOMNumInProgress(),
NumEquipments = _equipmentManagerService.CountNumEquipments(),
NumEquipmentForPartner = _equipmentManagerService.CountNumEquipmentsPerPartner(),
NumEquipmentsWithDocumentation = _equipmentManagerService.CountNumEquipmentsWithDocument(),
NumRecentEquipments = _equipmentManagerService.CountNumEquipmentsAddedLastWeek(),
NumMaterials = _materialManagerService.CountNumMaterials(),
NumMaterialsWithDocumentation = _materialManagerService.CountNumMaterialsWithDocument(),
NumRecentMaterials = _materialManagerService.CountNumMaterialsAddedLastWeek(),
LastFiveRequests = _billOfMaterialsManagerService.GetSearchedBom(latestSearchModel, string.Empty)
};
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
/// <summary>
/// Get All Equipments.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <Equipment> GetAllEquipments(SearchSortModel search)
{
var query = from equipment in Query
select equipment;
if (!string.IsNullOrEmpty(search.SearchString))
{
query = query.Where(t => t.EquipmentNumber.ToLower().Contains(search.SearchString) ||
t.SerialNumber.ToLower().Contains(search.SearchString) ||
t.Owner.ToLower().Contains(search.SearchString) ||
t.License.ToLower().Contains(search.SearchString) ||
t.Location.ToLower().Contains(search.SearchString)
);
}
query = Sort(query, search.SortColumn, search.SortDirection.ToString());
var data = Page(query, search.Page, search.PageSize).ToList();
return(data);
}
/// <summary>
/// Get All Bom Templates.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IResult GetBomTemplates(SearchSortModel search)
{
if (string.IsNullOrEmpty(search.SortColumn))
{
search.SortColumn = Constants.CreatedDate;
}
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
var query = (from bomTemplate in _bomRepository.Query.Where(x => x.Type == BomType.Template)
join bom in _bomRepository.Query on bomTemplate.BomId equals bom.TemplateId.Value into boms
select new
{
bomTemplate,
boms
}).OrderByDescending(t => t.bomTemplate.ModifiedDate).ToList();
if (query != null && query.Any())
{
result.Body = query.Select(x => new BomTemplateViewModel
{
BomTemplateId = x.bomTemplate.BomId.ToString(),
BomTemplateName = x.bomTemplate.Name,
Count = x.boms.Count()
}).ToList();
}
else
{
result.Message = CommonErrorMessages.NoResultFound;
}
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public IResult GetRequestsList(SearchSortModel search)
{
var requestViewModels = new List <ComeToOfficeRequestViewModel>();
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success,
StatusCode = HttpStatusCode.OK
};
try
{
var requests = _requestRepository.GetRequestsList(search);
if (requests.Any())
{
requestViewModels = requests.Select(t =>
{
var requestViewModel = new ComeToOfficeRequestViewModel();
requestViewModel.MapFromModel(t);
var employeeVm = new EmployeeViewModel();
employeeVm.MapFromModel(t.Employee);
requestViewModel.Employee = employeeVm;
return(requestViewModel);
}).ToList();
}
else
{
result.Message = "No records found";
}
search.SearchResult = requestViewModels;
result.Body = search;
}
catch (Exception ex)
{
_logger.LogError(ex, ex.Message);
result.Status = Status.Error;
result.Message = ex.Message;
result.StatusCode = HttpStatusCode.InternalServerError;
}
return(result);
}
/// <summary>
/// Get All Requests.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <Request> GetAllRequests(SearchSortModel search)
{
var query = from request in Query
select request;
if (!string.IsNullOrEmpty(search.SearchString))
{
query = query.Where(t => t.Description.ToLower().Contains(search.SearchString) ||
t.RequestedBy.ToLower().Contains(search.SearchString) ||
t.Company.ToLower().Contains(search.SearchString) ||
t.PhoneNumber.ToLower().Contains(search.SearchString) ||
t.MailUsers.Any(x => x.Name.Contains(search.SearchString) || x.Email.Contains(search.SearchString))
);
// TODO : Search by file name
}
query = Sort(query, search.SortColumn, search.SortDirection.ToString());
var data = Page(query, search.Page, search.PageSize).ToList();
return(data);
}
/// <summary>
/// Get All Materials.
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <Material> GetAllMaterials(SearchSortModel search)
{
var query = from material in Query
select material;
if (!string.IsNullOrEmpty(search.SearchString))
{
query = query.Where(t => t.Materialnumber.ToLower().Contains(search.SearchString) ||
t.Description.ToLower().Contains(search.SearchString) ||
t.ManufactorPartNumber.ToLower().Contains(search.SearchString) ||
t.Type.ToLower().Contains(search.SearchString) ||
t.ManufactorName.ToLower().Contains(search.SearchString)
);
}
query = Sort(query, search.SortColumn, search.SortDirection.ToString());
var data = Page(query, search.Page, search.PageSize).ToList();
return(data);
}
/// <summary>
/// Get all Bill Of Materials.
/// </summary>
/// <param name="search"></param>
/// <param name="userId"></param>
/// <param name="bomType"></param>
/// <returns></returns>
public List <BillOfMaterial> GetAllBillOfMaterial(SearchSortModel search, string userId, BomType bomType = BomType.Bom)
{
var query = from bom in Query
where bom.Type == bomType
select bom;
if (!string.IsNullOrEmpty(search.SearchString))
{
query = query.Where(t => t.Name.ToLower().Contains(search.SearchString) ||
t.Description.ToLower().Contains(search.SearchString));
}
if (!string.IsNullOrEmpty(userId))
{
query = query.Where(t => t.CreatedBy.ToLower().Contains(userId.ToLower()));
}
query = Sort(query, search.SortColumn, search.SortDirection.ToString());
var data = Page(query, search.Page, search.PageSize).ToList();
return(data);
}
/// <summary>
/// Get list of bom's viewmodel for logged user
/// </summary>
/// <param name="search"></param>
/// <param name="userid"></param>
/// <returns></returns>
public List <BillOfMaterialViewModel> GetSearchedBom(SearchSortModel search, string userid)
{
var bomViewModels = new List <BillOfMaterialViewModel>();
var allBoms = _bomRepository.GetAllBillOfMaterial(search, userid);
if (allBoms.Any())
{
bomViewModels = allBoms.Select(t =>
{
var bomViewModel = new BillOfMaterialViewModel();
bomViewModel.MapFromModel(t);
bomViewModel.TemplateId = t.TemplateId.ToString();
if (t.BomUser == null)
{
return(bomViewModel);
}
var bomUserViewModel = new BomUserViewModel();
bomViewModel.BomUser = (BomUserViewModel)bomUserViewModel.MapFromModel(t.BomUser);
return(bomViewModel);
}).ToList();
}
return(bomViewModels);
}
/// <summary>
/// Get Bill Of Material For Particular User.
/// </summary>
/// <param name="search"></param>
/// <param name="userid"></param>
/// <returns></returns>
public IResult GetBillOfMaterialsForUser(SearchSortModel search, string userid)
{
if (string.IsNullOrEmpty(search.SortColumn))
{
search.SortColumn = Constants.CreatedDate;
}
var result = new Result
{
Operation = Operation.Read,
Status = Status.Success
};
try
{
if (!string.IsNullOrEmpty(userid))
{
var bomViewModels = GetSearchedBom(search, userid);
if (!bomViewModels.Any())
{
result.Message = CommonErrorMessages.NoResultFound;
}
search.SearchResult = bomViewModels;
result.Body = search;
}
else
{
result.Status = Status.Fail;
result.Message = CommonErrorMessages.NoIdentifierProvided;
}
}
catch (Exception e)
{
result.Message = e.Message;
result.Status = Status.Fail;
}
return(result);
}
public IResult Materials(SearchSortModel search)
{
var materialList = _materialManager.GetAllMaterials(search);
return(materialList);
}
public IResult BomTemplates(SearchSortModel search)
{
var bomTemplates = _billOfMaterialsManager.GetBomTemplates(search);
return(bomTemplates);
}
public IResult BillOfMaterialsForUser(SearchSortModel search, string userid)
{
var boms = _billOfMaterialsManager.GetBillOfMaterialsForUser(search, userid);
return(boms);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
//public async Task<List<Employee>> GetAllEmployees()
//{
// return await _context.Employee.Include(e => e.EmployeeRoles).ThenInclude(e => e.Role).ToListAsync();
//}
public List <Employee> GetAllEmployees(SearchSortModel search)
{
var query = _context.Employee.Include(e => e.EmployeeRoles).ThenInclude(e => e.Role).AsQueryable();
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "employeename")
{
query = query.Where(t => t.Name.ToLower().Contains(search.SearchString));
}
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "email")
{
query = query.Where(t => t.Email.ToLower().Contains(search.SearchString));
}
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "role")
{
query = query.Where(t => t.EmployeeRoles.Any(r => r.RoleId == Convert.ToInt32(search.SearchString)));
}
if (search.userId != 0 && search.roleId != 0)
{
if (search.roleId == 1)
{
query = query.Where(t => t.Id != search.userId && (
t.EmployeeRoles.Any(role => role.RoleId == 2 || role.RoleId == 3)));
}
if (search.roleId == 2)
{
query = query.Where(t => t.Id != search.userId && (
t.EmployeeRoles.Any(role => role.RoleId == 3)));
}
}
search.TotalRecords = query.Count();
switch (search.SortDirection.ToString().ToLower())
{
case "asc":
if (search.SortColumn.ToLower() == "employeecode")
{
query = query.OrderBy(dec => dec.EmployeeCode);
}
else if (search.SortColumn.ToLower() == "employeename")
{
query = query.OrderBy(dec => dec.Name);
}
else
{
query = query.OrderBy(dec => dec.EmployeeCode);
}
break;
default:
if (search.SortColumn.ToLower() == "employeecode")
{
query = query.OrderByDescending(dec => dec.EmployeeCode);
}
else if (search.SortColumn.ToLower() == "employeename")
{
query = query.OrderByDescending(dec => dec.Name);
}
else
{
query = query.OrderByDescending(dec => dec.EmployeeCode);
}
break;
}
query = PagingExtensions.Page(query, search.Page, search.PageSize);
var data = query
.Select(user => new Employee
{
Id = user.Id,
EmployeeCode = user.EmployeeCode,
CurrentResidentialAddress = user.CurrentResidentialAddress,
Email = user.Email,
Name = user.Name,
Password = user.Password,
PermanentResidentialAddress = user.PermanentResidentialAddress,
EmployeeRoles = user.EmployeeRoles,
Status = user.Status
})
.ToList();
return(data);
}
public IResult Equipments(SearchSortModel search)
{
var equipmentList = _equipmentManager.GetAllEquipments(search);
return(equipmentList);
}
/// <summary>
/// Get All Files.
/// </summary>
/// <param name="searchSortModel"></param>
/// <returns></returns>
public IResult GetFiles(SearchSortModel searchSortModel)
{
throw new NotImplementedException();
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <HealthTrack> GetAllDeclarations(SearchSortModel search)
{
var query = _context.HealthTrack.Include(s => s.HealthTrackSymptoms).ThenInclude(s => s.Symptom).Include(q => q.HealthTrackQuestions).ThenInclude(q => q.Question).Include("Location").Include("Zone").Include(x => x.Employee).ThenInclude(x => x.EmployeeRoles).AsQueryable();
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "employeename")
{
query = query.Where(t => t.Employee.Name.ToLower().Contains(search.SearchString));
}
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "employeeid")
{
query = query.Where(t => t.Id == Convert.ToInt32(search.SearchString));
}
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "date")
{
query = query.Where(t => t.CreatedDate == Convert.ToDateTime(search.SearchString));
}
if (search.userId != 0 && search.roleId != 0)
{
if (search.roleId == 1)
{
query = query.Where(t => t.EmployeeId != search.userId && (
t.Employee.EmployeeRoles.Any(role => role.RoleId == 2 || role.RoleId == 3)));
}
}
search.TotalRecords = query.Count();
switch (search.SortDirection.ToString().ToLower())
{
case "asc":
if (search.SortColumn == "id")
{
query = query.OrderBy(dec => dec.Id);
}
else if (search.SortColumn == "employeename")
{
query = query.OrderBy(dec => dec.Employee.Name);
}
else
{
query = query.OrderBy(dec => dec.CreatedDate);
}
break;
default:
if (search.SortColumn == "id")
{
query = query.OrderByDescending(dec => dec.Id);
}
else if (search.SortColumn == "employeename")
{
query = query.OrderByDescending(dec => dec.Employee.Name);
}
else
{
query = query.OrderByDescending(dec => dec.CreatedDate);
}
break;
}
var data = query
.Select(declaration => new HealthTrack
{
Id = declaration.Id,
ResidentialAddress = declaration.ResidentialAddress,
PreExistHealthIssue = declaration.PreExistHealthIssue,
ContactWithCovidPeople = declaration.ContactWithCovidPeople,
TravelOustSideInLast15Days = declaration.TravelOustSideInLast15Days,
RequestNumber = declaration.RequestNumber,
LocationId = declaration.LocationId,
CreatedDate = declaration.CreatedDate,
ZoneId = declaration.ZoneId,
EmployeeId = declaration.EmployeeId,
Employee = declaration.Employee,
HealthTrackQuestions = declaration.HealthTrackQuestions,
HealthTrackSymptoms = declaration.HealthTrackSymptoms
})
.ToList();
return(data);
}
/// <summary>
///
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <CovidHealthTrack> GetCovidDeclarations(SearchSortModel search)
{
var query = _context.CovidHealthTrack.Include(h => h.Employee).ThenInclude(e => e.EmployeeRoles).Include("Location");
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "employeename")
{
query = query.Where(t => t.Employee.Name.ToLower().Contains(search.SearchString));
}
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "employeeid")
{
query = query.Where(t => t.Employee.EmployeeCode == Convert.ToInt32(search.SearchString));
}
if (!string.IsNullOrEmpty(search.SearchString) && search.PropertyName.ToLower() == "date")
{
query = query.Where(t => t.CreatedDate.Date == Convert.ToDateTime(search.SearchString).Date);
}
if (search.userId != 0 && search.roleId != 0)
{
if (search.roleId == 1)
{
query = query.Where(t => t.EmployeeId != search.userId && (
t.Employee.EmployeeRoles.Any(role => role.RoleId == 2 || role.RoleId == 3)));
}
}
search.TotalRecords = query.Count();
switch (search.SortDirection.ToString().ToLower())
{
case "asc":
if (search.SortColumn == "id")
{
query = query.OrderBy(dec => dec.Id);
}
else if (search.SortColumn == "employeename")
{
query = query.OrderBy(dec => dec.Employee.Name);
}
else
{
query = query.OrderBy(dec => dec.CreatedDate);
}
break;
default:
if (search.SortColumn == "id")
{
query = query.OrderByDescending(dec => dec.Id);
}
else if (search.SortColumn == "employeename")
{
query = query.OrderByDescending(dec => dec.Employee.Name);
}
else
{
query = query.OrderByDescending(dec => dec.CreatedDate);
}
break;
}
query = PagingExtensions.Page(query, search.Page, search.PageSize);
var data = query
.Select(declaration => new CovidHealthTrack
{
Id = declaration.Id,
CovidConfirmationDate = declaration.CovidConfirmationDate,
DateOfSymptoms = declaration.DateOfSymptoms,
FamilyMembersCount = declaration.FamilyMembersCount,
HospitalizationNeed = declaration.HospitalizationNeed,
OfficeLastDay = declaration.OfficeLastDay,
OthersInfectedInFamily = declaration.OthersInfectedInFamily,
Status = declaration.Status,
LocationId = declaration.LocationId,
CreatedDate = declaration.CreatedDate,
EmployeeId = declaration.EmployeeId,
Employee = declaration.Employee
})
.ToList();
return(data);
}
