using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;
using StockManMVC.Models;
using X.PagedList;

namespace StockManMVC.Controllers
{
    public class ItemFluxesController : Controller
    {
        private StockManEntities db = new StockManEntities();

        /// <summary>
        /// Selezione
        /// </summary>
        /// <param name="ItemID"></param>
        /// <param name="SearchVal"></param>
        /// <returns></returns>
        public static IEnumerable<ItemFlux> Select(int? ItemID, string SearchVal)
        {
            StockManEntities db = new StockManEntities();
            if (ItemID == null)
            {
                ItemID = 0;
            }
            var answ = db.ItemFlux.Where(s => s.ItemID == ItemID
                                        && (
                                                s.Note.Contains(SearchVal)
                                             || s.Location.Descr.Contains(SearchVal)
                                             || s.Location1.Descr.Contains(SearchVal)
                                             || s.Operator.LastName.Contains(SearchVal)
                                             || s.Operator.FirstName.Contains(SearchVal)
                                             || s.MovType.Descr.Contains(SearchVal)
                                        ));
            return answ;
        }
        /// <summary>
        /// Ricerca con selezione parametri
        /// </summary>
        /// <param name="ItemID"></param>
        /// <param name="SearchVal"></param>
        /// <param name="OrderBy"></param>
        /// <param name="Sort"></param>
        /// <returns></returns>
        public static IEnumerable<ItemFlux> Order(int? ItemID, string SearchVal, string OrderBy, string Sort)
        {
            IEnumerable<ItemFlux> answ = Select(ItemID, SearchVal);
            switch (OrderBy)
            {
                case "note":
                    if (Sort == "dsc")
                    {
                        answ = answ.OrderByDescending(x => x.Note);
                    }
                    else
                    {
                        answ = answ.OrderBy(x => x.Note);
                    }
                    break;
                case "Posizione":
                    if (Sort == "dsc")
                    {
                        answ = answ.OrderByDescending(x => x.Location.Descr);
                    }
                    else
                    {
                        answ = answ.OrderBy(x => x.Location.Descr);
                    }
                    break;
                case "Tipo":
                    if (Sort == "dsc")
                    {
                        answ = answ.OrderByDescending(x => x.MovType.Descr);
                    }
                    else
                    {
                        answ = answ.OrderBy(x => x.MovType.Descr);
                    }
                    break;
                case "Riferimento":
                    if (Sort == "dsc")
                    {
                        answ = answ.OrderByDescending(x => x.Location1.Descr);
                    }
                    else
                    {
                        answ = answ.OrderBy(x => x.Location1.Descr);
                    }
                    break;
                case "Operatore":
                    if (Sort == "dsc")
                    {
                        answ = answ.OrderByDescending(x => x.Operator.LastName);
                    }
                    else
                    {
                        answ = answ.OrderBy(x => x.Operator.LastName);
                    }
                    break;
                case "dtMov":
                default:
                    if (Sort == "dsc")
                    {
                        answ = answ.OrderByDescending(x => x.ID);
                    }
                    else
                    {
                        answ = answ.OrderBy(x => x.ID);
                    }
                    break;
            }
            return answ;
        }
        /// <summary>
        /// Ricerca con paginazione
        /// </summary>
        /// <param name="ItemID"></param>
        /// <param name="SearchVal"></param>
        /// <param name="OrderBy"></param>
        /// <param name="Sort"></param>
        /// <param name="startRowIndex"></param>
        /// <param name="maximumRows"></param>
        /// <returns></returns>
        public static IEnumerable<ItemFlux> SelectPage(int? ItemID, string SearchVal, string OrderBy, string Sort, int startRowIndex, int maximumRows)
        {
            return Order(ItemID, SearchVal, OrderBy, Sort).Skip(startRowIndex * maximumRows).Take(maximumRows);
        }


