public static LichTrinh LayNgayKhoiHanhTheoTen(string ten) { using (var context = new VeTauEntities(false)) { return context.LichTrinhs.SingleOrDefault(i => i.TenLichTrinh == ten); } }
public static DoanTau LayDoanTau(string id) { using (var context = new VeTauEntities(false)) { return context.DoanTaus.SingleOrDefault(i => i.Id == id); } }
public static GiaoDich LayGiaoDich(int giaoDichId) { using (var context = new VeTauEntities(false)) { return context.GiaoDiches.SingleOrDefault(kh => kh.Id == giaoDichId); } }
public static LichTrinh LayTheoId(int id) { using (var context = new VeTauEntities(false)) { return context.LichTrinhs.SingleOrDefault(i => i.Id == id); } }
public static DoanTau_LoaiGhe Lay(string doanTauId, int loaiGheId) { using (var context = new VeTauEntities(false)) { return context.DoanTau_LoaiGhe.SingleOrDefault(i => i.DoanTauId == doanTauId && i.LoaiGheId == loaiGheId); } }
public static List<LoaiKhachHang> LayTatCa() { using (var context = new VeTauEntities(false)) { return context.LoaiKhachHangs.ToList(); } }
public static bool KiemTraTonTaiId(string id) { using (var context = new VeTauEntities(false)) { return context.NhanViens.SingleOrDefault(nv => nv.Id == id.ToUpper()) != null; } }
public static bool KiemTraTonTaiId(string id) { using (var context = new VeTauEntities(false)) { return context.KhachHangs.SingleOrDefault(kh => kh.Id == id.ToLower()) != null; } }
public static KhachHang LayKhachHang(string id) { using (var context = new VeTauEntities(false)) { return context.KhachHangs.SingleOrDefault(kh => kh.Id == id); } }
public static List<KhachHang> LayTatCa(bool? ruleDangNhap) { using (var context = new VeTauEntities(false)) { return context.KhachHangs.Where(kh => ruleDangNhap==null|| kh.RuleDangNhap == ruleDangNhap).ToList(); } }
public static NhanVien LayNhanVien(string id, string matKhau) { using (var context = new VeTauEntities(false)) { return context.NhanViens.SingleOrDefault(nv => nv.Id == id && nv.MatKhau == matKhau); } }
public static List<NhanVien> LayTatCa() { using (var context = new VeTauEntities(false)) { return context.NhanViens.ToList(); } }
public static List<NhanVien> LayDanhSachNhanVien(string phongBanId) { using (var context = new VeTauEntities(false)) { return context.NhanViens.Where(nv => nv.PhongBanID == phongBanId).ToList(); } }
public static List<DoanTau_LoaiGhe> LayTatCa(int? loaiGheId) { using (var context = new VeTauEntities(false)) { return context.DoanTau_LoaiGhe.Where(g=>loaiGheId==null||g.LoaiGheId==loaiGheId).ToList(); } }
public static TuyenDuong LayTuyenDuong(int gaDauId, int gaCuoiId) { using (var context = new VeTauEntities(false)) { return context.TuyenDuongs.SingleOrDefault(i => i.GaTauDauId==gaDauId && i.GaTauCuoiId==gaCuoiId); } }
public static bool TaoDoanTauLoaiGhe(DoanTau_LoaiGhe dtlg) { using (var context = new VeTauEntities(false)) { context.DoanTau_LoaiGhe.Add(dtlg); return context.SaveChanges() > 0; } }
public static PhongBan LayPhongBan(string id) { using (var context = new VeTauEntities(false)) { return context.PhongBans.SingleOrDefault(pb => pb.Id == id); } }
public static List<NhanVien> LayTatCa(string phongBanId) { using (var context = new VeTauEntities(false)) { return context.NhanViens.Where(nv => phongBanId==string.Empty || nv.PhongBanID == phongBanId).ToList(); } }
public static LichTrinh_TuyenDuong LayLichTrinhTuyenDuong(int id) { using (var context = new VeTauEntities(false)) { return context.LichTrinh_TuyenDuong.SingleOrDefault(i => i.Id == id); } }
public static LoaiGhe LayLoaiGhe(int id) { using (var context = new VeTauEntities(false)) { return context.LoaiGhes.SingleOrDefault(gt => gt.Id == id); } }
public static GaTau LayPGaTau(int id) { using (var context = new VeTauEntities(false)) { return context.GaTaus.SingleOrDefault(gt => gt.Id == id); } }
public static bool TaoKhachHang(KhachHang khachHangMoi) { using (var context = new VeTauEntities(false)) { context.KhachHangs.Add(khachHangMoi); return context.SaveChanges() > 0; } }
public static bool TaoNhanVien(NhanVien nhanVienMoi) { using (var context = new VeTauEntities(false)) { context.NhanViens.Add(nhanVienMoi); return context.SaveChanges()>0; } }
public static ICollection<ChiTietGiaoDich> LayChiTietGiaoDiches(int giaoDichId) { using (var context = new VeTauEntities(false)) { return context.ChiTietGiaoDiches.Where(ct=>ct.GiaoDichId==giaoDichId).ToList(); } }
public static TuyenDuong LayTuyenDuong() { using (var context = new VeTauEntities(false)) { return context.TuyenDuongs.FirstOrDefault(); } }
public static TuyenDuong LayTuyenDuong(int id) { using (var context = new VeTauEntities(false)) { return context.TuyenDuongs.SingleOrDefault(i => i.Id == id); } }
public static int Them(GiaoDich giaoDich) { using (var context = new VeTauEntities(false)) { context.GiaoDiches.Add(giaoDich); return context.SaveChanges(); } }
public static int ThemDoanTau(DoanTau doanTau) { using (var context = new VeTauEntities(false)) { context.DoanTaus.Add(doanTau); return context.SaveChanges(); } }
public static List<TuyenDuong> LayTatCa() { using (var context = new VeTauEntities(false)) { var result = context.TuyenDuongs.ToList(); return result; } }
public static int ThemTuyenDuong(TuyenDuong tuyenDuong) { using (var context = new VeTauEntities(false)) { context.TuyenDuongs.Add(tuyenDuong); return context.SaveChanges(); } }