public class LichSuHoaDon
{
[Key]
public int IDLichSuHoaDon { get; set; }
public string TrangThai { get; set; }
public DateTime NgayDatHang { get; set; }
public DateTime? NgayNhanHang { get; set; }
[ForeignKey("HoaDon")]
public int ID_HoaDon { get; set; }
public virtual HoaDon HoaDon { get; set; }
}
public class HoaDon
{
[Key]
public int ID_HoaDon { get; set; }
public int SoLuong { get; set; }
public decimal Gia { get; set; }
public decimal TongTien { get; set; }
public string TrangThai { get; set; }
public DateTime NgayVanChuyen { get; set; }
public DateTime NgayGiaoHangDuKien { get; set; }
public string PhieuVanChuyen { get; set; }
public string GhiChu { get; set; }
[ForeignKey("NguoiDung")]
public int IDNguoiDung { get; set; }
[ForeignKey("PhuongThucThanhToan")]
public int IDPhuongThucThanhToan { get; set; }
[ForeignKey("ThongTinVanChuyen")]
public int IDHTVC { get; set; }
[ForeignKey("PhieuGiamGia")]
public int? IDPhieuGiamGia { get; set; }
public virtual NguoiDung NguoiDung { get; set; }
public virtual ThongTinVanChuyen ThongTinVanChuyen { get; set; }
public virtual PhieuGiamGia PhieuGiamGia { get; set; }
public virtual ICollection<LichSuHoaDon> LichSuHoaDons { get; set; }
public virtual ICollection<HoaDonChiTiet> HoaDonChiTiets { get; set; }
}
public class PhieuGiamGia
{
[Key]
public int IDPhieuGiamGia { get; set; }
public string TenPhieuGiamGia { get; set; }
public decimal MucGiamGia { get; set; }
public string DieuKien { get; set; }
public DateTime NgayBatDau { get; set; }
public DateTime NgayKetThuc { get; set; }
public int SoLuong { get; set; }
[ForeignKey("KieuGiamGia")]
public int IdKieuGiamGia { get; set; }
public virtual KieuGiamGia KieuGiamGia { get; set; }
public virtual ICollection<HoaDon> HoaDons { get; set; }
}
public class KieuGiamGia
{
[Key]
public int IdKieuGiamGia { get; set; }
public string TenKieuGiamGia { get; set; }
public decimal SoTienGiamGia { get; set; }
public virtual ICollection<PhieuGiamGia> PhieuGiamGias { get; set; }
}
public class NguoiDung
{
[Key]
public int IDNguoiDung { get; set; }
public string TenNguoiDung { get; set; }
public string Email { get; set; }
public string MatKhau { get; set; }
public string HoTen { get; set; }
public string SoDienThoai { get; set; }
public string GioiTinh { get; set; }
public DateTime NgaySinh { get; set; }
public string CCCD { get; set; }
public string Avatar { get; set; }
[ForeignKey("VaiTro")]
public int IDVaiTro { get; set; }
public virtual VaiTro VaiTro { get; set; }
public virtual ICollection<HoaDon> HoaDons { get; set; }
}
public class VaiTro
{
[Key]
public int IDVaiTro { get; set; }
public string TenVaiTro { get; set; }
public virtual ICollection<NguoiDung> NguoiDungs { get; set; }
}
public class ThongTinVanChuyen
{
[Key]
public int IDTTC { get; set; }
public string DiaChi { get; set; }
public string TenNguoiNhan { get; set; }
public string SDT { get; set; }
public string TrangThai { get; set; }
public string Tinh { get; set; }
public string Huyen { get; set; }
public string Xa { get; set; }
[ForeignKey("NguoiDung")]
public int IDNguoiDung { get; set; }
public virtual NguoiDung NguoiDung { get; set; }
}
public class SanPham
{
[Key]
public int IdSanPham { get; set; }
public string TenSanPham { get; set; }
public string MoTa { get; set; }
public string TrangThai { get; set; }
[ForeignKey("LoaiSanPham")]
public int IdLoaiSP { get; set; }
public virtual LoaiSanPham LoaiSanPham { get; set; }
public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }
public virtual ICollection<SanPhamKhuyenMai> SanPhamKhuyenMais { get; set; }
}
public class LoaiSanPham
{
[Key]
public int IdLoaiSP { get; set; }
public string TenLoaiSP { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<SanPham> SanPhams { get; set; }
}
public class SanPhamChiTiet
{
[Key]
public int IdSPChiTiet { get; set; }
public decimal Gia { get; set; }
public int SoLuong { get; set; }
public string ThongTinThem { get; set; }
[ForeignKey("SanPham")]
public int IdSanPham { get; set; }
[ForeignKey("Mau")]
public int IdMau { get; set; }
[ForeignKey("Led")]
public int IdLed { get; set; }
[ForeignKey("LoaiSanPham")]
public int IdLoaiSP { get; set; }
[ForeignKey("Hang")]
public int IdHang { get; set; }
[ForeignKey("Keycap")]
public int IdKeycap { get; set; }
public virtual SanPham SanPham { get; set; }
public virtual Mau Mau { get; set; }
public virtual Led Led { get; set; }
public virtual LoaiSanPham LoaiSanPham { get; set; }
public virtual Hang Hang { get; set; }
public virtual Keycap Keycap { get; set; }
}
public class Mau
{
[Key]
public int IdMau { get; set; }
public string TenMau { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }
}
public class Led
{
[Key]
public int IdLed { get; set; }
public string TenLed { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }
}
public class Hang
{
[Key]
public int IdHang { get; set; }
public string TenHang { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }
}
public class Keycap
{
[Key]
public int IdKeycap { get; set; }
public string TenKeycap { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }
}
public class KhuyenMai
{
[Key]
public int IDKhuyenMai { get; set; }
public string TenKhuyenMai { get; set; }
public decimal MucGiamGia { get; set; }
public DateTime NgayBatDau { get; set; }
public DateTime NgayKetThuc { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<SanPhamKhuyenMai> SanPhamKhuyenMais { get; set; }
}
public class SanPhamKhuyenMai
{
[Key]
public int IdSPKhuyenMai { get; set; }
[ForeignKey("SanPham")]
public int IdSanPham { get; set; }
[ForeignKey("KhuyenMai")]
public int IdKhuyenMai { get; set; }
public virtual SanPham SanPham { get; set; }
public virtual KhuyenMai KhuyenMai { get; set; }
}
public class HinhAnh
{
[Key]
public int IdHinhAnh { get; set; }
public string ImageUrl { get; set; }
[ForeignKey("SanPham")]
public int IdSanPham { get; set; }
public virtual SanPham SanPham { get; set; }
}
public class HoaDonChiTiet
{
[Key]
public int IDHoaDonChiTiet { get; set; }
[ForeignKey("HoaDon")]
public int ID_HoaDon { get; set; }
[ForeignKey("SanPhamChiTiet")]
public int IdSPChiTiet { get; set; }
public int SoLuong { get; set; }
public decimal Gia { get; set; }
public decimal TongTien { get; set; }
public virtual HoaDon HoaDon { get; set; }
public virtual SanPhamChiTiet SanPhamChiTiet { get; set; }
}
public class GioHang
{
[Key]
public int IDGioHang { get; set; }
[ForeignKey("NguoiDung")]
public int IDNguoiDung { get; set; }
public string TrangThai { get; set; }
public DateTime NgayTao { get; set; }
public virtual NguoiDung NguoiDung { get; set; }
public virtual ICollection<GioHangChiTiet> GioHangChiTiets { get; set; }
}
public class GioHangChiTiet
{
[Key]
public int IDGioHangChiTiet { get; set; }
[ForeignKey("GioHang")]
public int ID_GioHang { get; set; }
[ForeignKey("SanPhamChiTiet")]
public int IdSPChiTiet { get; set; }
public int SoLuong { get; set; }
public decimal Gia { get; set; }
public decimal TongTien { get; set; }
public virtual GioHang GioHang { get; set; }
public virtual SanPhamChiTiet SanPhamChiTiet { get; set; }
}
public class PhuongThucThanhToan
{
[Key]
public int IDPhuongThucThanhToan { get; set; }
public string TenPhuongThucThanhToan { get; set; }
public string TrangThai { get; set; }
public virtual ICollection<HoaDon> HoaDons { get; set; }
}