//SqlConnection sc = new SqlConnection("Data Source=SAGAR-PC;Initial Catalog=Bus Management System;Integrated Security=True"); // SqlCommand cmd; // SqlDataReader reader; public Admin(string id) { InitializeComponent(); Aid = id; Name_of_user.Text = "User :" + id; T_id_label.Hide(); route_and_bustime_combo_loader(); // load_new_ticket_ID(); dateTimePicker_ticket.MinDate = DateTime.Now.Date; dateTimePicker_ticket1.MinDate = DateTime.Now.Date; d1.MinDate = DateTime.Now.Date; }
private void load_new_ticket_ID() { string sql = null, member = null; sql = "select TOP 1 T_id from Ticket order by T_id DESC ;"; member = "T_id"; methods m = new methods(); string T_id = m.id_sender(sql, member); T_id_label.Text = T_id; T_id_label.Show(); Console.WriteLine("T_id" + T_id); }
private void btn_refresh_Click(object sender, EventArgs e) { //string v=checkedListBox_admin_Seat.SelectedItem.ToString(); //Console.WriteLine("VALUE::" + v); T_id_label.Hide(); textBox_contact_pass.Clear(); txtbox_name_pass.Clear(); textBox_total_fare.Clear(); checkedListBox_admin_Seat.Items.Clear(); /* string sql = "select [Bus Management System].dbo.Shedule.S_Time from [Bus Management System].dbo.Shedule where" + "[Bus Management System].dbo.Shedule.S_Time='" + combo_bustime.Text + "' and" + " [Bus Management System].dbo.Shedule.Ro_id=(select Road.Road_id from Road " + "where Road.[Route Name]='" + combo_route.Text + "')"; + string member = "S_Time"; + methods m = new methods(); + member =m.id_sender(sql,member); + Console.WriteLine("date"+member);*/ }