public int SuaGiaVe(GiaVe ve)
{
int kq = 0;
DAO_Ve kh = new DAO_Ve();
kq = kh.SuaGiaVe(ve);
return(kq);
}
public int XoaGiaVe(int a, string b)
{
int kq = 0;
DAO_Ve kh = new DAO_Ve();
kq = kh.XoaGiaVe(a, b);
return(kq);
}
public DataTable LoadVeTheoTuyen(string ghichu)
{
DAO_Ve ve = new DAO_Ve();
DataTable dt = new DataTable();
dt = ve.LoadVeTheoTuyen(ghichu);
return(dt);
}
public DataTable LoadGiaVe()
{
DAO_Ve ve = new DAO_Ve();
DataTable dt = new DataTable();
dt = ve.LoadGiaVe();
return(dt);
}
public DataTable LoadVeTheoTGTuyen(string ghichu, DateTime bd, DateTime kt)
{
DAO_Ve ve = new DAO_Ve();
DataTable dt = new DataTable();
dt = ve.LoadVeTheoTGTuyen(ghichu, bd, kt);
return(dt);
}
public DataTable LoadVeTheoChuyen(string idchuyen)
{
DAO_Ve ve = new DAO_Ve();
DataTable dt = new DataTable();
dt = ve.LoadVeTheoChuyen(idchuyen);
return(dt);
}
public DataTable LoadVeTheoTG(string idchuyen, DateTime bd, DateTime kt)
{
DAO_Ve ve = new DAO_Ve();
DataTable dt = new DataTable();
dt = ve.LoadVeTheoTG(idchuyen, bd, kt);
return(dt);
}
public string VeTuTang()
{
DAO_Ve ve = new DAO_Ve();
string dt = "";
dt = ve.VeMoi();
return(dt);
}
public string MaVeNDMoi()
{
DAO_Ve ve = new DAO_Ve();
string dt = "";
dt = ve.MaVeNDMoi();
return(dt);
}
public string GetGiaVe(string ghichu)
{
DAO_Ve ve = new DAO_Ve();
DAO_ChuyenXe cx = new DAO_ChuyenXe();
string idtuyen = cx.GetIDTuyen(ghichu);
string dt = ve.GetGiaVe(idtuyen);
return(dt);
}
public int ThemGiaVe(GiaVe ve)
{
int kq = 0;
DAO_Ve kh = new DAO_Ve();
DataTable dt = kh.IDGiaVe();
foreach (DataRow row in dt.Rows)
{
if (ve.id_tuyen_id == row[1].ToString())
{
return(-1);
}
}
kq = kh.ThemGiaVe(ve);
return(kq);
}
public int ThemVe(Ve ve)
{
int kq = 0;
DAO_Ve kh = new DAO_Ve();
DataTable dt = kh.IDVe();
foreach (DataRow row in dt.Rows)
{
if (ve.id_ve == row[0].ToString())
{
return(-1);
}
}
dt = kh.TrungVe();
foreach (DataRow row in dt.Rows)
{
if (ve.chuyen_id_chuyen == row[0].ToString() && ve.ghe_id_ghe == row[1].ToString())
{
return(-2);
}
}
kq = kh.ThemVe(ve);
return(kq);
}
