private void button1_Click(object sender, EventArgs e)
{
DashboardforAdmin dashboardforAdmin = new DashboardforAdmin();
this.Hide();
DialogResult d;
d = MessageBox.Show("Do you want to Go Back?", "", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (d == DialogResult.Yes)
{
dashboardforAdmin.Show();
}
else if (d == DialogResult.No)
{
this.Show();
}
else
{
Close();
}
}
private void LoginButton_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
connection.Open();
string sql = "SELECT *FROM userpermissions WHERE userName='******'";
SqlCommand command = new SqlCommand(sql, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
string Permission = Convert.ToString(reader["uniqueCode"]);
string passwordtext = Convert.ToString(reader["password"]);
if (passwordtext == Convert.ToString(textBoxPassword.Text))
{
username = Convert.ToString(textBoxUsername.Text);
if (Permission == "ST")
{
Dashboard dashboard = new Dashboard();
this.Hide();
dashboard.Show();
}
else if (Permission == "GU")
{
AddServiceProviderDetails addServiceProviderDetails = new AddServiceProviderDetails(textBoxUsername.Text);
this.Hide();
addServiceProviderDetails.Show();
}
else
{
DashboardforAdmin dfa = new DashboardforAdmin();
this.Hide();
dfa.Show();
}
}
else
{
MessageBox.Show("Wrong Username or Password...!!");
connection.Close();
}
}
else
{
MessageBox.Show("Wrong Username or Password...!!");
connection.Close();
}
}
private void Registerformbutton_Click(object sender, EventArgs e)
{
SqlConnection connection11 = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
connection11.Open();
string sql = "SELECT *FROM Registrations WHERE userName='******'";
SqlCommand command11 = new SqlCommand(sql, connection11);
SqlDataReader reader = command11.ExecuteReader();
if (reader.Read())
{
MessageBox.Show("This Username Already Used by Another Person....Give Another User Name....!!");
Registration rr = new Registration();
this.Hide();
rr.Show();
connection11.Close();
}
else
{
connection11.Close();
if (AgreeregistercheckBox.Text == "")
{
MessageBox.Show("agree can not be empty");
}
else if (NameregistertextBox.Text == "")
{
MessageBox.Show("Name can not be empty");
}
else if (UsernameregistertextBox.Text == "")
{
MessageBox.Show("User Name can not be empty");
}
else if (PasswordregistertextBox.Text == "")
{
MessageBox.Show("Password can not be empty");
}
else if (ConfirmpasswordregistertextBox.Text == "")
{
MessageBox.Show("Confrim Password can not be empty");
}
else if (EmailregistertextBox.Text == " ")
{
MessageBox.Show("Email can not be empty");
}
else if (DateofbirthregisterdateTimePicker.Text == "")
{
MessageBox.Show("Date of Birth can not be empty");
}
else if (MaleregisterradioButton.Text == "" && FemaleregisterradioButton.Text == "")
{
MessageBox.Show("Gender can not be empty");
}
else if (CityregistercomboBox.Text == "")
{
MessageBox.Show("Blood Group can not be empty");
}
else if (NidregistertextBox.Text == "")
{
MessageBox.Show("Blood Group can not be empty");
}
else if (MobilenumberregistertextBox.Text == "")
{
MessageBox.Show("Blood Group can not be empty");
}
else if (DivisionregistercomboBox.Text == "")
{
MessageBox.Show("Blood Group can not be empty");
}
else if (AddressregistertextBox.Text == "")
{
MessageBox.Show("Blood Group can not be empty");
}
else if (CategoryregistercomboBox.Text == "")
{
MessageBox.Show("Blood Group can not be empty");
}
else
{
SqlConnection connect = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
connect.Open();
string Gender = "";
if (MaleregisterradioButton.Checked)
{
Gender = "Male";
}
else
{
Gender = "Female";
}
string sql1 = "INSERT INTO Registrations(userName, emailId, password, category, Address, City, Division, bloodGroup, mobileNumber, NID, fullName, dateofbirth, gender, Profession) VALUES ('" + UsernameregistertextBox.Text + "','" + EmailregistertextBox.Text + "', '" + PasswordregistertextBox.Text + "','" + CategoryregistercomboBox.Text + "','" + AddressregistertextBox.Text + "','" + CityregistercomboBox.Text + "','" + DivisionregistercomboBox.Text + "','" + BloodgroupregistercomboBox.Text + "','" + MobilenumberregistertextBox.Text + "','" + NidregistertextBox.Text + "','" + NameregistertextBox.Text + "','" + DateofbirthregisterdateTimePicker.Text + "','" + Gender + "','" + ProfessionregistercomboBox.Text + "')";
string ab = "";
if (CategoryregistercomboBox.Text == "Service Giver")
{
ab = "GU";
}
else if (CategoryregistercomboBox.Text == "Service Taker")
{
ab = "ST";
}
else
{
ab = "AD";
}
SqlCommand command1 = new SqlCommand(sql1, connect);
int result = command1.ExecuteNonQuery();
if (result > 0)
{
string sql2 = "INSERT INTO userpermissions (userName, uniqueCode, password, Designation) VALUES('" + UsernameregistertextBox.Text + "','" + ab + "', '" + PasswordregistertextBox.Text + "','" + comboBoxDesig.Text + "')";
SqlCommand command2 = new SqlCommand(sql2, connect);
int result3 = command2.ExecuteNonQuery();
MessageBox.Show("Registration Sucessful....Please Login");
DashboardforAdmin login = new DashboardforAdmin();
this.Hide();
login.Show();
connect.Close();
}
else
{
MessageBox.Show("Error");
connect.Close();
}
connect.Close();
}
}
}
