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()); } }