using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using AutoMapper;
using gehGassi.Common.Data;
using gehGassi.Core.Interfaces;
using gehGassi.Core.Services;
using gehGassi.Domain.Common;
using gehGassi.Permissions;
using gehGassi.Web.Auth;
using gehGassi.Web.Auth.Attributes;
using gehGassi.Web.Helper;
using gehGassi.Web.Models;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Localization;

namespace gehGassi.Web.Controllers
{
    /// <summary>
    /// Controller für die Verwaltung von Werbungen, Listungen und Rubriken
    /// </summary>
    [Authorize]
    public class AdvertisementController : BaseController
    {
        private readonly IMapper _mapper;
        private readonly IStringLocalizer<AdvertisementController> _localizer;
        private readonly ILanguageService _languageService;
        private readonly IAdvertisementCategoryService _advertisementCategoryService;
        private readonly IProductService _productService;
        private readonly IAdvertisementService _advertisementService;
        private readonly ICountryService _countryService;
        private readonly ICustomerService _customerService;

        /// <summary>
        /// Erstellt eine Instanz
        /// </summary>
        /// <param name="mapper">Instanz eines IMapper</param>
        /// <param name="localizer">Instanz eines IStringLocalizer</param>
        /// <param name="languageService">Instanz eines ILanguageService</param>
        /// <param name="advertisementCategoryService">Instanz eines IAdvertisementCategoryService</param>
        /// <param name="productService">Instanz eines IProductService</param>
        /// <param name="advertisementService">Instanz eines IAdvertisementService</param>
        /// <param name="countryService">Instanz eines ICountryService</param>
        /// <param name="customerService">Instanz eines ICustomerService</param>
        public AdvertisementController(IMapper mapper, IStringLocalizer<AdvertisementController> localizer, ILanguageService languageService, IAdvertisementCategoryService advertisementCategoryService, 
            IProductService productService, IAdvertisementService advertisementService, ICountryService countryService, ICustomerService customerService)
        {
            _mapper = mapper;
            _localizer = localizer;
            _languageService = languageService;
            _advertisementCategoryService = advertisementCategoryService;
            _productService = productService;
            _advertisementService = advertisementService;
            _countryService = countryService;
            _customerService = customerService;
        }

        #region Werbung / Advertisement Admin Poweruser

        /// <summary>
        /// Gibt einen View für die Verwaltung von Werbungen zurück
        /// </summary>
        /// <returns>View</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsRead)]
        public IActionResult Index()
        {
            return View();
        }

        /// <summary>
        /// Gibt eine Liste von Entitäten basierend auf Abfragekriterien zurück
        /// </summary>
        /// <param name="dm">Abfragekriterien</param>
        /// <returns>Liste von gefundenen Entitäten</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsRead)]
        [HttpPost]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult GetAdvertisements([FromBody] DataManager dm)
        {
            if (dm != null)
            {
                var propList = new List<ComplexProperty>();
                dm.SetComplexProperties(propList);

                if (dm.Where != null)
                {
                    foreach (var whereFilter in dm.Where)
                    {
                        if (whereFilter.predicates == null)
                            continue;
                        foreach (var whereFilterPredicate in whereFilter.predicates)
                        {
                            if (whereFilterPredicate.Field == "status")
                                whereFilterPredicate.value = (AdvertisementStatus)((int)((long)whereFilterPredicate.value));
                            if (whereFilterPredicate.Field == "paymentType")
                                whereFilterPredicate.value = (PaymentType)((int)((long)whereFilterPredicate.value));
                            if (whereFilterPredicate.Field == "paymentStatus")
                                whereFilterPredicate.value = (PaymentStatus)((int)((long)whereFilterPredicate.value));
                            if (whereFilterPredicate.Field == "geoMode")
                                whereFilterPredicate.value = (GeoMode)((int)((long)whereFilterPredicate.value));
                        }
                    }
                }
            }

            var resultList = _advertisementService.FilterWithNames(dm?.SearchValue ?? "", SelectedLanguage, FallbackLanguage, includeDeleted: false, excludeDraft: true);

            //Sortierung
            resultList = dm.ApplySorting(resultList);
            //Filter
            resultList = dm.ApplyFiltering(resultList, out var countFiltered);
            //Paging
            resultList = dm.ApplyPaging(resultList);

            var resultListVm = resultList.ToList().Select(item => _mapper.Map<AdvertisementListVm>(item)).ToList();

            foreach (var itemVm in resultListVm)
            {
                itemVm.StatusText = itemVm.Status.GetDisplayName(AnnotationsLocalizer);
                itemVm.PaymentTypeText = itemVm.PaymentType.GetDisplayName(AnnotationsLocalizer);
                itemVm.PaymentStatusText = itemVm.PaymentStatus.GetDisplayName(AnnotationsLocalizer);
                itemVm.GeoModeText = itemVm.GeoMode.GetDisplayName(AnnotationsLocalizer);
            }

            //FilterPreview?
            if (!dm.RequiresCounts)
                return Json(resultListVm);

            return Json(new { result = resultListVm, count = countFiltered });
        }

        /// <summary>
        /// Anlegen einer Werbung
        /// </summary>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsCreate)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult Create()
        {
            var model = new AdvertisementCrudVm()
            {
                Id = Guid.NewGuid().ToString("N"),
                TextVms = new List<AdvertisementTextVm>(),
                CustomerName = _localizer["Common_None"],
                AdvertisementCategoryName = _localizer["Common_None"],
                Status = AdvertisementStatusVm.Draft,
                PaymentType = PaymentTypeVm.None,
                PaymentStatus = PaymentStatusVm.None,
                GeoMode = GeoModeVm.None
            };

            foreach (var language in _languageService.GetAllIso2())
            {
                model.TextVms.Add(new AdvertisementTextVm() { Id = model.Id, Language = language, Name = string.Empty, Description = string.Empty, ImageLanguage = string.Empty, Image2Language = string.Empty});
            }

            return PartialView("_Create", model);
        }

