public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file)
{
//int id = model.ProId;
//using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
//{
// model.Categories = new SelectList(_dbContext.Product_Categories.ToList(), "CatgId", "CategoryName");
//}
//model.Images = Directory.EnumerateFiles(Server.MapPath("~/Content/Images")).Select(i => Path.GetFileName(i));
bool isSave = false;
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
ProductDTO productdto = Mapper.Map <ProductVM, ProductDTO>(model);
Product_Name prod = Mapper.Map <ProductDTO, Product_Name>(productdto);
isSave = productservice.EditProductPost(prod);
if (isSave == true)
{
TempData["Message"] = "You have edited the product";
}
if (file != null)
{
int id = prod.ProId;
Product_Name pro = _dbContext.Product_Name.Find(id);
string path = Server.MapPath("/Images/" + model.ImageName);
FileInfo filez = new FileInfo(path);
filez.Delete();
AddImage(pro, file);
_dbContext.SaveChanges();
}
return(RedirectToAction("EditProduct"));
}
//Api service returning for list of product
public List <Product_Name> GetProductName()
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
return(_dbContext.Product_Name.ToList());
}
}
public Product_Name GetProductName(string prName)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
return(_dbContext.Product_Name.Where(x => x.ProductName == prName).FirstOrDefault());
}
}
//Api Service for returning a single product
public Product_Name GetProductName(int id)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
return(_dbContext.Product_Name.Where(x => x.ProId == id).FirstOrDefault());
}
}
public bool AddPage(Page model)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
string slug;
Page page = new Page
{
PageTitle = model.PageTitle
};
//check slug and set
if (string.IsNullOrWhiteSpace(model.Slug))
{
slug = model.PageTitle.Replace(" ", "-").ToLower();
}
else
{
slug = model.Slug.Replace(" ", "-").ToLower();
}
//Set title and slug unique
if (_dbContext.Pages.Any(p => p.PageTitle == model.PageTitle || _dbContext.Pages.Any(s => s.Slug == model.Slug)))
{
return(false);
}
page.Slug = slug;
page.Body = model.Body;
page.HasSidebar = model.HasSidebar;
page.Sorting = 100;
_dbContext.Pages.Add(page);
_dbContext.SaveChanges();
return(true);
}
}
public List <Product_Categories> GetCategories()
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
return(_dbContext.Product_Categories.ToList());
}
}
public List <Page> GetPages()
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
return(_dbContext.Pages.ToList());
}
}
public Product_Name EditProduct(int id)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
Product_Name product = _dbContext.Product_Name.Find(id);
return(product);
}
}
public ActionResult PageDetail(int id)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
var page = _dbContext.Pages.Find(id);
var pagedto = Mapper.Map <Page, PageDTO>(page);
PageVM model = new PageVM(pagedto);
return(View(model));
}
public List <Product_Name> Products(int?page, int?catId)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
return(_dbContext.Product_Name.ToArray()
.Where(c => catId == null || catId == 0 || c.CatFKId == catId)
.ToList());
}
}
public ActionResult EditProduct(int id)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
ProductDTO productdto = Mapper.Map <Product_Name, ProductDTO>(productservice.EditProduct(id));
ProductVM model = Mapper.Map <ProductDTO, ProductVM>(productdto);
model.Categories = new SelectList(_dbContext.Product_Categories.ToList(), "CatgId", "CategoryName");
model.Images = Directory.EnumerateFiles(Server.MapPath("~/Images/" + model.ProductName)).Select(i => Path.GetFileName(i));
return(View(model));
}
public ActionResult AddProduct()
{
ProductVM model = new ProductVM();
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
model.Categories = new SelectList(_dbContext.Product_Categories.ToList(), "CatgId", "CategoryName");
}
return(View(model));
}
public tblSidebar EditSidebar(tblSidebar bar)
{
tblSidebar sidebar = new tblSidebar();
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
sidebar = _dbContext.tblSidebars.Find(1);
sidebar.Body = bar.Body;
_dbContext.SaveChanges();
}
return(sidebar);
}
public ActionResult EditSidebar()
{
SidebarVM model;
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
tblSidebar sidebar = _dbContext.tblSidebars.Find(1);
var sidedto = Mapper.Map <tblSidebar, SidebarDTO>(sidebar);
model = new SidebarVM(sidedto);
}
return(View(model));
}
public ActionResult Products(int?page, int?catId)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
var pageNumber = page ?? 1;
List <ProductDTO> prod = productservice.Products(page, catId).Select(Mapper.Map <Product_Name, ProductDTO>).ToList();
List <ProductVM> productvm = prod.Select(v => new ProductVM(v)).ToList();
ViewBag.Categories = new SelectList(_dbContext.Product_Categories.ToList(), "CatgId", "CategoryName");
ViewBag.SelectedCat = catId.ToString();
var onePageOfProducts = productvm.ToPagedList(pageNumber, 3);
ViewBag.OnePageOfProducts = onePageOfProducts;
return(View(productvm));
}
public String DeleteCategory(int id)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
//bool result = false;
var catgry = _dbContext.Product_Categories.Find(id);
if (catgry != null)
{
_dbContext.Product_Categories.Remove(catgry);
_dbContext.SaveChanges();
//result = true;
}
return("success");
}
public String DeletePage(int id)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
//bool result = false;
var page = _dbContext.Pages.Find(id);
if (page != null)
{
_dbContext.Pages.Remove(page);
_dbContext.SaveChanges();
//result = true;
}
return("success");
}
//Api Service for adding new product
public bool AddProduct(Product_Name product, HttpPostedFileBase file)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
if (_dbContext.Product_Name.Any(p => p.ProductName == product.ProductName))
{
return(false);
}
product.Slug = product.ProductName.Replace(" ", "-").ToLower();
_dbContext.Product_Name.Add(product);
_dbContext.SaveChanges();
}
return(true);
}
public String RenameCategory(string catgName, int id)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
if (_dbContext.Product_Categories.Any(c => c.CategoryName == catgName))
{
return("titletaken");
}
Product_Categories catg = _dbContext.Product_Categories.Find(id);
catg.CategoryName = catgName;
catg.Slug = catgName.Replace(" ", "-").ToLower();
_dbContext.SaveChanges();
};
return("ok");
}
public bool ReorderCategory(int[] idz)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
int count = 1;
Product_Categories catg;
foreach (var ctId in idz)
{
catg = _dbContext.Product_Categories.Find(ctId);
catg.Sorting = count;
_dbContext.SaveChanges();
count++;
}
}
return(true);
}
public bool ReorderPage(int[] ids)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
int count = 1;
Page pg;
foreach (var pgId in ids)
{
pg = _dbContext.Pages.Find(pgId);
pg.Sorting = count;
_dbContext.SaveChanges();
count++;
}
}
return(true);
}
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
ProductDTO dto = Mapper.Map <ProductVM, ProductDTO>(model);
Product_Name prod = Mapper.Map <ProductDTO, Product_Name>(dto);
var isSave = productservice.AddProduct(prod, file);
if (isSave == true)
{
int id = prod.ProId;
Product_Name pro = _dbContext.Product_Name.Find(id);
AddImage(pro, file);
_dbContext.SaveChanges();
ViewBag.Message = "Success";
}
return(RedirectToAction("Products"));
}
public String DeleteProduct(int id)
{
Liquor_ShopEntities _dbContext = new Liquor_ShopEntities();
//bool result = false;
var product = _dbContext.Product_Name.Find(id);
if (product != null)
{
string path = Server.MapPath("/Images/" + product.ImageName);
FileInfo filez = new FileInfo(path);
filez.Delete();
_dbContext.Product_Name.Remove(product);
_dbContext.SaveChanges();
//result = true;
}
return("success");
}
public bool EditProductPost(Product_Name prod)
{
int id = prod.ProId;
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
Product_Name product = _dbContext.Product_Name.Find(id);
product.ProductName = prod.ProductName;
product.Description = prod.Description;
product.Price = prod.Price;
product.Size = prod.Size;
product.Slug = prod.ProductName.Replace(" ", "-").ToLower();
product.SKU = prod.SKU;
product.CatFKId = prod.CatFKId;
product.ImageName = prod.ImageName;
_dbContext.SaveChanges();
}
return(true);
}
public string AddCategory(string category)
{
string id;
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
if (_dbContext.Product_Categories.Any(c => c.CategoryName == category))
{
return("titletaken");
}
Product_Categories cat = new Product_Categories
{
CategoryName = category,
Slug = category.Replace(" ", "-").ToLower(),
Sorting = 100,
};
_dbContext.Product_Categories.Add(cat);
_dbContext.SaveChanges();
id = cat.CatgId.ToString();
}
return(id);
}
public bool EditPage(Page model)
{
using (Liquor_ShopEntities _dbContext = new Liquor_ShopEntities())
{
int id = model.PageId;
string slug = "home";
Page page = _dbContext.Pages.Find(id);
page.PageTitle = model.PageTitle;
//check slug and set
if (model.Slug != "home")
{
if (string.IsNullOrWhiteSpace(model.Slug))
{
slug = model.PageTitle.Replace(" ", "-").ToLower();
}
else
{
slug = model.Slug.Replace(" ", "-").ToLower();
}
}
//Set title and slug unique
if (_dbContext.Pages.Where(p => p.PageId != id).Any(p => p.PageTitle == model.PageTitle) ||
_dbContext.Pages.Where(s => s.PageId != id).Any(s => s.Slug == slug))
{
return(false);
}
page.Slug = slug;
page.Body = model.Body;
page.HasSidebar = model.HasSidebar;
_dbContext.SaveChanges();
return(true);
}
}
