public IList <KHAOSAT> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.KHAOSATs.Where(x => x.isDeleted == 0).Include(x => x.NHANVIEN).ToList());
}
}
public static IList <TRAMXE> GetTramLen()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.TRAMXEs.Where(x => x.isDeleted != 1).ToList());
}
}
public void Dispose()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
context.Dispose();
}
}
public KHACHHANG GetKH_SDT(string sdt)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.KHACHHANGs.Where(x => x.SDT == sdt).FirstOrDefault());
}
}
public KHACHHANG Detail(int?id)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.KHACHHANGs.Find(id));
}
}
public IList <TRAMXE> Search(string input)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.TRAMXEs.Where(x => x.isDeleted != 1 && (x.TenTram.Contains(input) || x.DiaChi.Contains(input) || input == "")).ToList());
}
}
public TINHTHANH Detail(string id)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.TINHTHANHs.Find(id));
}
}
public string GetGioLenXe(string maDiemDi, string maDiemDen, int maChuyen, int maTramLen)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_GetGioLenXe(maDiemDi, maDiemDen, maChuyen, maTramLen).FirstOrDefault());
}
}
public decimal?GetGiaVe(int maTramLen, int maTramXuong, int maChuyen)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_GetGiaVe(maTramLen, maTramXuong, maChuyen).FirstOrDefault());
}
}
//public IList<sp_GetTramXuong_Result> GetTramXuong(string maDiemDi, string maDiemDen, int thuTuTramLen)
//{
// using (QLXeKhachEntities context = new QLXeKhachEntities())
// {
// return context.sp_GetTramXuong(maDiemDi, maDiemDen, thuTuTramLen).ToList();
// }
//}
public IList <sp_GetTramXuong_v2_Result> GetTramXuong(int maTramLen)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_GetTramXuong_v2(maTramLen).ToList());
}
}
public IList <sp_GetGioKH_Result> GetGioKH(string maDiemDi, string maDiemDen)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_GetGioKH(maDiemDi, maDiemDen).ToList());
}
}
public IList <vw_ve> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.vw_ve.ToList());
}
}
//public IList<sp_GetTramLen_Result> GetTramLen(string maDiemDi, string maDiemDen)
//{
// using (QLXeKhachEntities context = new QLXeKhachEntities())
// {
// return context.sp_GetTramLen(maDiemDi, maDiemDen).ToList();
// }
//}
public IList <sp_GetTramLen_v2_Result> GetTramLen()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_GetTramLen_v2().ToList());
}
}
//public IList<sp_Get_DiemDen_Result> GetDiemDen(string maDiemDi)
//{
// using (QLXeKhachEntities context = new QLXeKhachEntities())
// {
// return context.sp_Get_DiemDen(maDiemDi).ToList();
// }
//}
public IList <sp_Get_DiemDen_v2_Result> GetDiemDen(string maDiemDi, int maTramLen, int maTramXuong)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_Get_DiemDen_v2(maDiemDi, maTramLen, maTramXuong).ToList());
}
}
public IList <LOAIXE> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.LOAIXEs.Where(x => x.isDeleted == 0).ToList());
}
}
public IList <sp_getGheTrong_Result> GetGheTrong(int maChuyen)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_getGheTrong(maChuyen).ToList());
}
}
public LOAIXE Detail(int?id)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.LOAIXEs.Find(id));
}
}
public sp_Get_Ve_Detail_Result GetVeEdit(int mave)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_Get_Ve_Detail(mave).FirstOrDefault());
}
}
public IList <TINHTHANH> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.TINHTHANHs.Where(x => x.isDeleted != 1).ToList());
}
}
public sp_ve_info_Result Detail(int?id)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_ve_info(id).FirstOrDefault());
}
}
public IList <TINHTHANH> Search(string input)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.TINHTHANHs.Where(x => x.isDeleted != 1 && (x.TenTT.Contains(input) || input == "")).ToList());
}
}
public VE LoadVeWWithMaVe(int?id)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.VEs.Find(id));
}
}
public IList <KHACHHANG> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.KHACHHANGs.Where(x => x.isDeleted != 1).ToList());
}
}
public IList <sp_GetDiemDi_Result> GetDiemDi(int maTramLen, int maTramXuong)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.sp_GetDiemDi(maTramLen, maTramXuong).ToList());
}
}
public IList <KHACHHANG> Search(string input)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.KHACHHANGs.Where(x => x.isDeleted != 1 && (x.TenKH.Contains(input) || input == "")).ToList());
}
}
public IList <GIACOBAN> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.GIACOBANs.Where(x => x.isDeleted != 1).ToList());
}
}
public IList <LOTRINH> GetAll()
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.LOTRINHs.Where(x => x.isDeleted != 1).Include(x => x.TRAMXE).Include(x => x.TUYENXE).ToList());
}
}
public GIACOBAN Detail(string maTT1, string maTT2, int maLoai)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.GIACOBANs.Find(maTT1, maTT2, maLoai));
}
}
public IList <LOTRINH> Search(string input)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.LOTRINHs.Where(x => x.isDeleted != 1 && (x.TUYENXE.DiemDi.Contains(input) || x.TUYENXE.DiemDen.Contains(input) || x.TRAMXE.TenTram.Contains(input) || input == "")).ToList());
}
}
public IList <KHAOSAT> Detail(int?id)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
return(context.KHAOSATs.Where(x => x.MaKS == id).Include(x => x.NHANVIEN).ToList());
}
}
