private void addToolStripMenuItem_Click(object sender, EventArgs e) { this.Hide(); AddItem adi = new AddItem(); adi.m = this; adi.Show(); }
public void getVehicle(AddItem ad = null, UpDe ud = null, AddCustomer adc = null, EditCust edc = null, string veh = null) { String cmd = "exec getVehicle ''"; if (veh != null) { cmd = "exec getVehicle '" + veh + "'"; } using (Conn = new SqlConnection()) { try { Conn.ConnectionString = "Server = (local);Database = Spare_parts;Trusted_Connection = true"; SqlCommand Cmd = new SqlCommand(cmd, Conn); Conn.Open(); SqlDataReader reader = Cmd.ExecuteReader(); if (ad != null) { while (reader.Read()) { ad.Veh(reader[0].ToString()); } } else if (ud != null) { while (reader.Read()) { ud.Veh(reader[0].ToString()); } } else if (edc != null) { while (reader.Read()) { edc.Veh(reader[0].ToString()); } } else { while (reader.Read()) { adc.Veh(reader[0].ToString()); } } } catch (SqlException) { MessageBox.Show("An error occured", "Error"); } } Conn.Close(); }
public void GetSupp(AddOrder ado = null, AddItem ads = null, String supp = null, UpDe ud = null) { String cmd = "exec getSuppNames ''"; if (supp != null) { cmd = "exec getSuppNames '" + supp + "'"; } using (Conn = new SqlConnection()) { try { Conn.ConnectionString = "Server = (local);Database = Spare_parts;Trusted_Connection = true"; SqlCommand Cmd = new SqlCommand(cmd, Conn); Conn.Open(); SqlDataReader reader = Cmd.ExecuteReader(); while (reader.Read()) { if (ads != null) { ads.Supp(reader[0].ToString()); } else if (ado != null) { ado.Supp(reader[0].ToString()); } else { ud.Supp(reader[0].ToString()); } } } catch (SqlException) { MessageBox.Show("An error occured", "Error"); } } Conn.Close(); }