void LoadTramCuoi(ComboBox cb)
{
BUS_Tram bus_tram = new BUS_Tram();
cb.DataSource = bus_tram.getTram();
cb.DisplayMember = "TenTram";
}
public void listTenTram()
{
cbTramDi.Items.Clear();
cbTramDen.Items.Clear();
cbIDTramDi.Items.Clear();
cbIDTramDen.Items.Clear();
BUS_Tram bus = new BUS_Tram();
DataTable dt = new DataTable();
dt = bus.listTram();
foreach (DataRow r in dt.Rows)
{
cbTramDi.Items.Add(r["TenTram"]);
cbTramDen.Items.Add(r["TenTram"]);
cbIDTramDi.Items.Add(r["ID_Tram"]);
cbIDTramDen.Items.Add(r["ID_Tram"]);
}
//hiển thị index=0 tức là vị trí đầu tiền trong cbox
if (cbIDTramDi.Items.Count > 0)
{
cbTramDi.SelectedIndex = 1;
cbTramDen.SelectedIndex = 0;
cbIDTramDi.SelectedIndex = 1;
cbIDTramDen.SelectedIndex = 0;
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbTenTram.Text))
{
return;
}
if (string.IsNullOrEmpty(cbDiaDiem.Text))
{
return;
}
BUS_Tram bus = new BUS_Tram();
DTO_Tram dto_tr = new DTO_Tram();
dto_tr.Id_Tram = Convert.ToInt32(cbIdTram.Text);
dto_tr.Ten_Tram = Convert.ToString(cbTenTram.Text);
dto_tr.Dia_Diem = Convert.ToString(cbDiaDiem.Text);
if (bus.suaTram(dto_tr))
{
MessageBox.Show("Sửa trạm thành công!");
loadGridTram();
}
else
{
MessageBox.Show("Sửa trạm không thành công!");
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbTenTram.Text))
{
return;
}
if (string.IsNullOrEmpty(cbDiaDiem.Text))
{
return;
}
BUS_Tram bus = new BUS_Tram();
DTO_Tram dto_tr = new DTO_Tram();
dto_tr.Ten_Tram = cbTenTram.Text;
dto_tr.Dia_Diem = cbDiaDiem.Text;
if (!bus.checkExistsTenTramInTram(dto_tr))
{
if (bus.Insert(dto_tr))
{
MessageBox.Show("Thêm trạm thành công!");
loadGridTram();
}
else
{
MessageBox.Show("Thêm trạm không thành công!");
}
}
else
{
MessageBox.Show("Tên trạm đã tồn tại!");
}
}
private void dgvTramTG_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvTramTG.SelectedCells.Count > 0)
{
int id_dau = (int)dgvTramTG.SelectedCells[0].OwningRow.Cells["Tram_ID_Tram"].Value;
//int id = (int)dgvTramTG.SelectedCells[0].OwningRow.Cells["ID_TramTG"].Value;
BUS_Tram bustram = new BUS_Tram();
BUS_Tram bustramcuoi = new BUS_Tram();
Tram tram = bustram.getTramByID(id_dau);
cbbTenTram.SelectedItem = tram;
lbDiaDiem.Text = tram.DiaDiem;
int index = -1;
int i = 0;
foreach (Tram item in cbbTenTram.Items)
{
if (item.IDTram == tram.IDTram)
{
index = i;
break;
}
i++;
}
cbbTenTram.SelectedIndex = index;
}
}
catch { }
}
private void txtTraCuu_TextChanged(object sender, EventArgs e)
{
BUS_Tram kh = new BUS_Tram();
if (string.IsNullOrEmpty(txtTraCuu.Text))
{
dgvTraCuuTram.DataSource = kh.LoadTram();
}
else
{
dgvTraCuuTram.DataSource = kh.TraCuuTram(txtTraCuu.Text);
}
}
public void loadGridTram()
{
BUS_Tram bus_tram = new BUS_Tram();
DataTable dt = new DataTable();
dt = bus_tram.listTram();
//gán dữ liệu vào datagridview
for (int i = 0; i < dgrv_Tram.ColumnCount; i++)
{
dgrv_Tram.Columns[i].DataPropertyName = dgrv_Tram.Columns[i].Name;
}
dgrv_Tram.DataSource = dt;
}
private void txtIDTuyenXe_TextChanged(object sender, EventArgs e)
{
try
{
if (dgvTuyenXe.SelectedCells.Count > 0)
{
int id_dau = (int)dgvTuyenXe.SelectedCells[0].OwningRow.Cells["ID_TramDau"].Value;
int id_cuoi = (int)dgvTuyenXe.SelectedCells[0].OwningRow.Cells["ID_TramCuoi"].Value;
int id = (int)dgvTuyenXe.SelectedCells[0].OwningRow.Cells["ID_Tuyen"].Value;
BUS_Tram bustramdau = new BUS_Tram();
BUS_Tram bustramcuoi = new BUS_Tram();
Tram tramdau = bustramdau.getTramByID(id_dau);
Tram tramcuoi = bustramcuoi.getTramByID(id_cuoi);
cbbTramDau.SelectedItem = tramdau;
cbbTramCuoi.SelectedItem = tramcuoi;
lbDiaDiemDau.Text = tramdau.DiaDiem;
lbDiaDiemCuoi.Text = tramcuoi.DiaDiem;
int index1 = -1, index2 = -1;
int i = 0, j = 0;
foreach (Tram item in cbbTramDau.Items)
{
if (item.IDTram == tramdau.IDTram)
{
index1 = i;
break;
}
i++;
}
foreach (Tram item in cbbTramCuoi.Items)
{
if (item.IDTram == tramcuoi.IDTram)
{
index2 = j;
break;
}
j++;
}
cbbTramDau.SelectedIndex = index1;
cbbTramCuoi.SelectedIndex = index2;
ShowListTramTrungGian(id);
}
}
catch { }
}
void getTenTram()
{
BUS_Tram bus = new BUS_Tram();
DTO_TramTrungGian dto_ttg = new DTO_TramTrungGian();
DataTable dt = new DataTable();
dt = bus.listTram();
foreach (DataRow r in dt.Rows)
{
cbTenTram.Items.Add(r["TenTram"]);
cbTramIdTram.Items.Add(r["ID_Tram"]);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (KTRONG() == false)
{
return;
}
else
{
Tram tempTram = new Tram();
tempTram.id_tram = txtIDTram.Text;
tempTram.ten_tram = txtTenTram.Text;
tempTram.dia_diem = txtDiaDiem.Text;
BUS_Tram tram = new BUS_Tram();
if (txtIDTram.Enabled == true)
{
if (tram.ThemTram(tempTram) == 1)
{
FormQLTram qlTram = new FormQLTram();
this.Close();
}
else
{
MessageBox.Show("Không Thêm Được");
return;
}
}
else
{
if (tram.SuaTram(tempTram) == 1)
{
FormQLTram qlTram = new FormQLTram();
qlTram.LoadQLTram();
this.Close();
}
else
{
MessageBox.Show("Không Sửa Được");
return;
}
}
txtIDTram.Enabled = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(IDDangChon))
{
MessageBox.Show("Click Vào Dòng muốn Xoá");
return;
}
BUS_Tram kh = new BUS_Tram();
if (kh.XoaTram(IDDangChon) == 1)
{
MessageBox.Show("Xoa Thanh Cong");
LoadQLTram();
}
else
{
MessageBox.Show("Không Xoá Được");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
BUS_Tram bus = new BUS_Tram();
DTO_Tram dto_tr = new DTO_Tram();
dto_tr.Id_Tram = Convert.ToInt32(cbIdTram.Text);
if (bus.xoaTram(dto_tr))
{
MessageBox.Show("Xóa trạm thành công!");
loadGridTram();
}
else
{
MessageBox.Show("Xóa trạm không thành công!");
}
cbTenTram.ResetText();
cbDiaDiem.ResetText();
}
void listTenTram()
{
BUS_Tram bus = new BUS_Tram();
DataTable dt = new DataTable();
dt = bus.listTram();
foreach (DataRow r in dt.Rows)
{
cbIdTram.Items.Add(r["ID_Tram"]);
cbTenTram.Items.Add(r["TenTram"]);
cbDiaDiem.Items.Add(r["Dia_diem"]);
}
//hiển thị index=0 tức là vị trí đầu tiền trong cbox
if (cbTenTram.Items.Count > 0)
{
cbIdTram.SelectedIndex = 0;
cbTenTram.SelectedIndex = 0;
cbDiaDiem.SelectedIndex = 0;
}
}
private void frmHOTRO_TenTram_Load(object sender, EventArgs e)
{
BUS_Tram tram = new BUS_Tram();
dgvTraCuuTram.DataSource = tram.LoadTram();
}
public void LoadQLTram()
{
BUS_Tram tram = new BUS_Tram();
dgvDSTram.DataSource = tram.LoadTram();
}