        /// <summary>
        /// Ricerca con selezione parametri
        /// </summary>
        /// <param name="ItemID"></param>
        /// <param name="SearchVal"></param>
        /// <param name="OrderBy"></param>
        /// <param name="Sort"></param>
        /// <returns></returns>
        public static IEnumerable<ItemFlux> Order(int? ItemID, string SearchVal, string SortOrd)
        {
            IEnumerable<ItemFlux> answ = Select(ItemID, SearchVal);
            // ora verifico ordinamento...
            switch (SortOrd)
            {
                case "Loc":
                    answ = answ.OrderBy(s => s.Location.Descr);
                    break;
                case "Loc_desc":
                    answ = answ.OrderByDescending(s => s.Location.Descr);
                    break;
                case "Qta":
                    answ = answ.OrderBy(s => s.Qta);
                    break;
                case "Qta_desc":
                    answ = answ.OrderByDescending(s => s.Qta);
                    break;
                case "Rif":
                    answ = answ.OrderBy(s => s.Location1.Descr);
                    break;
                case "Rif_desc":
                    answ = answ.OrderByDescending(s => s.Location1.Descr);
                    break;
                case "Val":
                    answ = answ.OrderBy(s => s.TotValue);
                    break;
                case "Val_desc":
                    answ = answ.OrderByDescending(s => s.TotValue);
                    break;
                case "DtMov":
                    answ = answ.OrderBy(s => s.dtMov).ThenBy(s => s.ID);
                    break;
                case "DtMov_desc":
                default:
                    answ = answ.OrderByDescending(s => s.dtMov).ThenByDescending(s => s.ID);
                    break;
            }
            return answ;
        }

        // GET: Location/ListByType/LocTypeID
        public ActionResult ListByItem(int? ID, string SearchVal, string SortOrd, int? page, int? pageSize)
        {
            // gestione selettore dim pagina
            if (page == null) page = 1;
            if (pageSize == null) pageSize = 10;
            ViewBag.pageSize = pageSize;
            var pageOptions = new[] { "5", "10", "25", "50", "100" };
            ViewBag.PageSizeDD = new SelectList(pageOptions, pageSize.ToString());

            if (ID == null) ID = 0;
            if (SearchVal == null) SearchVal = "";
            if (SortOrd == null) SortOrd = "";
            ViewBag.ID = ID;
            ViewBag.SearchVal = SearchVal;
            ViewBag.SortOrd = SortOrd;
            // fix valori sorting
            ViewBag.DtMovSortParm = String.IsNullOrEmpty(SortOrd) ? "DtMov" : "";
            ViewBag.LocSortParm = SortOrd == "Loc" ? "Loc_desc" : "Loc";
            ViewBag.QtaSortParm = SortOrd == "Qta" ? "Qta_desc" : "Qta";
            ViewBag.ValSortParm = SortOrd == "Val" ? "Val_desc" : "Val";
            ViewBag.RifSortParm = SortOrd == "Rif" ? "Rif_desc" : "Rif";

            var pagedData = Order(ID, SearchVal, SortOrd).ToPagedList((int)page, (int)pageSize);
            return PartialView("_ListByItem", pagedData);
        }
        /// <summary>
        /// calcolo num risultati
        /// </summary>
        /// <param name="ItemID"></param>
        /// <param name="SearchVal"></param>
        /// <returns></returns>
        public static int SelectCount(int? ItemID, string SearchVal)
        {
            return Select(ItemID, SearchVal).Count();
        }

        // GET: ItemFluxes
        public ActionResult Index()
        {
            var itemFlux = db.ItemFlux.Include(i => i.Location).Include(i => i.MovType).Include(i => i.Item).Include(i => i.Operator).Include(i => i.Location1);
            return View(itemFlux.ToList());
        }

        // GET: ItemFluxes/Details/5
        public ActionResult Details(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            ItemFlux itemFlux = db.ItemFlux.Find(id);
            if (itemFlux == null)
            {
                return HttpNotFound();
            }
            return View(itemFlux);
        }

