public static Get_TKNhanVien_Result GetNhanVien(int value) { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Get_TKNhanVien(value).FirstOrDefault()); } }
public static List <hd_Result> Search_HoaDonList(string value) { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.hd().Where(p => p.ten_HK.Contains(value)).ToList()); } }
public static List <NhanVien> Search_TTNhanVien(string value) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.NhanVien.Where(p => p.ten_NV.Contains(value)).ToList()); } } catch (Exception ex) { return(null); } }
public static List <CThd_Result> get_CTListHd() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.CThd().ToList()); } }catch (Exception ex) { return(null); } }
public static List <HD_BanHang> Get_ListHD() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.HD_BanHang.ToList()); } }catch (Exception) { return(null); } }
public static int Get_MaHangSX() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Hang_SX.Max(p => p.ma_Hang)); } } catch (Exception) { return(3000); } }
public static List <ChiTiet_HD_Result> get_CTListHd() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { List <ChiTiet_HD_Result> lst = entities.ChiTiet_HD().ToList(); return(lst); } }catch (Exception) { return(null); } }
public static List <Nha_CungCap> Search_NhaCC(string key) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Nha_CungCap.Where(p => p.ten_NCC.Contains(key)).ToList()); } } catch (Exception) { return(null); } }
public static int Get_MaKhachHang() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.KhachHang.Max(p => p.ma_KH)); } } catch (Exception) { return(7000); } }
public static SanPham Get_SanPham(int maSP) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.SanPham.Where(p => p.ma_SP == maSP).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static List <Get_SanPhamList_Result> Get_SanPhamList() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Get_SanPhamList().ToList()); } } catch (Exception) { return(null); } }
public static int Get_MaDanhMuc() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.DanhMuc.Max(p => p.ma_DM)); } } catch (Exception) { return(4000); } }
public static Gia_SP Get_GiaSP(int ma_Gia) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Gia_SP.Where(p => p.ma_GiaSP == ma_Gia).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static Loai_SP Get_LoaiSP(int maLoai) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Loai_SP.Where(p => p.ma_Loai == maLoai).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static int Get_MaLoaiSP() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Loai_SP.Max(p => p.ma_Loai)); } } catch (Exception) { return(2000); } }
public static List <Loai_SP> Search_LoaiSP(string key) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Loai_SP.Where(p => p.ten_Loai.Contains(key)).ToList()); } } catch (Exception) { return(null); } }
public static List <Loai_SP> Get_LoaiSPList() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Loai_SP.ToList()); } } catch (Exception) { return(null); } }
public static Nha_CungCap Get_NhaCungCap(int ma_NCC) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Nha_CungCap.Where(p => p.ma_NCC == ma_NCC).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static int Get_MaNhaCungCap() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Nha_CungCap.Max(p => p.ma_NCC)); } } catch (Exception) { return(1000); } }
public static List <DanhMuc> Get_DanhMucList() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.DanhMuc.ToList()); } } catch (Exception) { return(null); } }
public static List <DanhMuc> Search_DanhMuc(string key) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.DanhMuc.Where(p => p.ten_DM.Contains(key)).ToList()); } } catch (Exception) { return(null); } }
public static int Get_MaGiaSP() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Gia_SP.Max(p => p.ma_GiaSP)); } } catch (Exception) { return(10000); } }
public static DanhMuc Get_DanhMuc(int maDM) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.DanhMuc.Where(p => p.ma_DM == maDM).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static List <NhanVien> getNhanvien_List() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.NhanVien.ToList()); } } catch { return(null); } }
public static int Get_MaSanPham() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.SanPham.Max(p => p.ma_SP)); } } catch (Exception) { return(14000); } }
public static List <Hang_SX> Search_HangSX(string key) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Hang_SX.Where(p => p.ten_Hang.Contains(key)).ToList()); } } catch (Exception) { return(null); } }
public static List <KhachHang> Get_KhachHangList() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.KhachHang.ToList()); } } catch (Exception) { return(null); } }
public static Hang_SX Get_HangSX(int ma_Hang) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Hang_SX.Where(p => p.ma_Hang == ma_Hang).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static KhachHang Get_KhachHang(int maKH) { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.KhachHang.Where(p => p.ma_KH == maKH).FirstOrDefault()); } } catch (Exception) { return(null); } }
public static List <Nha_CungCap> Get_NhaCungCapList() { try { using (CuaHang_XeMayEntities entities = new CuaHang_XeMayEntities()) { return(entities.Nha_CungCap.ToList()); } } catch (Exception) { return(null); } }