public ActionResult DeleteFileManagerGridItem(List <String> values)
{
try
{
List <String> googleIdList = new List <string>();
List <int> idList = new List <int>();
foreach (var value in values)
{
String googleId = value.Split("-".ToCharArray())[0];
String id = value.Split("-".ToCharArray())[1];
googleIdList.Add(googleId);
idList.Add(id.ToInt());
}
var item = FileManagerRepository.GetSingle(idList.FirstOrDefault());
ConnectToStoreGoogleDrive(item.StoreId);
foreach (String v in values)
{
string googledriveFileId = v;
Task.Run(() => DeleteFile(googledriveFileId));
Thread.Sleep(50);
}
}
catch (DbEntityValidationException ex)
{
var message = GetDbEntityValidationExceptionDetail(ex);
Logger.Error(ex, "DbEntityValidationException:" + message);
}
catch (Exception exception)
{
Logger.Error(exception, "DeleteFileManagerGridItem :" + exception.StackTrace, String.Join(",", values));
}
return(Json(values, JsonRequestBehavior.AllowGet));
}
private void DeleteFile(string id)
{
var f = new FileManager();
if (id.ToInt() > 0)
{
f = FileManagerRepository.GetSingle(id.ToInt());
}
else
{
f = FileManagerRepository.GetFilesByGoogleImageId(id);
}
var filename = f.Title;
try
{
ConnectToStoreGoogleDrive(SessionStoreId);
this.UploadHelper.deleteFile(f.GoogleImageId);
}
catch (Exception ewx)
{
Logger.Error(ewx, "Exception is occured." + ewx.StackTrace);
}
FileManagerRepository.Delete(f);
FileManagerRepository.Save();
}
public ActionResult ChangeFileManagerGridOrderingOrState(List <OrderingItem> values, String checkbox = "")
{
try
{
foreach (OrderingItem item in values)
{
var content = FileManagerRepository.GetSingle(item.Id);
if (String.IsNullOrEmpty(checkbox))
{
content.Ordering = item.Ordering;
}
else if (checkbox.Equals("state", StringComparison.InvariantCultureIgnoreCase))
{
content.State = item.State;
}
else if (checkbox.Equals("Carousel", StringComparison.InvariantCultureIgnoreCase))
{
content.IsCarousel = item.State;
}
FileManagerRepository.Edit(content);
}
FileManagerRepository.Save();
}
catch (Exception exception)
{
Logger.Error(exception, "ChangeFileManagerGridOrderingOrState :" + exception.StackTrace, String.Join(",", values));
}
return(Json(new { values, checkbox }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Reference this in HTML as <img src="/Photo/WatermarkedImage/{ID}" />
/// Simplistic example supporting only jpeg images.
/// </summary>
/// <param name="ID">Photo ID</param>
public ActionResult WatermarkedImage(int id)
{
// Attempt to fetch the photo record from the database using Entity Framework 4.2.
var file = FileManagerRepository.GetSingle(id);
if (file != null) // Found the indicated photo record.
{
var dic = new Dictionary <String, String>();
// Create WebImage from photo data.
// Should have 'using System.Web.Helpers' but just to make it clear...
String url = String.Format("https://docs.google.com/uc?id={0}", file.GoogleImageId);
byte[] imageData = GeneralHelper.GetImageFromUrlFromCache(url, dic);
var wi = new System.Web.Helpers.WebImage(imageData);
// Apply the watermark.
wi.AddTextWatermark("EMIN YUCE");
// Extract byte array.
var image = wi.GetBytes("image/jpeg");
// Return byte array as jpeg.
return(File(image, "image/jpeg"));
}
else // Did not find a record with passed ID.
{
return(null); // 'Missing image' icon will display on browser.
}
}
public void GetProductCategoriesByStoreIdFromCache2()
{
FileManagerRepository ssss = new FileManagerRepository(dbContext);
var m = ssss.GetFilesByGoogleImageIdArray(new string[] { "0B9lWnliAZuUdaFRwZmVLZXRYWE0", "0B9lWnliAZuUdb1RaamRITnhkbXc", "0B9lWnliAZuUdNHlKdTVaRzg3OWM" });
Assert.IsNotNull(m);
}
public ActionResult DisplayImages(int storeId = 1, String search = "")
{
storeId = GetStoreId(storeId);
ViewBag.Store = StoreRepository.GetSingle(storeId);
var images = FileManagerRepository.GetFilesBySearchKey(storeId, search);
return(View(images));
}
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 PhotosViewModel GetPhotos(int page)
{
var resultModel = new PhotosViewModel();
resultModel.SStore = this.MyStore;
var m = FileManagerRepository.GetImagesByStoreId(MyStore.Id, page, 24);
resultModel.SFileManagers = new PagedList <FileManager>(m.items, m.page - 1, m.pageSize, m.totalItemCount);
resultModel.SNavigations = NavigationRepository.GetStoreActiveNavigations(this.MyStore.Id);
resultModel.SSettings = this.GetStoreSettings();
return(resultModel);
}
public void Thumbnail(int id, int storeId, int width = 60, int height = 60)
{
var dic = new Dictionary <String, String>();
// Loading photos’ info from database for specific image...
var file = FileManagerRepository.GetFilesByStoreIdFromCache(storeId).FirstOrDefault(r => r.Id == id);
String url = String.Format("https://docs.google.com/uc?id={0}", file.GoogleImageId);
byte[] imageData = GeneralHelper.GetImageFromUrlFromCache(url, dic);
new WebImage(imageData)
.Resize(width, height, false, true) // Resizing the image to 100x100 px on the fly...
.Crop(1, 1) // Cropping it to remove 1px border at top and left sides (bug in WebImage)
.Write();
}
public ActionResult GetImagesByLabels(int storeId, String[] labels, String entityType, int id)
{
var images = FileManagerRepository.GetFilesByStoreIdAndLabels(storeId, labels);
var list = new List <FileManager>();
if (entityType.Equals(StoreConstants.ProductType, StringComparison.InvariantCultureIgnoreCase))
{
var productFiles = ProductFileRepository.GetProductFilesByProductId(id);
list.AddRange(images.Where(r => !productFiles.Select(r1 => r1.FileManagerId).Contains(r.Id)));
}
else if (entityType.Equals(StoreConstants.BlogsType, StringComparison.InvariantCultureIgnoreCase) || entityType.Equals(StoreConstants.NewsType, StringComparison.InvariantCultureIgnoreCase))
{
var contentFiles = ContentFileRepository.GetContentFilesByContentId(id);
list.AddRange(images.Where(r => !contentFiles.Select(r1 => r1.FileManagerId).Contains(r.Id)));
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
private void DeleteFileFromDb(string fileStatus, List <FileManager> files)
{
try
{
if (files.Count > 0)
{
foreach (var fileManager in files)
{
FileManagerRepository.Delete(fileManager);
}
FileManagerRepository.Save();
Logger.Info(String.Format("Deleted " + fileStatus + " files:" + files.Count));
}
}
catch (Exception ex)
{
Logger.Error(ex, "DeleteFiles From Db:" + ex.Message, fileStatus);
}
}
private void DeleteFile(string googledriveFileId)
{
String id = "";
try
{
String googleId = googledriveFileId.Split("-".ToCharArray())[0];
id = googledriveFileId.Split("-".ToCharArray())[1];
if (!String.IsNullOrEmpty(googleId))
{
try
{
UploadHelper.deleteFile(googleId);
}
catch (Exception ex)
{
Logger.Error(ex, String.Format("GoogleId={0} file could not deleted from google drive", googledriveFileId) + " " + ex.StackTrace, googledriveFileId);
}
}
}
catch (Exception ex)
{
Logger.Error(ex, String.Format("GoogleId={0} could not deleted from DB.", googledriveFileId) + " " + ex.StackTrace, googledriveFileId);
}
try
{
var item = FileManagerRepository.GetSingle(id.ToInt());
FileManagerRepository.Delete(item);
FileManagerRepository.Save();
}
catch (DbEntityValidationException ex)
{
var message = GetDbEntityValidationExceptionDetail(ex);
Logger.Error(ex, "DbEntityValidationException:" + message);
}
catch (Exception ex)
{
Logger.Error(ex, String.Format("GoogleId={0} could not deleted from DB.", googledriveFileId) + ex.StackTrace, googledriveFileId);
}
}
public ActionResult ChangeIsCarouselState(int fileId = 0, bool isCarousel = false)
{
try
{
var s = FileManagerRepository.GetSingle(fileId);
s.IsCarousel = isCarousel;
FileManagerRepository.Edit(s);
FileManagerRepository.Save();
}
catch (DbEntityValidationException ex)
{
var message = GetDbEntityValidationExceptionDetail(ex);
Logger.Error(ex, "DbEntityValidationException:" + message);
}
catch (Exception exception)
{
Logger.Error(exception, "ChangeIsCarouselState fileId" + fileId + " isCarousel:" + isCarousel + " " + exception.StackTrace, fileId, isCarousel);
}
return(Json(new { fileId, isCarousel }, JsonRequestBehavior.AllowGet));
}
private void DeleteFiles(string fileStatus)
{
var errorFiles = FileManagerRepository.GetFilesByFileStatus(fileStatus);
var stores = errorFiles.GroupBy(r => r.StoreId);
var errorList = new List <int>();
foreach (var store in stores)
{
try
{
int storeId = store.Key;
ConnectGoogleDrive(storeId);
errorList.AddRange(DeleteGoogleDriveFiles(errorFiles));
}
catch (Exception ex)
{
Logger.Error(ex, "ConnectGoogleDrive:DeleteFiles:" + ex.Message, fileStatus);
}
}
errorFiles = errorFiles.Where(r => !errorList.Contains(r.Id)).ToList();
DeleteFileFromDb(fileStatus, errorFiles);
}
private FileManager SaveFiles(HttpPostedFileBase file, int storeId = 1)
{
var fileManager = ConvertToFileManager(file, storeId);
try
{
var imageBype = ImageHelper.CreateGoogleImage(file);
ConnectToStoreGoogleDrive(SessionStoreId);
var googleFile = this.UploadHelper.InsertFile(file.FileName, "File Desc", imageBype);
ConvertToFileManager(fileManager, googleFile);
fileManager.FileStatus = "Success";
}
catch (Exception ewx)
{
Logger.Error(ewx, "this.UploadHelper.InsertFile Exception is occured." + ewx.StackTrace, storeId);
fileManager.FileStatus = "Error";
}
FileManagerRepository.Add(fileManager);
FileManagerRepository.Save();
return(fileManager);
}
public StoreHomePage GetHomePage()
{
int page = 1;
StoreHomePage resultModel = new StoreHomePage();
resultModel.SStore = MyStore;
resultModel.SCarouselImages = FileManagerRepository.GetStoreCarousels(MyStore.Id);
resultModel.SProductCategories = ProductCategoryRepository.GetProductCategoriesByStoreId(MyStore.Id);
var products = ProductRepository.GetProductsCategoryId(MyStore.Id, null, StoreConstants.ProductType, true, page, 24);
resultModel.SProducts = new PagedList <Product>(products.items, products.page - 1, products.pageSize, products.totalItemCount);
var contents = ContentRepository.GetContentsCategoryId(MyStore.Id, null, StoreConstants.NewsType, true, page, 24);
resultModel.SNews = new PagedList <Content>(contents.items, contents.page - 1, contents.pageSize, contents.totalItemCount);
contents = ContentRepository.GetContentsCategoryId(MyStore.Id, null, StoreConstants.BlogsType, true, page, 24);
resultModel.SBlogs = new PagedList <Content>(contents.items, contents.page - 1, contents.pageSize, contents.totalItemCount);
resultModel.SBlogsCategories = CategoryRepository.GetCategoriesByStoreId(MyStore.Id, StoreConstants.BlogsType, true);
resultModel.SNewsCategories = CategoryRepository.GetCategoriesByStoreId(MyStore.Id, StoreConstants.NewsType, true);
resultModel.SNavigations = NavigationRepository.GetStoreActiveNavigations(this.MyStore.Id);
resultModel.SSettings = this.GetStoreSettings();
return(resultModel);
}
public List <FileManager> GetImagesByStoreId(int storeId, bool?isActive)
{
return(FileManagerRepository.GetImagesByStoreId(storeId, isActive));
}
public async Task <List <FileManager> > GetImagesByStoreIdAsync(int storeId, bool?isActive)
{
return(await FileManagerRepository.GetImagesByStoreIdAsync(storeId, isActive));
}
public StorePagedList <FileManager> GetImagesByStoreId(int storeId, int page, int pageSize)
{
return(FileManagerRepository.GetImagesByStoreId(storeId, page, pageSize));
}
public List <FileManager> GetStoreCarousels(int storeId)
{
return(FileManagerRepository.GetStoreCarousels(storeId));
}
public FileManager GetFilesById(int id)
{
return(FileManagerRepository.GetSingle(id));
}
public FileManager GetFilesByGoogleImageId(string googleImageId)
{
return(FileManagerRepository.GetFilesByGoogleImageId(googleImageId));
}
public List <FileManager> GetFilesByStoreId(int storeId)
{
return(FileManagerRepository.GetFilesByStoreId(storeId));
}
public async Task <List <FileManager> > GetStoreCarouselsAsync(int storeId, int?take)
{
return(await FileManagerRepository.GetStoreCarouselsAsync(storeId, take));
}
public async Task <StorePagedList <FileManager> > GetImagesByFileSizeAsync(int storeId, string imageSourceType, string fileSizes, int page, int pageSize)
{
return(await FileManagerRepository.GetImagesByFileSizeAsync(storeId, imageSourceType, fileSizes, page, pageSize));
}
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));
}
public ActionResult GetImages(int storeId)
{
var images = FileManagerRepository.GetFilesByStoreId(storeId);
return(Json(images, JsonRequestBehavior.AllowGet));
}
public ActionResult Download(string id)
{
var f = FileManagerRepository.GetFilesByGoogleImageId(id);
return(RedirectToAction("Index"));
}
