public IList <Model.Client> GetAll(ClientSearchRequest request)
{
var query = _context.Client.Where(x => x.Inactive == false).AsQueryable();
if (!string.IsNullOrWhiteSpace(request?.AppUserId))
{
query = query.Where(x => x.AppUserId == request.AppUserId);
}
if (!string.IsNullOrWhiteSpace(request?.FirstName))
{
query = query.Where(x => x.FirstName.StartsWith(request.FirstName));
}
if (!string.IsNullOrWhiteSpace(request?.LastName))
{
query = query.Where(x => x.LastName.StartsWith(request.LastName));
}
if (!string.IsNullOrWhiteSpace(request?.CompanyName))
{
query = query.Where(x => x.CompanyName.StartsWith(request.CompanyName));
}
var list = query.ToList();
return(_mapper.Map <IList <Model.Client> >(list));
}
private async Task LoadClients(int countryId = 0)
{
var personList = await _personService.Get <List <PersonModel> >(null);
var loginDataList = await _loginDataService.Get <List <LoginDataModel> >(null);
var countriesList = await _countryService.Get <List <CountryModel> >(null);
if (countryId != 0)
{
var request = new ClientSearchRequest
{
CountryId = countryId
};
var clientsList = await _clientService.Get <List <ClientModel> >(request);
var result = GenerateResult(clientsList, personList, loginDataList, countriesList);
dgvClients.AutoGenerateColumns = false;
dgvClients.DataSource = result;
}
else
{
var clientsList = await _clientService.Get <List <ClientModel> >(null);
var result = GenerateResult(clientsList, personList, loginDataList, countriesList);
dgvClients.AutoGenerateColumns = false;
dgvClients.DataSource = result;
}
}
public async Task <IEnumerable <SearchedClientEntity> > SearchClient(ClientSearchRequest request)
{
using (SqlConnection dbConn = (SqlConnection)_db.Database.GetDbConnection())
{
ClientSearchArgs args = new ClientSearchArgs(request.Page, request.PageSize);
args.FirstName = request.FirstName;
args.LastName = request.LastName;
if (request.Sex.HasValue)
{
args.SexId = (byte)request.Sex.Value;
}
args.PersonalNumber = request.PersonalNumber;
args.BirthDate = request.BirthDate;
args.BirthCity = request.City;
args.PhoneNumber = request.PhoneNumber;
return(await dbConn.ProcedureReader <SearchedClientEntity, ClientSearchArgs>("uspClientSearch", args));
}
}
public async Task <SearchClientResponse> SearchClient(ClientSearchRequest request)
{
System.Collections.Generic.IEnumerable <Domain.Models.DbEntities.SearchedClientEntity> dbEntity = await _repository.SearchClient(request);
return(new SearchClientResponse
{
Clients = dbEntity.Select(a =>
new SearchedClient
{
Id = a.Id,
FirstName = a.FirstName,
LastName = a.LastName,
BirthDate = a.BirthDate,
City = a.BirthCity,
PersonalNumber = a.PersonalNumber,
Sex = (Sex)a.SexId
})
});
}
async Task Login()
{
IsBusy = true;
//Set api username and password to user inputs
APIService.Username = Username;
APIService.Password = Password;
try
{
ClientSearchRequest request = new ClientSearchRequest
{
Username = Username
};
var obj = await _service.Get <List <ClientModel> >(request);
if (obj == null)
{
await Application.Current.MainPage.DisplayAlert("Error", "Invalid username or password!", "OK");
}
else
{
//Since we're using get method which returns a list of items, we're going to loop through the list, even though only one
// client will be returned inside a list. Then we'll set his ClientId to APIService.LoggedUserId so we can exploit logged user benefits
// throughout the app
for (int i = 0; i < obj.Count; i++)
{
APIService.LoggedUserId = obj[i].ClientId;
}
Application.Current.MainPage = new VehicleOfferView();
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
finally
{
IsBusy = false;
}
}
public IList <Model.Client> GetAll([FromQuery] ClientSearchRequest request)
{
return(_service.GetAll(request));
}
public async Task <IActionResult> ClientSearch(ClientSearchRequest request)
{
return(Ok(await _clientService.SearchClient(request)));
}
