Пример #1
0
 public IList <KHAOSAT> GetAll()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.KHAOSATs.Where(x => x.isDeleted == 0).Include(x => x.NHANVIEN).ToList());
     }
 }
Пример #2
0
 public static IList <TRAMXE> GetTramLen()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.TRAMXEs.Where(x => x.isDeleted != 1).ToList());
     }
 }
Пример #3
0
 public void Dispose()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         context.Dispose();
     }
 }
Пример #4
0
 public KHACHHANG GetKH_SDT(string sdt)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.KHACHHANGs.Where(x => x.SDT == sdt).FirstOrDefault());
     }
 }
Пример #5
0
 public KHACHHANG Detail(int?id)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.KHACHHANGs.Find(id));
     }
 }
Пример #6
0
 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());
     }
 }
Пример #7
0
 public TINHTHANH Detail(string id)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.TINHTHANHs.Find(id));
     }
 }
Пример #8
0
 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());
     }
 }
Пример #9
0
 public decimal?GetGiaVe(int maTramLen, int maTramXuong, int maChuyen)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.sp_GetGiaVe(maTramLen, maTramXuong, maChuyen).FirstOrDefault());
     }
 }
Пример #10
0
 //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());
     }
 }
Пример #11
0
 public IList <sp_GetGioKH_Result> GetGioKH(string maDiemDi, string maDiemDen)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.sp_GetGioKH(maDiemDi, maDiemDen).ToList());
     }
 }
Пример #12
0
 public IList <vw_ve> GetAll()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.vw_ve.ToList());
     }
 }
Пример #13
0
 //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());
     }
 }
Пример #14
0
        //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());
            }
        }
Пример #15
0
 public IList <LOAIXE> GetAll()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.LOAIXEs.Where(x => x.isDeleted == 0).ToList());
     }
 }
Пример #16
0
 public IList <sp_getGheTrong_Result> GetGheTrong(int maChuyen)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.sp_getGheTrong(maChuyen).ToList());
     }
 }
Пример #17
0
 public LOAIXE Detail(int?id)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.LOAIXEs.Find(id));
     }
 }
Пример #18
0
 public sp_Get_Ve_Detail_Result GetVeEdit(int mave)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.sp_Get_Ve_Detail(mave).FirstOrDefault());
     }
 }
Пример #19
0
 public IList <TINHTHANH> GetAll()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.TINHTHANHs.Where(x => x.isDeleted != 1).ToList());
     }
 }
Пример #20
0
 public sp_ve_info_Result Detail(int?id)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.sp_ve_info(id).FirstOrDefault());
     }
 }
Пример #21
0
 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());
     }
 }
Пример #22
0
 public VE LoadVeWWithMaVe(int?id)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.VEs.Find(id));
     }
 }
Пример #23
0
 public IList <KHACHHANG> GetAll()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.KHACHHANGs.Where(x => x.isDeleted != 1).ToList());
     }
 }
Пример #24
0
 public IList <sp_GetDiemDi_Result> GetDiemDi(int maTramLen, int maTramXuong)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.sp_GetDiemDi(maTramLen, maTramXuong).ToList());
     }
 }
Пример #25
0
 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());
     }
 }
Пример #26
0
 public IList <GIACOBAN> GetAll()
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.GIACOBANs.Where(x => x.isDeleted != 1).ToList());
     }
 }
Пример #27
0
 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());
     }
 }
Пример #28
0
 public GIACOBAN Detail(string maTT1, string maTT2, int maLoai)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.GIACOBANs.Find(maTT1, maTT2, maLoai));
     }
 }
Пример #29
0
 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());
     }
 }
Пример #30
0
 public IList <KHAOSAT> Detail(int?id)
 {
     using (QLXeKhachEntities context = new QLXeKhachEntities())
     {
         return(context.KHAOSATs.Where(x => x.MaKS == id).Include(x => x.NHANVIEN).ToList());
     }
 }