public List <Sanpham> TimKiemSanPham(string key)
{
List <Sanpham> List = new List <Sanpham>();
var dbContext = new shopContext();
if (key == "xxx")
{
var sanpham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
select new
{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
PhanLoaiId = sp.PhanLoaiId
});
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
sp.PhanLoaiId = item.PhanLoaiId;
Hinhanh h = new Hinhanh();
h.TenFile = item.HinhAnh;
sp.HinhAnh = h;
List.Add(sp);
}
}
else
{
var sanpham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
where sp.TenSanPham.StartsWith(key)
select new
{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
PhanLoaiId = sp.PhanLoaiId
});
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
sp.PhanLoaiId = item.PhanLoaiId;
Hinhanh h = new Hinhanh();
h.TenFile = item.HinhAnh;
sp.HinhAnh = h;
List.Add(sp);
}
}
return(List);
}
public async Task <IActionResult> Edit(string id, [Bind("HaMa,HaTen,HaUrl")] Hinhanh hinhanh)
{
if (id != hinhanh.HaMa)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(hinhanh);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HinhanhExists(hinhanh.HaMa))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(hinhanh));
}
public List <Sanpham> ThemGioHang(int maspp)
{
var dbContext = new shopContext();
var sanpham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
where sp.SanPhamId == maspp
select new
{
SanPhamId = sp.SanPhamId,
TenSp = sp.TenSanPham,
HinhAnh = h.TenFile,
GiaBanLe = sp.GiaBanLe,
});
List <Sanpham> ListSP = new List <Sanpham>();
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSp;
sp.GiaBanLe = item.GiaBanLe;
Hinhanh h = new Hinhanh();
h.TenFile = item.HinhAnh;
sp.HinhAnh = h;
ListSP.Add(sp);
}
return(ListSP);
}
public IActionResult SuaSanPham(Sanpham model, string TenAnh, string[] tenKichThuoc, float[] giaThem)
{
var dbContext = new shopContext();
if (ModelState.IsValid)
{
// kiểm tra hình ảnh đã có trong database chưa
var dsHinhAnh = (from dsha in dbContext.Hinhanh
where dsha.TenFile == TenAnh
select dsha).ToList();
// thêm ảnh vào table hinhanh
if (dsHinhAnh.Count != 0)
{
var hinhanh = new Hinhanh()
{
TenFile = TenAnh
};
dbContext.Hinhanh.Add(hinhanh);
dbContext.SaveChanges();
}
//lấy id của ảnh
var anh = (from ha in dbContext.Hinhanh
where ha.TenFile == TenAnh
select ha).ToList();
//sua sản phẩm
var sanpham = dbContext.Sanpham.First(a => a.SanPhamId == model.SanPhamId);
sanpham.TenSanPham = model.TenSanPham;
sanpham.Mota = model.Mota;
sanpham.GiaBanLe = model.GiaBanLe;
sanpham.TrangThai = model.TrangThai;
sanpham.PhanLoaiId = model.PhanLoaiId;
sanpham.KhuyenMaiId = model.KhuyenMaiId;
sanpham.HinhAnhId = anh[0].HinhAnhId;
dbContext.SaveChanges();
//thêm kích thước vào bảng kichthuoc
var x = (from sp in dbContext.Sanpham
where sp.TenSanPham == model.TenSanPham
select sp).ToList();
for (int i = 0; i < tenKichThuoc.Length; i++)
{
//lấy id của kích thước tương ứng với tên kích thước
var kichthuoc1 = (from kt in dbContext.Kichthuoc
where kt.TenKichThuoc == tenKichThuoc[i] && kt.SanPhamId == model.SanPhamId
select kt).ToList();
var kichthuoc = dbContext.Kichthuoc.First(a => a.KichThuocid == kichthuoc1[0].KichThuocid);
kichthuoc.GiaThem = giaThem[i];
dbContext.SaveChanges();
}
return(RedirectToAction("Suasanpham", "sanpham", new { id = model.SanPhamId, success = "Sửa sản phẩm thành công" }));
}
return(RedirectToAction("Suasanpham", "sanpham", new { id = model.SanPhamId, error = "Sửa sản phẩm không thành công" }));
}
public async Task <IActionResult> Create([Bind("HaMa,HaTen,HaUrl")] Hinhanh hinhanh)
{
if (ModelState.IsValid)
{
_context.Add(hinhanh);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(hinhanh));
}
public IActionResult ThemSanPham(Sanpham model, string TenAnh, string[] tenKichThuoc, float[] giaThem)
{
var dbContext = new shopContext();
if (ModelState.IsValid)
{
// thêm ảnh vào table hinhanh
var hinhanh = new Hinhanh()
{
TenFile = TenAnh
};
dbContext.Hinhanh.Add(hinhanh);
dbContext.SaveChanges();
//lấy id của ảnh
var anh = (from ha in dbContext.Hinhanh
where ha.TenFile == TenAnh
select ha).ToList();
//thêm sản phẩm
var sanpham = new Sanpham()
{
TenSanPham = model.TenSanPham,
Mota = model.Mota,
GiaBanLe = model.GiaBanLe,
TrangThai = model.TrangThai,
PhanLoaiId = model.PhanLoaiId,
KhuyenMaiId = model.KhuyenMaiId,
HinhAnhId = anh[0].HinhAnhId
};
dbContext.Sanpham.Add(sanpham);
dbContext.SaveChanges();
//thêm kích thước vào bảng kichthuoc
var x = (from sp in dbContext.Sanpham
where sp.TenSanPham == model.TenSanPham
select sp).ToList();
for (int i = 0; i < tenKichThuoc.Length; i++)
{
var kichthuoc = new Kichthuoc()
{
SanPhamId = x[0].SanPhamId,
TenKichThuoc = tenKichThuoc[i],
GiaThem = giaThem[i]
};
dbContext.Kichthuoc.Add(kichthuoc);
dbContext.SaveChanges();
}
return(RedirectToAction("Themsanpham", "sanpham", new { success = "Thêm sản phẩm thành công" }));
}
return(RedirectToAction("Themsanpham", "sanpham", new { error = "Thêm sản phẩm không thành công" }));
}
public IActionResult XemDanhSachSanPham()
{
var dbContext = new shopContext();
var sanpham = (from sp in dbContext.Sanpham
join pl in dbContext.Phanloai
on sp.PhanLoaiId equals pl.PhanLoaiId
join ha in dbContext.Hinhanh
on sp.HinhAnhId equals ha.HinhAnhId
join km in dbContext.Khuyenmai
on sp.KhuyenMaiId equals km.KhuyenMaiId into x
from subpet in x.DefaultIfEmpty()
select new
{
idSanPham = sp.SanPhamId,
tensp = sp.TenSanPham,
mota = sp.Mota,
giabanle = sp.GiaBanLe,
trangThai = sp.TrangThai,
TenLoai = pl.TenLoai,
phantramgiam = subpet.PhanTramGiam,
hinhanh = ha.TenFile
});
List <Sanpham> List = new List <Sanpham>();
foreach (var item in sanpham)
{
Sanpham sp = new Sanpham();
Hinhanh ha = new Hinhanh();
Khuyenmai km = new Khuyenmai();
Phanloai pl = new Phanloai();
sp.SanPhamId = item.idSanPham;
sp.TenSanPham = item.tensp;
sp.Mota = item.mota;
sp.GiaBanLe = item.giabanle;
sp.TrangThai = item.trangThai;
pl.TenLoai = item.TenLoai;
km.PhanTramGiam = item.phantramgiam * 100;
ha.TenFile = item.hinhanh;
sp.PhanLoai = pl;
sp.HinhAnh = ha;
sp.KhuyenMai = km;
List.Add(sp);
}
ViewBag.sanpham = List;
return(View());
}
public IActionResult XemChiTietHoaDon(int id)
{
var dbContext = new shopContext();
var cthd = (from ct in dbContext.Chitiethoadon
join sp in dbContext.Sanpham
on ct.SanPhamId equals sp.SanPhamId
join kt in dbContext.Kichthuoc
on ct.KichThuocId equals kt.KichThuocid
join ha in dbContext.Hinhanh
on sp.HinhAnhId equals ha.HinhAnhId
where ct.HoaDonId == id
select new{
tensp = sp.TenSanPham,
soluong = ct.SoLuong,
Tenkichthuoc = kt.TenKichThuoc,
giatien = ct.TongTien,
tienkm = ct.TienKhuyenMai,
tiensaukm = ct.TongSauKm,
hinhanh = ha.TenFile
});
List <Chitiethoadon> dsChiTiet = new List <Chitiethoadon>();
foreach (var item in cthd)
{
Chitiethoadon ct = new Chitiethoadon();
Hinhanh ha = new Hinhanh();
Sanpham sp = new Sanpham();
Kichthuoc kt = new Kichthuoc();
sp.TenSanPham = item.tensp;
ct.SoLuong = item.soluong;
kt.TenKichThuoc = item.Tenkichthuoc;
ct.TongTien = item.giatien;
ct.TienKhuyenMai = item.tienkm;
ct.TongSauKm = item.tiensaukm;
ha.TenFile = item.hinhanh;
sp.HinhAnh = ha;
ct.SanPham = sp;
ct.KichThuoc = kt;
dsChiTiet.Add(ct);
}
ViewBag.chitiet = dsChiTiet;
ViewBag.idHoaDon = id;
return(View());
}
public IActionResult Index()
{
var dbContext = new shopContext();
var khuyenmai = (from km in dbContext.Khuyenmai select km).ToList();
foreach (var item in khuyenmai)
{
if (item.NgayBatDau <= DateTime.Now && item.NgayKetThuc >= DateTime.Now)
{
//update khuyến mãi kích hoạt đã đến ngày khuyến mãi
var km = dbContext.Khuyenmai.First(a => a.KhuyenMaiId == item.KhuyenMaiId);
km.TrangThai = 1;
dbContext.SaveChanges();
}
else
{
var km = dbContext.Khuyenmai.First(a => a.KhuyenMaiId == item.KhuyenMaiId);
km.TrangThai = 0;
dbContext.SaveChanges();
//lấy danh sách sản phẩm có khuyến mãi id = item.khuyenmaiId;
var sanpham = (from sp in dbContext.Sanpham
where sp.KhuyenMaiId == item.KhuyenMaiId
select sp).ToList();
//update sản phẩm đã hết hạn khuyến mãi
foreach (var sp in sanpham)
{
var ItemSanPham = dbContext.Sanpham.First(a => a.SanPhamId == sp.SanPhamId);
ItemSanPham.KhuyenMaiId = null;
dbContext.SaveChanges();
}
// var sanpham = dbContext.Sanpham.First(a => a.KhuyenMaiId == item.KhuyenMaiId);
// sanpham.KhuyenMaiId = null;
// dbContext.SaveChanges();
// dbContext.Dispose();
}
}
var SanPhamm = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
join km in dbContext.Khuyenmai
on sp.KhuyenMaiId equals km.KhuyenMaiId into x
from subkm in x.DefaultIfEmpty()
where sp.TrangThai == 1
select new{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
Mota = sp.Mota,
GiaBanLe = sp.GiaBanLe,
Hinhanh = h.TenFile,
KhuyenMaiId = sp.KhuyenMaiId,
PhanTramGiam = subkm.PhanTramGiam
}).Take(7);
List <Sanpham> List = new List <Sanpham>();
foreach (var sp in SanPhamm)
{
Sanpham s = new Sanpham();
Hinhanh h = new Hinhanh();
Khuyenmai k = new Khuyenmai();
s.SanPhamId = sp.SanPhamId;
s.TenSanPham = sp.TenSanPham;
s.Mota = sp.Mota;
s.GiaGoc = sp.GiaBanLe - sp.GiaBanLe * sp.PhanTramGiam;
s.GiaBanLe = sp.GiaBanLe;
s.KhuyenMaiId = sp.KhuyenMaiId;
h.TenFile = sp.Hinhanh;
//xử lý chuyển phần trăm giảm sang %
k.PhanTramGiam = sp.PhanTramGiam * 100;
s.KhuyenMai = k;
s.HinhAnh = h;
List.Add(s);
}
ViewData["x"] = List;
return(View());
}
public IActionResult ChiTietSanPham(int id)
{
var dbContext = new shopContext();
var SanPham = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
where sp.SanPhamId == id
select new
{
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
Mota = sp.Mota,
GiaBanLe = sp.GiaBanLe,
TenFile = h.TenFile
});
List <Sanpham> List = new List <Sanpham>();
foreach (var sp in SanPham)
{
Sanpham sanPham = new Sanpham();
Hinhanh h = new Hinhanh();
sanPham.SanPhamId = sp.SanPhamId;
sanPham.TenSanPham = sp.TenSanPham;
sanPham.Mota = sp.Mota;
sanPham.GiaBanLe = sp.GiaBanLe;
h.TenFile = sp.TenFile;
sanPham.HinhAnh = h;
List.Add(sanPham);
}
ViewData["sanpham"] = List;
// hiển thị danh sách bình luận
var binhLuan = (from bl in dbContext.Binhluan
join tk in dbContext.Taikhoan
on bl.TaiKhoanId equals tk.TaiKhoanId
where bl.SanPhamId == id
select new {
binhluanId = bl.BinhLuanId,
noidung = bl.NoiDung,
username = tk.Username
}).ToList();
List <Binhluan> DSBinhLuan = new List <Binhluan>();
foreach (var item in binhLuan)
{
Binhluan bl = new Binhluan();
Taikhoan tk = new Taikhoan();
bl.BinhLuanId = item.binhluanId;
bl.NoiDung = item.noidung;
string Str1 = item.username.Substring(0, 1);
tk.Username = Str1;
tk.Password = item.username;
bl.TaiKhoan = tk;
DSBinhLuan.Add(bl);
}
if (DSBinhLuan.Count == 0)
{
ViewBag.empty = "Không có bình luận cho sản phẩm này";
}
ViewBag.binhluan = DSBinhLuan;
//hien thi danh sach phan hoi
var DSPhanHoi = (from ph in dbContext.Phanhoi
join tk in dbContext.Taikhoan
on ph.TaiKhoanId equals tk.TaiKhoanId
orderby ph.PhanHoiId descending
select new {
PhanHoiId = ph.PhanHoiId,
BinhLuanId = ph.BinhLuanId,
NoiDung = ph.NoiDung,
userName = tk.Username
}).ToList();
List <Phanhoi> ListPhanHoi = new List <Phanhoi>();
foreach (var item in DSPhanHoi)
{
Phanhoi ph = new Phanhoi();
ph.PhanHoiId = item.PhanHoiId;
ph.BinhLuanId = item.BinhLuanId;
ph.NoiDung = item.NoiDung;
Taikhoan tk = new Taikhoan();
string Str1 = item.userName.Substring(0, 1);
tk.Password = Str1;
tk.Username = item.userName;
ph.TaiKhoan = tk;
ListPhanHoi.Add(ph);
}
ViewBag.phanhoi = ListPhanHoi;
return(View());
}
public IActionResult DatHang(int id)
{
var dbContext = new shopContext();
var sanpham = (from sp in dbContext.Sanpham
where sp.SanPhamId == id
select sp).ToList();
var ListSP = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
join km in dbContext.Khuyenmai
on sp.KhuyenMaiId equals km.KhuyenMaiId into x
from subkm in x.DefaultIfEmpty()
select new
{
PhanLoaiId = sp.PhanLoaiId,
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
PhanTramGiam = subkm.PhanTramGiam,
KhuyenmaiId = sp.KhuyenMaiId
});
List <Sanpham> List = new List <Sanpham>();
foreach (var item in ListSP)
{
var sp = new Sanpham();
var h = new Hinhanh();
var k = new Khuyenmai();
float?giaSauGiam = item.GiaBanLe - item.GiaBanLe * item.PhanTramGiam;
sp.PhanLoaiId = item.PhanLoaiId;
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
h.TenFile = item.HinhAnh;
k.PhanTramGiam = item.PhanTramGiam * 100;
sp.KhuyenMaiId = item.KhuyenmaiId;
sp.GiaGoc = giaSauGiam;
sp.HinhAnh = h;
sp.KhuyenMai = k;
List.Add(sp);
}
ViewData["listSP"] = List;
var PhanLoai = (from pl in dbContext.Phanloai
orderby pl.PhanLoaiId
select pl);
List <Phanloai> ListPL = new List <Phanloai>();
foreach (var item in PhanLoai)
{
Phanloai phanloai = new Phanloai();
phanloai.PhanLoaiId = item.PhanLoaiId;
phanloai.TenLoai = item.TenLoai;
ListPL.Add(phanloai);
}
ViewData["listPL"] = ListPL;
//lay ma khuyen mai cua san pham
float?phantramKM = 0;
if (sanpham[0].KhuyenMaiId != null)
{
var km = (from khuyenmai in dbContext.Khuyenmai
where khuyenmai.KhuyenMaiId == sanpham[0].KhuyenMaiId
select khuyenmai).ToList();
phantramKM = km[0].PhanTramGiam;
}
//--------------------------
var gioHangSession = HttpContext.Session.GetString("gioHangSession");
if (gioHangSession == null)
{
//chưa có giỏ hàng (khởi tạo)
var KichThuoc = (from kt in dbContext.Kichthuoc where kt.SanPhamId == id select kt).ToList();
var ktId = 0;
foreach (var item in KichThuoc)
{
if (item.TenKichThuoc == "Nhỏ")
{
ktId = item.KichThuocid;
}
}
List <Chitiethoadon> ListChiTietHoaDon = new List <Chitiethoadon>();
Chitiethoadon chitiethoadon = new Chitiethoadon();
chitiethoadon.SanPhamId = id;
chitiethoadon.SoLuong = 1;
chitiethoadon.KichThuocId = ktId;
chitiethoadon.TongTien = (float)(sanpham[0].GiaBanLe * 1 - sanpham[0].GiaBanLe * phantramKM);
ListChiTietHoaDon.Add(chitiethoadon);
HttpContext.Session.SetString("gioHangSession", JsonConvert.SerializeObject(ListChiTietHoaDon));
}
else
{
// nếu đã có giỏ hàng sẵn
List <Chitiethoadon> listCart = JsonConvert.DeserializeObject <List <Chitiethoadon> >(HttpContext.Session.GetString("gioHangSession"));
// kiểm tra sản phẩm thêm vào có tồn tại trong giỏ hàng chưa
int flag = 0;
for (int i = 0; i < listCart.Count; i++)
{
if (listCart[i].SanPhamId == id)
{
// listCart.RemoveAt(i);
flag = 1;
}
}
if (flag == 0)// giỏ hàng chưa có sản phẩm này
{
var KichThuoc = (from kt in dbContext.Kichthuoc where kt.SanPhamId == id select kt).ToList();
var ktId = 0;
foreach (var item in KichThuoc)
{
if (item.TenKichThuoc == "Nhỏ")
{
ktId = item.KichThuocid;
}
}
Chitiethoadon chitiethoadon = new Chitiethoadon();
chitiethoadon.SanPhamId = id;
chitiethoadon.SoLuong = 1;
chitiethoadon.KichThuocId = ktId;
chitiethoadon.TongTien = (float)(sanpham[0].GiaBanLe * 1 - sanpham[0].GiaBanLe * phantramKM);
listCart.Add(chitiethoadon);
HttpContext.Session.SetString("gioHangSession", JsonConvert.SerializeObject(listCart));
}
else // giỏ hàng đã có sản phẩm
// nếu có rồi thì giữ nguyên như cũ
{
}
}
//---------------------------
//hiển thị giỏ hàng
//-----------------------------
float?TongTien = 0;
List <Chitiethoadon> chiTietHoaDonss = JsonConvert.DeserializeObject <List <Chitiethoadon> >(HttpContext.Session.GetString("gioHangSession"));
List <Chitiethoadon> ListSanPhamCart = new List <Chitiethoadon>();
for (int i = 0; i < chiTietHoaDonss.Count(); i++)
{
var gh = (from sp in dbContext.Sanpham
join kt in dbContext.Kichthuoc
on sp.SanPhamId equals kt.SanPhamId
where kt.KichThuocid == chiTietHoaDonss[i].KichThuocId
select new {
masp = sp.SanPhamId,
tensp = sp.TenSanPham.ToString(),
GiaBanLe = sp.GiaBanLe,
kichThuocId = kt.KichThuocid,
TenKichThuoc = kt.TenKichThuoc.ToString(),
GiaThem = kt.GiaThem,
soluong = chiTietHoaDonss[i].SoLuong,
tongtien = chiTietHoaDonss[i].TongTien.ToString()
}
).ToList();
foreach (var x in gh)
{
Chitiethoadon ct = new Chitiethoadon();
Sanpham sp = new Sanpham();
Kichthuoc kt = new Kichthuoc();
ct.KichThuocId = x.kichThuocId;
kt.TenKichThuoc = x.TenKichThuoc;
kt.GiaThem = x.GiaThem;
ct.SanPhamId = x.masp;
sp.TenSanPham = x.tensp;
sp.GiaBanLe = x.GiaBanLe;
ct.SoLuong = x.soluong;
float tong = float.Parse(x.tongtien);
ct.TongTien = tong;
TongTien = TongTien + ct.TongTien;
ct.SanPham = sp;
ct.KichThuoc = kt;
ListSanPhamCart.Add(ct);
}
}
HttpContext.Session.SetString("gioHangSession", JsonConvert.SerializeObject(ListSanPhamCart));
ViewBag.tongtien = TongTien;
ViewBag.gioHang = ListSanPhamCart;
//---------------------------------
// ViewBag.gioHang = new List<Chitiethoadon>();
return(View(sanpham));
}
public IActionResult ThucDon()
{
var dbContext = new shopContext();
var PhanLoai = (from pl in dbContext.Phanloai
orderby pl.PhanLoaiId
select pl);
List <Sanpham> List = new List <Sanpham>();
var ListSP = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
join km in dbContext.Khuyenmai
on sp.KhuyenMaiId equals km.KhuyenMaiId into x
from subkm in x.DefaultIfEmpty()
where sp.TrangThai == 1
select new
{
PhanLoaiId = sp.PhanLoaiId,
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
KhuyenMaiId = sp.KhuyenMaiId,
PhanTramGiam = subkm.PhanTramGiam
});
foreach (var item in ListSP)
{
var sp = new Sanpham();
var h = new Hinhanh();
var k = new Khuyenmai();
sp.PhanLoaiId = item.PhanLoaiId;
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
h.TenFile = item.HinhAnh;
sp.KhuyenMaiId = item.KhuyenMaiId;
k.PhanTramGiam = item.PhanTramGiam * 100;
sp.KhuyenMai = k;
sp.GiaGoc = item.GiaBanLe - item.GiaBanLe * item.PhanTramGiam;
sp.HinhAnh = h;
List.Add(sp);
}
ViewData["listSP"] = List;
// hiển thị danh sách sản phẩm khuyến mãi
List <Sanpham> ListKM = new List <Sanpham>();
var ListSPKM = (from sp in dbContext.Sanpham
join h in dbContext.Hinhanh
on sp.HinhAnhId equals h.HinhAnhId
join km in dbContext.Khuyenmai
on sp.KhuyenMaiId equals km.KhuyenMaiId into x
from subkm in x.DefaultIfEmpty()
where sp.TrangThai == 1
select new
{
PhanLoaiId = sp.PhanLoaiId,
SanPhamId = sp.SanPhamId,
TenSanPham = sp.TenSanPham,
GiaBanLe = sp.GiaBanLe,
HinhAnh = h.TenFile,
KhuyenMaiId = sp.KhuyenMaiId,
PhanTramGiam = subkm.PhanTramGiam
});
foreach (var item in ListSPKM)
{
var sp = new Sanpham();
var h = new Hinhanh();
var k = new Khuyenmai();
sp.PhanLoaiId = item.PhanLoaiId;
sp.SanPhamId = item.SanPhamId;
sp.TenSanPham = item.TenSanPham;
sp.GiaBanLe = item.GiaBanLe;
h.TenFile = item.HinhAnh;
sp.KhuyenMaiId = item.KhuyenMaiId;
k.PhanTramGiam = item.PhanTramGiam * 100;
sp.KhuyenMai = k;
sp.GiaGoc = item.GiaBanLe - item.GiaBanLe * item.PhanTramGiam;
sp.HinhAnh = h;
ListKM.Add(sp);
}
ViewBag.ListKM = ListKM;
return(View(PhanLoai));
}
public IActionResult InHoaDon(int id)
{
var dbContext = new shopContext();
var hoadon = (from hd in dbContext.Hoadon
join ps in dbContext.Phiship
on hd.PhiShipId equals ps.PhiShipId
join kh in dbContext.Khachhang
on hd.KhachHangId equals kh.KhachHangId
join nv in dbContext.Nhanvien
on hd.NhanVienId equals nv.NhanVienId
where hd.HoaDonId == id
select new{
idhd = hd.HoaDonId,
TenKhachHang = kh.HoTen,
quan = hd.Quan,
ngaytao = hd.NgayTao,
TenNguoiNhan = hd.TenNguoiNhan,
soNha = hd.SoNha,
sdt = hd.Sdt,
phiship = ps.ChiPhi,
tienkhuyenmai = hd.TienGiamGia,
TongTienChuaShip = hd.TongTienChuaShip,
tongcong = hd.TongTienThanhToan
}).ToList();
List <Hoadon> DSHoaDon = new List <Hoadon>();
foreach (var item in hoadon)
{
Hoadon hd = new Hoadon();
hd.HoaDonId = item.idhd;
hd.NgayTao = item.ngaytao;
hd.TenNguoiNhan = item.TenNguoiNhan;
hd.SoNha = item.soNha;
hd.Sdt = item.sdt;
hd.TienGiamGia = item.tienkhuyenmai;
hd.TongTienChuaShip = item.TongTienChuaShip;
hd.TongTienThanhToan = item.tongcong;
hd.Quan = item.quan;
Phiship ps = new Phiship();
ps.ChiPhi = item.phiship;
Khachhang kh = new Khachhang();
kh.HoTen = item.TenKhachHang;
hd.KhachHang = kh;
hd.PhiShip = ps;
DSHoaDon.Add(hd);
}
// ViewBag.hoadon = DSHoaDon;
var chitiet = (from ct in dbContext.Chitiethoadon
join hd in dbContext.Hoadon
on ct.HoaDonId equals hd.HoaDonId
join sp in dbContext.Sanpham
on ct.SanPhamId equals sp.SanPhamId
join kt in dbContext.Kichthuoc
on ct.KichThuocId equals kt.KichThuocid
join ha in dbContext.Hinhanh
on sp.HinhAnhId equals ha.HinhAnhId
join km in dbContext.Khuyenmai
on sp.KhuyenMaiId equals km.KhuyenMaiId into x
from subnv in x.DefaultIfEmpty()
where hd.HoaDonId == id
select new{
tensp = sp.TenSanPham,
hinhanh = ha.TenFile,
gia = ct.TongTien,
soluong = ct.SoLuong,
giam = subnv.PhanTramGiam * sp.GiaBanLe,
tamtinh = ct.TongSauKm,
tenKichThuoc = kt.TenKichThuoc
}).ToList();
List <Chitiethoadon> DSChiTiet = new List <Chitiethoadon>();
foreach (var item in chitiet)
{
Sanpham sp = new Sanpham();
Chitiethoadon ct = new Chitiethoadon();
Hinhanh ha = new Hinhanh();
Kichthuoc kt = new Kichthuoc();
sp.TenSanPham = item.tensp;
ha.TenFile = item.hinhanh;
ct.TongTien = item.gia;
ct.SoLuong = item.soluong;
ct.TienKhuyenMai = item.giam;
ct.TongSauKm = item.tamtinh;
kt.TenKichThuoc = item.tenKichThuoc;
sp.HinhAnh = ha;
ct.SanPham = sp;
ct.KichThuoc = kt;
DSChiTiet.Add(ct);
}
var hoadon_cthd = new Tuple <List <Hoadon>, List <Chitiethoadon> >(DSHoaDon, DSChiTiet);
return(new ViewAsPdf(hoadon_cthd));
}
