public async Task <List <string> > GetUserRoles(int userId)
{
List <string> userRoles = new List <string>();
try
{
using (SqlConnection con = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand(UserRolesQueries.SelectUserRoleByUserId(), con);
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
await con.OpenAsync();
SqlDataReader reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
string role = reader["RoleName"].ToString();
userRoles.Add(role);
}
}
}
catch (Exception ex)
{
this.logger.LogError(ex.Message);
throw ex;
}
return(userRoles);
}
public async Task <bool> AddUserRole(int userId, string role)
{
var isAddedUserRole = false;
try
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
using (SqlCommand cmd = new SqlCommand(UserRolesQueries.InsertUserRole(), cn))
{
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
cmd.Parameters.Add("@RoleName", SqlDbType.VarChar, 50).Value = role;
await cn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
cn.Close();
}
isAddedUserRole = true;
}
catch (Exception ex)
{
this.logger.LogError(ex.Message);
throw ex;
}
return(isAddedUserRole);
}
