private void Detour_Click(object sender, EventArgs e)
{
TidInfo.Name = delete_text.Text;
comm = con.CreateCommand();
comm.CommandText = "DELETE FROM `project`.`buy_tour` WHERE t_id ='" + TidInfo.Name + "'and u_id = '" + UserInfo.Name + "'";
try
{
int rowsAffected = comm.ExecuteNonQuery();
MessageBox.Show("Tour Removed!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Acc oldform = (Acc)Application.OpenForms["Acc"];
oldform.Close();
this.Close();
Acc fm = new Acc(UserInfo.Name);
fm.Show();
con.Close();
}
private void loginbutton_Click(object sender, EventArgs e)
{
i = 0;
MySqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from user_account where u_id='" + usernametextbox.Text + "'and password='******'";
cmd.ExecuteNonQuery();
var name = usernametextbox.Text;
comm = con.CreateCommand();
comm.CommandText = "Insert into project.login_his values @u_id";
comm.Parameters.AddWithValue("@u_id", name);
UserInfo.Name = usernametextbox.Text;
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
i = Convert.ToInt32(dt.Rows.Count.ToString());
if (i == 0)
{
MessageBox.Show("The username or password is incorrect. Try again!");
usernametextbox.Clear();
passwordtextbox.Clear();
usernametextbox.Select();
}
else
{
string data = usernametextbox.Text;
register_login newform = (register_login)Application.OpenForms["register_login"];
newform.Close();
this.Close();
Acc fm = new Acc(data);
fm.Show();
con.Close();
}
}
private void addtour_Click(object sender, EventArgs e)
{
comm = con.CreateCommand();
comm.CommandText = "INSERT INTO project.buy_tour (`t_id`, `u_id`) " + "VALUES " + "(@tid,@uid)";
comm.Parameters.AddWithValue("@tid", TidInfo.Name);
comm.Parameters.AddWithValue("@uid", UserInfo.Name);
try
{
int rowsAffected = comm.ExecuteNonQuery();
MessageBox.Show("Tour Added!");
Alltour newform = (Alltour)Application.OpenForms["Alltour"];
newform.Close();
Acc oldform = (Acc)Application.OpenForms["Acc"];
oldform.Close();
this.Close();
Acc fm = new Acc(UserInfo.Name);
fm.Show();
con.Close();
}
catch
{
MessageBox.Show("Tour already in your plan!");
}
}
