public IActionResult Index()
{
ThucDonViewModel dsThucDon = new ThucDonViewModel(db);
ViewBag.ListProduct = dsThucDon.GetAllData().Take(6);
return(View());
}
public IActionResult Index()
{
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
ViewBag.ListProduct = query_thucdon.GetDataByPage(1, 6);
LoaiThucDonViewModel query_loaithucdon = new LoaiThucDonViewModel(db);
ViewBag.ListCate = query_loaithucdon.GetLoaiThucDon();
ViewBag.ListDiscount = query_thucdon.GetAllData().Where(x => x.KhuyenMai != 0).Take(4);
return(View());
}
public IActionResult Index()
{
BannerViewModal bnQuangCao = new BannerViewModal(db);
ViewBag.ListBanner = bnQuangCao.GetAllData().Take(3);
ThucDonViewModel dsThucDon = new ThucDonViewModel(db);
ViewBag.ListProduct = dsThucDon.GetAllData().Where(x => x.KhuyenMai == 0).Take(4);
ViewBag.ListDiscount = dsThucDon.GetAllData().Where(x => x.KhuyenMai != 0).Take(4);
ViewBag.ListProductHot = dsThucDon.GetAllData().OrderByDescending(p => p.LuotMua).Take(4);
ViewBag.ListProductViews = dsThucDon.GetAllData().OrderByDescending(p => p.LuotXem).Take(4);
ViewBag.ListProductFULL = dsThucDon.GetAllData();
ThuongHieuViewModal dsThuongHieu = new ThuongHieuViewModal(db);
ViewBag.ThuongHieu = dsThuongHieu.GetThuongHieuThucDon();
return(View());
}
public IActionResult sortby(string value)
{
ThucDonViewModel dstd = new ThucDonViewModel(db);
var td = dstd.GetAllData();
if (value == ("Name"))
{
ViewBag.ListProduct = dstd.SortByName();
return(PartialView("_viewresultSortBy", ViewBag.ListProduct));
}
if (value == ("Price"))
{
ViewBag.ListProduct = td.OrderBy(p => p.Gia);
return(PartialView("_viewresultSortBy", ViewBag.ListProduct));
}
ViewBag.ListProduct = td;
return(PartialView("_viewresultSortBy", ViewBag.ListProduct));
}
public IActionResult Index()
{
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
ViewBag.ListProduct = query_thucdon.GetAllData().Take(8);
LoaiThucDonViewModel query_loaithucdon = new LoaiThucDonViewModel(db);
ViewBag.ListCate = query_loaithucdon.GetLoaiThucDon();
ThuongHieuViewModal query_thuonghieuthucdon = new ThuongHieuViewModal(db);
ViewBag.ListBrand = query_thuonghieuthucdon.GetThuongHieuThucDon();
NongDoViewModal query_nongdo = new NongDoViewModal(db);
ViewBag.ListND = query_nongdo.GetNongDoThucDon();
DungTichViewModal query_dungtich = new DungTichViewModal(db);
ViewBag.ListDT = query_dungtich.GetDungTichThucDon();
return(View());
}
public IActionResult Index()
{
string day = DateTime.Now.ToString("yyyy-MM-dd");;
var myDbContext = db.GioHang.Include(g => g.MaKhachHangNavigation);
//string date = item.NgayDat.ToString();
//date = date.Substring(0, 10);
var dshd = myDbContext.Where(p => p.NgayDat.ToString().Substring(0, 10) == day);
var dshdM = myDbContext.Where(p => p.NgayDat.Value.Month == Convert.ToInt32(DateTime.Now.Month));
var dshdY = myDbContext.Where(p => p.NgayDat.Value.Year == Convert.ToInt32(DateTime.Now.Year));
double totalDay = 0;
double totalMonth = 0;
double totalYear = 0;
int count = 0;
foreach (var item in dshdM)
{
totalYear += Convert.ToDouble(item.TongCong);
}
foreach (var item in dshdM)
{
totalMonth += Convert.ToDouble(item.TongCong);
}
foreach (var item in dshd)
{
totalDay += Convert.ToDouble(item.TongCong);
if (item.TrangThai == 0)
{
count++;
}
}
ViewBag.TotalDay = totalDay;
ViewBag.TotalMonth = totalMonth;
ViewBag.TotalYear = totalYear;
ViewBag.List = dshd;
ViewBag.Count = count;
var giohang = new OderViewModel();
List <OrderDetailViewModel> listorder = new List <OrderDetailViewModel>();
List <ChiTietGioHang> ctgiohang = db.ChiTietGioHang.ToList();
foreach (var item in ctgiohang)
{
OrderDetailViewModel tmp = new OrderDetailViewModel();
if (db.ThucDon.Find(item.MaThucDon).KhuyenMai > 0)
{
tmp.gia = db.ThucDon.Find(item.MaThucDon).GiaKhuyenMai;
}
else
{
tmp.gia = db.ThucDon.Find(item.MaThucDon).Gia;
}
tmp.masp = item.MaThucDon;
tmp.soluong = item.SoLuong;
tmp.thanhtien = tmp.gia * tmp.soluong;
tmp.tensp = db.ThucDon.Find(item.MaThucDon).TenThucDon;
tmp.id = item.MaCtgioHang;
listorder.Add(tmp);
//giohang.ctgiohangs.Add(tmp);
}
ThucDonViewModel dsThucDon = new ThucDonViewModel(db);
//List<ThucDonViewModel> dsThucDon = new List<ThucDonViewModel>();
var pro = dsThucDon.GetAllData().OrderByDescending(p => p.LuotMua).Take(4);
ViewBag.ProductHot = dsThucDon.GetAllData().OrderByDescending(p => p.LuotXem).Take(3);
ViewBag.ListProduct = listorder;
return(View());
}
