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) { } }