ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Parameters.AddWithValue("@UserName", username); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Parameters.Add("@OK", SqlDbType.Bit).Direction = ParameterDirection.Output; cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); return Convert.ToBoolean(cmd.Parameters["@OK"].Value); } public override string[] GetRolesForUser(string username) { string[] rollid = new string[1] { "ADMINISTRATORS" }; return rollid; } public override void CreateRole(string roleName) { if (HttpContext.Current.User.IsInRole("ADMINISTRATORS")) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "CreateRole_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).Direction = ParameterDirection.Output; cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); return Convert.ToBoolean(cmd.Parameters["@OK"].Value); } public override string[] GetRolesForUser(string username) { string[] rollid = new string[1] { "ADMINISTRATORS" }; return rollid; } public override void CreateRole(string roleName) { if (HttpContext.Current.User.IsInRole("ADMINISTRATORS")) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "CreateRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager
annaabi.ee 
