{ cmd.Parameters["@RoleName"].Value = role; cmd.ExecuteNonQuery(); } } cmd.Connection.Close(); } public override string ApplicationName { get { return "Tallinna Täiskasvanute Gümnaasiumi testimiskeskus"; } set { throw new Exception("The method or operation is not implemented."); } } public override bool IsUserInRole(string username, string roleName) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "IsUserInRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Parameters.AddWithValue("@UserName", username); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Parameters.Add("@OK", SqlDbType.Bit)
foreach (string role in roleNames) { cmd.Parameters["@RoleName"].Value = role; cmd.ExecuteNonQuery(); } } cmd.Connection.Close(); } public override string ApplicationName { get { return "Tallinna Täiskasvanute Gümnaasiumi testimiskeskus"; } set { throw new Exception("The method or operation is not implemented."); } } public override bool IsUserInRole(string username, string roleName) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "IsUserInRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionString); cmd.Parameters.AddWithValue("@UserName", username); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Parameters.Add("@OK", SqlDbType.Bit)
annaabi.ee 
