public ActionResult DeleteConfirmed(int id)
{
PageDesign pagedesign = PageDesignRepository.GetSingle(id);
try
{
PageDesignRepository.Delete(pagedesign);
PageDesignRepository.Save();
if (IsSuperAdmin)
{
return(RedirectToAction("Index", new { storePageDesignId = pagedesign.StorePageDesignId }));
}
else
{
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
Logger.Error(ex, "Unable to delete:" + ex.StackTrace, pagedesign);
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(pagedesign));
}
public ActionResult ImportExcel(int id, HttpPostedFileBase excelFile = null)
{
if (excelFile == null)
{
return(RedirectToAction("Index", new { storePageDesignId = id }));
}
var dt = ExcelHelper.PostValues(excelFile);
int selectedStoreId = id;
var resultList = PageDesignRepository.GetPageDesignByStoreId(selectedStoreId, "");
var pageDesingsExcelReport = MapToListHelper.ToList <PageDesign>(dt);
foreach (var pageDesign in pageDesingsExcelReport.Where(r =>
!r.Name.Equals("Name", StringComparison.InvariantCultureIgnoreCase) &&
!r.PageTemplate.Equals("PageTemplate", StringComparison.InvariantCultureIgnoreCase)))
{
pageDesign.StorePageDesignId = id;
var pageDesignTask = resultList.FirstOrDefault(r => r.Name.Equals(pageDesign.Name, StringComparison.InvariantCultureIgnoreCase));
if (pageDesignTask == null)
{
pageDesign.Id = 0;
PageDesignRepository.Add(pageDesign);
}
else
{
pageDesignTask.PageTemplate = pageDesign.PageTemplate;
PageDesignRepository.Edit(pageDesignTask);
}
pageDesign.CreatedDate = DateTime.Now;
pageDesign.UpdatedDate = DateTime.Now;
}
PageDesignRepository.Save();
return(RedirectToAction("Index", new { storePageDesignId = id }));
}
//
// GET: /PageDesigns/
public ViewResult Index(int storePageDesignId = 0, String search = "")
{
var resultList = new List <PageDesign>();
resultList = PageDesignRepository.GetPageDesignByStoreId(storePageDesignId, search);
return(View(resultList));
}
public void TestGetStoreActiveNavigationsAsync()
{
int storeId = 9;
var nav = new NavigationRepository(new StoreContext(ConnectionString));
var pds = new PageDesignRepository(new StoreContext(ConnectionString));
var mainMenu = nav.GetStoreActiveNavigationsAsync(storeId);
var pageDesignTask = pds.GetPageDesignByName(storeId, "MainLayout");
}
public ActionResult ExportExcel(int id = 0)
{
int storePageDesignId = id;
var storePageDesing = StorePageDesignRepository.GetSingle(storePageDesignId);
var resultList = PageDesignRepository.GetPageDesignByStoreId(storePageDesignId, "");
var dt = MapToListHelper.ToDataTable(resultList);
var report = ExcelHelper.GetExcelByteArrayFromDataTable(dt);
return(File(report, "application/vnd.ms-excel",
String.Format("PageDesigns-{0}-{1}.xls", storePageDesing.Name, DateTime.Now.ToString("yyyyMMdd", System.Globalization.CultureInfo.GetCultureInfo("en-US")))));
}
public async Task <ActionResult> Index3()
{
int?categoryId = null;
String ConnectionString = "Stores";
var rep = new ProductRepository(new StoreContext(ConnectionString));
var rep2 = new ContentRepository(new StoreContext(ConnectionString));
var rep3 = new PageDesignRepository(new StoreContext(ConnectionString));
var rep4 = new ProductCategoryRepository(new StoreContext(ConnectionString));
var rep5 = new CategoryRepository(new StoreContext(ConnectionString));
var rep6 = new FileManagerRepository(new StoreContext(ConnectionString));
var productsTask = rep.GetProductsByBrandAsync(StoreId, 5, 100, null);
var pageDesignTask = rep3.GetPageDesignByName(StoreId, "HomePage");
var blogsTask = rep2.GetMainPageContentsAsync(StoreId, categoryId, StoreConstants.BlogsType, 5);
var newsTask = rep2.GetMainPageContentsAsync(StoreId, categoryId, StoreConstants.NewsType, 5);
var productCategoriesTask = rep4.GetProductCategoriesByStoreIdAsync(StoreId, StoreConstants.ProductType, true);
var categoriesTask = rep5.GetCategoriesByStoreIdAsync(StoreId, StoreConstants.NewsType, true);
var sliderTask = rep6.GetStoreCarouselsAsync(StoreId, 58);
//IProductService rep = ProductService;
//IContentService rep2 = ContentService;
//IPageDesignService rep3 = PageDesignService;
//IProductCategoryService rep4 = ProductCategoryService;
//ICategoryService rep5 = CategoryService;
//IFileManagerService rep6 = FileManagerService;
await Task.WhenAll(productsTask, blogsTask, newsTask, pageDesignTask, sliderTask, categoriesTask,
productCategoriesTask);
HomePageHelper.StoreId = this.StoreId;
HomePageHelper.StoreSettings = GetStoreSettings();
var products = productsTask.Result;
var blogs = blogsTask.Result;
var news = newsTask.Result;
var pageDesing = pageDesignTask.Result;
var sliderImages = sliderTask.Result;
var categories = categoriesTask.Result;
var productCategories = productCategoriesTask.Result;
StoreLiquidResult liquidResult = HomePageHelper.GetHomePageDesign(pageDesing, sliderImages, products, blogs,
news, categories, productCategories);
liquidResult.MyStore = this.MyStore;
return(View(liquidResult));
}
public void TestGetRelatedContentsPartial()
{
var rr = new ContentRepository(new StoreContext(ConnectionString));
var pds = new PageDesignRepository(new StoreContext(ConnectionString));
var cat = new CategoryRepository(new StoreContext(ConnectionString));
int categoryId = 77;
var contentType = "news";
var categoryTask = cat.GetCategoryAsync(categoryId);
int take = 5;
var relatedContentsTask = rr.GetContentByTypeAndCategoryIdAsync(9, contentType, categoryId, take, 0);
var pageDesignTask = pds.GetPageDesignByName(9, "RelatedContentsPartial");
}
public ActionResult SaveOrEdit(PageDesign pagedesign)
{
var spd = StorePageDesignRepository.GetSingle(pagedesign.StorePageDesignId);
ViewBag.StorePageDesignName = spd.Name;
try
{
if (ModelState.IsValid)
{
if (pagedesign.Id > 0)
{
PageDesignRepository.Edit(pagedesign);
}
else
{
var isSamePageNameExists = PageDesignRepository.GetPageDesignByStoreId(pagedesign.StorePageDesignId, "")
.Any(r => r.Name.Equals(pagedesign.Name, StringComparison.InvariantCultureIgnoreCase));
if (isSamePageNameExists)
{
ModelState.AddModelError("", "Same Page Desing Name exists, put a different name.");
return(View(pagedesign));
}
PageDesignRepository.Add(pagedesign);
}
PageDesignRepository.Save();
if (IsSuperAdmin)
{
return(RedirectToAction("SaveOrEdit", new { id = pagedesign.Id, storePageDesignId = pagedesign.StorePageDesignId }));
}
else
{
return(RedirectToAction("Index"));
}
}
}
catch (Exception ex)
{
Logger.Error(ex, "Unable to save:" + ex.StackTrace, pagedesign);
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(pagedesign));
}
public ActionResult SetPageDesignText(int id = 0, String text = "", String name = "", int storePageDesignId = 0)
{
var item = new PageDesign();
if (id == 0)
{
if (storePageDesignId != 0 && !String.IsNullOrEmpty(name))
{
var isSamePageNameExists =
PageDesignRepository.GetPageDesignByStoreId(storePageDesignId, "")
.Any(r => r.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase));
if (isSamePageNameExists)
{
return(Json("Same name exists.", JsonRequestBehavior.AllowGet));
}
item.PageTemplate = text;
item.CreatedDate = DateTime.Now;
item.State = true;
item.Name = name;
item.Type = name;
item.UpdatedDate = DateTime.Now;
PageDesignRepository.Add(item);
}
}
else
{
item = PageDesignRepository.GetSingle(id);
item.PageTemplate = text;
item.Name = name;
item.Type = name;
item.UpdatedDate = DateTime.Now;
PageDesignRepository.Edit(item);
}
PageDesignRepository.Save();
return(Json("", JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> Index()
{
int?categoryId = null;
String ConnectionString = "Stores";
var rep = new ProductRepository(new StoreContext(ConnectionString));
var rep2 = new ContentRepository(new StoreContext(ConnectionString));
var rep3 = new PageDesignRepository(new StoreContext(ConnectionString));
var list = rep.GetProductsByBrandAsync(StoreId, 5, 100, null);
var pageDesignTask = rep3.GetPageDesignByName(StoreId, "HomePage");
var blogsTask = rep2.GetMainPageContentsAsync(StoreId, categoryId, StoreConstants.BlogsType, 5);
var newsTask = rep2.GetMainPageContentsAsync(StoreId, categoryId, StoreConstants.NewsType, 5);
await Task.WhenAll(list, pageDesignTask, blogsTask, newsTask);
return(View(list.Result));
}
//
// GET: /PageDesigns/Edit/5
public ActionResult SaveOrEdit(int id = 0, int storePageDesignId = 0)
{
var pagedesign = new PageDesign();
if (id == 0)
{
pagedesign.CreatedDate = DateTime.Now;
pagedesign.State = true;
pagedesign.UpdatedDate = DateTime.Now;
pagedesign.StorePageDesignId = storePageDesignId;
}
else
{
pagedesign = PageDesignRepository.GetSingle(id);
pagedesign.State = true;
pagedesign.UpdatedDate = DateTime.Now;
}
var spd = StorePageDesignRepository.GetSingle(pagedesign.StorePageDesignId);
ViewBag.StorePageDesignName = spd.Name;
return(View(pagedesign));
}
public ActionResult CopyPageDesign(int id)
{
PageDesign pagedesign = PageDesignRepository.GetSingle(id);
try
{
var guid = Guid.NewGuid().ToString();
var pagedesignCopy = new PageDesign();
pagedesignCopy.PageTemplate = pagedesign.PageTemplate;
pagedesignCopy.Name = pagedesign.Name + "_" + guid;
pagedesignCopy.Type = pagedesign.Type + "_" + guid;
pagedesignCopy.Id = 0;
pagedesignCopy.CreatedDate = DateTime.Now;
pagedesignCopy.State = true;
pagedesignCopy.UpdatedDate = DateTime.Now;
pagedesignCopy.StorePageDesignId = pagedesign.StorePageDesignId;
PageDesignRepository.Add(pagedesignCopy);
PageDesignRepository.Save();
}
catch (Exception ex)
{
Logger.Error(ex, "Unable to save:" + ex.StackTrace, pagedesign);
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
if (IsSuperAdmin)
{
return(RedirectToAction("Index", new { storePageDesignId = pagedesign.StorePageDesignId }));
}
else
{
return(RedirectToAction("Index"));
}
}
public Task <PageDesign> GetPageDesignByName(int storeId, string name)
{
return(PageDesignRepository.GetPageDesignByName(storeId, name));
}
public ActionResult GetPageDesignText(int id)
{
var item = PageDesignRepository.GetSingle(id);
return(Json(item, JsonRequestBehavior.AllowGet));
}
//
// GET: /PageDesigns/Details/5
public ViewResult Details(int id)
{
PageDesign pagedesign = PageDesignRepository.GetSingle(id);
return(View(pagedesign));
}
public ActionResult SearchAutoComplete(String term, String action, String controller, int id = 0)
{
String searchKey = term;
var list = new List <String>();
if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("PageDesigns", StringComparison.InvariantCultureIgnoreCase))
{
int storePageDesignId = id;
list = PageDesignRepository.GetPageDesignByStoreId(storePageDesignId, searchKey).Select(r => r.Name).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
int storeId = GetStoreId(id);
if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Products", StringComparison.InvariantCultureIgnoreCase))
{
list = ProductRepository.GetProductByTypeAndCategoryId(storeId, StoreConstants.ProductType, 0, searchKey, null).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("News", StringComparison.InvariantCultureIgnoreCase))
{
list = ContentRepository.GetContentsByStoreId(storeId, searchKey, StoreConstants.NewsType).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Blogs", StringComparison.InvariantCultureIgnoreCase))
{
list = ContentRepository.GetContentsByStoreId(storeId, searchKey, StoreConstants.BlogsType).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Navigations", StringComparison.InvariantCultureIgnoreCase))
{
list = NavigationRepository.GetNavigationsByStoreId(storeId, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Stores", StringComparison.InvariantCultureIgnoreCase))
{
list = StoreRepository.GetStoresByStoreId(searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Labels", StringComparison.InvariantCultureIgnoreCase))
{
list = LabelRepository.GetLabelsByStoreId(storeId, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("EmailLists", StringComparison.InvariantCultureIgnoreCase))
{
list = EmailListRepository.GetStoreEmailList(storeId, searchKey).Select(r => r.Email).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Contacts", StringComparison.InvariantCultureIgnoreCase))
{
list = ContactRepository.GetContactsByStoreId(storeId, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Locations", StringComparison.InvariantCultureIgnoreCase))
{
list = LocationRepository.GetLocationsByStoreId(storeId, searchKey).Select(r => r.Address).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Brands", StringComparison.InvariantCultureIgnoreCase))
{
list = BrandRepository.GetBrandsByStoreId(storeId, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("ProductCategories", StringComparison.InvariantCultureIgnoreCase))
{
list = ProductCategoryRepository.GetProductCategoriesByStoreId(storeId, StoreConstants.ProductType, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("BlogsCategories", StringComparison.InvariantCultureIgnoreCase))
{
list = CategoryRepository.GetCategoriesByStoreId(storeId, StoreConstants.BlogsType, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("NewsCategories", StringComparison.InvariantCultureIgnoreCase))
{
list = CategoryRepository.GetCategoriesByStoreId(storeId, StoreConstants.NewsType, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("StoreCategories", StringComparison.InvariantCultureIgnoreCase))
{
list = CategoryRepository.GetCategoriesByStoreId(0, StoreConstants.StoreType, searchKey).Select(r => r.Name).ToList();
}
else if (action.Equals("DisplayImages", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("FileManager", StringComparison.InvariantCultureIgnoreCase))
{
list = FileManagerRepository.GetFilesBySearchKey(storeId, searchKey).Select(r => r.OriginalFilename).ToList();
}
else if (action.Equals("Settings", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Stores", StringComparison.InvariantCultureIgnoreCase))
{
list = SettingRepository.GetStoreSettingsByType(storeId, "", searchKey).Select(r => String.Format("{0}", r.SettingKey)).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("StoreLanguages", StringComparison.InvariantCultureIgnoreCase))
{
list = StoreLanguageRepository.GetStoreLanguages(storeId, searchKey).Select(r => String.Format("{0}", r.Name)).ToList();
}
else if (action.Equals("Index", StringComparison.InvariantCultureIgnoreCase) &&
controller.Equals("Activities", StringComparison.InvariantCultureIgnoreCase))
{
list = ActivityRepository.GetActivitiesByStoreId(storeId, searchKey).Select(r => String.Format("{0}", r.Name)).ToList();
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
//
// GET: /PageDesigns/Delete/5
public ActionResult Delete(int id)
{
PageDesign pagedesign = PageDesignRepository.GetSingle(id);
return(View(pagedesign));
}
public void TestGetPageDesignByName()
{
int storeId = 9;
var pds = new PageDesignRepository(new StoreContext(ConnectionString));
var pageDesignTask = pds.GetPageDesignByName(storeId, "MainLayoutJavaScriptFiles");
}
