public IEnumerable <LoaiSanPham_OBJ> TimKiemThongTinSanPham(string TuKhoa) { try { MayTinhDbContext db = new MayTinhDbContext(); IList <LoaiSanPham_OBJ> DanhSach = new List <LoaiSanPham_OBJ>(); TuKhoa = TuKhoa.Trim(); if (string.IsNullOrEmpty(TuKhoa) == false) { var query = from item in db.LoaiSanPhams where item.TenLoaiSanPham.Trim() == TuKhoa || item.DonViTinh.Trim() == TuKhoa || item.GhiChu.Trim() == TuKhoa select item; foreach (var item in query) { DanhSach.Add(Mapper(item)); } return(DanhSach); } return(null); } catch { return(null); } }
public IEnumerable <NhaSanXuat_OBJ> TimKiemThongTinNhaSanXuat(string TuKhoa) { try { MayTinhDbContext db = new MayTinhDbContext(); IList <NhaSanXuat_OBJ> DanhSach = new List <NhaSanXuat_OBJ>(); TuKhoa = TuKhoa.Trim(); if (string.IsNullOrEmpty(TuKhoa) == false) { var query = from item in db.NhaSanXuats where item.TenNhaSanXuat.Trim() == TuKhoa || item.QuocGia.Trim() == TuKhoa select item; foreach (var item in query) { DanhSach.Add(Mapper(item)); } return(DanhSach); } return(null); } catch { return(null); } }
public IEnumerable <TaiKhoan_OBJ> TimKiemThongTinTaiKhoan(string TuKhoa) { try { MayTinhDbContext db = new MayTinhDbContext(); IList <TaiKhoan_OBJ> DanhSach = new List <TaiKhoan_OBJ>(); TuKhoa = TuKhoa.Trim(); if (string.IsNullOrEmpty(TuKhoa) == false) { var query = from item in db.TaiKhoans where item.TenTaiKhoan.Trim() == TuKhoa || item.TenNguoiDung.Trim() == TuKhoa || item.GioiTinh.Trim() == TuKhoa || item.DiaChi.Trim() == TuKhoa || item.DienThoai.Trim() == TuKhoa select item; foreach (var item in query) { DanhSach.Add(Mapper(item)); } return(DanhSach); } return(null); } catch { return(null); } }
public LoaiSanPham_OBJ Xoa(int id) { MayTinhDbContext db = new MayTinhDbContext(); Base.LoaiSanPham item = db.LoaiSanPhams.Find(id); if (item == null) { return(null); } db.LoaiSanPhams.Remove(item); db.SaveChanges(); return(Mapper(item)); }
public TaiKhoan_OBJ Xoa(string TenTaiKhoan) { MayTinhDbContext db = new MayTinhDbContext(); Base.TaiKhoan item = db.TaiKhoans.Find(TenTaiKhoan); if (item == null) { return(null); } db.TaiKhoans.Remove(item); db.SaveChanges(); return(Mapper(item)); }
public NhaSanXuat_OBJ Xoa(int id) { MayTinhDbContext db = new MayTinhDbContext(); Base.NhaSanXuat item = db.NhaSanXuats.Find(id); if (item == null) { return(null); } db.NhaSanXuats.Remove(item); db.SaveChanges(); return(Mapper(item)); }
public bool ThemMoi(LoaiSanPham_OBJ obj) { try { MayTinhDbContext db = new MayTinhDbContext(); db.LoaiSanPhams.Add(MapperBase(obj)); db.SaveChanges(); return(true); } catch { return(false); } }
public bool ThemMoi(ThongSoKyThuat_OBJ obj) { try { MayTinhDbContext db = new MayTinhDbContext(); db.ThongSoKyThuats.Add(MapperBase(obj)); db.SaveChanges(); return(true); } catch { return(false); } }
public TaiKhoan_OBJ GetMa(string TenTaiKhoan) { try { MayTinhDbContext db = new MayTinhDbContext(); var items = (from item in db.TaiKhoans where item.TenTaiKhoan == TenTaiKhoan select item).SingleOrDefault(); return(Mapper(items)); } catch { return(null); } }
public NhaSanXuat_OBJ GetMa(int MaNhaSanXuat) { try { MayTinhDbContext db = new MayTinhDbContext(); var items = (from item in db.NhaSanXuats where item.MaNhaSanXuat == MaNhaSanXuat select item).SingleOrDefault(); return(Mapper(items)); } catch { return(null); } }
public ThongSoKyThuat_OBJ GetMa(int MaSanPham, int MaMay) { try { MayTinhDbContext db = new MayTinhDbContext(); var items = (from item in db.ThongSoKyThuats where item.MaSanPham == MaSanPham && item.MaMay == MaMay select item).SingleOrDefault(); return(Mapper(items)); } catch { return(null); } }
public LoaiSanPham_OBJ GetMa(int MaLoaiSanPham) { try { MayTinhDbContext db = new MayTinhDbContext(); var items = (from item in db.LoaiSanPhams where item.MaLoaiSanPham == MaLoaiSanPham select item).SingleOrDefault(); return(Mapper(items)); } catch { return(null); } }
public bool CapNhap(ThongSoKyThuat_OBJ obj) { try { MayTinhDbContext db = new MayTinhDbContext(); Base.ThongSoKyThuat item = MapperBase(obj); db.Entry(item).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); } catch { return(false); } }
public ThongSoKyThuat_OBJ Xoa(int MaSanPham, int MaMay) { MayTinhDbContext db = new MayTinhDbContext(); Base.ThongSoKyThuat item = ( from items in db.ThongSoKyThuats where items.MaSanPham == MaSanPham && items.MaMay == MaMay select items).SingleOrDefault(); if (item == null) { return(null); } db.ThongSoKyThuats.Remove(item); db.SaveChanges(); return(Mapper(item)); }
public IEnumerable <LoaiSanPham_OBJ> HienThiDanhSachLoaiSanPham() { try { MayTinhDbContext db = new MayTinhDbContext(); IList <LoaiSanPham_OBJ> DanhSach = new List <LoaiSanPham_OBJ>(); var query = db.LoaiSanPhams.ToList(); foreach (var item in query) { DanhSach.Add(Mapper(item)); } return(DanhSach); } catch { return(null); } }
public IEnumerable <TaiKhoan_OBJ> HienThiDanhSachTaiKhoan() { try { MayTinhDbContext db = new MayTinhDbContext(); IList <TaiKhoan_OBJ> DanhSach = new List <TaiKhoan_OBJ>(); var query = db.TaiKhoans.ToList(); foreach (var item in query) { DanhSach.Add(Mapper(item)); } return(DanhSach); } catch { return(null); } }
public TaiKhoanModels() { MayTinhDbContext = new MayTinhDbContext(); }