private void Duyet_danh_sach_cho_ngoi()
{
{
var withBlock = fm;
lenh = "Select IdChuyen from ChuyenXe where IdTuyen = '" + fm.cbo_TenTuyenVe.SelectedValue.ToString() + "'" + " and NgayDi = '" + Convert.ToDateTime(fm.cbo_NgayVe.SelectedValue.ToString()) + "' and Gio = '" + fm.cbo_GioVe.SelectedValue.ToString() + "'" + " and So_Xe = '" + fm.cbo_XeVe.SelectedValue.ToString() + "'";
// Lay Idchuyen cua chuyen do ra
bang_dat_ve = Ket_noi.Doc_bang(lenh);
IdChuyen = bang_dat_ve.Rows[0]["IdChuyen"].ToString();
}
lenh = "Select * from ChoNgoi where IdChuyen = '" + IdChuyen + "' and So_Xe = '" + fm.cbo_XeVe.SelectedValue.ToString() + "'";
SqlCommand com = new SqlCommand(lenh, Ket_noi.connect);
try
{
Ket_noi.connect.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read() == true)
{
for (int i = 0; i <= grb_16.Controls.Count - 1; i++)
{
if (dr.GetValue(2).ToString() == grb_16.Controls[i].Text)
{
((DevComponents.DotNetBar.ButtonX)grb_16.Controls[i]).Image = Properties.Resources.hanh_khach;
}
}
}
Ket_noi.connect.Close();
}
catch (Exception ex)
{
MessageBox.Show("Không đọc được danh sách chỗ ngồi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
private void Doc_Thoi_diem()
{
luoi_Thoi_diem.ClearSelection();
lenh = "Select IdTuyen, ThoiDiem.IdThoiDiem , Ngay, Gio from ThoiDiem, ChiTietTuyen where ChiTietTuyen.IdThoiDiem = ThoiDiem.IdThoiDiem ";
bang_thoi_diem = Ket_noi.Doc_bang(lenh);
luoi_Thoi_diem.DataSource = bang_thoi_diem;
}
private void btn_HienDanhSach_Click(object sender, EventArgs e)
{
if (flag)
{
luoi_Thoi_diem.ClearSelection();
lenh = "Select ChiTietTuyen.IdTuyen, TenTuyen , ThoiDiem.IdThoiDiem , Ngay, Gio from ThoiDiem, ChiTietTuyen, TuyenXe ";
lenh += " where ChiTietTuyen.IdThoiDiem = ThoiDiem.IdThoiDiem and TuyenXe.IdTuyen = ChiTietTuyen.IdTuyen";
bang_danh_sach = Ket_noi.Doc_bang(lenh);
luoi_Thoi_diem.DataSource = bang_danh_sach;
cbo_MaSoTuyen.DataSource = bang_danh_sach;
cbo_MaSoTuyen.DisplayMember = "IdTuyen";
cbo_MaSoTuyen.ValueMember = "IdTuyen";
cbo_MaSoTuyen1.DataBindings.Clear();
cbo_TenTuyen.DataBindings.Clear();
cbo_MaThoiDiem.DataBindings.Clear();
date_Chay.DataBindings.Clear();
txt_GioChay.DataBindings.Clear();
cbo_MaSoTuyen1.DataBindings.Add("Text", bang_danh_sach, "IdTuyen");
cbo_TenTuyen.DataBindings.Add("text", bang_danh_sach, "TenTuyen");
cbo_MaThoiDiem.DataBindings.Add("text", bang_danh_sach, "IdThoiDiem");
date_Chay.DataBindings.Add("text", bang_danh_sach, "Ngay");
txt_GioChay.DataBindings.Add("text", bang_danh_sach, "Gio");
btn_HienDanhSach.Text = "Lọc danh sách tuyến";
flag = false;
}
else
{
Update_ChiTietTuyen();
btn_HienDanhSach.Text = "Hiện tất cả danh sách";
flag = true;
}
}
private void Form_Login_Load(object sender, EventArgs e)
{
Timer1.Start();
Timer2.Start();
Ket_noi.Tao_ket_noi();
Kiem_tra_ket_noi();
lblChaoMung.Visible = true;
PictureBox2.Width = 0;
}
private void Doc_tuyen_xe()
{
lenh = "Select IdTuyen, TenTuyen from TuyenXe";
bang_Tuyen_xe = Ket_noi.Doc_bang(lenh);
cbo_MaSoTuyen.DataSource = bang_Tuyen_xe;
cbo_MaSoTuyen.DisplayMember = "IdTuyen";
cbo_MaSoTuyen.ValueMember = "IdTuyen";
cbo_MaSoTuyen1.Text = cbo_MaSoTuyen.Text;
Xoa_lien_ket();
Tao_lien_ket();
}
public void update_()
{
lenh = "Delete from ChiTietTuyen where IdThoiDiem in (Select IdThoiDiem from ThoiDiem where Ngay < '" + Convert.ToString(DateTime.Today.Date) + "')";
SqlCommand com1 = new SqlCommand(lenh, Ket_noi.connect);
try
{
Ket_noi.connect.Open();
com1.ExecuteNonQuery();
Ket_noi.connect.Close();
}
catch (Exception ex)
{
Ket_noi.connect.Close();
}
lenh = "Select * from ChiTietTuyen";
bang = Ket_noi.Doc_bang(lenh);
if (bang.Rows.Count == 0)
{
lenh = "Delete from ThoiDiem";
}
else
{
lenh = "Delete from ThoiDiem where Ngay < '" + Convert.ToString(DateTime.Today.Date) + "'";
}
SqlCommand com2 = new SqlCommand(lenh, Ket_noi.connect);
try
{
Ket_noi.connect.Open();
com2.ExecuteNonQuery();
Ket_noi.connect.Close();
}
catch (Exception ex)
{
Ket_noi.connect.Close();
}
// --------------------------------------------------Xu ly voi bang chuyenxxe, chongoi, banve
lenh = "Delete from BanVe where IdChuyen in( Select IdChuyen from ChuyenXe where NgayDi < '" + System.Convert.ToString(DateTime.Today.Date) + "')";
SqlCommand com = new SqlCommand(lenh, Ket_noi.connect);
try
{
Ket_noi.connect.Open();
com.ExecuteNonQuery();
Ket_noi.connect.Close();
}
catch (Exception ex)
{
Ket_noi.connect.Close();
}
lenh = "Delete from ChoNgoi where IdChuyen in( Select IdChuyen from ChuyenXe where NgayDi < '" + System.Convert.ToString(DateTime.Today.Date) + "')";
SqlCommand com4 = new SqlCommand(lenh, Ket_noi.connect);
try
{
Ket_noi.connect.Open();
com4.ExecuteNonQuery();
Ket_noi.connect.Close();
}
catch (Exception ex)
{
Ket_noi.connect.Close();
}
lenh = "Select * from BanVe";
bang = Ket_noi.Doc_bang(lenh);
if (bang.Rows.Count == 0)
{
lenh = "Delete from ChuyenXe";
}
else
{
lenh = "Delete from ChuyenXe where IdChuyen <> (Select IdChuyen from BanVe)";
}
SqlCommand com3 = new SqlCommand(lenh, Ket_noi.connect);
try
{
Ket_noi.connect.Open();
com3.ExecuteNonQuery();
Ket_noi.connect.Close();
}
catch (Exception ex)
{
Ket_noi.connect.Close();
}
}
