public void Tram_XoaTram(DataGridView dgv)
{
DAO_Tram daTram = new DAO_Tram();
int cr = dgv.CurrentCell.RowIndex;
int matram = Convert.ToInt32(dgv.Rows[cr].Cells[0].Value);
daTram.Delete_Tram(matram);
}
public void Tram_AutoMaTram(TextBox txt)
{
DAO_Tram daTram = new DAO_Tram();
int maTram = Convert.ToInt32(daTram.Find_MaTram());
maTram++;
txt.Text = maTram.ToString();
}
public int XoaTram(string a)
{
int kq = 0;
DAO_Tram kh = new DAO_Tram();
kq = kh.XoaTram(a);
return(kq);
}
public int SuaTram(Tram a)
{
int kq = 0;
DAO_Tram tram = new DAO_Tram();
kq = tram.SuaTram(a);
return(kq);
}
public DataTable TraCuuTram(string tentram)
{
DAO_Tram tram = new DAO_Tram();
DataTable dt = new DataTable();
dt = tram.FindTram(tentram);
return(dt);
}
public DataTable LoadTram()
{
DAO_Tram tram = new DAO_Tram();
DataTable dt = new DataTable();
dt = tram.LoadTram();
return(dt);
}
public void Tram_CbbTramDi(ComboBox cbb)
{
DAO_Tram daTram = new DAO_Tram();
cbb.DataSource = daTram.Fill_CbbTram();
cbb.DisplayMember = "TenTram";
cbb.ValueMember = "TenTram";
if (cbb.Items.Count > 0)
{
cbb.SelectedIndex = 0;
}
}
public void Tram_CbbTramDen(ComboBox cbb1, ComboBox cbb2)
{
DAO_Tram daTram = new DAO_Tram();
int maTram = daTram.Find_IDTramByName(cbb2.SelectedValue.ToString());
cbb1.DataSource = daTram.Fill_CBBTramDenVe(maTram);
cbb1.DisplayMember = "TenTram";
cbb1.ValueMember = "TenTram";
if (cbb1.Items.Count > 0)
{
cbb1.SelectedIndex = 0;
}
}
public void Tuyen_FillDGV(ComboBox cbb, DataGridView dgv)
{
DAO_Tuyen daTuyen = new DAO_Tuyen();
DAO_Tram daTram = new DAO_Tram();
string tenTram = "";
if (cbb.Items.Count > 0)
{
tenTram = cbb.SelectedValue.ToString();
}
int ID_Tram1 = Convert.ToInt32(daTram.Find_IDTramByName(tenTram));
dgv.DataSource = daTuyen.Fill_TuyenXe(ID_Tram1);
}
public int ThemTram(Tram a)
{
int kq = 0;
DAO_Tram tram = new DAO_Tram();
DataTable dt = tram.IDTram();
foreach (DataRow row in dt.Rows)
{
if (a.id_tram == row[0].ToString())
{
return(-1);
}
}
kq = tram.ThemTram(a);
return(kq);
}
public Tram getTramByID(int id)
{
DAO_Tram daoTram = new DAO_Tram();
return(daoTram.GetTramByID(id));
}
public List <Tram> getTram()
{
DAO_Tram daoTram = new DAO_Tram();
return(daoTram.GetTram());
}
public void Tram_ThemTram(DTO.Tram tram)
{
DAO_Tram daTram = new DAO_Tram();
daTram.Add_Tram(tram);
}
public void Tram_LoadDGV(DataGridView dgv)
{
DAO_Tram daTram = new DAO_Tram();
dgv.DataSource = daTram.Fill_Tram();
}
public void Tram_SuaTram(DTO.Tram tram)
{
DAO_Tram daTram = new DAO_Tram();
daTram.Update_Tram(tram);
}
