public async Task <IEnumerable <User> > GetAllUsersAsync()
{
const string sql = "SELECT user_id, name, surname, position_id, role_id FROM users";
var res = await _mySqlRepository.SelectItemsAsync <User>(sql);
return(res);
}
public async Task <IEnumerable <Client> > GetAllClientsAsync()
{
const string sql = "SELECT client_id, client_name, client_middleName, client_surname, client_address, client_phoneNumber FROM clients";
var res = await _mySqlRepository.SelectItemsAsync <Client>(sql);
return(res);
}