public static List <LaptopDTO> GetLaptops()
{
List <LaptopDTO> laptops = null;
using (var db = new ThietBiOnlineEntities())
{
laptops = (from laptop in db.Laptops.AsNoTracking()
orderby laptop.ID descending
select new LaptopDTO
{
ID = laptop.ID,
TenSanPham = laptop.TenSanPham,
GiaSanPham = laptop.GiaSanPham,
SoLuong = laptop.SoLuong,
HinhAnhSanPham = laptop.HinhAnhSanPham,
IDLoaiSanPham = laptop.IDLoaiSanPham,
ManHinh = laptop.ManHinh,
CPU = laptop.CPU,
RAM = laptop.RAM,
VGA = laptop.VGA,
Connection = laptop.Connection,
HDH = laptop.HDH,
Nang = laptop.Nang
}).Take(6).ToList();
}
return(laptops);
}
public static List <PhoneDTO> GetPhones()
{
List <PhoneDTO> phones = null;
using (var db = new ThietBiOnlineEntities())
{
phones = (from phone in db.Phones.AsNoTracking()
orderby phone.ID descending
select new PhoneDTO
{
ID = phone.ID,
TenSanPham = phone.TenSanPham,
GiaSanPham = phone.GiaSanPham,
SoLuong = phone.SoLuong,
HinhAnhSanPham = phone.HinhAnhSanPham,
IDLoaiSanPham = phone.IDLoaiSanPham,
ManHinh = phone.ManHinh,
CameraTruoc = phone.CameraTruoc,
CameraSau = phone.CameraSau,
RAM = phone.RAM,
BoNhoTrong = phone.BoNhoTrong,
CPU = phone.CPU,
GPU = phone.GPU,
Pin = phone.Pin,
HDH = phone.HDH
}).Take(6).ToList();
}
return(phones);
}
public static List <TabletDTO> GetTablets()
{
List <TabletDTO> tablets = null;
using (var db = new ThietBiOnlineEntities())
{
tablets = (from tablet in db.Tablets.AsNoTracking()
orderby tablet.ID descending
select new TabletDTO
{
ID = tablet.ID,
TenSanPham = tablet.TenSanPham,
GiaSanPham = tablet.GiaSanPham,
SoLuong = tablet.SoLuong,
HinhAnhSanPham = tablet.HinhAnhSanPham,
IDLoaiSanPham = tablet.IDLoaiSanPham,
ManHinh = tablet.ManHinh,
CameraTruoc = tablet.CameraTruoc,
CameraSau = tablet.CameraSau,
CPU = tablet.CPU,
GPU = tablet.GPU,
RAM = tablet.RAM,
BoNhoTrong = tablet.BoNhoTrong,
Connection = tablet.Connection,
Pin = tablet.Pin,
HDH = tablet.HDH
}).Take(6).ToList();
}
return(tablets);
}
public static List <LaptopDTO> GetALLaptops()
{
List <LaptopDTO> laptops = null;
using (var db = new ThietBiOnlineEntities())
{
laptops = db.Laptops.AsNoTracking()
.Select(x => new LaptopDTO
{
ID = x.ID,
TenSanPham = x.TenSanPham,
GiaSanPham = x.GiaSanPham,
SoLuong = x.SoLuong,
HinhAnhSanPham = x.HinhAnhSanPham,
IDLoaiSanPham = x.IDLoaiSanPham,
ManHinh = x.ManHinh,
CPU = x.CPU,
RAM = x.RAM,
VGA = x.VGA,
Connection = x.Connection,
HDH = x.HDH,
Nang = x.Nang
})
.ToList();
}
return(laptops);
}
public static List <TabletDTO> GetAllTablet()
{
List <TabletDTO> tablets = null;
using (var db = new ThietBiOnlineEntities())
{
tablets = db.Tablets.AsNoTracking()
.Select(x => new TabletDTO
{
ID = x.ID,
TenSanPham = x.TenSanPham,
GiaSanPham = x.GiaSanPham,
SoLuong = x.SoLuong,
HinhAnhSanPham = x.HinhAnhSanPham,
IDLoaiSanPham = x.IDLoaiSanPham,
ManHinh = x.ManHinh,
CameraTruoc = x.CameraTruoc,
CameraSau = x.CameraSau,
CPU = x.CPU,
GPU = x.GPU,
RAM = x.RAM,
BoNhoTrong = x.BoNhoTrong,
Connection = x.Connection,
Pin = x.Pin,
HDH = x.HDH
})
.ToList();
}
return(tablets);
}
public static List <PhoneDTO> GetALLPhone()
{
List <PhoneDTO> phones = null;
using (var db = new ThietBiOnlineEntities())
{
phones = db.Phones.AsNoTracking()
.Select(x => new PhoneDTO
{
ID = x.ID,
TenSanPham = x.TenSanPham,
GiaSanPham = x.GiaSanPham,
SoLuong = x.SoLuong,
HinhAnhSanPham = x.HinhAnhSanPham,
IDLoaiSanPham = x.IDLoaiSanPham,
ManHinh = x.ManHinh,
CameraTruoc = x.CameraTruoc,
CameraSau = x.CameraSau,
RAM = x.RAM,
BoNhoTrong = x.BoNhoTrong,
CPU = x.CPU,
GPU = x.GPU,
Pin = x.Pin,
HDH = x.HDH
})
.ToList();
}
return(phones);
}
public static int InsertUser(User user)
{
using (var db = new ThietBiOnlineEntities())
{
db.Users.Add(user);
db.SaveChanges();
return(user.ID);
}
}
public static Phone GetSinglePhone(int ID)
{
Phone phone = null;
using (var db = new ThietBiOnlineEntities())
{
phone = db.Phones.AsNoTracking().SingleOrDefault(x => x.ID == ID);
}
return(phone);
}
public static List <Phone> Search(string valueToFind)
{
List <Phone> phones = null;
using (var db = new ThietBiOnlineEntities())
{
phones = db.Phones.Where(x => x.TenSanPham.Contains(valueToFind)).ToList();
}
return(phones);
}
public static DonHang GetSingleDonHang(int ID)
{
DonHang donhang = null;
using (var db = new ThietBiOnlineEntities())
{
donhang = db.DonHangs.AsNoTracking().SingleOrDefault(x => x.ID == ID);
}
return(donhang);
}
public static List <DonHang> GetALLDonHang()
{
List <DonHang> donHangs = null;
using (var db = new ThietBiOnlineEntities())
{
donHangs = db.DonHangs.AsNoTracking().ToList();
}
return(donHangs);
}
public static List <Laptop> GetAll()
{
List <Laptop> laptops = null;
using (var db = new ThietBiOnlineEntities())
{
laptops = db.Laptops.OrderBy(x => x.ID).ToList();
}
return(laptops);
}
public static Laptop GetSingleLaptop(int ID, string IDLoaiSanPham)
{
Laptop laptop = null;
using (var db = new ThietBiOnlineEntities())
{
laptop = db.Laptops.AsNoTracking().SingleOrDefault(x => (x.ID == ID) && (x.IDLoaiSanPham == IDLoaiSanPham));
}
return(laptop);
}
public static Laptop GetSingleLaptop(int ID)
{
Laptop laptop = null;
using (var db = new ThietBiOnlineEntities())
{
laptop = db.Laptops.AsNoTracking().SingleOrDefault(x => x.ID == ID);
}
return(laptop);
}
public static List <Laptop> Search(string valueToFind)
{
List <Laptop> laptops = null;
using (var db = new ThietBiOnlineEntities())
{
laptops = db.Laptops.Where(x => x.TenSanPham.Contains(valueToFind)).ToList();
}
return(laptops);
}
public static List <Phone> GetAll()
{
List <Phone> phones = null;
using (var db = new ThietBiOnlineEntities())
{
phones = db.Phones.OrderBy(x => x.ID).ToList();
}
return(phones);
}
public static User GetByID(string userName)
{
User user = null;
using (var db = new ThietBiOnlineEntities())
{
user = db.Users.SingleOrDefault(x => x.UserName == userName);
}
return(user);
}
public static Tablet GetSingleTablet(int ID)
{
Tablet tablet = null;
using (var db = new ThietBiOnlineEntities())
{
tablet = db.Tablets.AsNoTracking().SingleOrDefault(x => x.ID == ID);
}
return(tablet);
}
public static List <Tablet> GetAll()
{
List <Tablet> tablets = null;
using (var db = new ThietBiOnlineEntities())
{
tablets = db.Tablets.OrderBy(x => x.ID).ToList();
}
return(tablets);
}
public static Tablet GetSingleTablet(int ID, string IDLoaiSanPham)
{
Tablet tablet = null;
using (var db = new ThietBiOnlineEntities())
{
tablet = db.Tablets.AsNoTracking().SingleOrDefault(x => (x.ID == ID) && (x.IDLoaiSanPham == IDLoaiSanPham));
}
return(tablet);
}
public static List <Tablet> Search(string valueToFind)
{
List <Tablet> tablets = null;
using (var db = new ThietBiOnlineEntities())
{
tablets = db.Tablets.Where(x => x.TenSanPham.Contains(valueToFind)).ToList();
}
return(tablets);
}
public static bool InsertIntoLaptop(Laptop laptop)
{
var result = false;
using (var db = new ThietBiOnlineEntities())
{
db.Laptops.Add(laptop);
result = db.SaveChanges() > 0 ? true : false;
}
return(result);
}
public static int InsertIntoDonHang(DonHang donHang)
{
var result = 0;
using (var db = new ThietBiOnlineEntities())
{
db.DonHangs.Add(donHang);
result = db.SaveChanges();
}
return(result);
}
public static int InsertIntoChiTietDonHangLaptop(ChiTietDonHangLaptop chiTietDonHangLaptop)
{
var result = 0;
using (var db = new ThietBiOnlineEntities())
{
db.ChiTietDonHangLaptops.Add(chiTietDonHangLaptop);
result = db.SaveChanges();
}
return(result);
}
public static bool InsertIntoPhone(Phone phone)
{
var result = false;
using (var db = new ThietBiOnlineEntities())
{
db.Phones.Add(phone);
result = db.SaveChanges() > 0 ? true : false;
}
return(result);
}
public static bool UpdateIntoTablet(Tablet tablet)
{
var result = false;
using (var db = new ThietBiOnlineEntities())
{
db.Entry(tablet).State = System.Data.Entity.EntityState.Modified;
result = db.SaveChanges() > 0 ? true : false;
}
return(result);
}
public static Phone GetSinglePhone(int ID, string IDLoaiSanPham)
{
Phone phone = null;
using (var db = new ThietBiOnlineEntities())
{
phone = db.Phones.AsNoTracking().SingleOrDefault(x => (x.ID == ID) &&
(x.IDLoaiSanPham == IDLoaiSanPham));
}
return(phone);
}
public static bool InsertIntoTablet(Tablet tablet)
{
var result = false;
using (var db = new ThietBiOnlineEntities())
{
db.Tablets.Add(tablet);
result = db.SaveChanges() > 0 ? true : false;
}
return(result);
}
public static bool DeleteIntoTablet(int ID)
{
var result = false;
using (var db = new ThietBiOnlineEntities())
{
var tablet = db.Tablets.SingleOrDefault(x => x.ID == ID);
db.Tablets.Remove(tablet);
result = db.SaveChanges() > 0 ? true : false;
}
return(result);
}
public static int CheckUser(string userName, string password)
{
User user = null;
using (var db = new ThietBiOnlineEntities())
{
user = db.Users.SingleOrDefault(x => x.UserName == userName);
}
if (user == null)
{
return(0);
}
else
{
if (user.Password == password)
{
return(1);
}
else
{
return(-2);
}
}
}