cmd.CommandText = "CreateRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } } public override bool DeleteRole(string roleName, bool throwOnPopulatedRole) { bool tulemus = false; if (HttpContext.Current.User.IsInRole("ADMINISTRATORS")) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Connection.Open(); if (throwOnPopulatedRole)
cmd.CommandText = "CreateRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionString); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } } public override bool DeleteRole(string roleName, bool throwOnPopulatedRole) { bool tulemus = false; if (HttpContext.Current.User.IsInRole("ADMINISTRATORS")) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionString); cmd.Parameters.AddWithValue("@RoleName", roleName); cmd.Connection.Open(); if (throwOnPopulatedRole)
annaabi.ee 
