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 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 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 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));
}
