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.Extensions.Localization;
using SixLabors.ImageSharp;
using SixLabors.ImageSharp.Advanced;
using SixLabors.ImageSharp.Processing;

namespace gehGassi.Web.Controllers
{
    /// <summary>
    /// Controller für die Verwaltung von Bannern
    /// </summary>
    [Authorize]
    public class BannerController : BaseController
    {
        private readonly IMapper _mapper;
        private readonly IStringLocalizer<BannerController> _localizer;
        private readonly ILanguageService _languageService;
        private readonly IBannerService _bannerService;
        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="bannerService">Instanz eines IBannerService</param>
        /// <param name="countryService">Instanz eines ICountryService</param>
        /// <param name="customerService">Instanz eines ICustomerService</param>
        public BannerController(IMapper mapper, IStringLocalizer<BannerController> localizer, ILanguageService languageService, IBannerService bannerService, ICountryService countryService, ICustomerService customerService)
        {
            _mapper = mapper;
            _localizer = localizer;
            _languageService = languageService;
            _bannerService = bannerService;
            _countryService = countryService;
            _customerService = customerService;
        }

        #region Admin PowerUser

        /// <summary>
        /// Gibt einen View für die Verwaltung von Bannern zurück
        /// </summary>
        /// <returns>View</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.BannersManage, Permission.BannersRead)]
        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.BannersManage, Permission.BannersRead)]
        [HttpPost]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult GetBanners([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 = (BannerStatus)((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 = _bannerService.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<BannerListVm>(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);
                itemVm.BannerLocationText = itemVm.BannerLocation.GetDisplayName(AnnotationsLocalizer);
                itemVm.BannerSizeText = itemVm.BannerSize.GetDisplayName(AnnotationsLocalizer);
            }

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

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

        /// <summary>
        /// Anlegen eines Banners
        /// </summary>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.BannersManage, Permission.BannersCreate)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public IActionResult Create()
        {
            var model = new BannerCrudVm()
            {
                Id = Guid.NewGuid().ToString("N"),
                TextVms = new List<BannerTextVm>(),
                CustomerName = _localizer["Common_None"],
                Status = BannerStatusVm.Draft,
                PaymentType = PaymentTypeVm.None,
                PaymentStatus = PaymentStatusVm.None,
                GeoMode = GeoModeVm.None,
                BannerLocation = BannerLocationVm.None,
                BannerSize = BannerSizeVm.Standard,
                CurrentViews = 0,
                CurrentClicks = 0,
                Budget = 0,
                BudgetUsed = 0,
                PriceClick = 0,
                PriceView = 0
            };

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

            return PartialView("_Create", model);
        }

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

            if (ModelState.IsValid)
            {
                var item = _bannerService.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("ImageLanguage", textVm.Language, textVm.ImageLanguage);
                    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.GetBannerPath(item.Id) + $"bn_{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
                        switch (item.BannerSize)
                        {
                            //Thumbnails
                            case BannerSize.Standard or BannerSize.Large:
                                await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 320);
                                break;
                            case BannerSize.MediumRectangular:
                                await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 300);
                                break;
                        }
                    }
                }

                _bannerService.Add(item);
                await _bannerService.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.GetBannerPath(item.Id) + $"bn_{Guid.NewGuid():N}{extension}";
                    item.Image = filenameToUse;
                    await _bannerService.CommitAsync(User.Identity.Name);

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

                    switch (item.BannerSize)
                    {
                        //Thumbnails
                        case BannerSize.Standard or BannerSize.Large:
                            await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 320);
                            break;
                        case BannerSize.MediumRectangular:
                            await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 300);
                            break;
                    }

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

                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("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 eines Banners
        /// </summary>
        /// <param name="id">Id des Banners</param>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.PowerUserOnly)]
        [HasPermission(Permission.BannersManage, Permission.BannersEdit)]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> Edit(string id)
        {
            var item = await _bannerService.GetAsync(id);
            if (item != null)
            {
                var model = _mapper.Map<BannerCrudVm>(item);

                model.TextVms = new List<BannerTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new BannerTextVm()
                    {
                        Id = item.Id,
                        Language = language,
                        Name = item.Get("Name", 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 customer = await _customerService.GetAsync(model.CustomerId);
                model.CustomerName = customer != null ? customer.Name : "";

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

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

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

                        _mapper.Map(model, item);

                        //Texte setzen
                        foreach (var textVm in model.TextVms)
                        {
                            item.Set("Name", textVm.Language, textVm.Name);
                            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);
                                    switch (oldSize)
                                    {
                                        //Thumbnails
                                        case BannerSize.Standard or BannerSize.Large:
                                            await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 320);
                                            break;
                                        case BannerSize.MediumRectangular:
                                            await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 300);
                                            break;
                                    }
                                }

                                if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                                {
                                    //Neue Bilddaten verwenden....
                                    var extension = Path.GetExtension(textVm.ImageLanguage);
                                    var fileName = Path.GetFileName(textVm.ImageLanguage);
                                    var filenameToUse = FileServiceHelper.GetBannerPath(item.Id) + $"bn_{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
                                    switch (item.BannerSize)
                                    {
                                        //Thumbnails
                                        case BannerSize.Standard or BannerSize.Large:
                                            await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 320);
                                            break;
                                        case BannerSize.MediumRectangular:
                                            await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 300);
                                            break;
                                    }
                                }
                            }
                        }

                        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);
                                switch (oldSize)
                                {
                                    //Thumbnails
                                    case BannerSize.Standard or BannerSize.Large:
                                        await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldImage, 320);
                                        break;
                                    case BannerSize.MediumRectangular:
                                        await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldImage, 300);
                                        break;
                                }
                            }

                            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) + $"bn_{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
                                switch (item.BannerSize)
                                {
                                    //Thumbnails
                                    case BannerSize.Standard or BannerSize.Large:
                                        await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 320);
                                        break;
                                    case BannerSize.MediumRectangular:
                                        await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 300);
                                        break;
                                }
                            }
                        }

                        await _bannerService.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("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 eines Banners
        /// </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.BannersManage, Permission.BannersDelete)]
        [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 _bannerService.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.GetBannerPath(item.Id);
                            await FileService.ClearDirectoryAsync(FileServiceHelper.DocumentContainer, postingPath);
                            switch (item.BannerSize)
                            {
                                //Thumbnails
                                case BannerSize.Standard or BannerSize.Large:
                                    await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, item.Image, 320);
                                    break;
                                case BannerSize.MediumRectangular:
                                    await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, item.Image, 300);
                                    break;
                            }

                            var languages = item.GetLanguages("ImageLanguage");
                            foreach (var language in languages)
                            {
                                item.SetLanguage(language);
                                var imageLocalized = item.ImageLanguage;
                                if (!string.IsNullOrWhiteSpace(imageLocalized))
                                {
                                    switch (item.BannerSize)
                                    {
                                        //Thumbnails
                                        case BannerSize.Standard or BannerSize.Large:
                                            await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 320);
                                            break;
                                        case BannerSize.MediumRectangular:
                                            await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, imageLocalized, 300);
                                            break;
                                    }
                                }
                            }

                            _bannerService.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 _bannerService.CommitAsync(User.Identity.Name);
            return Json(batchResult);
        }

        #endregion

        #region Kunden

        /// <summary>
        /// Gibt einen View für die Verwaltung von Bannern für Kunden zurück
        /// </summary>
        /// <returns>View</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.BannersManage, Permission.BannersRead)]
        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.BannersManage, Permission.BannersRead)]
        [CustomerAuthorize("customerUniqueId")]
        [HttpPost]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> GetBannersCustomer([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 = (BannerStatus)((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 = _bannerService.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<BannerListVm>(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);
                itemVm.BannerLocationText = itemVm.BannerLocation.GetDisplayName(AnnotationsLocalizer);
                itemVm.BannerSizeText = itemVm.BannerSize.GetDisplayName(AnnotationsLocalizer);
            }

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

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

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

                model.TextVms = new List<BannerTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new BannerTextVm()
                    {
                        Id = item.Id,
                        Language = language,
                        Name = item.Get("Name", 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 customer = await _customerService.GetAsync(model.CustomerId);
                model.CustomerName = customer != null ? customer.Name : "";

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

        /// <summary>
        /// Bearbeiten eines Banners für Kunden
        /// </summary>
        /// <param name="model">Model</param>
        /// <returns>Json</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.BannersManage, Permission.BannersEdit)]
        [CustomerAuthorize("CustomerId")]
        [ValidateAntiForgeryToken]
        [HttpPost]
        public async Task<IActionResult> EditCustomer(BannerCrudVm model)
        {
            var result = new ResponseVm { Success = false };

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

                        _mapper.Map(model, item);

                        //Texte setzen
                        foreach (var textVm in model.TextVms)
                        {
                            item.Set("Name", textVm.Language, textVm.Name);
                            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);
                                    switch (oldSize)
                                    {
                                        //Thumbnails
                                        case BannerSize.Standard or BannerSize.Large:
                                            await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 320);
                                            break;
                                        case BannerSize.MediumRectangular:
                                            await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldLangImage, 300);
                                            break;
                                    }
                                }

                                if (!string.IsNullOrWhiteSpace(textVm.ImageLanguage))
                                {
                                    //Neue Bilddaten verwenden....
                                    var extension = Path.GetExtension(textVm.ImageLanguage);
                                    var fileName = Path.GetFileName(textVm.ImageLanguage);
                                    var filenameToUse = FileServiceHelper.GetBannerPath(item.Id) + $"bn_{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
                                    switch (item.BannerSize)
                                    {
                                        //Thumbnails
                                        case BannerSize.Standard or BannerSize.Large:
                                            await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 320);
                                            break;
                                        case BannerSize.MediumRectangular:
                                            await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 300);
                                            break;
                                    }
                                }
                            }
                        }

                        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);
                                switch (oldSize)
                                {
                                    //Thumbnails
                                    case BannerSize.Standard or BannerSize.Large:
                                        await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldImage, 320);
                                        break;
                                    case BannerSize.MediumRectangular:
                                        await RemoveBannerThumbnail(FileServiceHelper.DocumentContainer, oldImage, 300);
                                        break;
                                }
                            }

                            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) + $"bn_{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
                                switch (item.BannerSize)
                                {
                                    //Thumbnails
                                    case BannerSize.Standard or BannerSize.Large:
                                        await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 320);
                                        break;
                                    case BannerSize.MediumRectangular:
                                        await GenerateBannerThumbnailByWidth(FileServiceHelper.DocumentContainer, filenameToUse, 300);
                                        break;
                                }
                            }
                        }

                        await _bannerService.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("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 eines Banners für Kunden
        /// </summary>
        /// <param name="id">Id des Banners</param>
        /// <param name="customerUniqueId">UniqueId des Kunden</param>
        /// <returns>PartialView</returns>
        [Authorize(Policy = Policies.CustomerOnly)]
        [HasPermission(Permission.BannersManage, Permission.BannersEdit)]
        [CustomerAuthorize("customerUniqueId")]
        [ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
        public async Task<IActionResult> DetailsCustomer(string id, Guid customerUniqueId)
        {
            var item = await _bannerService.GetAsync(id);
            if (item != null)
            {
                var model = _mapper.Map<BannerCrudVm>(item);

                model.TextVms = new List<BannerTextVm>();
                foreach (var language in _languageService.GetAllIso2())
                {
                    model.TextVms.Add(new BannerTextVm()
                    {
                        Id = item.Id,
                        Language = language,
                        Name = item.Get("Name", 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 customer = await _customerService.GetAsync(model.CustomerId);
                model.CustomerName = customer != null ? customer.Name : "";

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

        /// <summary>
        /// Stornieren von Bannern
        /// </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.BannersManage, Permission.BannersCancel)]
        [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 _bannerService.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 = BannerStatus.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 _bannerService.CommitAsync(User.Identity.Name);
            return Json(batchResult);
        }

        #endregion

        #region Banner Thumbnails

        /// <summary>
        /// Erstellt ein Thumbnail basierend auf der Breite
        /// </summary>
        /// <param name="container">Container</param>
        /// <param name="filename">Dateiname</param>
        /// <param name="size">Größe für Breite und Höhe</param>
        /// <returns>Task</returns>
        internal async Task GenerateBannerThumbnailByWidth(string container, string filename, int size)
        {
            try
            {
                using (var imgStream = await FileService.GetAsStreamAsync(container, filename))
                {
                    using (var img = await Image.LoadAsync(imgStream))
                    {
                        img.Mutate(x => x.Resize(new ResizeOptions() { Mode = ResizeMode.Max, Size = new Size(size) }));

                        var format = img.DetectEncoder(filename);

                        await using (var memStream = new MemoryStream())
                        {
                            await img.SaveAsync(memStream, format);
                            memStream.Position = 0;
                            await FileService.StoreAsync(container, $"thumbnails/banner/{size}/{filename}", memStream);
                        }
                    }
                }
            }
            catch
            {

            }
        }

        /// <summary>
        /// Löschen eines Thumbnails für ein Bild
        /// </summary>
        /// <param name="container">Container</param>
        /// <param name="fileName">Dateiname</param>
        /// <param name="size">Größe für Breite und Höhe</param>
        /// <returns>Task</returns>
        internal async Task RemoveBannerThumbnail(string container, string fileName, int size)
        {
            try
            {
                var file = await FileService.GetAsync(container, $"thumbnails/banner/{size}/{fileName}");
                if (file != null)
                {
                    await FileService.DeleteAsync(container, $"thumbnails/banner/{size}/{fileName}");
                }
            }
            catch
            {

            }
        }

        #endregion
    }


}