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