/// <summary>
/// Generates thumbnails based on parameters
/// </summary>
/// <param name="configuration">Json configuration of IDBrowserService as IDBrowserConfiguration class</param>
/// <param name="siteName">Site name to generate thumbnails</param>
/// <param name="fromDateTime">From date filter</param>
/// <param name="toDateTime">To date filter</param>
/// <param name="fileFilter">File type filter</param>
/// <param name="imageGuid">Generate single image guid</param>
/// <param name="overwrite">Overwrite existing thumbnails</param>
public async static void GenerateThumbnails(IDBrowserConfiguration configuration, string siteName, DateTime fromDateTime,
DateTime toDateTime, string fileFilter, string imageGuid, bool overwrite)
{
SiteSettings siteSettings = configuration.Sites[siteName];
var optionsBuilder = new DbContextOptionsBuilder <IDImagerDB>();
if (siteSettings.ConnectionStrings.DBType.Equals("MsSql"))
{
optionsBuilder.UseSqlServer(siteSettings.ConnectionStrings.IDImager);
}
else if (siteSettings.ConnectionStrings.DBType.Equals("Postgres"))
{
optionsBuilder.UseNpgsql(siteSettings.ConnectionStrings.IDImager);
optionsBuilder.ReplaceService <ISqlGenerationHelper, PostgresSqlGenerationHelper>();
}
IDImagerDB db = new IDImagerDB(GetIDImagerDBOptionsBuilder <IDImagerDB>(siteSettings.ConnectionStrings.DBType,
siteSettings.ConnectionStrings.IDImager).Options);
IDImagerThumbsDB dbThumbs = new IDImagerThumbsDB(GetIDImagerDBOptionsBuilder <IDImagerThumbsDB>(siteSettings.ConnectionStrings.DBType,
siteSettings.ConnectionStrings.IDImagerThumbs).Options);
var queryCatalogItem = from catalogItem in db.idCatalogItem.Include("idFilePath")
where configuration.ImageFileExtensions.Contains(catalogItem.idFileType) ||
configuration.VideoFileExtensions.Contains(catalogItem.idFileType)
select catalogItem;
if (fromDateTime != DateTime.MinValue)
{
queryCatalogItem = queryCatalogItem.Where(x => x.idCreated >= fromDateTime);
}
if (toDateTime != DateTime.MinValue)
{
queryCatalogItem = queryCatalogItem.Where(x => x.idCreated <= toDateTime);
}
if (!string.IsNullOrEmpty(fileFilter))
{
queryCatalogItem = queryCatalogItem.Where(x => x.idFileType.ToLower().Equals(fileFilter.ToLower()));
}
if (!string.IsNullOrEmpty(imageGuid))
{
queryCatalogItem = queryCatalogItem.Where(x => x.GUID.Equals(imageGuid, StringComparison.OrdinalIgnoreCase));
}
int intCountCatalogItem = queryCatalogItem.Count();
int intCatalogItemCounter = 0;
int intThumbnailsGenerated = 0;
foreach (idCatalogItem catalogItem in queryCatalogItem)
{
List <String> typesToGenerate = new List <String>();
List <idThumbs> idThumbsT = dbThumbs.idThumbs.Where(x => x.ImageGUID == catalogItem.GUID && x.idType.Equals("T")).ToList();
List <idThumbs> idThumbsM = dbThumbs.idThumbs.Where(x => x.ImageGUID == catalogItem.GUID && x.idType.Equals("M")).ToList();
List <idThumbs> idThumbsR = dbThumbs.idThumbs.Where(x => x.ImageGUID == catalogItem.GUID && x.idType.Equals("R")).ToList();
if (idThumbsT.Count() == 0)
{
typesToGenerate.Add("T");
}
if (idThumbsM.Count() == 0)
{
typesToGenerate.Add("M");
}
if (catalogItem.idHasRecipe > 0 && idThumbsR.Count() == 0)
{
typesToGenerate.Add("R");
}
if (overwrite)
{
foreach (idThumbs thumb in idThumbsT)
{
dbThumbs.idThumbs.Remove(thumb);
}
foreach (idThumbs thumb in idThumbsM)
{
dbThumbs.idThumbs.Remove(thumb);
}
foreach (idThumbs thumb in idThumbsR)
{
dbThumbs.idThumbs.Remove(thumb);
}
typesToGenerate.Clear();
typesToGenerate.Add("T");
typesToGenerate.Add("M");
if (catalogItem.idHasRecipe > 0)
{
typesToGenerate.Add("R");
}
}
if (typesToGenerate.Count() > 0)
{
try
{
SaveImageThumbnailResult result = await StaticFunctions.SaveImageThumbnail(catalogItem, db, dbThumbs, typesToGenerate,
siteSettings.ServiceSettings);
foreach (Exception ex in result.Exceptions)
{
LogGenerateThumbnailsException(ex);
Console.WriteLine(ex.ToString());
}
if (result.Exceptions.Count > 0)
{
LogGenerateThumbnailsFailedCatalogItem(catalogItem);
}
intThumbnailsGenerated += result.ImageStreams.Count();
}
catch (Exception e)
{
LogGenerateThumbnailsException(e);
LogGenerateThumbnailsFailedCatalogItem(catalogItem);
Console.WriteLine(e.ToString());
}
}
intCatalogItemCounter += 1;
Console.CursorLeft = 0;
Console.Write(String.Format("{0} of {1} catalogitems checked. {2} thumbnails generated", intCatalogItemCounter, intCountCatalogItem, intThumbnailsGenerated));
}
}
public async static Task <SaveImageThumbnailResult> SaveImageThumbnail(idCatalogItem catalogItem, IDImagerDB db, IDImagerThumbsDB dbThumbs,
List <string> types, ServiceSettings serviceSettings)
{
SaveImageThumbnailResult result = new SaveImageThumbnailResult();
Stream imageStream = null;
String filePath = null;
try
{
filePath = GetImageFilePath(catalogItem, serviceSettings.FilePathReplace);
imageStream = GetImageFileStream(filePath);
foreach (String type in types)
{
int imageWidth;
int imageHeight;
if (type.Equals("T"))
{
imageWidth = 160;
imageHeight = 120;
}
else
{
imageWidth = serviceSettings.MThumbmailWidth;
imageHeight = serviceSettings.MThumbnailHeight;
}
XmpRecipeContainer xmpRecipeContainer = null;
if (type.Equals("T") || type.Equals("R"))
{
if (catalogItem.idHasRecipe > 0)
{
XDocument recipeXDocument = await GetRecipeXDocument(db, catalogItem);
xmpRecipeContainer = XmpRecipeHelper.ParseXmlRecepie(recipeXDocument);
}
}
MemoryStream resizedImageStream = new MemoryStream();
MagickReadSettings magickReadSettings = null;
if (Enum.TryParse <MagickFormat>(catalogItem.idFileType, true, out MagickFormat magickFormat))
{
magickReadSettings = new MagickReadSettings {
Format = magickFormat
};
}
imageStream.Position = 0;
MagickImage image = new MagickImage(imageStream, magickReadSettings)
{
Format = MagickFormat.Jpeg,
};
image.Resize(imageWidth, imageHeight);
if (xmpRecipeContainer != null)
{
XmpRecipeHelper.ApplyXmpRecipe(xmpRecipeContainer, image);
}
image.Write(resizedImageStream);
resizedImageStream.Position = 0;
bool boolThumbExists = await dbThumbs.idThumbs
.AnyAsync(x => x.ImageGUID == catalogItem.GUID && x.idType == type);
if (!boolThumbExists)
{
idThumbs newThumb = new idThumbs
{
GUID = Guid.NewGuid().ToString().ToUpper(),
ImageGUID = catalogItem.GUID,
idThumb = StreamToByteArray(resizedImageStream),
idType = type
};
dbThumbs.idThumbs.Add(newThumb);
}
result.ImageStreams.Add(resizedImageStream);
}
if (imageStream != null)
{
imageStream.Close();
}
await dbThumbs.SaveChangesAsync();
}
catch (Exception ex)
{
if (imageStream != null)
{
imageStream.Close();
}
result.Exceptions.Add(new Exception(String.Format("Error generating thumbnail for imageGUID {0} file {1}", catalogItem.GUID, filePath), ex));
}
return(result);
}
