//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);*/
}
