private void buttonMaid_Click(object sender, EventArgs e) { ServiceProviderProfile serviceProviderProfile = new ServiceProviderProfile(spUserName); this.Hide(); serviceProviderProfile.Show(); }
private void buttonMaid_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBconnection"].ConnectionString); connection.Open(); string sql1 = "SELECT *FROM userpermissions WHERE userName= '******'AND Block='" + "yes" + "'"; SqlCommand command = new SqlCommand(sql1, connection); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { MessageBox.Show("You cannot do this Operation. Please Contact Support Center. "); connection.Close(); } else { ServiceProviderProfile serviceProviderProfile = new ServiceProviderProfile(spUserName); this.Hide(); serviceProviderProfile.Show(); connection.Close(); } }