        /// <summary>
        /// Anlegen einer Werbung
        /// </summary>
        /// <param name="model">Model</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsCreate)]
        [ValidateAntiForgeryToken]
        [HttpPost]
        public async Task<IActionResult> Create(AdvertisementCrudVm model)
        {
            var result = new ResponseVm { Success = false };

            if (ModelState.IsValid)
            {
                var item = _advertisementService.Create();
                _mapper.Map(model, item);
                item.Created = DateTimeOffset.UtcNow;
                item.UpdatedAt = DateTimeOffset.UtcNow;

                // Texte setzen
                foreach (var textVm in model.TextVms)
                {
                    item.Set("Name", textVm.Language, textVm.Name);
                    item.Set("Description", textVm.Language, textVm.Description);
                    item.Set("ImageLanguage", textVm.Language, textVm.ImageLanguage);
                    item.Set("Image2Language", textVm.Language, textVm.Image2Language);
                    item.Set("UrlLanguage", textVm.Language, textVm.UrlLanguage);

                    if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                    {
                        //Neue Bilddaten verwenden....
                        var extension = Path.GetExtension(textVm.ImageLanguage);
                        var fileName = Path.GetFileName(textVm.ImageLanguage);
                        var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                        item.Set("ImageLanguage", textVm.Language, filenameToUse);

                        //Kopieren
                        var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.ImageLanguage);
                        await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                        //Thumbnails
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                    }
                    if (!string.IsNullOrWhiteSpace(textVm.Image2Language))
                    {
                        //Neue Bilddaten verwenden....
                        var extension = Path.GetExtension(textVm.Image2Language);
                        var fileName = Path.GetFileName(textVm.Image2Language);
                        var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                        item.Set("Image2Language", textVm.Language, filenameToUse);

                        //Kopieren
                        var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.Image2Language);
                        await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                        //Thumbnails
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                    }
                }

                _advertisementService.Add(item);
                await _advertisementService.CommitAsync(User.Identity.Name);

                if (!string.IsNullOrWhiteSpace(model.Image))
                {
                    //Nun das Bild umbenennen und dann kopieren. Ebenso Thumbnails erstellen
                    var extension = Path.GetExtension(model.Image);
                    var fileName = Path.GetFileName(model.Image);

                    var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{Guid.NewGuid():N}{extension}";
                    item.Image = filenameToUse;
                    await _advertisementService.CommitAsync(User.Identity.Name);

                    //Kopieren
                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image);
                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                    //Thumbnails
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);

