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