using System;
using System.Linq;
using Microsoft.AspNetCore.Mvc;
using System.Data.SqlClient;
using C1.Web.Mvc;
using C1.Web.Mvc.Serialization;
using MvcExplorer.Models;
using Microsoft.EntityFrameworkCore;

namespace MvcExplorer.Controllers
{
    public partial class ListBoxController : Controller
    {
        private readonly C1NWindEntities _db;

        public ListBoxController(C1NWindEntities db)
        {
            _db = db;
        }
        public ActionResult MultiSelect()
        {
            return View(_db);
        }

        public ActionResult ListUpdateProducts([C1JsonRequest]CollectionViewEditRequest<Product> requestData)
        {
            return this.C1Json(CollectionViewHelper.Edit<Product>(requestData, item =>
            {
                string error = string.Empty;
                bool success = true;
                try
                {
                    _db.Entry(item as object).State = EntityState.Modified;
                    _db.SaveChanges();
                }
                catch (Exception e)
                {
                    error = GetExceptionMessage(e);
                    success = false;
                }
                return new CollectionViewItemResult<Product>
                {
                    Error = error,
                    Success = success,
                    Data = item
                };
            }, () => _db.Products.ToList<Product>()));
        }

        // Get the real exception message
        internal static string GetExceptionMessage(Exception e)
        {
            var msg = e.Message;
            var sqlException = GetSqlException(e);
            if (sqlException != null)
            {
                msg = sqlException.Message;
            }
            return msg;
        }

        /// <summary>
        /// In order to get the real exception message.
        /// </summary>
        private static SqlException GetSqlException(Exception e)
        {
            while (e != null && !(e is SqlException))
            {
                e = e.InnerException;
            }
            return e as SqlException;
        }
    }
}

@model C1NWindEntities

<c1-list-box width="400px" height="200px" display-member-path="ProductName" checked-member-path="Discontinued">
    <c1-items-source update-action-url="ListUpdateProducts" source-collection="@Model.Products"></c1-items-source>
</c1-list-box>

@section Description{
    @Html.Raw(ListBoxRes.MultiSelect_Text0)
}