private void buttonLoadStatusF4()
{
SqlConnection con = Database_Connection.OpenCon();
string query = @"select status from seat_status where trip_id=@tid and seat_no='f4'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@tid", trip_id_number);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
statusF4 = Convert.ToString(reader[0]);
// b = Int32.Parse(a);
}
if (statusF4 == "av")
{
buttonF4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(128)))), ((int)(((byte)(0)))));
}
else if (statusF4 == "booked")
{
buttonF4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(112)))), ((int)(((byte)(128)))), ((int)(((byte)(44)))));
}
else if (statusF4 == "sold")
{
buttonF4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(204)))), ((int)(((byte)(51)))), ((int)(((byte)(51)))));
}
}
private void ButtonConfirm_Click(object sender, EventArgs e)
{
try {
foreach (string el in l)
{
Console.WriteLine(el);
SqlConnection con = Database_Connection.OpenCon();
string query = @"UPDATE seat_status SET status = 'sold' WHERE Seat_no='" + el + "' and trip_id=" + trip_id + "";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
Database_Connection.CloseCon();
}
SqlConnection con1 = Database_Connection.OpenCon();
MessageBox.Show("Successfull\n Thank You.");
string query1 = @"update Bus_info set seat=(seat-" + i + ") where ID=" + trip_id + "";
SqlCommand cmd1 = new SqlCommand(query1, con1);
//MessageBox.Show("Successfull\n Thank You.");
cmd1.ExecuteNonQuery();
Database_Connection.CloseCon();
}
catch (Exception ex) {
// MessageBox.Show(Convert.ToString(trip_id));
MessageBox.Show(ex.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
try {
SqlConnection con = Database_Connection.OpenCon();
string em = Convert.ToString(TextBoxEmail.Text);
string query = @"INSERT INTO user_info(full_name, email, user_name , password , user_type ) VALUES(@nm , @em , @un , @pw , @type )";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@un", TextBoxUserName.Text);
cmd.Parameters.AddWithValue("@nm", TextBoxYourName.Text);
cmd.Parameters.AddWithValue("@pw", TextBoxPassword.Text);
cmd.Parameters.AddWithValue("@em", em);
cmd.Parameters.AddWithValue("@type", "user");
if (TextBoxPassword.Text.Equals(TextBoxPassword2.Text) && CheckBoxAgree.Checked && IsValidEmail(TextBoxEmail.Text))
{
cmd.ExecuteNonQuery();
//cmd.ExecuteScalar();
MessageBox.Show("Successful");
}
else
{
MessageBox.Show("Password does not match\n check box does not checked \n Email not valid");
}
}
catch (SqlException ex) {
MessageBox.Show("User Name already Used");
//MessageBox.Show(ex.ToString());
}
catch (Exception ex) {
MessageBox.Show("User Name already Used");
//MessageBox.Show(ex.ToString());
}
}
private void ButtonConfirm_Click(object sender, EventArgs e)
{
try {
foreach (string el in l)
{
Console.WriteLine(el);
SqlConnection con = Database_Connection.OpenCon();
string query = @"UPDATE seat_status SET status = 'sold' WHERE Seat_no='" + el + "' and trip_id=" + trip_id + "";
SqlCommand cmd = new SqlCommand(query, con);
MessageBox.Show("Successfull\n Thank You.");
cmd.ExecuteNonQuery();
query = @"insert into user_history (trip_id, seat_no, date, price , user_id) values (" + trip_id + " , '" + el + "', '" + date1 + "', 500 , '" + userId + "')";
cmd = new SqlCommand(query, con);
//MessageBox.Show("Successfull\n Thank You.");
cmd.ExecuteNonQuery();
Database_Connection.CloseCon();
}
}
catch (Exception ex) {
// MessageBox.Show(Convert.ToString(trip_id));
MessageBox.Show(ex.ToString());
}
}
private void UserControlShowBusesGridView_Load(object sender, EventArgs e)
{
try {
SqlConnection con = Database_Connection.OpenCon();
string query = @"select ID, name, time , fare , seat from Bus_info where date='" + dateforquery + "' and To_1='" + to1 + "' and From_1='" + from1 + "'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@dd", dateforquery);
cmd.Parameters.AddWithValue("@tt", to1);
cmd.Parameters.AddWithValue("@frm", from1);
//MessageBox.Show(query);
//MessageBox.Show(to1);
//MessageBox.Show(from1);
SqlDataAdapter sqlDa = new SqlDataAdapter(cmd);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
dataGridViewBusAvailable.DataSource = dtbl;
}
catch (SqlException ex) {
MessageBox.Show("You have made an database exception");
}
catch (Exception ex) {
MessageBox.Show("You have made an database exception");
}
}
private void button2_Click(object sender, EventArgs e)
{
dateOrginal = dateOrginal.AddDays(1);
string s = dateOrginal.ToString("yyyy-MM-dd");
string dates = dateOrginal.ToString("dd-MMMM-yyyy");
labelDateText.Text = dates;
try
{
SqlConnection con = Database_Connection.OpenCon();
string query = @"select ID, name, time , fare , seat from Bus_info where date= @dd and To_1=@tt and From_1=@frm";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@dd", s);
cmd.Parameters.AddWithValue("@tt", to1);
cmd.Parameters.AddWithValue("@frm", from1);
SqlDataAdapter sqlDa = new SqlDataAdapter(cmd);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
dataGridViewBusAvailable.DataSource = dtbl;
}
catch (SqlException ex)
{
MessageBox.Show("You have made an database exception");
}
catch (Exception ex)
{
MessageBox.Show("You have made an database exception");
}
}
private void button2_Click(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-IBAJJID;Initial Catalog=BusTicket;Integrated Security=True");
SqlConnection con = Database_Connection.OpenCon();
//string query = @"select email from user_info";
string query = @"Select full_name from user_info where password=@pw and user_name=@un";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@un", TextBoxUserName.Text);
cmd.Parameters.AddWithValue("@pw", TextBoxPassword.Text);
cmd.ExecuteNonQuery();
//MessageBox.Show(Convert.ToString(i));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//write the data on to the screen
//call the objects from their index
// reader[0]));
string a = Convert.ToString(reader[0]);
//MessageBox.Show(a);
// TextBoxUserName.Text = a;
panelSignInForm.Controls.Clear();
panelSignInForm.Controls.Add(new UserControlUser(TextBoxUserName.Text, a, panelSignInForm));
}
}
public void display()
{
SqlConnection con = Database_Connection.OpenCon();
string query = "select trip_id,seat_no,date,price from user_history where user_id='" + user_id + "'";
SqlCommand cmd = new SqlCommand(query, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
cmd.ExecuteNonQuery();
Database_Connection.CloseCon();
}
private void UserControlShowBusesGridView_Load(object sender, EventArgs e)
{
SqlConnection con = Database_Connection.OpenCon();
string query = @"select name, time , fare , seat from Bus_info where date= @dd";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@dd", dateforquery);
SqlDataAdapter sqlDa = new SqlDataAdapter(cmd);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
dataGridViewBusAvailable.DataSource = dtbl;
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = Database_Connection.OpenCon();
string em = Convert.ToString(TextBoxEmail.Text);
string query = @"INSERT INTO user_info(full_name, email, user_name , password) VALUES(@nm , @em , @un , @pw)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@un", TextBoxUserName.Text);
cmd.Parameters.AddWithValue("@nm", TextBoxYourName.Text);
cmd.Parameters.AddWithValue("@pw", TextBoxPassword.Text);
cmd.Parameters.AddWithValue("@em", em);
cmd.ExecuteNonQuery();
cmd.ExecuteScalar();
}
private void button2_Click(object sender, EventArgs e)
{
//MessageBox.Show( DateTime.Now.ToString("MM-yyyy-dd"));
try
{
SqlConnection con = Database_Connection.OpenCon();
//string query = @"select email from user_info";
string query = @"Select full_name , user_name , user_type from user_info where password=@pw and user_name=@un";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@un", TextBoxUserName.Text);
cmd.Parameters.AddWithValue("@pw", TextBoxPassword.Text);
cmd.ExecuteNonQuery();
//MessageBox.Show(Convert.ToString(i));
if (!TextBoxUserName.Text.Equals("UserName") && !TextBoxPassword.Text.Equals(null))
{
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
MessageBox.Show("User does not exist");
}
while (reader.Read())
{
//write the data on to the screen
//call the objects from their index
// reader[0]));
string a = Convert.ToString(reader[0]);
string b = Convert.ToString(reader[1]);
string c = Convert.ToString(reader[2]);
//MessageBox.Show(a);
if (TextBoxUserName.Text.Equals(b) && c.Equals("user"))
{
panelSignInForm.Controls.Clear();
panelSignInForm.Controls.Add(new UserControlUser(TextBoxUserName.Text, a, panelSignInForm));
}
if (TextBoxUserName.Text.Equals(b) && c.Equals("admin"))
{
//panelSignInForm.Controls.Clear();
//panelSignInForm.Controls.Add(new UserControlUser(TextBoxUserName.Text, a, panelSignInForm));
// panelSignInForm.Controls.Add(new BusTicketAdmin.UserControlAdminFront(TextBoxUserName.Text, a, panelSignInForm));
//panelSignInForm.Controls.Add(new BusTicketAdmin.UserControlAdminFront(TextBoxUserName.Text , a));
BusTicketAdmin.Form1 f = new BusTicketAdmin.Form1(a, TextBoxUserName.Text);
//f.Activate();
//this.Hide();
f.Show();
//BusTicketAdmin.FormManageTrip fm = new BusTicketAdmin.FormManageTrip(a, TextBoxUserName.Text);
//fm.Show();
}
}
}
else
{
MessageBox.Show("User Name and Password\n can not be null");
}
}
catch (SqlException ex)
{
}
catch (Exception ex)
{
}
}
