public ActionResult AddProduct(Tbl_Product product)
{
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(product);
_unitOfWork.SaveChanges();
return(View());
}
public ActionResult UpdateProduct(ProductDetail pd, HttpPostedFileBase _ProductImage)
{
if (ModelState.IsValid)
{
Tbl_Product prod = _unitOfWork.GetRepositoryInstance <Tbl_Product>().GetFirstOrDefault(pd.ProductId);
prod = prod != null ? prod : new Tbl_Product();
prod.CategoryId = pd.CategoryId;
prod.Description = pd.Description;
prod.IsActive = pd.IsActive;
prod.IsFeatured = pd.IsFeatured;
prod.Price = pd.Price;
prod.ProductImage = _ProductImage != null ? _ProductImage.FileName : prod.ProductImage;
prod.ProductName = pd.ProductName;
prod.ModifiedDate = DateTime.Now;
if (prod.ProductId == 0)
{
prod.CreatedDate = DateTime.Now;
prod.IsDelete = false;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(prod);
}
else
{
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Update(prod);
_unitOfWork.SaveChanges();
}
if (_ProductImage != null)
{
uc.UploadImage(_ProductImage, prod.ProductId + "_", "/Content/ProductImage/", Server, _unitOfWork, 0, prod.ProductId, 0);
}
return(RedirectToAction("Products"));
}
pd.Categories = new SelectList(_unitOfWork.GetRepositoryInstance <Tbl_Category>().GetAllRecordsIQueryable(), "CategoryId", "CategoryName");
return(View("UpdateProduct", pd));
}
public IHttpActionResult Post(Tbl_Product product)
{
//adminLoginRepository.Insert(Admin);
productRepository.Insert(product);
return(Created("api/products/" + product.ProductId, product));
}
public SearchVM GetSearchProduct(string search, int page)
{
using (var db = new ProjectWebEntities())
{
var model = new SearchVM();
var pageNum = 10;
var key = "";
if (!string.IsNullOrEmpty(search))
{
key = Util.RemoveSignInVietnameseString(search);
}
var listSearchDb = db.sp_Search_Product(key).Where(p => p.IsDisable == false && p.IsStatus == 0).ToList();
var listSearch = new List <Tbl_Product>();
foreach (var item in listSearchDb)
{
var result = new Tbl_Product();
result.Name = item.Name;
result.ImagePath = item.ImagePath;
result.RealPrice = item.RealPrice;
result.Id = item.Id;
result.ProductTypeId = item.ProductTypeId;
//result.ProductTypeName = result.Tbl_ProductType.Name;
listSearch.Add(result);
}
model.ListSearch = listSearch.ToPagedList(page, pageNum);
return(model);
}
}
public ActionResult ProductEdit(Tbl_Product Product, HttpPostedFileBase file)
{
if (Session["AdminId"] != null)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/ProductImgs/"), pic);
file.SaveAs(path);
Product.ProductImage = pic;
}
else
{
Product.ProductImage = Product.ProductImage;
}
Product.ModifiedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Update(Product);
ViewBag.CategoryId = new SelectList(_DBEntity.Tbl_Category, "CategoryId", "CategoryName", Product.ProductId);
return(RedirectToAction("Product"));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult UpdateProduct(Tbl_Product Product, HttpPostedFileBase file)
{
if (Session["AdminId"] != null)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/ProductImgs/"), pic);
file.SaveAs(path);
}
Product.ProductImage = pic;
Product.IsDelete = false;
Product.CreatedDate = DateTime.Now;
_DBEntity.Tbl_Product.Add(Product);
_DBEntity.SaveChanges();
ViewBag.CategoryId = new SelectList(_DBEntity.Tbl_Category, "CategoryId", "CategoryName", Product.ProductId);
return(RedirectToAction("Product"));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public IActionResult Index()
{
var model = prod_repository.GetAll();
List <Tbl_Product> products = new List <Tbl_Product>();
foreach (var item in model)
{
Tbl_Product tbl_Product = new Tbl_Product();
tbl_Product.Category = item.Category;
tbl_Product.Description = item.Description;
tbl_Product.PriceSale = item.PriceSale;
tbl_Product.Price = item.Price;
tbl_Product.ProductName = item.ProductName;
tbl_Product.ProductId = item.ProductId;
Tbl_ProductImage img = new Tbl_ProductImage();
img = prodImage_repository.GetByParameter(i => i.ProductId == item.ProductId);
tbl_Product.ProductImage = img.ImageName;
products.Add(tbl_Product);
}
if (User.Identity.IsAuthenticated)
{
int?memberid = HttpContextAccessor.HttpContext.Session.GetInt32("memberid");
int count = cart_repository.GetAllRecordsCountByParameter(i => i.MemberId == memberid);
this.session.SetInt32("Cartcount", count);
}
return(View(products));
}
public JsonResult CartData()
{
var memberid = User.FindFirstValue(ClaimTypes.Sid);
List <Tbl_Product> product = new List <Tbl_Product>();
IEnumerable <Tbl_Cart> cart = Cart_repository.GetListByParameter(i => i.CartStatusId == 1 && i.MemberId == Convert.ToInt32(memberid));
foreach (var item in cart)
{
int _count = cart.Where(x => x.ProductId == item.ProductId).Count();
Tbl_Product tbl_Product = new Tbl_Product();
tbl_Product = prod_repository.GetById(item.ProductId);
Tbl_ProductImage img = new Tbl_ProductImage();
img = ProdImage_Repository.GetByParameter(i => i.ProductId == item.ProductId);
tbl_Product.ProductImage = img.ImageName;
tbl_Product.TotalProduct = _count;
if (product.Any(s => s.ProductId == item.ProductId))
{
continue;
}
product.Add(tbl_Product);
}
ViewBag.TotalPrice = product.Sum(i => i.PriceSale * i.TotalProduct);
//ViewBag.TotalPrice = product.Sum(i => i.PriceSale);
return(Json(product));
}
public IActionResult GetProduct(int id)
{
Tbl_Product pd = prod_repository.GetByParameter(i => i.ProductId == id);
pd.ProductImage = prodImage_repository.GetByParameter(i => i.ProductId == pd.ProductId).ImageName;
return(PartialView("_quickView", pd));
}
/// <summary>
/// Product Detail
/// </summary>
/// <param name="pId"></param>
/// <returns></returns>
public ActionResult ProductDetail(int pId)
{
Tbl_Product pd = _unitOfWork.GetRepositoryInstance <Tbl_Product>().GetFirstOrDefault(pId);
ViewBag.SimilarProducts = _unitOfWork.GetRepositoryInstance <Tbl_Product>().GetListByParameter(i => i.CategoryId == pd.CategoryId).ToList();
return(View(pd));
}
public ActionResult ProductDelete(int productId)
{
Tbl_Product delete = unit.GetRepositoryInstance <Tbl_Product>().GetFirstorDefault(productId);
delete.IsDelete = true;
unit.GetRepositoryInstance <Tbl_Product>().Update(delete);
return(RedirectToAction("Product"));
}
// [ValidateAntiForgeryToken]
// [Authorize(Roles = "Admin")]
public ActionResult _DeleteConfirmed(int id)
{
Tbl_Product _product = db.Tbl_Product.Find(id);
db.Tbl_Product.Remove(_product);
db.SaveChanges();
return(RedirectToAction("Product_List"));
}
public ActionResult Create(Tbl_Product model)
{
using (var db = new ProjectWebEntities())
{
try
{
model.DateCreate = DateTime.Now;
model.Url = Util.GenerateUrl(model.Name);
model.ImageDetails = Request.Form["multiImage"];
if (Request.Form["RealPrice"] != "" && Request.Form["RealPrice"] != null)
{
model.RealPrice = decimal.Parse(Request.Form["RealPrice"].Replace(".", "").Replace("đ", ""));
}
model.IsDisable = Request.Form["IsDisable"] != "on";
//if (Request.Form["ParentId"] != null && Request.Form["ParentId"] != "")
//{
// string[] parList = Request.Form["ParentId"].Split(',');
// for (int i = parList.Count() - 1; i >= 0; i--)
// {
// if (parList[i] != "")
// {
// if (int.Parse(parList[i]) > 0)
// {
// model.ProductTypeId = int.Parse(parList[i]);
// break;
// }
// }
// }
//}
//create new
if (model.Id == 0)
{
model.ViewNumber = 0;
db.Tbl_Product.Add(model);
db.pr_LogSystem_save("Thêm dữ liệu(" + model.Name + ")", "Thêm", "Product", User.Identity.Name);
db.SaveChanges();
}
else// edit
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
db.pr_LogSystem_save("Cập nhật dữ liệu(" + model.Name + ")", "Cập nhật", "Product", User.Identity.Name);
}
//save product icon
//Xóa cache
CacheHelper.ClearAllOutputCache();
}
catch (Exception ex)
{
_logger.Error("An Error Happened! ", ex);
}
return(RedirectToAction("Index", "Product"));
}
}
public ActionResult ProductAdd(Tbl_Product table)
{
using (GenericUnitOfWork _unitOfWork = new GenericUnitOfWork())
{
table.CreatedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(table);
return(RedirectToAction("Product"));
}
}
public ActionResult ProductEdit(Tbl_Product table)
{
table.ModifiedDate = DateTime.Now;
using (GenericUnitOfWork _unitOfWork = new GenericUnitOfWork())
{
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Update(table);
return(RedirectToAction("Product"));
}
}
public ActionResult ViewImageofProducts(Tbl_Product _product, int id)
{
// Tbl_Product _product = new Tbl_Product();
using (dbOnlineShoppingEntities db = new dbOnlineShoppingEntities())
{
_product = db.Tbl_Product.Where(x => x.ProductId == id).FirstOrDefault();
}
return(View(_product));
}
public ActionResult Create(int id)
{
using (var db = new ProjectWebEntities())
{
var model = new Tbl_Product();
if (id != 0)
{
model = db.Tbl_Product.Find(id);
}
return(View(model));
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Tbl_Product tbl_Product = await db.Products.FindAsync(id);
tbl_Product.IsDelete = true;
tbl_Product.IsActive = false;
tbl_Product.SalesmanUserId = User.Identity.GetUserId();
db.Products.AddOrUpdate(tbl_Product);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: Tbl_Product/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tbl_Product tbl_Product = await db.Products.FindAsync(id);
if (tbl_Product == null)
{
return(HttpNotFound());
}
return(View(tbl_Product));
}
private dbOnlineShoppingEntities db = new dbOnlineShoppingEntities(); // Connection String
// GET: HomePgProductDetails
public ActionResult ProductDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tbl_Product _product = db.Tbl_Product.Find(id);
if (_product == null)
{
return(HttpNotFound());
}
return(View(_product));
}
public ActionResult ProductAdd(Tbl_Product tbl, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Product_Images/"), pic);
file.SaveAs(path);
}
tbl.ProductImage = pic;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(tbl);
return(RedirectToAction("Product"));
}
// GET: Tbl_Product/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tbl_Product tbl_Product = await db.Products.FindAsync(id);
if (tbl_Product == null)
{
return(HttpNotFound());
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "CategoryName", tbl_Product.CategoryId);
return(View(tbl_Product));
}
public ActionResult ProductEdit(Tbl_Product tbl, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/ProductImg/"), pic);
file.SaveAs(path);
}
tbl.ProductImage = file != null? pic: tbl.ProductImage;
tbl.ModifiedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Update(tbl);
return(RedirectToAction("Product"));
}
public ActionResult EditProduct(Tbl_Product tbl, HttpPostedFileBase file)
{
string picture = null;
if (file != null)
{
picture = Path.GetFileName(file.FileName);
string path = Path.Combine(Server.MapPath("/Images/ProductImages/"), picture);
file.SaveAs(path);
}
tbl.ProductImagePath = file != null ? picture : tbl.ProductImagePath;
tbl.MdifiedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Update(tbl);
return(View());
}
public ActionResult AddProduct(Tbl_Product tbl, HttpPostedFileBase file)
{
string picture = null;
if (file != null)
{
picture = Path.GetFileName(file.FileName);
string path = Path.Combine(Server.MapPath("~/Images/ProductImages/"), picture);
file.SaveAs(path);
}
tbl.ProductImagePath = picture;
tbl.CreatedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(tbl);
return(Redirect("Products"));
}
public ActionResult ProductAdd(Tbl_Product product, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Images/pic"), pic);
file.SaveAs(path);
}
product.ProductImage = pic;
product.CreatedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(product);
return(RedirectToAction("Product"));
}
public async Task <ActionResult> Edit([Bind(Include = "ProductId,ProductName,CategoryId,IsActive,IsDelete,CreatedDate,ModifiedDate,Description,Price")] Tbl_Product tbl_Product)
{
if (ModelState.IsValid)
{
tbl_Product.IsActive = true;
tbl_Product.IsDelete = false;
tbl_Product.ModifiedDate = DateTime.Now;
tbl_Product.SalesmanUserId = User.Identity.GetUserId();
db.Entry(tbl_Product).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "CategoryName", tbl_Product.CategoryId);
return(View(tbl_Product));
}
public ActionResult ProductAdd(Tbl_Product tbl, HttpPostedFileBase file)
{
string picName = null;
string picPath;
if (file != null)
{
picName = System.IO.Path.GetFileName(file.FileName);
picPath = System.IO.Path.Combine(Server.MapPath("~/ProductImages/"), picName);
//file is uploaded
file.SaveAs(picPath);
}
tbl.ProductImage = picName;
tbl.CreatedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(tbl);
return(RedirectToAction("Product"));
}
public ActionResult ProductAdd(Tbl_Product new_p, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Products/"), pic);
file.SaveAs(path);
}
new_p.ProductImage = pic;
new_p.CreatedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(new_p);
//_unitOfWork.db.func_insert_procduct(new_p.ProductName, new_p.CategoryId, new_p.Price);
//ViewBag.CategoryId = new SelectList(_unitOfWork.GetRepositoryInstance<Tbl_Category>().GetAllRecords(),"CategoryId", "CategoryName",new_p.CategoryId);
return(RedirectToAction("Products"));
}
public ActionResult ProductAdd(Tbl_Product tbl, HttpPostedFileBase file)
{
string pic = null;
if (file != null)
{
var fileName = Path.GetFileNameWithoutExtension(file.FileName);
var extention = Path.GetExtension(file.FileName);
pic = fileName.Replace(" ", "_") + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + extention;
string path = Path.Combine(Server.MapPath("~/ProductImg/"), pic);
file.SaveAs(path);
}
tbl.ProductImage = pic;
tbl.CreatedDate = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Product>().Add(tbl);
return(RedirectToAction("Product"));
}
