private void button3_Click_1(object sender, EventArgs e) { this.Hide(); ViewBuyerSeller view_buyer_seller_page = new ViewBuyerSeller(); view_buyer_seller_page.Show(); }
private void button2_Click(object sender, EventArgs e) { this.Hide(); ViewBuyerSeller BuyerSeller_page = new ViewBuyerSeller(); BuyerSeller_page.Show(); }
private void Update_Click(object sender, EventArgs e) { int i; long j; if (string.IsNullOrWhiteSpace(Fname.Text)) { MessageBox.Show("Please enter a first name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(Lname.Text)) { MessageBox.Show("Please enter a last name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(StrAdd.Text)) { MessageBox.Show("Please enter a street address", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(City.Text)) { MessageBox.Show("Please enter a city", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (State.SelectedItem == null) { MessageBox.Show("Please select a state", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Zip.TextLength != 5 || !int.TryParse(Zip.Text, out i)) { MessageBox.Show("Please enter a 5 digit Zip Code ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Phone.TextLength != 10 || !long.TryParse(Phone.Text, out j)) { MessageBox.Show("Please enter a 10 digit phone", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (string.IsNullOrWhiteSpace(Email.Text)) { MessageBox.Show("Please enter an e-mail", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (status.SelectedItem == null) { MessageBox.Show("Please select a status.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { this.Hide(); ViewBuyerSeller BS_Page = new ViewBuyerSeller(); updateBUYERSELLER(SSNText.Text, Fname.Text, Mname.Text, Lname.Text, Email.Text, Phone.Text, StrAdd.Text, City.Text, State.SelectedItem.ToString(), Zip.Text, status.SelectedItem.ToString()); BS_Page.Show(); } }
public void addBUYERSELLER(string atype, string aSSN, string afname, string amname, string alname, string aemail, string aphone, string astreetAdd, string acity, string aBS_State, string azip) { { float zero = 0; string status = "Active"; SqlCommand addbs = SqlConnectionCommand.getCommand(); addbs.CommandText = "USE SRDB INSERT INTO BUYERSELLER Values " + "(@strtype, @strSSN, @strfname, @strmname, @strlname, @stremail, @strphone, @strstreetAdd, @strcity, @strState, @strzip, @floatProfit, @strstatus)"; addbs.Parameters.AddWithValue("@strtype", atype); addbs.Parameters.AddWithValue("@strSSN", aSSN); addbs.Parameters.AddWithValue("@strfname", afname); addbs.Parameters.AddWithValue("@strmname", amname); addbs.Parameters.AddWithValue("@strlname", alname); addbs.Parameters.AddWithValue("@stremail", aemail); addbs.Parameters.AddWithValue("@strphone", aphone); addbs.Parameters.AddWithValue("@strstreetAdd", astreetAdd); addbs.Parameters.AddWithValue("@strcity", acity); addbs.Parameters.AddWithValue("@strState", aBS_State); addbs.Parameters.AddWithValue("@strzip", azip); addbs.Parameters.AddWithValue("@floatProfit", zero); addbs.Parameters.AddWithValue("@strstatus", status); try { addbs.ExecuteNonQuery(); MessageBox.Show("Successfully added"); this.Hide(); ViewBuyerSeller BS_Page = new ViewBuyerSeller(); BS_Page.Show(); } catch (Exception ex) { // MessageBox.Show(ex.ToString()); MessageBox.Show("The SSN entered already exists, Please enter another SSN.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }