//
// GET: /Employees/List?terms=Mar
public JsonNetResult List(EmployeeSearchParameters searchParameters)
{
var query = new SearchEmployees(searchParameters);
var results = Query(query);
return(Json(new
{
Items = results,
Skipped = searchParameters.Skip,
TotalResults = query.Stats.TotalResults
}));
}
public async Task <ActionResult <IEnumerable <EmployeeDto> > > SearchAsync([FromQuery] SearchEmployees query)
{
var result = await _queryDispatcher
.DispatchAsync <SearchEmployees, IEnumerable <EmployeeDto> >(query);
if (result is null || !result.Any())
{
return(NotFound());
}
return(Ok(result));
}
public async Task <IEnumerable <EmployeeDto> > HandleAsync(SearchEmployees query)
{
var entities = await _repository.SearchAsync(e => !query.Position.HasValue || e.Position == query.Position);
if (query.YearOfBirth != null)
{
entities = entities.Where(e => e.YearOfBirth <= query.YearOfBirth);
}
entities = entities.Where(d =>
string.IsNullOrEmpty(query.Name) || d.Name.ToLower().StartsWith(query.Name.ToLower()));
return(entities.AsDtos());
}
public IHttpActionResult getEmployeeDetails([FromBody] SearchEmployees searchemployees)
{
Console.WriteLine(searchemployees.firstname);
string sSQL = "select EmployeeSSN, FirstName, LastName from [ACA].[xferEmployee] ";
string sConditionOne = "";
string sConditionTwo = "";
if (searchemployees.firstname.Trim() == "")
{
}
else
{
sConditionOne = " FirstName LIKE '%" + searchemployees.firstname.ToUpper() + "%'";
}
if (searchemployees.lastname.Trim() == "")
{
}
else
{
sConditionTwo = " LastName LIKE '%" + searchemployees.lastname.ToUpper() + "%'";
}
if (sConditionOne == "" && sConditionTwo == "")
{
sSQL = sSQL + " TOP [100]";
}
if (sConditionOne == "" && sConditionTwo != "")
{
sSQL = sSQL + " WHERE " + sConditionTwo;
}
if (sConditionOne != "" && sConditionTwo == "")
{
sSQL = sSQL + " WHERE " + sConditionOne;
}
if (sConditionOne != "" && sConditionTwo != "")
{
sSQL = sSQL + " WHERE " + sConditionOne + " AND " + sConditionTwo;
}
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteForSelect(sSQL);
var json = JsonConvert.SerializeObject(result);
var listData = JsonConvert.DeserializeObject <List <EmployeeSearchResults> >(json);
return(Ok(listData));
}
//
// GET: /Employees/List?terms=Mar
public JsonNetResult List(EmployeeSearchParameters searchParameters)
{
var query = new SearchEmployees(searchParameters);
var results = Query(query);
return Json(new
{
Items = results,
Skipped = searchParameters.Skip,
TotalResults = query.Stats.TotalResults
});
}
