public bool IsInRoleAsync(TUser user, string roleId)
{
string query = $"SELECT COUNT(*) FROM {UserRoles.TableName} WHERE {UserRoles.UserId.Name} = @UserId AND {UserRoles.RoleId.Name} = @RoleId";
List <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", user.Id),
new MySqlParameter("@RoleId", roleId)
};
object result = db.GetScalar(query, parameters);
return(int.Parse(result.ToString()) > 0);
}
public bool IsExistIdentityNumber(string identityNumber, int studentId)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@identity_number", identityNumber),
new MySqlParameter("@id", studentId)
};
string sql = $"SELECT {Tables.Students.TableName}.* FROM {Tables.Students.TableName}" +
$" WHERE {Tables.Students.IdentityNumber.Name}=@identity_number AND {Tables.Students.Id.Name}!=@id";
return(_dbContext.GetScalar(sql, parameters) != null);
}