private void order_button_Click(object sender, EventArgs e)
{
this.Hide();
customer_login objcustlg = new customer_login();
objcustlg.Show();
}
private void signup_btn_Click(object sender, EventArgs e)
{
fieldcheck();
if (check == false)
{
MessageBox.Show("Please complete the fields!");
}
else
{
SqlConnection conn = new SqlConnection(connString);
SqlTransaction trans = default;
try
{
conn = new SqlConnection(connString);
conn.Open();
trans = conn.BeginTransaction();
using (var cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.Transaction = trans;
cmd.CommandText =
@"INSERT INTO Customers (customer_name, customer_password)
VALUES ( @name, @pass)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@name", this.cust_name.Text.Trim());
cmd.Parameters.AddWithValue("@pass", this.cust_pass.Text.Trim());
cmd.ExecuteNonQuery();
}
trans.Commit();
MessageBox.Show("Add Success. Please continue ordering.");
this.Hide();
customer_login objcustlg = new customer_login();
objcustlg.Show();
}
catch (Exception ex)
{
if (trans != null)
{
trans.Rollback();
}
MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (trans != null)
{
trans.Dispose();
}
if (conn != null)
{
conn.Close();
}
}
}
}