void XulyTimKiemTCL()
{
c = new BUS_Chuyen();
DataTable dt = new DataTable();
dto_c = new DTO_Chuyen();
int Tuyen = -1;
dto_c.ID_Chuyen = -1;
if (cbbTuyenXe.SelectedIndex != 0)
{
if (Int32.TryParse(cbbTuyenXe.Text.ToString(), out int x))
{
Tuyen = x;
}
}
if (cbbChuyenXe.SelectedIndex != 0)
{
if (Int32.TryParse(cbbChuyenXe.Text.ToString(), out int x))
{
dto_c.ID_Chuyen = x;
}
}
string Loai = cbbLoaiXe.Text.ToString();
if (cbbChuyenXe.Text.ToString() == "All" && cbbLoaiXe.Text.ToString() == "All" && cbbTuyenXe.Text.ToString() == "All")
{
LoaddgvChuyen();
}
dt = c.ListChuyenDK(Tuyen, dto_c.ID_Chuyen, Loai);
dgvChuyenXe.DataSource = dt;
}
//Xử lý dgvChuyen
void LoaddgvChuyen()
{
c = new BUS_Chuyen();
DataTable dt = new DataTable();
dt = c.ListChuyen();
dgvChuyenXe.DataSource = dt;
}
private void btUpdate_Click(object sender, EventArgs e)
{
c = new BUS_Chuyen();
DialogResult dlr = MessageBox.Show("Are you sure you want to UPDATE ?", "UPDATE", MessageBoxButtons.YesNo, MessageBoxIcon.None);
if (dlr == DialogResult.Yes)
{
c.UpdateChuyen(dto_c);
}
this.Close();
}
private void btInsert_Click(object sender, EventArgs e)
{
c = new BUS_Chuyen();
DialogResult dlr = MessageBox.Show("Are you sure you want to Insert ?", "INSERT", MessageBoxButtons.YesNo, MessageBoxIcon.None);
if (dlr == DialogResult.Yes)
{
c.InsertChuyen(dto_c);
}
this.Close();
}
private void btnXoaChuyenXe_Click(object sender, EventArgs e)
{
c = new BUS_Chuyen();
DialogResult dlr = MessageBox.Show("Are you sure you want to DLETE ?", "DELETE", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlr == DialogResult.Yes)
{
c.DeleteChuyen(dto_c.ID_Chuyen);
}
LoaddgvChuyen();
}
void loadcbbLoai()
{
c = new BUS_Chuyen();
DataTable dt = new DataTable();
dt = c.ListcbbLoai();
foreach (DataRow r in dt.Rows)
{
cbbLoaiXe.Items.Add(r["TenLoai"]);
}
cbbLoaiXe.SelectedIndex = 0;
}
private void btnSearchChuyenXe_Click(object sender, EventArgs e)
{
c = new BUS_Chuyen();
DataTable dt = new DataTable();
string tu, den;
tu = "%" + tbTu.Text.ToString() + "%";
den = "%" + tbDen.Text.ToString() + "%";
dt = c.ListChuyenSearch(tu, den);
dgvChuyenXe.DataSource = dt;
}
void loadcbbTuyen()
{
c = new BUS_Chuyen();
DataTable dt = new DataTable();
dt = c.ListcbbTuyen();
cbbTuyenXe.Items.Add("All");
foreach (DataRow r in dt.Rows)
{
cbbTuyenXe.Items.Add(r["ID_Tuyen"]);
}
cbbTuyenXe.SelectedIndex = 0;
}
private void btnXoaChuyenXe_Click(object sender, EventArgs e)
{
if (principal.IsInRole("client "))
{
MessageBox.Show("Bạn không có quyền thực hiện chức năng này");
}
if (principal.IsInRole("admin "))
{
c = new BUS_Chuyen();
DialogResult dlr = MessageBox.Show("Are you sure you want to DLETE ?", "DELETE", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlr == DialogResult.Yes)
{
c.DeleteChuyen(dto_c.ID_Chuyen);
}
LoaddgvChuyen();
}
}