                    //Altes Löschen
                    await FileService.DeleteAsync(FileServiceHelper.TempContainer, model.Image);
                }
                if (!string.IsNullOrWhiteSpace(model.Image2))
                {
                    //Nun das Bild umbenennen und dann kopieren. Ebenso Thumbnails erstellen
                    var extension = Path.GetExtension(model.Image2);
                    var fileName = Path.GetFileName(model.Image2);

                    var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{Guid.NewGuid():N}{extension}";
                    item.Image2 = filenameToUse;
                    await _advertisementService.CommitAsync(User.Identity.Name);

                    //Kopieren
                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image2);
                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                    //Thumbnails
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);

                    //Altes Löschen
                    await FileService.DeleteAsync(FileServiceHelper.TempContainer, model.Image2);
                }

                result.Data = item.ToCamelCaseJson();
                result.Success = true;
                result.Html = string.Empty;
                return Json(result);
            }

            ModelState.Remove("CountryName");
            var country = _countryService.GetCountry(model.Address.CountryCode);
            model.CountryName = country != null ? country.Name : "";

            ModelState.Remove("StateName");
            var state = _countryService.GetState(model.Address.CountryCode, model.Address.State);
            model.StateName = state != null ? state.Name : "";

            ModelState.Remove("AdvertisementCategoryName");
            var advertisementCategory = await _advertisementCategoryService.GetAsync(model.AdvertisementCategoryId);
            model.AdvertisementCategoryName = advertisementCategory != null ? advertisementCategory.Name : "";

            ModelState.Remove("CustomerName");
            var customer = await _customerService.GetAsync(model.CustomerId);
            model.CustomerName = customer != null ? customer.Name : "";

            result.Html = await PartialView("_Create", model).ToStringAsync(ControllerContext);
            return Json(result);
        }

        /// <summary>
        /// Bearbeiten einer Werbung
        /// </summary>
        /// <param name="id">Id der Werbung</param>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsEdit)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> Edit(string id)
        {
            var item = await _advertisementService.GetAsync(id);
            if (item != null)
            {
                var model = _mapper.Map<AdvertisementCrudVm>(item);

                model.TextVms = new List<AdvertisementTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new AdvertisementTextVm()
                    {
                        Id = item.Id,
                        Language = language,
                        Name = item.Get("Name", language, true),
                        Description = item.Get("Description", language, true),
                        ImageLanguage = item.Get("ImageLanguage", language, true),
                        Image2Language = item.Get("Image2Language", language, true),
                        UrlLanguage = item.Get("UrlLanguage", language, true)
                    });
                }

                var country = _countryService.GetCountry(model.Address.CountryCode);
                model.CountryName = country != null ? country.Name : "";

                var state = _countryService.GetState(model.Address.CountryCode, model.Address.State);
                model.StateName = state != null ? state.Name : "";

                var advertisementCategory = await _advertisementCategoryService.GetAsync(model.AdvertisementCategoryId);
                model.AdvertisementCategoryName = advertisementCategory != null ? advertisementCategory.Name : "";

                var customer = await _customerService.GetAsync(model.CustomerId);
                model.CustomerName = customer != null ? customer.Name : "";

                return PartialView("_Edit", model);
            }
            return PartialView("_Error");
        }

        /// <summary>
        /// Bearbeiten einer Werbung
        /// </summary>
        /// <param name="model">Model</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsEdit)]
        [ValidateAntiForgeryToken]
        [HttpPost]
        public async Task<IActionResult> Edit(AdvertisementCrudVm model)
        {
            var result = new ResponseVm { Success = false };

            if (ModelState.IsValid)
            {
                var item = await _advertisementService.GetAsync(model.Id);
                if (item is { Deleted: false })
                {
                    if (item.Version.SequenceEqual(model.Version))
                    {
                        var oldImage = item.Image;
                        var oldImage2 = item.Image2;

                        _mapper.Map(model, item);

                        //Texte setzen
                        foreach (var textVm in model.TextVms)
                        {
                            item.Set("Name", textVm.Language, textVm.Name);
                            item.Set("Description", textVm.Language, textVm.Description);
                            var oldLangImage = item.Get("ImageLanguage", textVm.Language, true);
                            item.Set("ImageLanguage", textVm.Language, textVm.ImageLanguage);
                            var oldLangImage2 = item.Get("Image2Language", textVm.Language, true);
                            item.Set("Image2Language", textVm.Language, textVm.Image2Language);
                            item.Set("UrlLanguage", textVm.Language, textVm.UrlLanguage);

                            if (oldLangImage != textVm.ImageLanguage)
                            {
                                //Alte Daten löschen, neue Daten anlegen
                                if (!string.IsNullOrWhiteSpace(oldLangImage))
                                {
                                    await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldLangImage);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 400);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 200);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 100);
                                }

                                if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                                {
                                    //Neue Bilddaten verwenden....
                                    var extension = Path.GetExtension(textVm.ImageLanguage);
                                    var fileName = Path.GetFileName(textVm.ImageLanguage);
                                    var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                                    item.Set("ImageLanguage", textVm.Language, filenameToUse);

                                    //Kopieren
                                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.ImageLanguage);
                                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                    //Thumbnails
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                                }
                            }
                            if (oldLangImage2 != textVm.Image2Language)
                            {
                                //Alte Daten löschen, neue Daten anlegen
                                if (!string.IsNullOrWhiteSpace(oldLangImage2))
                                {
                                    await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldLangImage2);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage2, 400);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage2, 200);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage2, 100);
                                }

                                if (!string.IsNullOrWhiteSpace(textVm.Image2Language))
                                {
                                    //Neue Bilddaten verwenden....
                                    var extension = Path.GetExtension(textVm.Image2Language);
                                    var fileName = Path.GetFileName(textVm.Image2Language);
                                    var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                                    item.Set("Image2Language", textVm.Language, filenameToUse);

                                    //Kopieren
                                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.Image2Language);
                                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                    //Thumbnails
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                                }
                            }
                        }

                        item.UpdatedAt = DateTimeOffset.UtcNow;

                        if (oldImage != item.Image)
                        {
                            //Alte Daten löschen, neue Daten anlegen
                            if (!string.IsNullOrWhiteSpace(oldImage))
                            {
                                await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldImage);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 400);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 200);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 100);
                            }

                            if (!string.IsNullOrWhiteSpace(item.Image))
                            {
                                //Neue Bilddaten verwenden....
                                var extension = Path.GetExtension(item.Image);
                                var fileName = Path.GetFileName(item.Image);
                                var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{Guid.NewGuid():N}{extension}";
                                item.Image = filenameToUse;

                                //Kopieren
                                var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image);
                                await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                //Thumbnails
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                            }
                        }
                        if (oldImage2 != item.Image2)
                        {
                            //Alte Daten löschen, neue Daten anlegen
                            if (!string.IsNullOrWhiteSpace(oldImage2))
                            {
                                await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldImage2);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage2, 400);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage2, 200);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage2, 100);
                            }

                            if (!string.IsNullOrWhiteSpace(item.Image2))
                            {
                                //Neue Bilddaten verwenden....
                                var extension = Path.GetExtension(item.Image2);
                                var fileName = Path.GetFileName(item.Image2);
                                var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{Guid.NewGuid():N}{extension}";
                                item.Image2 = filenameToUse;

                                //Kopieren
                                var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image2);
                                await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                //Thumbnails
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                            }
                        }

                        await _advertisementService.CommitAsync(User.Identity.Name);

                        result.Data = item.ToCamelCaseJson();
                        result.Success = true;
                        result.Html = string.Empty;
                        return Json(new { result.Success, result.Html, result.Data });
                    }
                    else
                    {
                        ModelState.AddModelError("", _localizer["Err_Entity_Changed"].Value);
                    }
                }
                else
                {
                    ModelState.AddModelError("", _localizer["Err_Entity_Deleted"].Value);
                }
            }

            ModelState.Remove("CountryName");
            var country = _countryService.GetCountry(model.Address.CountryCode);
            model.CountryName = country != null ? country.Name : "";

            ModelState.Remove("StateName");
            var state = _countryService.GetState(model.Address.CountryCode, model.Address.State);
            model.StateName = state != null ? state.Name : "";

            ModelState.Remove("AdvertisementCategoryName");
            var advertisementCategory = await _advertisementCategoryService.GetAsync(model.AdvertisementCategoryId);
            model.AdvertisementCategoryName = advertisementCategory != null ? advertisementCategory.Name : "";

            ModelState.Remove("CustomerName");
            var customer = await _customerService.GetAsync(model.CustomerId);
            model.CustomerName = customer != null ? customer.Name : "";

            result.Html = await PartialView("_Edit", model).ToStringAsync(ControllerContext);
            return Json(result);
        }

        /// <summary>
        /// Löschen einer Werbung
        /// </summary>
        /// <param name="ids">Liste Id der Entität</param>
        /// <param name="forceDelete">Sollen die Daten physisch gelöscht werden?</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsDelete)]
        [HttpPost]
        public async Task<IActionResult> Delete(List<string> ids, bool forceDelete = false)
        {
            var batchErrorHeader = $"<p><strong>{_localizer["Common_BatchDelete_Failed"].Value}</strong></p>";
            var batchResult = new BatchResponseVm(batchErrorHeader) { Success = true };

            foreach (var id in ids)
            {
                var item = await _advertisementService.GetAsync(id);
                if (item != null)
                {
                    //await _customerService.ResetTypeAsync(item.Id); //Spezial zurücksetzen wenn nötig
                    var usedCount = 0;

                    //var productsCount = await _productService.CountByAdvertisementCategoryAsync(item.Id);
                    //usedCount += productsCount;

                    if (usedCount == 0)
                    {
                        //TODO: Gibt es Resets die notwendig sind?
                        //await _productService.ResetAdvertisementCategoryAsync(item.Id, true);

                        batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = item.Id.ToString(), Name = item.Name, Success = true, NotFound = false, ErrorMessage = "" });

                        if (forceDelete)
                        {
                            var postingPath = FileServiceHelper.GetListingPath(item.Id);
                            await FileService.ClearDirectoryAsync(FileServiceHelper.DocumentContainer, postingPath);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image, 400);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image, 200);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image, 100);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image2, 400);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image2, 200);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image2, 100);

                            var languages = item.GetLanguages("ImageLanguage");
                            foreach (var language in languages)
                            {
                                item.SetLanguage(language);
                                var imageLocalized = item.ImageLanguage;
                                if (!string.IsNullOrWhiteSpace(imageLocalized))
                                {
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 400);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 200);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 100);
                                }
                                var image2Localized = item.Image2Language;
                                if (!string.IsNullOrWhiteSpace(image2Localized))
                                {
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, image2Localized, 400);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, image2Localized, 200);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, image2Localized, 100);
                                }
                            }

                            _advertisementService.Remove(item);
                        }
                        else
                        {
                            item.Deleted = true;
                            item.UpdatedAt = DateTimeOffset.UtcNow;
                        }
                    }
                    else
                    {
                        if (usedCount != 0)
                        {
                            batchResult.Success = false;
                            batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = id.ToString(), Name = item.Name, Success = false, NotFound = false, ErrorMessage = string.Format(_localizer["Common_BatchDelete_InUse"], $"<strong>{item.Name}</strong>", $"<strong>{usedCount}</strong>") + "<br/>" });
                        }
                    }
                }
                else
                {
                    batchResult.Success = false;
                    batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = id.ToString(), Name = "", Success = false, NotFound = true, ErrorMessage = string.Format(_localizer["Common_BatchDelete_NotFound"], $"<strong>{id}</strong>") + "<br/>" });
                }
            }
            if (batchResult.BatchResponseList.Any(c => c.Success))
                await _advertisementService.CommitAsync(User.Identity.Name);
            return Json(batchResult);
        }

        #endregion

        #region Werbung / Advertisement Kunden

        /// <summary>
        /// Gibt einen View für die Verwaltung von Werbungen für Kunden zurück
        /// </summary>
        /// <returns>View</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsRead)]
        public IActionResult IndexCustomer()
        {
            var customerId = User.CustomerUniqueId();
            return View(customerId);
        }

        /// <summary>
        /// Gibt eine Liste von Entitäten basierend auf Abfragekriterien zurück
        /// </summary>
        /// <param name="dm">Abfragekriterien</param>
        /// <param name="customerUniqueId">UniqueId des Kunden</param>
        /// <returns>Liste von gefundenen Entitäten</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsRead)]
        [CustomerAuthorize("customerUniqueId")]
        [HttpPost]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> GetAdvertisementsCustomer([FromBody] DataManager dm, Guid customerUniqueId)
        {
            if (dm != null)
            {
                var propList = new List<ComplexProperty>();
                dm.SetComplexProperties(propList);

                if (dm.Where != null)
                {
                    foreach (var whereFilter in dm.Where)
                    {
                        if (whereFilter.predicates == null)
                            continue;
                        foreach (var whereFilterPredicate in whereFilter.predicates)
                        {
                            if (whereFilterPredicate.Field == "status")
                                whereFilterPredicate.value = (AdvertisementStatus)((int)((long)whereFilterPredicate.value));
                            if (whereFilterPredicate.Field == "paymentType")
                                whereFilterPredicate.value = (PaymentType)((int)((long)whereFilterPredicate.value));
                            if (whereFilterPredicate.Field == "paymentStatus")
                                whereFilterPredicate.value = (PaymentStatus)((int)((long)whereFilterPredicate.value));
                            if (whereFilterPredicate.Field == "geoMode")
                                whereFilterPredicate.value = (GeoMode)((int)((long)whereFilterPredicate.value));
                        }
                    }
                }
            }

            long customerId = -1;
            var customer = await _customerService.GetByUniqueIdAsync(customerUniqueId);
            if (customer != null)
                customerId = customer.Id;

            var resultList = _advertisementService.FilterWithNamesCustomer(customerId,dm?.SearchValue ?? "", SelectedLanguage, FallbackLanguage, includeDeleted: false, excludeDraft: true);

            //Sortierung
            resultList = dm.ApplySorting(resultList);
            //Filter
            resultList = dm.ApplyFiltering(resultList, out var countFiltered);
            //Paging
            resultList = dm.ApplyPaging(resultList);

            var resultListVm = resultList.ToList().Select(item => _mapper.Map<AdvertisementListVm>(item)).ToList();

            foreach (var itemVm in resultListVm)
            {
                itemVm.StatusText = itemVm.Status.GetDisplayName(AnnotationsLocalizer);
                itemVm.PaymentTypeText = itemVm.PaymentType.GetDisplayName(AnnotationsLocalizer);
                itemVm.PaymentStatusText = itemVm.PaymentStatus.GetDisplayName(AnnotationsLocalizer);
                itemVm.GeoModeText = itemVm.GeoMode.GetDisplayName(AnnotationsLocalizer);
            }

            //FilterPreview?
            if (!dm.RequiresCounts)
                return Json(resultListVm);

            return Json(new { result = resultListVm, count = countFiltered });
        }

        /// <summary>
        /// Bearbeiten einer Werbung für Kunden
        /// </summary>
        /// <param name="id">Id der Werbung</param>
        /// <param name="customerUniqueId">UniqueId des Kunden</param>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsEdit)]
        [CustomerAuthorize("customerUniqueId")]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> EditCustomer(string id, Guid customerUniqueId)
        {
            var item = await _advertisementService.GetAsync(id);
            if (item != null)
            {
                var model = _mapper.Map<AdvertisementCrudVm>(item);

                model.TextVms = new List<AdvertisementTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new AdvertisementTextVm()
                    {
                        Id = item.Id,
                        Language = language,
                        Name = item.Get("Name", language, true),
                        Description = item.Get("Description", language, true),
                        ImageLanguage = item.Get("ImageLanguage", language, true),
                        Image2Language = item.Get("Image2Language", language, true),
                        UrlLanguage = item.Get("UrlLanguage", language, true)
                    });
                }

                var country = _countryService.GetCountry(model.Address.CountryCode);
                model.CountryName = country != null ? country.Name : "";

                var state = _countryService.GetState(model.Address.CountryCode, model.Address.State);
                model.StateName = state != null ? state.Name : "";

                var advertisementCategory = await _advertisementCategoryService.GetAsync(model.AdvertisementCategoryId);
                model.AdvertisementCategoryName = advertisementCategory != null ? advertisementCategory.Name : "";

                var customer = await _customerService.GetAsync(model.CustomerId);
                model.CustomerName = customer != null ? customer.Name : "";

                return PartialView("_EditCustomer", model);
            }
            return PartialView("_Error");
        }

        /// <summary>
        /// Bearbeiten einer Werbung
        /// </summary>
        /// <param name="model">Model</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsEdit)]
        [CustomerAuthorize("CustomerId")]
        [ValidateAntiForgeryToken]
        [HttpPost]
        public async Task<IActionResult> EditCustomer(AdvertisementCrudVm model)
        {
            var result = new ResponseVm { Success = false };

            if (ModelState.IsValid)
            {
                var item = await _advertisementService.GetAsync(model.Id);
                if (item is { Deleted: false })
                {
                    if (item.Version.SequenceEqual(model.Version))
                    {
                        var oldImage = item.Image;

                        _mapper.Map(model, item);

                        //Texte setzen
                        foreach (var textVm in model.TextVms)
                        {
                            item.Set("Name", textVm.Language, textVm.Name);
                            item.Set("Description", textVm.Language, textVm.Description);
                            var oldLangImage = item.Get("ImageLanguage", textVm.Language, true);
                            item.Set("ImageLanguage", textVm.Language, textVm.ImageLanguage);
                            item.Set("UrlLanguage", textVm.Language, textVm.UrlLanguage);

                            if (oldLangImage != textVm.ImageLanguage)
                            {
                                //Alte Daten löschen, neue Daten anlegen
                                if (!string.IsNullOrWhiteSpace(oldLangImage))
                                {
                                    await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldLangImage);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 400);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 200);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 100);
                                }

                                if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                                {
                                    //Neue Bilddaten verwenden....
                                    var extension = Path.GetExtension(textVm.ImageLanguage);
                                    var fileName = Path.GetFileName(textVm.ImageLanguage);
                                    var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                                    item.Set("ImageLanguage", textVm.Language, filenameToUse);

                                    //Kopieren
                                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.ImageLanguage);
                                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                    //Thumbnails
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                                }
                            }
                        }

                        item.UpdatedAt = DateTimeOffset.UtcNow;

                        if (oldImage != item.Image)
                        {
                            //Alte Daten löschen, neue Daten anlegen
                            if (!string.IsNullOrWhiteSpace(oldImage))
                            {
                                await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldImage);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 400);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 200);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 100);
                            }

                            if (!string.IsNullOrWhiteSpace(item.Image))
                            {
                                //Neue Bilddaten verwenden....
                                var extension = Path.GetExtension(item.Image);
                                var fileName = Path.GetFileName(item.Image);
                                var filenameToUse = FileServiceHelper.GetAdvertisementPath(item.Id) + $"ad_{Guid.NewGuid():N}{extension}";
                                item.Image = filenameToUse;

                                //Kopieren
                                var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image);
                                await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                //Thumbnails
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                            }
                        }

                        await _advertisementService.CommitAsync(User.Identity.Name);

                        result.Data = item.ToCamelCaseJson();
                        result.Success = true;
                        result.Html = string.Empty;
                        return Json(new { result.Success, result.Html, result.Data });
                    }
                    else
                    {
                        ModelState.AddModelError("", _localizer["Err_Entity_Changed"].Value);
                    }
                }
                else
                {
                    ModelState.AddModelError("", _localizer["Err_Entity_Deleted"].Value);
                }
            }

            ModelState.Remove("CountryName");
            var country = _countryService.GetCountry(model.Address.CountryCode);
            model.CountryName = country != null ? country.Name : "";

            ModelState.Remove("StateName");
            var state = _countryService.GetState(model.Address.CountryCode, model.Address.State);
            model.StateName = state != null ? state.Name : "";

            ModelState.Remove("AdvertisementCategoryName");
            var advertisementCategory = await _advertisementCategoryService.GetAsync(model.AdvertisementCategoryId);
            model.AdvertisementCategoryName = advertisementCategory != null ? advertisementCategory.Name : "";

            ModelState.Remove("CustomerName");
            var customer = await _customerService.GetAsync(model.CustomerId);
            model.CustomerName = customer != null ? customer.Name : "";

            result.Html = await PartialView("_EditCustomer", model).ToStringAsync(ControllerContext);
            return Json(result);
        }

        /// <summary>
        /// Details einer Werbung für Kunden
        /// </summary>
        /// <param name="id">Id der Werbung</param>
        /// <param name="customerUniqueId">UniqueId des Kunden</param>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.AdvertisementsManage, Permission.AdvertisementsEdit)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> DetailsCustomer(string id, Guid customerUniqueId)
        {
            var item = await _advertisementService.GetAsync(id);
            if (item != null)
            {
                var model = _mapper.Map<AdvertisementCrudVm>(item);

                model.TextVms = new List<AdvertisementTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new AdvertisementTextVm()
                    {
                        Id = item.Id,
                        Language = language,
                        Name = item.Get("Name", language, true),
                        Description = item.Get("Description", language, true),
                        ImageLanguage = item.Get("ImageLanguage", language, true),
                        UrlLanguage = item.Get("UrlLanguage", language, true)
                    });
                }

                var country = _countryService.GetCountry(model.Address.CountryCode);
                model.CountryName = country != null ? country.Name : "";

                var state = _countryService.GetState(model.Address.CountryCode, model.Address.State);
                model.StateName = state != null ? state.Name : "";

                var advertisementCategory = await _advertisementCategoryService.GetAsync(model.AdvertisementCategoryId);
                model.AdvertisementCategoryName = advertisementCategory != null ? advertisementCategory.Name : "";

                var customer = await _customerService.GetAsync(model.CustomerId);
                model.CustomerName = customer != null ? customer.Name : "";

                return PartialView("_DetailsCustomer", model);
            }
            return PartialView("_Error");
        }

        /// <summary>
        /// Stornieren einer Werbung
        /// </summary>
        /// <param name="ids">Liste Id der Entität</param>
        /// <param name="customerUniqueId">UniqueId des Kunden</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.ListingsManage, Permission.ListingsCancel)]
        [CustomerAuthorize("customerUniqueId")]
        [HttpPost]
        public async Task<IActionResult> CancelCustomer(List<string> ids, Guid customerUniqueId)
        {
            var batchErrorHeader = $"<p><strong>{_localizer["Common_BatchCancel_Failed"].Value}</strong></p>";
            var batchResult = new BatchResponseVm(batchErrorHeader) { Success = true };

            //TODO: Stornierung genau überdenken--- BEstellung?

            foreach (var id in ids)
            {
                var item = await _advertisementService.GetAsync(id);
                if (item != null && item.CustomerId == User.CustomerId())
                {
                    //await _customerService.ResetTypeAsync(item.Id); //Spezial zurücksetzen wenn nötig
                    //await _pinService.CancelByListingAsync(item.Id);
                    var usedCount = 0;

                    //var productsCount = await _productService.CountByAdvertisementCategoryAsync(item.Id);
                    //usedCount += productsCount;

                    if (usedCount == 0)
                    {
                        //TODO: Gibt es Resets die notwendig sind?
                        //await _productService.ResetAdvertisementCategoryAsync(item.Id, true);

                        batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = item.Id.ToString(), Name = item.Name, Success = true, NotFound = false, ErrorMessage = "" });

                        item.Status = AdvertisementStatus.Cancelled;
                        item.UpdatedAt = DateTimeOffset.UtcNow;
                    }
                    else
                    {
                        if (usedCount != 0)
                        {
                            batchResult.Success = false;
                            batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = id.ToString(), Name = item.Name, Success = false, NotFound = false, ErrorMessage = string.Format(_localizer["Common_BatchCancel_InUse"], $"<strong>{item.Name}</strong>", $"<strong>{usedCount}</strong>") + "<br/>" });
                        }
                    }
                }
                else
                {
                    batchResult.Success = false;
                    batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = id.ToString(), Name = "", Success = false, NotFound = true, ErrorMessage = string.Format(_localizer["Common_BatchCancel_NotFound"], $"<strong>{id}</strong>") + "<br/>" });
                }
            }
            if (batchResult.BatchResponseList.Any(c => c.Success))
                await _advertisementService.CommitAsync(User.Identity.Name);
            return Json(batchResult);
        }

        #endregion

        #region Categories / Rubriken

        /// <summary>
        /// Gibt einen View für die Verwaltung von Rubriken für Werbung zurück
        /// </summary>
        /// <returns>View</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        public IActionResult IndexCategories()
        {
            return View();
        }

        /// <summary>
        /// Gibt eine Liste von Entitäten basierend auf Abfragekriterien zurück
        /// </summary>
        /// <param name="dm">Abfragekriterien</param>
        /// <returns>Liste von gefundenen Entitäten</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        [HttpPost]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult GetCategories([FromBody] DataManager dm)
        {
            if (dm != null)
            {
                var propList = new List<ComplexProperty>();
                dm.SetComplexProperties(propList);

                if (dm.Where != null)
                {
                    foreach (var whereFilter in dm.Where)
                    {
                        if (whereFilter.predicates == null)
                            continue;
                        foreach (var whereFilterPredicate in whereFilter.predicates)
                        {
                            if (whereFilterPredicate.Field == "onlineStatus")
                                whereFilterPredicate.value = (OnlineStatus)((int)((long)whereFilterPredicate.value));
                        }
                    }
                }
            }

            var resultList = _advertisementCategoryService.FilterWithNames(dm?.SearchValue ?? "", SelectedLanguage, FallbackLanguage, false);

            //Sortierung
            resultList = dm.ApplySorting(resultList);
            //Filter
            resultList = dm.ApplyFiltering(resultList, out var countFiltered);
            //Paging
            resultList = dm.ApplyPaging(resultList);

            var resultListVm = resultList.ToList().Select(item => _mapper.Map<AdvertisementCategoryListVm>(item)).ToList();

            foreach (var itemVm in resultListVm)
            {
                itemVm.OnlineStatusText = itemVm.OnlineStatus.GetDisplayName(AnnotationsLocalizer);
            }

            //FilterPreview?
            if (!dm.RequiresCounts)
                return Json(resultListVm);

            return Json(new { result = resultListVm, count = countFiltered });
        }

        /// <summary>
        /// Anlegen einer Rubrik
        /// </summary>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult CreateCategory()
        {
            var model = new AdvertisementCategoryVm()
            {
                Id = Guid.NewGuid().ToString("N"),
                TextVms = new List<AdvertisementCategoryTextVm>(),
                OnlineStatus = OnlineStatusVm.Offline
            };

            foreach (var language in _languageService.GetAllIso2())
            {
                model.TextVms.Add(new AdvertisementCategoryTextVm() { Id = model.Id, Language = language, Name = string.Empty, Description = string.Empty, ImageLanguage = string.Empty});
            }

            return PartialView("_CreateCategory", model);
        }

        /// <summary>
        /// Anlegen einer Rubrik
        /// </summary>
        /// <param name="model">Model</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        [ValidateAntiForgeryToken]
        [HttpPost]
        public async Task<IActionResult> CreateCategory(AdvertisementCategoryVm model)
        {
            var result = new ResponseVm { Success = false };

            if (ModelState.IsValid)
            {
                var item = _advertisementCategoryService.Create();
                _mapper.Map(model, item);
                item.Created = DateTimeOffset.UtcNow;
                item.UpdatedAt = DateTimeOffset.UtcNow;

                // Texte setzen
                foreach (var textVm in model.TextVms)
                {
                    item.Set("Name", textVm.Language, textVm.Name);
                    item.Set("Description", textVm.Language, textVm.Description);
                    item.Set("ImageLanguage", textVm.Language, textVm.ImageLanguage);

                    if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                    {
                        //Neue Bilddaten verwenden....
                        var extension = Path.GetExtension(textVm.ImageLanguage);
                        var fileName = Path.GetFileName(textVm.ImageLanguage);
                        var filenameToUse = FileServiceHelper.GetAdvertisementCategoryPath(item.Id) + $"cat_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                        item.Set("ImageLanguage", textVm.Language, filenameToUse);

                        //Kopieren
                        var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.ImageLanguage);
                        await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                        //Thumbnails
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                        await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                    }
                }

                _advertisementCategoryService.Add(item);
                await _advertisementCategoryService.CommitAsync(User.Identity.Name);

                if (!string.IsNullOrWhiteSpace(model.Image))
                {
                    //Nun das Bild umbenennen und dann kopieren. Ebenso Thumbnails erstellen
                    var extension = Path.GetExtension(model.Image);
                    var fileName = Path.GetFileName(model.Image);
                    
                    var filenameToUse = FileServiceHelper.GetAdvertisementCategoryPath(item.Id) + $"cat_{Guid.NewGuid():N}{extension}";
                    item.Image = filenameToUse;
                    await _advertisementCategoryService.CommitAsync(User.Identity.Name);

                    //Kopieren
                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image);
                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                    //Thumbnails
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);

                    //Altes Löschen
                    await FileService.DeleteAsync(FileServiceHelper.TempContainer, model.Image);
                }

                result.Data = item.ToCamelCaseJson();
                result.Success = true;
                result.Html = string.Empty;
                return Json(result);
            }

            result.Html = await PartialView("_CreateCategory", model).ToStringAsync(ControllerContext);
            return Json(result);
        }

        /// <summary>
        /// Bearbeiten einer Rubrik
        /// </summary>
        /// <param name="id">Id der Rubrik</param>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> EditCategory(string id)
        {
            var item = await _advertisementCategoryService.GetAsync(id);
            if (item != null)
            {
                var model = _mapper.Map<AdvertisementCategoryVm>(item);

                model.TextVms = new List<AdvertisementCategoryTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new AdvertisementCategoryTextVm()
                    {
                        Id = item.Id, 
                        Language = language, 
                        Name = item.Get("Name", language, true), 
                        Description = item.Get("Description", language, true),
                        ImageLanguage = item.Get("ImageLanguage", language, true)
                    });
                }

                return PartialView("_EditCategory", model);
            }
            return PartialView("_Error");
        }

        /// <summary>
        /// Bearbeiten einer Rubrik
        /// </summary>
        /// <param name="model">Model</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        [ValidateAntiForgeryToken]
        [HttpPost]
        public async Task<IActionResult> EditCategory(AdvertisementCategoryVm model)
        {
            var result = new ResponseVm { Success = false };

            if (ModelState.IsValid)
            {
                var item = await _advertisementCategoryService.GetAsync(model.Id);
                if (item is { Deleted: false })
                {
                    if(item.Version.SequenceEqual(model.Version))
                    {
                        var oldImage = item.Image;

                        _mapper.Map(model, item);

                        //Texte setzen
                        foreach (var textVm in model.TextVms)
                        {
                            item.Set("Name", textVm.Language, textVm.Name);
                            item.Set("Description", textVm.Language, textVm.Description);
                            var oldLangImage = item.Get("ImageLanguage", textVm.Language, true);
                            item.Set("ImageLanguage", textVm.Language, textVm.ImageLanguage);

                            if (oldLangImage != textVm.ImageLanguage)
                            {
                                //Alte Daten löschen, neue Daten anlegen
                                if (!string.IsNullOrWhiteSpace(oldLangImage))
                                {
                                    await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldLangImage);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 400);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 200);
                                    await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 100);
                                }

                                if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                                {
                                    //Neue Bilddaten verwenden....
                                    var extension = Path.GetExtension(textVm.ImageLanguage);
                                    var fileName = Path.GetFileName(textVm.ImageLanguage);
                                    var filenameToUse = FileServiceHelper.GetAdvertisementCategoryPath(item.Id) + $"cat_{textVm.Language}-{Guid.NewGuid():N}{extension}";
                                    item.Set("ImageLanguage", textVm.Language, filenameToUse);

                                    //Kopieren
                                    var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, textVm.ImageLanguage);
                                    await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                    //Thumbnails
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                    await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                                }
                            }
                        }

                        item.UpdatedAt = DateTimeOffset.UtcNow;

                        if (oldImage != item.Image)
                        {
                            //Alte Daten löschen, neue Daten anlegen
                            if (!string.IsNullOrWhiteSpace(oldImage))
                            {
                                await FileService.DeleteAsync(FileServiceHelper.DocumentContainer, oldImage);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 400);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 200);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, oldImage, 100);
                            }

                            if (!string.IsNullOrWhiteSpace(item.Image))
                            {
                                //Neue Bilddaten verwenden....
                                var extension = Path.GetExtension(item.Image);
                                var fileName = Path.GetFileName(item.Image);
                                var filenameToUse = FileServiceHelper.GetAdvertisementCategoryPath(item.Id) + $"cat_{Guid.NewGuid():N}{extension}";
                                item.Image = filenameToUse;

                                //Kopieren
                                var tempFile = await FileService.GetAsync(FileServiceHelper.TempContainer, model.Image);
                                await FileService.StoreAsync(FileServiceHelper.DocumentContainer, filenameToUse, tempFile);

                                //Thumbnails
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 400);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 200);
                                await GenerateThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 100);
                            }
                        }

                        await _advertisementCategoryService.CommitAsync(User.Identity.Name);

                        result.Data = item.ToCamelCaseJson();
                        result.Success = true;
                        result.Html = string.Empty;
                        return Json(new { result.Success, result.Html, result.Data });
                    }
                    else
                    {
                        ModelState.AddModelError("", _localizer["Err_Entity_Changed"].Value);
                    }
                }
                else
                {
                    ModelState.AddModelError("", _localizer["Err_Entity_Deleted"].Value);
                }
            }

            result.Html = await PartialView("_EditCategory", model).ToStringAsync(ControllerContext);
            return Json(result);
        }

        /// <summary>
        /// Löschen einer Rubrik
        /// </summary>
        /// <param name="ids">Liste Id der Entität</param>
        /// <param name="forceDelete">Sollen die Daten physisch gelöscht werden?</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.SettingsManage, Permission.SettingsAdvertisementCategories)]
        [HttpPost]
        public async Task<IActionResult> DeleteCategory(List<string> ids, bool forceDelete = false)
        {
            var batchErrorHeader = $"<p><strong>{_localizer["Common_BatchDelete_Failed"].Value}</strong></p>";
            var batchResult = new BatchResponseVm(batchErrorHeader) { Success = true };

            foreach (var id in ids)
            {
                var item = await _advertisementCategoryService.GetAsync(id);
                if (item != null)
                {
                    //await _customerService.ResetTypeAsync(item.Id); //Spezial zurücksetzen wenn nötig
                    await _advertisementService.DeleteByCategoryAsync(item.Id, forceDelete);
                    var usedCount = 0;

                    var productsCount = await _productService.CountByAdvertisementCategoryAsync(item.Id);
                    usedCount += productsCount;
                    
                    if (usedCount == 0)
                    {
                        await _productService.ResetAdvertisementCategoryAsync(item.Id, true);

                        batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = item.Id.ToString(), Name = item.Title, Success = true, NotFound = false, ErrorMessage = "" });

                        if (forceDelete)
                        {
                            var postingPath = FileServiceHelper.GetAdvertisementCategoryPath(item.Id);
                            await FileService.ClearDirectoryAsync(FileServiceHelper.DocumentContainer, postingPath);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image, 400);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image, 200);
                            await RemoveThumbnail(FileServiceHelper.DocumentContainer, item.Image, 100);

                            var languages = item.GetLanguages("ImageLanguage");
                            foreach (var language in languages)
                            {
                                item.SetLanguage(language);
                                var imageLocalized = item.ImageLanguage;
                                if (string.IsNullOrWhiteSpace(imageLocalized)) continue;
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 400);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 200);
                                await RemoveThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 100);
                            }

                            _advertisementCategoryService.Remove(item);
                        }
                        else
                        {
                            item.Deleted = true;
                            item.UpdatedAt = DateTimeOffset.UtcNow;
                        }
                    }
                    else
                    {
                        if (usedCount != 0)
                        {
                            batchResult.Success = false;
                            batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = id.ToString(), Name = item.Title, Success = false, NotFound = false, ErrorMessage = string.Format(_localizer["Common_BatchDelete_InUse"], $"<strong>{item.Title}</strong>", $"<strong>{usedCount}</strong>") + "<br/>" });
                        }
                    }
                }
                else
                {
                    batchResult.Success = false;
                    batchResult.BatchResponseList.Add(new BatchResponseItemVm() { Id = id.ToString(), Name = "", Success = false, NotFound = true, ErrorMessage = string.Format(_localizer["Common_BatchDelete_NotFound"], $"<strong>{id}</strong>") + "<br/>" });
                }
            }
            if (batchResult.BatchResponseList.Any(c => c.Success))
                await _advertisementCategoryService.CommitAsync(User.Identity.Name);
            return Json(batchResult);
        }

        #endregion

        #region Lookup

        /// <summary>
        /// Gibt eine Liste von Rubriken für LookUp zurück
        /// </summary>
        /// <param name="dm">DataManager</param>
        /// <param name="includeNone">Soll "Keine(r)" integriert werden</param>
        /// <returns>Liste</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        public async Task<IActionResult> LookupCategories([FromBody] DataManager dm, bool includeNone = false)
        {
            var filter = string.Empty;
            if (dm.Where?.FirstOrDefault() != null)
            {
                filter = dm.Where.First().value.ToString();
                if (filter.IndexOf('(') > 0)
                {
                    filter = filter.Substring(0, (filter.IndexOf('(') - 1));
                    filter = filter.TrimEnd();
                }
            }

            var items = await _advertisementCategoryService.FilterWithNames(filter, SelectedLanguage, FallbackLanguage, false).ToListAsync();
            var result = items.Select(item => new LookupItemVm() { Id = item.Id.ToString(), Name = $"{item.Name}" }).OrderBy(c => c.Name).ToList();

            if (includeNone)
                result.Insert(0, new LookupItemVm() { Id = "", Name = _localizer["Common_None"].ToString() });

            return Json(result);
        }

        #endregion
    }
}