public ContactsModify(ResourceManager _rm, Models.Contacts _Con, string[] _ResourceNames, Pages.Contacts _conpage)
{
InitializeComponent();
rm = _rm;
Con = _Con;
ResourceNames = _ResourceNames;
Tb_Name.Clear();
Tb_Name.Text = Con.Con_Name.Trim();
Tb_Phone.Clear();
Tb_Phone.Text = Con.Con_Phone.Trim();
Tb_Email.Clear();
Tb_Email.Text = Con.Con_Email.Trim();
conpage = _conpage;
LoadFormats();
}
private void Bt_Update_Click(object sender, EventArgs e)
{
db.closeConnection();
SqlCommand cmd = db.UpdateTrip(Tb_Name.Text, Tb_Streetname.Text, Tb_City.Text, Tb_PostCode.Text, Tb_Province.Text, Tb_Phone.Text, Tb_Name2.Text, Tb_StreetAddress2.Text, Tb_City2.Text, Tb_Postcode2.Text, Tb_Province2.Text, Tb_Phone2.Text, Tb_Description.Text, Tb_Statue.Text, TripID.ToString());
cmd.Parameters.AddWithValue("@S_Name", Tb_Name.Text);
cmd.Parameters.AddWithValue("@S_StreetAddress", Tb_Streetname.Text);
cmd.Parameters.AddWithValue("@S_City", Tb_City.Text);
cmd.Parameters.AddWithValue("@S_Postcode", Tb_PostCode.Text);
cmd.Parameters.AddWithValue("@S_Province", Tb_Province.Text);
cmd.Parameters.AddWithValue("@S_Phone", Tb_Phone.Text);
cmd.Parameters.AddWithValue("@R_Name", Tb_Name2.Text);
cmd.Parameters.AddWithValue("@R_StreetAddress", Tb_StreetAddress2.Text);
cmd.Parameters.AddWithValue("@R_City", Tb_City2.Text);
cmd.Parameters.AddWithValue("@R_Postcode", Tb_Postcode2.Text);
cmd.Parameters.AddWithValue("@R_Province", Tb_Province2.Text);
cmd.Parameters.AddWithValue("@R_Phone", Tb_Phone2.Text);
cmd.Parameters.AddWithValue("@R_Description", Tb_Description.Text);
cmd.Parameters.AddWithValue("@Status", Tb_Statue.Text);
cmd.ExecuteNonQuery();
Tb_Name.ResetText();
Tb_Streetname.ResetText();
Tb_City.ResetText();
Tb_PostCode.ResetText();
Tb_Province.ResetText();
Tb_Phone.ResetText();
Tb_Name2.ResetText();
Tb_StreetAddress2.ResetText();
Tb_City2.ResetText();
Tb_Postcode2.ResetText();
Tb_Province2.ResetText();
Tb_Phone2.ResetText();
Tb_Description.ResetText();
Tb_Statue.ResetText();
}
