// GET: Home
public ActionResult Index(ListProductViewModel listProductViewModel)
{
listProductViewModel.ListProduct = DatabaseProduct.Lay_DS_SanPham();
return(View(listProductViewModel));
//CCallApi.GetTemplateAsync(CConfig.ListProduct + "?tensp=aaaa");
//return View();
}
public ActionResult ProductDetail(string FriendlyUrl, string string1, string string2)
{
try
{
Classification Objcata = cms_db.GetObjClasscifiByFriendlyUrl(FriendlyUrl);
if (Objcata != null)
{
this.SetInforMeta(Objcata.ClassificationMetakeyword, Objcata.ClassificationMetaDes);
ListProductViewModel model = new ListProductViewModel();
model.CataObj = Objcata;
model.lstProduct = cms_db.GetlstProductByCataId(Objcata.ClassificationId);
return(View("ListPartial", model));
}
else
{
DetailProductViewModel model = new DetailProductViewModel();
model.MainProduct = cms_db.GetObjProductByFriendlyURL(FriendlyUrl);
model.CataObj = cms_db.GetObjClasscifiById(model.MainProduct.CategoryId.Value);
model.lstSameProduct = cms_db.GetlstProductByCataIdHasNum(model.MainProduct.CategoryId.Value, 8);
model.lstImage = cms_db.GetLstMediaContent(model.MainProduct.ProductId, (int)EnumCore.ObjTypeId.san_pham).ToList();
this.SetInforMeta(model.MainProduct.MetadataKeyword, model.MainProduct.MetadataDesc);
return(View("DetailPartial", model));
}
}
catch (Exception e)
{
cms_db.AddToExceptionLog("ProductDetail", "ProductController(Public)", e.ToString());
return(RedirectToAction("ErrorExeption", "ErrorMessage"));
}
}
public ActionResult AllProduct()
{
try
{
this.SetInforMeta("", "");
List <ListProductViewModel> _tmpmodel = new List <ListProductViewModel>();
List <Classification> lstCata = cms_db.GetlstClassifiBySchemeId((int)EnumCore.ClassificationScheme.san_pham).ToList();
List <Classification> lstCata2 = new List <Classification>();
foreach (Classification _val in lstCata)
{
List <Classification> tmpcate = cms_db.GetlstClassifiByParentId(_val.ClassificationId).ToList();
if (tmpcate.Count == 0)
{
lstCata2.Add(_val);
}
}
foreach (Classification _val in lstCata2)
{
ListProductViewModel tmp = new ListProductViewModel();
if (_val.ObjPrent != null)
{
tmp.ParentCataObj = _val.ObjPrent;
}
tmp.CataObj = _val;
tmp.lstProduct = cms_db.GetlstProductByCataIdHasNum(_val.ClassificationId, 3);
_tmpmodel.Add(tmp);
}
return(View("ListAll", _tmpmodel));
}
catch (Exception e)
{
cms_db.AddToExceptionLog("AllProduct", "ProductController(Public)", e.ToString());
return(RedirectToAction("ErrorExeption", "ErrorMessage"));
}
}
public ActionResult Index()
{
List <ProductItemViemModel> list = new List <ProductItemViemModel>();
var temp = _context.Products.ToList();
foreach (var item in temp)
{
ProductItemViemModel product = new ProductItemViemModel
{
Count = item.Count,
Id = item.Id,
IsAvailable = item.IsAvailable,
Name = item.Name,
Price = item.Price
};
list.Add(product);
}
temp.Clear();
ListProductViewModel model = new ListProductViewModel()
{
listProduct = list
};
return(View(model));
}
public async Task <ResultViewModel> Show([FromRoute] string product_id)
{
bool productIdIsValid = Guid.TryParse(product_id, out Guid output);
if (!productIdIsValid)
{
return new ResultViewModel()
{
Success = false,
Message = "ID inválido."
}
}
;
var product = await _productRepository.Find(product_id);
ListProductViewModel data = product == null
? null
: new ListProductViewModel(product);
return(new ResultViewModel()
{
Success = true,
Message = null,
Data = data
});
}
public ActionResult ListProduct(Int32?Page, String InvoiceDescription, Int32?FamilyId, Int32?SubFamilyId, Int32?FatherId)
{
var model = new ListProductViewModel();
model.Fill(CargarDatosContext(), Page, InvoiceDescription, FamilyId, SubFamilyId, FatherId);
return(View(model));
}
public IActionResult Index(int?pageSize, string drop, int page = 1)
{
var products = new ListProductViewModel();
if (pageSize == null)
{
pageSize = _configuration.GetValue <int>("PageSize");
}
products.PageSize = pageSize;
products.SortType = drop;
products.Data = _productRepository.GetAllPaging(null, "", page, pageSize.Value);
if (drop == "hightolow")
{
products.Data.Results = products.Data.Results.OrderByDescending(x => x.Price).ToList();
}
if (drop == "lowtohigh")
{
products.Data.Results = products.Data.Results.OrderByDescending(x => x.Price).Reverse().ToList();
}
if (drop == "atoz")
{
products.Data.Results = products.Data.Results.OrderByDescending(x => x.Name).Reverse().ToList();
}
if (drop == "ztoa")
{
products.Data.Results = products.Data.Results.OrderByDescending(x => x.Name).ToList();
}
return(View(products));
}
// GET: Product
public async Task <IActionResult> Index()
{
ListProductViewModel viewModel = new ListProductViewModel();
viewModel.Product = await _context.Producten.Include(p => p.ProductType).ToListAsync();
viewModel.Frisdrankenlijst = viewModel.Product.Where(x => x.ProductType.Naam == "Frisdrank").ToList();
viewModel.Alcohollijst = viewModel.Product.Where(x => x.ProductType.Naam == "Alcohol").ToList();
viewModel.Snacklijst = viewModel.Product.Where(x => x.ProductType.Naam == "Snack").ToList();
foreach (var item in viewModel.Frisdrankenlijst)
{
item.Aantal = 0;
}
foreach (var item in viewModel.Alcohollijst)
{
item.Aantal = 0;
}
foreach (var item in viewModel.Snacklijst)
{
item.Aantal = 0;
}
viewModel.Bestelling = new Bestelling()
{
Productenlijst = new List <Product> {
}
};
return(View(viewModel));
}
public ActionResult ListMyProducts()
{
List <Product> products;
if (HttpContext.Cache["listProducts"] == null)
{
using (NorthwindEntities db = new NorthwindEntities())
{
products = db.Products.Include("Category").Include("Supplier").ToList();
}
HttpContext.Cache.Add("listProducts", products, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(20), CacheItemPriority.Normal, null);
}
else
{
products = HttpContext.Cache["listProducts"] as List <Product>;
}
ListProductViewModel model = new ListProductViewModel
{
Products = products
};
return(View(model));
}
/// <summary>
/// GET: Product
/// </summary>
/// <param name="listProductViewModel"></param>
/// <returns></returns>
public ActionResult Index(ListProductViewModel listProductViewModel)
{
listProductViewModel.Categories = businessManager.GetAllCategorie();
listProductViewModel.Products = businessManager.GetAllProduit();
listProductViewModel.Search = "";
return(View(listProductViewModel));
}
public async System.Threading.Tasks.Task <ActionResult> ListProduct()
{
var vm = new ListProductViewModel();
await vm.Fill(CargarDatosContext());
return(View(vm));
}
public IActionResult ListProducts()
{
ListProductViewModel ListProductsView = new ListProductViewModel();
Product product1 = new Product()
{
Nombre = "Raqueta",
Precio = 320000,
Color = "Blanca"
};
Product product2 = new Product()
{
Nombre = "Balon Futbol",
Precio = 100000,
Color = "W/B"
};
Product product3 = new Product()
{
Nombre = "Tennis",
Precio = 200000,
Color = "Azules"
};
ListProductsView.Products.Add(product1);
ListProductsView.Products.Add(product2);
ListProductsView.Products.Add(product3);
return(View(ListProductsView));
}
public async Task <IActionResult> VerminderenMetEen(ListProductViewModel viewModel, int Product_ID)
{
viewModel.ProductEventChange = _context.Producten.Include(x => x.ProductType).FirstOrDefault(x => x.ProductID == Product_ID);
viewModel.ProductEventChange.Aantal_in_Frigo -= 1;
if (viewModel.ProductEventChange.Aantal_in_Frigo > 0)
{
try
{
_context.Update(viewModel.ProductEventChange);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(viewModel.ProductEventChange.ProductID))
{
return(NotFound());
}
else
{
throw;
}
}
}
viewModel.DrankInMagazijn = await _context.Producten.Include(p => p.ProductType).ToListAsync();
viewModel.DrankInIjskast = new List <Product>();
foreach (Product item in viewModel.DrankInMagazijn)
{
if (!viewModel.DrankInIjskast.Contains(item) && item.Aantal_in_Frigo >= 0)
{
viewModel.DrankInIjskast.Add(item);
}
}
return(View(nameof(IndexManager), viewModel));
}
public ActionResult ListProduct(Int32?p)
{
var vm = new ListProductViewModel();
vm.Fill(CargarDatosContext(), p);
return(View(vm));
}
public IActionResult Search(ListProductViewModel viewModel)
{
if (!string.IsNullOrWhiteSpace(viewModel.ProductSearch))
{
viewModel.Products = _unitOfWork.Products.Find(p => p.Name.Contains(viewModel.ProductSearch)).ToList();
return(View("Index", viewModel));
}
return(RedirectToAction("Index"));
}
public ActionResult Index(int?page)
{
AppDbContext dbContext = new AppDbContext();
ListProductViewModel listProduct = new ListProductViewModel();
listProduct.Brands = dbContext.getBrands.ToList();
List <ProductModels> products = dbContext.getProducts.ToList();
List <GetProductViewModel> getProducts = new List <GetProductViewModel>();
/*Get products details*/
foreach (var item in products)
{
ModelModels model = dbContext.getModels.SingleOrDefault(m => m.Id == item.ModelId);
BrandModels brand = dbContext.getBrands.SingleOrDefault(b => b.BrandId == model.BrandId);
CategoryModels category = dbContext.getCategories.SingleOrDefault(c => c.CategoryId == model.CategoryId);
GetProductViewModel getProduct = new GetProductViewModel
{
Id = item.Id,
Name = model.Name,
Brand = brand.Brand,
Category = category.Category,
Price = item.Price,
Color = item.Color,
Storage = item.Storage,
Processor = item.Processor,
Memory = item.Memory,
Display = item.Display,
Details = item.Details,
CreatedBy = item.CreatedBy,
CreatedDate = item.CreatedDate
};
getProduct.Photos = dbContext.getProductPhotos(item.Id).ToList();
getProducts.Add(getProduct);
}
/*Search product and sort by date*/
listProduct.Products = getProducts.OrderByDescending(p => p.CreatedDate).ToList().ToPagedList(page ?? 1, 20);
/*Get the number of each product in a brand*/
listProduct.EachProductsOfBrands = new List <int>();
foreach (var brand in listProduct.Brands)
{
List <ProductModels> productsOfBrands = dbContext.getProductBrands(brand.BrandId).ToList();
int numberOfBrand = productsOfBrands.Count;
listProduct.EachProductsOfBrands.Add(numberOfBrand);
}
/*Create Index view with product details*/
return(View(listProduct));
}
public async Task <IActionResult> PlusEenSnack(ListProductViewModel viewModel, int Product_ID)
{
viewModel.GekozenSnack = _context.Producten.Include(x => x.ProductType).Where(x => x.ProductType.Naam == "Snack").FirstOrDefault(x => x.ProductID == Product_ID);
viewModel.GekozenSnack.Aantal += 1;
viewModel.Snacklijst = await _context.Producten.Include(p => p.ProductType).Where(x => x.ProductType.Naam == "Snack").ToListAsync();
viewModel.Alcohollijst = await _context.Producten.Include(p => p.ProductType).Where(x => x.ProductType.Naam == "Alcohol").ToListAsync();
viewModel.Frisdrankenlijst = await _context.Producten.Include(p => p.ProductType).Where(x => x.ProductType.Naam == "Frisdrank").ToListAsync();
return(View(nameof(Index), viewModel));
}
public async Task <IActionResult> Search(ListProductViewModel viewModel)
{
if (!string.IsNullOrEmpty(viewModel.ZoekProduct))
{
viewModel.Product = await _context.Producten.Include(p => p.ProductType)
.Where(x => x.Naam.Contains(viewModel.ZoekProduct)).ToListAsync();
}
else
{
viewModel.Product = await _context.Producten.Include(p => p.ProductType).ToListAsync();
}
return(View("IndexManager", viewModel));
}
public IActionResult Gop(int id, int?pageSize, string sortBy, int page = 1)
{
var gop = new ListProductViewModel();
if (pageSize == null)
{
pageSize = _configuration.GetValue <int>("PageSize");
}
gop.PageSize = pageSize;
gop.SortType = sortBy;
gop.Data = _productRepository.GetAllByGop(7, page, pageSize.Value);
return(View(gop));
}
public ActionResult FindProduct(ListProductViewModel viewModel)
{
try
{
viewModel.ListProducts = DatabaseInternal.GetListProduct(new ListProductViewModel());
viewModel.CurrentListProductType = DatabaseInternal.GetListProduct(viewModel);
//CCallApi.GetTemplateAsync(CConfig.ListProduct+ "?Tensp=aaaa");
}
catch (Exception ex)
{
LogFile.Error(ex.ToString()); // Ghi thông tin ra file
}
return(View(viewModel));
}
public ActionResult Search(ListProductViewModel listProductViewModel)
{
listProductViewModel.Categories = businessManager.GetAllCategorie();
Boolean searchForm = listProductViewModel.Search != null;
if (!searchForm)
{
listProductViewModel.Products = getAllProducts();
}
else if (searchForm)
{
listProductViewModel.Products = businessManager.GetProductsByNameSearch(listProductViewModel.Search);
}
return(View("Index", listProductViewModel));
}
public async Task <IActionResult> IndexManager()
{
ListProductViewModel viewModel = new ListProductViewModel();
viewModel.DrankInMagazijn = await _context.Producten.Include(p => p.ProductType).ToListAsync();
viewModel.DrankInIjskast = new List <Product>();
foreach (Product item in viewModel.DrankInMagazijn)
{
if (!viewModel.DrankInIjskast.Contains(item) && item.Aantal_in_Frigo >= 0)
{
viewModel.DrankInIjskast.Add(item);
}
}
return(View(viewModel));
}
public ViewResult Index()
{
var products = _productRepo.AllProducts.OrderByDescending(p => p.DateAdded).ToList();
foreach (var p in products)
{
p.Images = _productRepo.GetImages(p.Id).ToList();
}
var model = new ListProductViewModel
{
Products = products,
Categories = _categoryRepo.Categories,
Statuses = _statusRepo.Statuses
};
return(View(model));
}
public IActionResult List(int?storeID)
{
var Products = (storeID.HasValue) ?
Db.Products.Where(p => p.StoreID == storeID).ToList() : Db.Products.ToList();
var productview = new ListProductViewModel()
{
Products = Products,
StoreID = storeID
};
if (Products.Count() == 0)
{
return(View("Empty", productview));
}
return(View(productview));
}
public List <ListProductViewModel> ListProduct()
{
var viewModels = new List <ListProductViewModel>();
foreach (var product in _context.Products)
{
var viewModel = new ListProductViewModel();
viewModel.Id = product.Id;
viewModel.ProductName = product.ProductName;
viewModel.Description = product.Description;
viewModel.Price = product.Price;
viewModel.Image = product.Image;
viewModels.Add(viewModel);
}
return(viewModels);
}
public async Task DrankenOverzichtExcel()
{
ListProductViewModel viewModel = new ListProductViewModel();
viewModel.Product = await _context.Producten.Include(x => x.ProductType).ToListAsync();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage Ep = new ExcelPackage();
ExcelWorksheet Sheet = Ep.Workbook.Worksheets.Add("ExcelProduct");
Sheet.Cells["A1"].Value = "Naam";
Sheet.Cells["B1"].Value = "ProductType";
Sheet.Cells["C1"].Value = "Aankoopprijs";
Sheet.Cells["D1"].Value = "Verkoopprijs";
Sheet.Cells["E1"].Value = "Slotwaarde";
Sheet.Cells["F1"].Value = "Aantal in stock";
Sheet.Cells["G1"].Value = "Aantal in ijskast";
int row = 2;
foreach (var item in viewModel.Product)
{
Sheet.Cells[string.Format("A{0}", row)].Value = item.Naam;
Sheet.Cells[string.Format("B{0}", row)].Value = item.ProductType;
Sheet.Cells[string.Format("C{0}", row)].Value = item.AankoopPrijs;
Sheet.Cells[string.Format("C{0}", row)].Style.Numberformat.Format = "0.00";
Sheet.Cells[string.Format("D{0}", row)].Value = item.VerkoopPrijs;
Sheet.Cells[string.Format("D{0}", row)].Style.Numberformat.Format = "0.00";
Sheet.Cells[string.Format("E{0}", row)].Value = item.Slotwaarde;
Sheet.Cells[string.Format("F{0}", row)].Value = item.Aantal_in_stock;
Sheet.Cells[string.Format("G{0}", row)].Value = item.Aantal_in_Frigo;
row++;
}
Sheet.Cells["A:AZ"].AutoFitColumns();
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Headers.Add("content-disposition", "attachment: filename=" + "Report.xlsx");
await Response.Body.WriteAsync(Ep.GetAsByteArray());
Response.StatusCode = StatusCodes.Status200OK;
}
public ActionResult ProductList(string FriendlyUrl)
{
try
{
Classification Objcata = cms_db.GetObjClasscifiByFriendlyUrl(FriendlyUrl);
if (Objcata != null)
{
this.SetInforMeta(Objcata.ClassificationMetakeyword, Objcata.ClassificationMetaDes);
ListProductViewModel model = new ListProductViewModel();
model.CataObj = Objcata;
if (cms_db.GetlstClassifiByParentId(Objcata.ClassificationId).Count() > 0)
{
List <ListProductViewModel> _tmpmodel = new List <ListProductViewModel>();
List <Classification> lstCata = cms_db.GetlstClassifiByParentId(Objcata.ClassificationId).ToList();
foreach (Classification _val in lstCata)
{
ListProductViewModel tmp = new ListProductViewModel();
tmp.CataObj = _val;
tmp.lstProduct = cms_db.GetlstProductByCataIdHasNum(_val.ClassificationId, 4);
ViewBag.MainCata = Objcata;
_tmpmodel.Add(tmp);
}
return(View("ListCatalogryPro", _tmpmodel));
}
else
{
model.lstProduct = cms_db.GetlstProductByCataId(Objcata.ClassificationId);
}
return(View("ListPartial", model));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
catch (Exception e)
{
cms_db.AddToExceptionLog("ProductList", "ProductController(Public)", e.ToString());
return(RedirectToAction("ErrorExeption", "ErrorMessage"));
}
}
public ActionResult List(int page = 1, string search = "", int marca = 0)
{
var pageLen = 12;
var model = new ListProductViewModel();
var from = (page - 1) * pageLen;
var listini = _db.listinimarche
.Where(i => i.datainiziovalidità == null || i.datainiziovalidità <= DateTime.Today)
.Where(i => i.datafinevalidità >= DateTime.Today)
.Where(i => i.inuso == "Si")
.Where(i => i.idaziendamaster == Const.IdAziendaMaster);
var results = new List <Product>();
foreach (var listino in listini)
{
var resultList = _db.Database.SqlQuery <Product>(GetProductQuery(listino.idlistino)).ToList();
if (marca != 0)
{
resultList = resultList.Where(i => i.idmarca == marca).ToList();
}
if (!string.IsNullOrEmpty(search))
{
resultList = resultList.Where(i => i.descrizionebrevearticolo.ToUpper().Contains(search.ToUpper()) || i.codicearticolo.ToUpper().Contains(search.ToUpper())).ToList();
}
results.AddRange(resultList);
}
model.Products = results.Skip(from).Take(12).ToList();
model.ProductTotal = results.Count();
model.ProductFrom = from + 1;
model.ProductTo = from + pageLen;
model.PageTotal = (int)Math.Ceiling((double)model.ProductTotal / pageLen);
model.CurrentPage = page;
model.CategoryDesc = _db.Marchegestite.Where(i => i.idmarca == marca).Select(i => i.descrizionemarca).FirstOrDefault();
model.Category = marca;
model.Search = search;
return(View(model));
}
public IActionResult Catalog(int id, int?pageSize, string drop, int page = 1)
{
var catalog = new ListProductViewModel();
if (pageSize == null)
{
pageSize = _configuration.GetValue <int>("PageSize");
}
catalog.PageSize = pageSize;
catalog.SortType = drop;
if (id == 6)
{
catalog.Data = _productRepository.GetAllByMonth(id, 0, page, pageSize.Value);
}
else
{
catalog.Data = _productRepository.GetAllPaging(id, string.Empty, page, pageSize.Value);
}
catalog.Category = _productCategoryRepository.GetById(id);
if (drop == "hightolow")
{
catalog.Data.Results = catalog.Data.Results.OrderByDescending(x => x.Price).ToList();
}
if (drop == "lowtohigh")
{
catalog.Data.Results = catalog.Data.Results.OrderByDescending(x => x.Price).Reverse().ToList();
}
if (drop == "atoz")
{
catalog.Data.Results = catalog.Data.Results.OrderByDescending(x => x.Name).Reverse().ToList();
}
if (drop == "ztoa")
{
catalog.Data.Results = catalog.Data.Results.OrderByDescending(x => x.Name).ToList();
}
return(View(catalog));
}
public static List <SanPham> GetListProduct(ListProductViewModel viewModel)
{
CSQL objSQL = new CSQL(DatabaseProduct.connectionString);
try
{
if (objSQL._OpenConnection() == false)
{
throw new Exception("Không thể kết nối");
}
// input param
if (viewModel.Tensp != null)
{
SqlParameter prmTensp = new SqlParameter("@Tensp", SqlDbType.NVarChar, 50);
prmTensp.Direction = ParameterDirection.Input;
objSQL.Command.Parameters.Add(prmTensp);
prmTensp.Value = viewModel.Tensp;
}
SqlDataReader reader = objSQL.GetDataReaderFromSP("LIST_PRODUCT_GET");
var ListProduct = new List <SanPham>();
SanPham SP;
while (reader.Read())
{
try
{
SP = new SanPham();
if (!reader.IsDBNull(reader.GetOrdinal("ID")))
{
SP.ID = reader.GetInt32(reader.GetOrdinal("ID"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Tensp")))
{
SP.Tensp = reader.GetString(reader.GetOrdinal("Tensp"));
}
if (!reader.IsDBNull(reader.GetOrdinal("Gia")))
{
SP.Gia = reader.GetDouble(reader.GetOrdinal("Gia"));
}
if (!reader.IsDBNull(reader.GetOrdinal("MoTaSP")))
{
SP.MoTaSP = reader.GetString(reader.GetOrdinal("MoTaSP"));
}
ListProduct.Add(SP);
}
catch (Exception ex) {
ex.ToString();
}
}
return(ListProduct);
}
catch (Exception ex)
{
LogFile.Error(ex.ToString()); // Ghi thông tin ra file
}
finally
{
objSQL._CloseConnection();
}
return(new List <SanPham>());
}
