public async Task <IList <Role> > GetAllRolesFor(int idLocalAccount)
{
DbParameter[] parameters = new InputDbParameter[] { new InputDbParameter("IdLocalAccountParam", MySqlDbType.Int32, idLocalAccount) };
var list = await new GetRolesWithIdLocalAccountDbStoredProcedure(parameters).ExecuteCommand() as List <Role>;
return(list ?? new List <Role>());
}
public async Task<string> GetTitlesName(int idDoctor, int idMedicalTitle)
{
InputDbParameter inParam1 = new InputDbParameter("IdMedicalTitleParam", MySqlDbType.Int32, idMedicalTitle);
DbStoredProcedure storedProcedure = new GetTitlesNameDbStoredProcedure(new InputDbParameter[] { inParam1 });
return (string)(await storedProcedure.ExecuteCommand());
}
public async Task <string> GetClinicsName(int idClinic)
{
InputDbParameter inParam = new InputDbParameter("IdClinicParam", MySqlDbType.Int32, idClinic);
DbStoredProcedure storedProcedure = new GetClinicsNameDbStoredProcedure(new InputDbParameter[] { inParam });
return((string)(await storedProcedure.ExecuteCommand()));
}
public async Task <List <LocalAccount> > GetAllWithRoleNames()
{
DbParameter[] parameters = new InputDbParameter[] { };
return(await new GetActiveLocalAccountsDbStoredProcedure(parameters).ExecuteCommand() as List <LocalAccount>);
}