        // GET: ItemFluxes/Create
        public ActionResult Create()
        {
            ViewBag.LocationID = new SelectList(db.Location, "ID", "Descr");
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr");
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr");
            ViewBag.OperatorID = new SelectList(db.Operator, "ID", "CodExt");
            ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr");
            return View();
        }

        // POST: ItemFluxes/Create
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
        // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Create([Bind(Include = "ID,ItemID,LocationID,MovTypeID,ExtLocationID,dtMov,Qta,TotValue,UnitVal,Note,dtExport,OperatorID")] ItemFlux itemFlux)
        {
            if (ModelState.IsValid)
            {
                db.ItemFlux.Add(itemFlux);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.LocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.LocationID);
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr", itemFlux.MovTypeID);
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr", itemFlux.ItemID);
            ViewBag.OperatorID = new SelectList(db.Operator, "ID", "CodExt", itemFlux.OperatorID);
            ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
            return View(itemFlux);
        }

        // GET: ItemFluxes/Create with params preselected
        public ActionResult CreatePrecompiled(int ItemID, string MovTypeID)
        {
            ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr");
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr", MovTypeID);
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr", ItemID);
            ViewBag.enabEditVal = true;
            // preparo query degli scaffali ammissibili
            // recupero SOLO gli scaffali ammissibili
            var query = db.Location.Where(o => o.LocType.IsStock).Join(db.ItemStock.Where(s => s.ItemID == ItemID),
                  l => l.ID,
                  s => s.LocationID,
                  (l, s) => new { l.ID, l.Descr });
            // in base al tipo di mov richiesto determino cosa mostrare... 
            string CurrStyle = "";
            switch (MovTypeID)
            {
                case "CAR":
                    // per partire scelgo la posizione di default ric ordini
                    string stdLocationId = "#RIC-ORD";
                    // cerco se ci sia una posizione occupata dall'item in stock..
                    if (db.ItemStock.Where(s => s.ItemID == ItemID).Count() > 0)
                    {
                        stdLocationId = db.ItemStock.Where(s => s.ItemID == ItemID).ToList()[0].LocationID;
                    }
                    ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", stdLocationId);
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsFor), "ID", "Descr");
                    CurrStyle = "bg-success";
                    break;
                case "SCAR":
                    if (query.Count() > 0)
                    {
                        ViewBag.LocationID = new SelectList(query, "ID", "Descr");
                    }
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsCli), "ID", "Descr");
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-danger";
                    break;
                case "MOV":
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr");
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-primary";
                    break;
                case "OFOR":
                    ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", "#RIC-ORD");
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsFor), "ID", "Descr");
                    CurrStyle = "bg-info";
                    break;
                case "RETT":
                    if (query.Count() > 0)
                    {
                        ViewBag.LocationID = new SelectList(query, "ID", "Descr");
                    }
                    ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr");
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-warning";
                    break;
                case "ND":
                default:
                    ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr");
                    CurrStyle = "bg-default";
                    break;
            }
            ViewBag.CurrStyle = CurrStyle;
            // aggiungo valori default...
            ItemFlux itemFlux = new ItemFlux();
            itemFlux.dtMov = DateTime.Now.Date;
            // alore propongo corrente
            return PartialView("_CreatePrecompiled", itemFlux);
        }

        // POST: ItemFluxes/Create
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
        // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult CreatePrecompiled([Bind(Include = "ID,ItemID,LocationID,MovTypeID,ExtLocationID,dtMov,Qta,TotValue,UnitVal,CodDoc,Note")] ItemFlux itemFlux)
        {
            // aggiungo campi mancanti...
            if (itemFlux.dtMov == null) itemFlux.dtMov = DateTime.Now;
            if (itemFlux.Note == null) itemFlux.Note = "";
            if (itemFlux.CodDoc == null) itemFlux.CodDoc = "";
            itemFlux.dtExport = null;
            string currOpID = "ND"; // default
            try
            {
                var trovato = db.Operator.SingleOrDefault(s => s.CodExt == User.Identity.Name || s.CodExt.Contains(User.Identity.Name) || s.ID == User.Identity.Name);
                Operator currOp = (Operator)trovato;
                currOpID = currOp.ID;
            }
            catch
            { }
            itemFlux.OperatorID = currOpID;
            itemFlux.ModOperatorID = currOpID;

            // verifico Qta: SE CAR > 0, se SCAR < 0, se MOV / rett libero...
            switch (itemFlux.MovTypeID)
            {
                case "CAR":
                    itemFlux.Qta = Math.Abs(itemFlux.Qta);
                    break;
                case "SCAR":
                    itemFlux.Qta = -Math.Abs(itemFlux.Qta);
                    break;
                default:
                    break;
            }

            if (ModelState.IsValid)
            {
                db.ItemFlux.Add(itemFlux);
                db.SaveChanges();
                // rimando a pag esterna...
                return RedirectToAction("Details", "Items", new { ID = itemFlux.ItemID, StockItemID = itemFlux.ItemID });
                //return RedirectToAction("Index");
            }

            ViewBag.LocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.LocationID);
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr", itemFlux.MovTypeID);
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr", itemFlux.ItemID);
            ViewBag.OperatorID = new SelectList(db.Operator, "ID", "CodExt", itemFlux.OperatorID);
            ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);

            return View("CreatePrecompiled", itemFlux);
        }

        // GET: ItemFluxes/ConvOrder/5 converte da ORDINE a CARICO e manda in edit...
        public ActionResult ConvOrder(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            ItemFlux itemFlux = db.ItemFlux.Find(id);
            if (itemFlux == null)
            {
                return HttpNotFound();
            }
            // converto ordine in carico!
            if (itemFlux.MovTypeID == "OFOR")
            {
                itemFlux.MovTypeID = "CAR";
                db.SaveChanges();
            }
            // ritorno a dettaglio!
            return RedirectToAction("Details", "Items", new { ID = itemFlux.ItemID, StockItemID = itemFlux.ItemID });
        }


        // GET: ItemFluxes/Duplicate/5
        public ActionResult Duplicate(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            int newId = 0;
            int ItemID = 0;
            // ora chiamo stored e recupero nuovo ID del record duplicato
            using (var ctx = new StockManEntities())
            {
                // esegue stored procedure come function, recuperando nuovo ID creato...
                var newItemFlux = ctx.stp_ItemFluxDuplicate(id).ToList();
                newId = newItemFlux[0].ID;
                ItemID = newItemFlux[0].ItemID;
            }

            // rimando in editing!
            return RedirectToAction("Edit", "ItemFluxes", new { ID = newId, mode = "std" });
            //return Edit(newId, "std");
            //return RedirectToAction("Details", "Items", new { ID = ItemID, StockItemID = ItemID });
        }

        // GET: ItemFluxes/Read/5
        public ActionResult Read(int? id,string mode)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            if (mode == null)
            {
                mode = "std";
            }
            // recupero item
            ItemFlux itemFlux = db.ItemFlux.Find(id);
            if (itemFlux == null)
            {
                return HttpNotFound();
            }
            // recupero SOLO gli scaffali ammissibili
            var query = db.Location.Where(o => o.LocType.IsStock).Join(db.ItemStock.Where(s => s.ItemID == itemFlux.ItemID),
                  l => l.ID,
                  s => s.LocationID,
                  (l, s) => new { l.ID, l.Descr });
            // calcolo sfondo e location ammesse da vari casi tipo movimento
            string CurrStyle = "";
            ViewBag.LocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.LocationID);
            ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
            switch (itemFlux.MovTypeID)
            {
                case "CAR":
                    // per partire scelgo la posizione di default ric ordini
                    ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", itemFlux.LocationID);
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsFor), "ID", "Descr", itemFlux.ExtLocationID);
                    CurrStyle = "bg-success";
                    break;
                case "SCAR":
                    if (query.Count() > 0)
                    {
                        ViewBag.LocationID = new SelectList(query, "ID", "Descr");
                    }
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsCli), "ID", "Descr", itemFlux.ExtLocationID);
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-danger";
                    break;
                case "MOV":
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", itemFlux.ExtLocationID);
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-primary";
                    break;
                case "OFOR":
                    ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", itemFlux.LocationID);
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsFor), "ID", "Descr", itemFlux.ExtLocationID);
                    CurrStyle = "bg-info";
                    break;
                case "RETT":
                    if (query.Count() > 0)
                    {
                        ViewBag.LocationID = new SelectList(query, "ID", "Descr");
                    }
                    ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-warning";
                    break;
                case "ND":
                default:
                    ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
                    CurrStyle = "bg-default";
                    break;
            }
            // altri valori in viewbag
            ViewBag.CurrStyle = CurrStyle;
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr", itemFlux.MovTypeID);
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr", itemFlux.ItemID);
            ViewBag.OperatorID = new SelectList(db.Operator, "ID", "CodExt", itemFlux.OperatorID);
            if (mode == "std")
            {
                return PartialView(itemFlux);
            }
            else
            {
                return View(itemFlux);
            }

        }

        // GET: ItemFluxes/Edit/5
        public ActionResult Edit(int? id, string mode)
        {
            if (mode == null)
            {
                mode = "std";
            }
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            // recupero item
            ItemFlux itemFlux = db.ItemFlux.Find(id);
            if (itemFlux == null)
            {
                return HttpNotFound();
            }
            // recupero SOLO gli scaffali ammissibili
            var query = db.Location.Where(o => o.LocType.IsStock).Join(db.ItemStock.Where(s => s.ItemID == itemFlux.ItemID),
                  l => l.ID,
                  s => s.LocationID,
                  (l, s) => new { l.ID, l.Descr });
            // calcolo sfondo e location ammesse da vari casi tipo movimento
            string CurrStyle = "";
            ViewBag.LocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.LocationID);
            ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
            switch (itemFlux.MovTypeID)
            {
                case "CAR":
                    // per partire scelgo la posizione di default ric ordini
                    ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", itemFlux.LocationID);
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsFor), "ID", "Descr", itemFlux.ExtLocationID);
                    CurrStyle = "bg-success";
                    break;
                case "SCAR":
                    if (query.Count() > 0)
                    {
                        ViewBag.LocationID = new SelectList(query, "ID", "Descr");
                    }
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsCli), "ID", "Descr", itemFlux.ExtLocationID);
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-danger";
                    break;
                case "MOV":
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", itemFlux.ExtLocationID);
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-primary";
                    break;
                case "OFOR":
                    ViewBag.LocationID = new SelectList(db.Location.Where(o => o.LocType.IsStock), "ID", "Descr", itemFlux.LocationID);
                    ViewBag.ExtLocationID = new SelectList(db.Location.Where(o => o.LocType.IsFor), "ID", "Descr", itemFlux.ExtLocationID);
                    CurrStyle = "bg-info";
                    break;
                case "RETT":
                    if (query.Count() > 0)
                    {
                        ViewBag.LocationID = new SelectList(query, "ID", "Descr");
                    }
                    ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
                    ViewBag.enabEditVal = false;
                    CurrStyle = "bg-warning";
                    break;
                case "ND":
                default:
                    ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);
                    CurrStyle = "bg-default";
                    break;
            }
            // altri valori in viewbag
            ViewBag.CurrStyle = CurrStyle;
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr", itemFlux.MovTypeID);
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr", itemFlux.ItemID);
            ViewBag.OperatorID = new SelectList(db.Operator, "ID", "CodExt", itemFlux.OperatorID);
            if (mode == "std")
            {
                return PartialView(itemFlux);
            }
            else
            {
                return View(itemFlux);
            }
        }

        // POST: ItemFluxes/Edit/5
        // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
        // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Edit([Bind(Include = "ID,LocationID,ExtLocationID,dtMov,Qta,TotValue,UnitVal,CodDoc,Note,dtExport")] ItemFlux itemFlux)
        {
            // recupero vecchi valori...
            ItemFlux itemFluxOld = db.ItemFlux.Find(itemFlux.ID);
            // fix operatore modifica
            string currOpIDMod = "ND"; // default
            try
            {
                var trovato = db.Operator.SingleOrDefault(s => s.CodExt == User.Identity.Name || s.CodExt.Contains(User.Identity.Name) || s.ID == User.Identity.Name);
                Operator currOp = (Operator)trovato;
                currOpIDMod = currOp.ID;
            }
            catch
            { }
            itemFlux.ModOperatorID = currOpIDMod;
            // imposto valori vecchi x campi "bloccati" (articolo, tipo movimento, operatore iniziale...)
            itemFlux.ItemID = itemFluxOld.ItemID;
            itemFlux.MovTypeID = itemFluxOld.MovTypeID;
            if (itemFlux.OperatorID == null) itemFlux.OperatorID = itemFluxOld.OperatorID;
            // fix valori opzionali da non annullare...
            if (itemFlux.dtMov == null) itemFlux.dtMov = DateTime.Now;
            if (itemFlux.Note == null) itemFlux.Note = "";
            if (itemFlux.CodDoc == null) itemFlux.CodDoc = "";
            // continuo
            if (ModelState.IsValid)
            {
                // verifico: se è un carico --> positivo, scarico --> negativo!
                switch (itemFlux.MovTypeID)
                {
                    case "CAR":
                        itemFlux.Qta = Math.Abs(itemFlux.Qta);
                        break;
                    case "SCAR":
                        itemFlux.Qta = -Math.Abs(itemFlux.Qta);
                        break;
                    default:
                        break;
                }
                // sblocco vecchio item x non fare conflitto
                db.Entry(itemFluxOld).State = EntityState.Detached;
                // indico che devo salvare nuovo!
                db.Entry(itemFlux).State = EntityState.Modified;
                db.SaveChanges();

                // rimando pag dettaglio...
                return RedirectToAction("Details", "Items", new { ID = itemFlux.ItemID, StockItemID = itemFlux.ItemID });
                //return RedirectToAction("Index");
            }
            ViewBag.LocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.LocationID);
            ViewBag.MovTypeID = new SelectList(db.MovType, "ID", "Descr", itemFlux.MovTypeID);
            ViewBag.ItemID = new SelectList(db.Item, "ID", "Descr", itemFlux.ItemID);
            ViewBag.OperatorID = new SelectList(db.Operator, "ID", "CodExt", itemFlux.OperatorID);
            ViewBag.ExtLocationID = new SelectList(db.Location, "ID", "Descr", itemFlux.ExtLocationID);

            // rimando pag dettaglio...
            return View(itemFlux);
        }

        // GET: ItemFluxes/Delete/5
        public ActionResult Delete(int? id, string mode)
        {
            if (mode == null)
            {
                mode = "std";
            }
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            ItemFlux itemFlux = db.ItemFlux.Find(id);
            if (itemFlux == null)
            {
                return HttpNotFound();
            }
            if (mode == "std")
            {
                return PartialView(itemFlux);
            }
            else
            {
                return View(itemFlux);
            }
        }

        // POST: ItemFluxes/Delete/5
        [HttpPost, ActionName("Delete")]
        [ValidateAntiForgeryToken]
        public ActionResult DeleteConfirmed(int id)
        {
            ItemFlux itemFlux = db.ItemFlux.Find(id);
            db.ItemFlux.Remove(itemFlux);
            db.SaveChanges();
            //return RedirectToAction("Index");
            return RedirectToAction("Details", "Items", new { ID = itemFlux.ItemID, StockItemID = itemFlux.ItemID });
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }
    }
}