public IActionResult Index(string id)
{
ThucDonViewModel query = new ThucDonViewModel(db);
var td = query.GetDataById(id);
var thucDon = db.ThucDon.Find(Convert.ToInt32(id));
if (thucDon.LuotXem == null)
{
thucDon.LuotXem = 1;
}
else
{
thucDon.LuotXem++;
}
db.Update(thucDon);
db.SaveChanges();
ViewBag.CungLoai = query.GetAllDataByCate(td.MaLoai.ToString()).Take(3);
DanhGiaViewModel query_dg = new DanhGiaViewModel(db);
ViewBag.ListDanhGia = query_dg.GetDanhGiaByProduct(id).OrderByDescending(x => x.MaDanhGia);
ViewBag.ThucDon = td;
return(View());
}
public IActionResult Index()
{
ThucDonViewModel dsThucDon = new ThucDonViewModel(db);
ViewBag.ListProduct = dsThucDon.GetAllData().Take(6);
return(View());
}
public IActionResult GetProductSearchCount(string keyword)
{
ThucDonViewModel query = new ThucDonViewModel(db);
var response = query.GetDataByName(keyword).Count();
return(Json(response));
}
public IActionResult GetProductByPageWithFilter(string maloai, string sapxep, int page = 1, int limit = 6)
{
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
var response = query_thucdon.GetAllDataWithFilterByPage(page, limit, maloai, sapxep);
return(Json(response));
}
public IActionResult GetProductCount(string MaLoai = "0")
{
ThucDonViewModel query = new ThucDonViewModel(db);
var response = query.GetAllDataByCate(MaLoai).Count();
return(Json(response));
}
public IActionResult GetProductCountWithFilter(string maloai, string sapxep)
{
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
var response = query_thucdon.GetAllDataWithFilter(maloai, sapxep).Count();
return(Json(response));
}
public IActionResult GetProductByPage(string maloai, string page)
{
ThucDonViewModel query = new ThucDonViewModel(db);
var response = query.GetDataWithCateByPage(maloai, int.Parse(page));
return(Json(response));
}
public IActionResult AddProduct(string product_name, IFormFile product_img,
string product_category, string product_price, string filter,
string product_discount, string product_info, string page)
{
ThucDon newProduct = new ThucDon();
if (product_img != null)
{
string path_to_image = "wwwroot/uploads/product/" + product_img.FileName;
using (var stream = new FileStream(path_to_image, FileMode.Create))
{
product_img.CopyTo(stream);
}
newProduct.HinhAnh = product_img.FileName;
}
newProduct.TenThucDon = product_name;
newProduct.MaLoai = int.Parse(product_category);
newProduct.Gia = float.Parse(product_price);
newProduct.KhuyenMai = int.Parse(product_discount);
newProduct.MoTa = product_info;
ThucDonViewModel query = new ThucDonViewModel(db);
query.InsertThucDon(newProduct);
var response = query.GetDataWithCateByPage(filter, int.Parse(page));
return(Json(response));
}
public IActionResult BindDataToForm(string id)
{
ThucDonViewModel query = new ThucDonViewModel(db);
var response = query.GetDataById(id);
return(Json(response));
}
public IActionResult FilterProduct(string maloai)
{
ThucDonViewModel query = new ThucDonViewModel(db);
var response = query.GetDataWithCateByPage(maloai, 1);
return(Json(response));
}
public IActionResult UpdateProduct(string product_id, string product_name,
IFormFile product_img, string product_category,
string product_price, string product_discount, string filter,
string old_product_img, string product_info, string page)
{
ThucDon editProduct = new ThucDon
{
MaThucDon = int.Parse(product_id),
TenThucDon = product_name,
MaLoai = int.Parse(product_category),
Gia = float.Parse(product_price),
KhuyenMai = int.Parse(product_discount),
MoTa = product_info
};
if (product_img == null)
{
editProduct.HinhAnh = old_product_img;
}
else
{
string path_to_image = "wwwroot/uploads/product/" + product_img.FileName;
using (var stream = new FileStream(path_to_image, FileMode.Create))
{
product_img.CopyTo(stream);
}
editProduct.HinhAnh = product_img.FileName;
}
ThucDonViewModel query = new ThucDonViewModel(db);
query.EditThucDon(editProduct);
var response = query.GetDataWithCateByPage(filter, int.Parse(page));
return(Json(response));
}
public IActionResult SearchProduct(string keyword, string page = "1")
{
var page_num = int.Parse(page);
ThucDonViewModel query = new ThucDonViewModel(db);
var response = query.GetDataByNameWithPage(keyword, page_num);
return(Json(response));
}
public IActionResult GetProductByName(string keyword, int page = 1, int limit = 6)
{
keyword = keyword.ToLower();
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
var response = query_thucdon.GetDataByNameWithPage(keyword, page, limit);
return(Json(response));
}
public IActionResult GetProductCountWithKeyword(string keyword)
{
keyword = keyword.ToLower();
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
var response = query_thucdon.GetDataByName(keyword).Count();
return(Json(response));
}
public IActionResult getProductsByCate(string categoryID)
{
//return Content("Oke");
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
ViewBag.ListProduct = query_thucdon.GetAllDataByCate(categoryID);
return(PartialView("_resultCategory", ViewBag.ListProduct));
}
public IActionResult Index(string id)
{
ThucDonViewModel query = new ThucDonViewModel(db);
var td = query.GetDataById(id);
ViewBag.CungLoai = query.GetAllDataByCate(td.MaLoai.ToString()).Take(4);
DanhGiaViewModel query_dg = new DanhGiaViewModel(db);
ViewBag.ListDanhGia = query_dg.GetDanhGiaByProduct(id).OrderByDescending(x => x.MaDanhGia);
return(View(td));
}
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()
{
ThucDonViewModel dsThucDon = new ThucDonViewModel(db);
//var pageNumber = page ?? 1;
//var allProduct = dsThucDon.GetAllData();
//var onePageProduct = allProduct.ToPagedList(pageNumber, 5);
ViewBag.List = dsThucDon.GetDataWithCateByPage("0", 1);
LoaiThucDonViewModel dsLoai = new LoaiThucDonViewModel(db);
var data = dsLoai.GetLoaiThucDon();
ViewBag.ListCate = data;
return(View());
}
public IActionResult GetProductByPage(int page, int status)
{
ThucDonViewModel query_thucdon = new ThucDonViewModel(db);
if (status == 1)
{
page = page + 1;
}
else
{
page = page - 1;
}
ViewBag.ListProduct = query_thucdon.GetDataByPage(page, 8);
return(PartialView("_resultCategory", ViewBag.ListProduct));
}
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()
{
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 DeleteProductSearch(string id, string keyword, string page)
{
List <ChiTietGioHang> ctgh = db.ChiTietGioHang.Where(x => x.MaThucDon == int.Parse(id)).ToList();
foreach (var item in ctgh)
{
db.ChiTietGioHang.Remove(item);
}
List <DanhGia> dg = db.DanhGia.Where(x => x.MaThucDon == int.Parse(id)).ToList();
foreach (var item in dg)
{
db.DanhGia.Remove(item);
}
ThucDonViewModel query = new ThucDonViewModel(db);
query.DeleteThucDonById(id);
var response = query.GetDataByNameWithPage(keyword, int.Parse(page));
return(Json(response));
}
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());
}
