private void button3_Click(object sender, EventArgs e)
{
SqlConnection Connection = new SqlConnection(Con.ConnectionString());
SqlCommand DEL = new SqlCommand("DELETE FROM Suppliers WHERE Company=@Company", Connection);
DEL.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
try
{
Connection.Open();
int s = DEL.ExecuteNonQuery();
Connection.Close();
if (s == 1)
{
toolStripStatusLabel1.Text = "Successfully Deleted";
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPMobile.Text = "";
TPResidential.Text = "";
Fax.Text = "";
Email.Text = "";
Web.Text = "";
Comapny.Focus();
}
}
catch
{
}
}
private void button2_Click(object sender, EventArgs e)
{
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPResidential.Text = "";
TPMobile.Text = "";
Fax.Text = "";
Web.Text = "";
Email.Text = "";
toolStripStatusLabel1.Text = "Cleared";
Comapny.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
if (Comapny.Text.ToString().Trim(' ') == "")
{
toolStripStatusLabel1.Text = "Please ENter Company Name";
Comapny.Text = "";
Comapny.Focus();
}
else if (Names.Text.ToString().Trim(' ') == "")
{
toolStripStatusLabel1.Text = "Please Enter Name";
Names.Text = "";
Names.Focus();
}
else
{
SqlConnection Connection = new SqlConnection(Con.ConnectionString());
try
{
if (button1.Text.ToString() == "Save")
{
SqlCommand INSERT = new SqlCommand("INSERT INTO Suppliers VALUES(@Names,@Company,@OfficeAddress,@ResidentialAddress,@TPOffice,@TPResidential,@TPMobile,@Fax,@Email,@Web)", Connection);
INSERT.Parameters.AddWithValue("@Names", Names.Text.ToString());
INSERT.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
INSERT.Parameters.AddWithValue("@OfficeAddress", Residential.Text.ToString());
INSERT.Parameters.AddWithValue("@ResidentialAddress", Residential.Text.ToString());
INSERT.Parameters.AddWithValue("@TPOffice", TPOffice.Text.ToString());
INSERT.Parameters.AddWithValue("@TPResidential", TPResidential.Text.ToString());
INSERT.Parameters.AddWithValue("@TPMobile", TPMobile.Text.ToString());
INSERT.Parameters.AddWithValue("@Fax", Fax.Text.ToString());
INSERT.Parameters.AddWithValue("@Email", Email.Text.ToString());
INSERT.Parameters.AddWithValue("@Web", Web.Text.ToString());
Connection.Open();
int a = INSERT.ExecuteNonQuery();
Connection.Close();
if (a == 1)
{
toolStripStatusLabel1.Text = "Successfully Saved";
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPMobile.Text = "";
TPResidential.Text = "";
Fax.Text = "";
Email.Text = "";
Web.Text = "";
}
else
{
toolStripStatusLabel1.Text = "Error Data Not Saved";
}
}
else
{
SqlCommand UPDATENAME = new SqlCommand("UPDATE Suppliers SET Names=@Names WHERE Company=@Company", Connection);
UPDATENAME.Parameters.AddWithValue("@Names", Names.Text.ToString());
UPDATENAME.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand ADD1 = new SqlCommand("UPDATE Suppliers SET OfficeAddress=@OfficeAddress WHERE Company=@Company", Connection);
ADD1.Parameters.AddWithValue("@OfficeAddress", Official.Text.ToString());
ADD1.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand Add2 = new SqlCommand("UPDATE Suppliers SET ResidentialAddress=@ResidentialAddress WHERE Company=@Company", Connection);
Add2.Parameters.AddWithValue("@ResidentialAddress", Residential.Text.ToString());
Add2.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPDATETPOFF = new SqlCommand("UPDATE Suppliers SET TPOffice=@TPOffice WHERE Company=@Company", Connection);
UPDATETPOFF.Parameters.AddWithValue("@TPOffice", TPOffice.Text.ToString());
UPDATETPOFF.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPTPRES = new SqlCommand("UPDATE Suppliers SET TPResidential=@TPResidential WHERE Company=@Company", Connection);
UPTPRES.Parameters.AddWithValue("@TPResidential", TPResidential.Text.ToString());
UPTPRES.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPTPMOB = new SqlCommand("UPDATE Suppliers SET TPMobile=@TPMobile WHERE Company=@Company", Connection);
UPTPMOB.Parameters.AddWithValue("@TPMobile", TPMobile.Text.ToString());
UPTPMOB.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPFAX = new SqlCommand("UPDATE Suppliers Set Fax=@Fax WHERE Company=@Company", Connection);
UPFAX.Parameters.AddWithValue("@Fax", Fax.Text.ToString());
UPFAX.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPEMAIL = new SqlCommand("UPDATE Suppliers SET Email=@Email WHERE Company=@Company", Connection);
UPEMAIL.Parameters.AddWithValue("@Email", Email.Text.ToString());
UPEMAIL.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
SqlCommand UPWEB = new SqlCommand("UPDATE Suppliers SET Web=@Web WHERE Company=@Company", Connection);
UPWEB.Parameters.AddWithValue("@Web", Web.Text.ToString());
UPWEB.Parameters.AddWithValue("@Company", Comapny.Text.ToString());
Connection.Open();
int a, b, c, d, x, f, g, h, i;
a = UPDATENAME.ExecuteNonQuery();
b = ADD1.ExecuteNonQuery();
c = Add2.ExecuteNonQuery();
d = UPDATETPOFF.ExecuteNonQuery();
x = UPTPRES.ExecuteNonQuery();
f = UPTPMOB.ExecuteNonQuery();
g = UPFAX.ExecuteNonQuery();
h = UPEMAIL.ExecuteNonQuery();
i = UPWEB.ExecuteNonQuery();
if ((a == 1) && (b == 1) && (c == 1) && (d == 1) && (x == 1) && (f == 1) && (g == 1) && (h == 1) && (i == 1))
{
toolStripStatusLabel1.Text = "Update Successfully";
Names.Text = "";
Comapny.Text = "";
Official.Text = "";
Residential.Text = "";
TPOffice.Text = "";
TPMobile.Text = "";
TPResidential.Text = "";
Fax.Text = "";
Email.Text = "";
Web.Text = "";
}
Connection.Close();
}
}
catch
{
MessageBox.Show("Invalid Data Fields or unhandled Error Occered", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Comapny.Focus();
}
}