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