private void button3_Click(object sender, EventArgs e)
{
UpdatePerson up = new UpdatePerson();
this.Hide();
up.Show();
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void button1_Click(object sender, EventArgs e)
{
try
{
//If The Function Return True
if (CU())
{
MessageBox.Show("This person can not be deleted because this uniquename exist in DeletedPersonDataBase, please change the uniquename");
this.Hide();
UpdatePerson up = new UpdatePerson();
up.Show();
}
else
{
//Using The Function For Deleting A Person From DataBase
deletePerson();
///////////////
//This logic is used to refresh the page
//Because after person is deleted its name remains in combobox
this.Hide();
MainPage mp = new MainPage();
mp.Show();
mp.Hide();
DeletePerson dp = new DeletePerson();
dp.Show();
}
con.Close();
}
catch
{
MessageBox.Show("Select one person");
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void button1_Click(object sender, EventArgs e)
{
try
{
//Variable declaration
string uniquename, date;
double eu, fr, den;
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from Person_Table where Uniquename='" + comboBox1.SelectedItem.ToString() + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
uniquename = dr["uniquename"].ToString();
eu = int.Parse(dr["eu"].ToString());
fr = int.Parse(dr["fr"].ToString());
den = int.Parse(dr["den"].ToString());
date = dr["date"].ToString();
//UPDATE UNIQUENAME
//If Unique Name Exist Then The Person Can Not Be Saved
if (CU())
{
MessageBox.Show("This person already exist / write another uniquename");
break;
}
else if (textBox11.Text == "")
{
SqlCommand u = con.CreateCommand();
u.CommandText = "update Person_Table set uniquename='" + textBox10.Text + "' where Uniquename='" + uniquename + "'";
u.ExecuteNonQuery();
}
else
{
SqlCommand u = con.CreateCommand();
u.CommandText = "update Person_Table set uniquename='" + textBox11.Text + "' where Uniquename='" + uniquename + "'";
u.ExecuteNonQuery();
}
///////////////////////////////////////////////////////////////////////////////////////////////
//UPDATE NAME
SqlCommand n = con.CreateCommand();
n.CommandText = "update Person_Table set name='" + textBox7.Text + "' where Uniquename='" + uniquename + "'";
n.ExecuteNonQuery();
//UPDATE SURNAME
SqlCommand s = con.CreateCommand();
s.CommandText = "update Person_Table set surname='" + textBox8.Text + "' where Uniquename='" + uniquename + "'";
s.ExecuteNonQuery();
//UPDATE ADDRESS
SqlCommand a = con.CreateCommand();
a.CommandText = "update Person_Table set address='" + textBox9.Text + "' where Uniquename='" + uniquename + "'";
a.ExecuteNonQuery();
//UPDATE EU
///////////////////////////////////////////////////////
if (textBox1.Text != "")
{
eu = eu + int.Parse(textBox1.Text);
}
if (textBox4.Text != "")
{
eu = eu - int.Parse(textBox4.Text);
}
SqlCommand EU = con.CreateCommand();
EU.CommandText = "update Person_Table set eu='" + eu + "' where Uniquename='" + uniquename + "'";
EU.ExecuteNonQuery();
///////////////////////////////////////////////////////
//UPDATE FR
///////////////////////////////////////////////////////
if (textBox2.Text != "")
{
fr = fr + int.Parse(textBox2.Text);
}
if (textBox5.Text != "")
{
fr = fr - int.Parse(textBox5.Text);
}
SqlCommand FR = con.CreateCommand();
FR.CommandText = "update Person_Table set fr='" + fr + "' where Uniquename='" + uniquename + "'";
FR.ExecuteNonQuery();
///////////////////////////////////////////////////////
//UPDATE DEN
///////////////////////////////////////////////////////
if (textBox3.Text != "")
{
den = den + int.Parse(textBox3.Text);
}
if (textBox6.Text != "")
{
den = den - int.Parse(textBox6.Text);
}
SqlCommand DEN = con.CreateCommand();
DEN.CommandText = "update Person_Table set den='" + den + "' where Uniquename='" + uniquename + "'";
DEN.ExecuteNonQuery();
///////////////////////////////////////////////////////
MessageBox.Show("updated");
}
//connection close
con.Close();
//Refresh the page
this.Hide();
MainPage mp = new MainPage();
mp.Show();
mp.Hide();
UpdatePerson up = new UpdatePerson();
up.Show();
}
catch
{
MessageBox.Show("Please select a person");
}
}