public static List <BanChayNhat> LaySanPham(int count)
{
dbHasakoProjectDataContext data = new dbHasakoProjectDataContext();
List <BanChayNhat> dsHS = new List <BanChayNhat>();
List <HAISANKHO> ds = data.HAISANKHOs.ToList();
List <CHITIETDONHANG> ct = data.CHITIETDONHANGs.ToList();
foreach (var hs in ds)
{
DANHMUCHAISANKHO dm = data.DANHMUCHAISANKHOs.FirstOrDefault(x => x.MaDM == hs.MaDM);
int?sum = 0;
foreach (var c in ct)
{
if (c.MaHS == hs.MaHS)
{
sum += c.Soluong;
}
}
dsHS.Add(new BanChayNhat()
{
MaHS = hs.MaHS, MaDM = dm.MaDM, TenDM = dm.TenDM, TenHS = hs.TenHS, DonGia = hs.Dongia, AnhBia = hs.Anhbia, HangTon = hs.Soluongton, DaBan = sum, MoTa = hs.Mota
});
}
return(dsHS.OrderByDescending(x => x.DaBan).Take(count).ToList());
}
public static List <KhuyenMaiTrongTuan> LaySanPham()
{
dbHasakoProjectDataContext data = new dbHasakoProjectDataContext();
List <KhuyenMaiTrongTuan> dsHS = new List <KhuyenMaiTrongTuan>();
List <HAISANKHO> ds = data.HAISANKHOs.OrderBy(s => s.Ngaycapnhat).Take(3).ToList();
Random rnd = new Random();
foreach (var hs in ds)
{
int pt = rnd.Next(30, 50);
double ptd = Convert.ToDouble(pt);
double dgd = Convert.ToDouble(hs.Dongia);
double km = hs.Dongia * (1 - ptd / 100);
int? db = 0;
DANHMUCHAISANKHO dm = data.DANHMUCHAISANKHOs.FirstOrDefault(x => x.MaDM == hs.MaDM);
if (data.CHITIETDONHANGs.Where(x => x.MaHS == hs.MaHS).FirstOrDefault() != null)
{
db = data.CHITIETDONHANGs.Where(x => x.MaHS == hs.MaHS).Sum(x => x.Soluong);
}
else
{
db = 0;
}
dsHS.Add(new KhuyenMaiTrongTuan()
{
MaHS = hs.MaHS, TenDM = dm.TenDM, TenHS = hs.TenHS, DonGia = hs.Dongia, AnhBia = hs.Anhbia, PhanTramGiam = pt, GiaKM = km, HangTon = hs.Soluongton, DaBan = db
});
}
return(dsHS);
}
//chưa code
public ActionResult SanPhamMoiNhat()
{
var sp = SanPhamMoiTatCa(1);
var spmoi = sp.FirstOrDefault();
DANHMUCHAISANKHO dm = data.DANHMUCHAISANKHOs.FirstOrDefault(x => x.MaDM == spmoi.MaDM);
string tendm = dm.TenDM;
ViewBag.tendm = tendm;
return(PartialView(spmoi));
}
