private void button2_Click(object sender, EventArgs e)
{
if (name_.Enabled != true)
{
name_.Enabled = true;
gender.Enabled = true;
contactno.Enabled = true;
dateofbirth.Enabled = true;
comboBox1BG.Enabled = true;
CNIC.Enabled = true;
}
else if (name_.Enabled == true)
{
name_.Enabled = false;
gender.Enabled = false;
contactno.Enabled = false;
dateofbirth.Enabled = false;
comboBox1BG.Enabled = false;
CNIC.Enabled = false;
if (name_.Text == String.Empty | userID.Text == String.Empty | contactno.Text == String.Empty | dateofbirth.Text == String.Empty | gender.Text == String.Empty | comboBox1BG.Text == String.Empty | CNIC.Text == String.Empty)
{
MessageBox.Show("Fill All Fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
if (name_.Text != String.Empty && userID.Text != String.Empty && contactno.Text != String.Empty && dateofbirth.Text != String.Empty && gender.Text != String.Empty && comboBox1BG.Text != String.Empty && CNIC.Text != String.Empty)
{
try
{
signup data = new signup(name_.Text, userID.Text, "", gender.Text, contactno.Text, dateofbirth.Text);
SqlCommand scmd = new SqlCommand("update Employee set E_name='" + data.name + "',E_username='******',Gender='" + data.gender + "',contactNo='" + data.contactNo + "',Blood_Group='" + comboBox1BG.Text + "',DOB='" + data.DOB + "',CNIC='" + CNIC.Text + "' where E_id='" + int.Parse(textBoxID.Text) + "'", database.con);
database.con.Open();
int o = scmd.ExecuteNonQuery();
MessageBox.Show("Account Updated", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
database.con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
database.con.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
database.con.Close();
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (userID.Text.Contains(" ") || userPASS.Text.Contains(" "))
{
errorProvider1.SetError(userID, "No spaces");
errorProvider1.SetError(userPASS, "No spaces");
}
else
{
errorProvider1.Clear();
if (name_.Text == String.Empty | userID.Text == String.Empty | userPASS.Text == String.Empty | contactno.Text == String.Empty | dateofbirth.Text == String.Empty | gender.Text == String.Empty | comboBox1BG.Text == String.Empty | CNIC.Text == String.Empty | type_.Text == String.Empty)
{
MessageBox.Show("Fill All Fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
if (name_.Text != String.Empty && userID.Text != String.Empty && userPASS.Text != String.Empty && contactno.Text != String.Empty && dateofbirth.Text != String.Empty && gender.Text != String.Empty && comboBox1BG.Text != String.Empty && CNIC.Text != String.Empty && type_.Text != String.Empty)
{
try
{
signup data = new signup(name_.Text, userID.Text, userPASS.Text, gender.Text, contactno.Text, dateofbirth.Text);
SqlCommand scmd = new SqlCommand("update Employee set E_name='" + data.name + "',E_username='******',E_password='******',Gender='" + data.gender + "',contactNo='" + data.contactNo + "',Blood_Group='" + comboBox1BG.Text + "',DOB='" + data.DOB + "',CNIC='" + CNIC.Text + "',Type='" + type_.Text + "' where E_id='" + listBox1.SelectedItem + "'", database.con);
database.con.Open();
int o = scmd.ExecuteNonQuery();
MessageBox.Show("Account Updated", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
database.con.Close();
name_.Text = "";
userID.Text = "";
userPASS.Text = "";
gender.Text = "";
contactno.Text = "";
dateofbirth.Text = "";
comboBox1BG.Text = "";
CNIC.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
database.con.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
database.con.Close(); listboxdata();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (userID.Text.Contains(" ") || userPASS.Text.Contains(" "))
{
errorProvider1.SetError(userID, "No spaces");
errorProvider1.SetError(userPASS, "No spaces");
}
else
{
if (name_.Text == String.Empty | userID.Text == String.Empty | userPASS.Text == String.Empty | contactno.Text == String.Empty | dateofbirth.Text == String.Empty | gender.Text == String.Empty | comboBox1BG.Text == String.Empty | CNIC.Text == String.Empty | type_.Text == String.Empty)
{
MessageBox.Show("Fill All Fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
if (name_.Text != String.Empty && userID.Text != String.Empty && userPASS.Text != String.Empty && contactno.Text != String.Empty && dateofbirth.Text != String.Empty && gender.Text != String.Empty && comboBox1BG.Text != String.Empty && CNIC.Text != String.Empty && type_.Text != String.Empty)
{
database.con.Open();
SqlDataAdapter sda = new SqlDataAdapter("Select * From Employee where E_Username ='******'", database.con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
MessageBox.Show("Username Already Taken", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
database.con.Close();
}
else
{
try
{
signup data = new signup(name_.Text, userID.Text, userPASS.Text, gender.Text, contactno.Text, dateofbirth.Text);
SqlCommand scmd = new SqlCommand("insert into Employee values('" + data.name + "','" + data.username + "','" + data.password + "','" + data.gender + "','" + data.contactNo + "','" + comboBox1BG.Text + "','" + data.DOB + "','" + CNIC.Text + "','" + type_.Text + "')", database.con);
int o = scmd.ExecuteNonQuery();
MessageBox.Show("Sign Up Process Complete", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
database.con.Close();
name_.Text = "";
userID.Text = "";
userPASS.Text = "";
gender.Text = "";
contactno.Text = "";
dateofbirth.Text = "";
comboBox1BG.Text = "";
CNIC.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
database.con.Close();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
database.con.Close(); listboxdata();
}
}
}