Exemplo n.º 1
0
        private void Savebtn_Click(object sender, EventArgs e)
        {
            DialogResult AddCustomer = MessageBox.Show("Are You Sure You Wish To ADD This Customer?", "Add Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (AddCustomer == DialogResult.Yes)
            {
            dataset.Clear();
            MySqlConnection con = new MySqlConnection();
            con.ConnectionString = LoginForm.constring;
            MySqlDataAdapter dataadapter = new MySqlDataAdapter();
            con.Open();

            MySqlCommand command = con.CreateCommand();
            MySqlCommand commandaddress = con.CreateCommand();
            commandaddress.CommandText = "INSERT INTO address (address_line1, address_line2, address_city, address_county, address_postcode) VALUES "+"('"+Addl1txt.Text+"','"+Addl2txt.Text+"','"+Towntxt.Text+"','"+Countytxt.Text+"','"+Postcodetxt.Text+"');";
            commandaddress.ExecuteNonQuery();

            MySqlCommand commandfindaddid = con.CreateCommand();
            command.CommandText = "SELECT * FROM address WHERE address_line1='"+Addl1txt.Text+"' AND address_postcode='" + Postcodetxt.Text + "'";
            dataadapter.SelectCommand = command;
            dataadapter.Fill(dataset, "address");
            DataRow dr = dataset.Tables["address"].Rows[0];

            command.CommandText = "INSERT INTO customer (address_id, customer_forename, customer_surname, customer_email, customer_phone) VALUES" + "(" + dr[0].ToString()+ ",'" + Forenametxt.Text + "','" + Surnametxt.Text + "','" + Emailtxt.Text + "'," + Phonetxt.Text + ");";
            command.ExecuteNonQuery();
            MessageBox.Show("The Customer Has Been Added Successfully.");
            con.Close();
            dataset.Clear();

            ManageAccounts ManageAccounts = new ManageAccounts();
            ManageAccounts.Show();
            this.Close();

            }
        }
Exemplo n.º 2
0
 private void ManageAccountsbtn_Click(object sender, EventArgs e)
 {
     ManageAccounts ManageAccounts = new ManageAccounts();
     ManageAccounts.Show();
     this.Dispose(false);
 }