Samuele E. Locatelli
472 lines
13 KiB
C#
472 lines
13 KiB
C#
using StockManMVC.Models;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.Entity;
|
|
using System.Linq;
|
|
using System.Net;
|
|
using System.Web.Configuration;
|
|
using System.Web.Mvc;
|
|
|
|
namespace StockManMVC.Controllers
|
|
{
|
|
public class ItemsController : Controller
|
|
{
|
|
private StockManEntities db = new StockManEntities();
|
|
|
|
/// <summary>
|
|
/// Selezione
|
|
/// </summary>
|
|
/// <param name="SearchVal"></param>
|
|
/// <returns></returns>
|
|
public static IEnumerable<Item> Select(string SearchVal)
|
|
{
|
|
StockManEntities db = new StockManEntities();
|
|
var answ = db.Item
|
|
.Include(s => s.ItemFlux)
|
|
.Where(s => s.Descr.Contains(SearchVal)
|
|
|| s.DescrExt.Contains(SearchVal)
|
|
|| s.ItemFamilyID.Contains(SearchVal)
|
|
|| s.ItemFamily.Descr.Contains(SearchVal)
|
|
|| s.CodInt.Contains(SearchVal)
|
|
|| s.CodExt.Contains(SearchVal)
|
|
|| s.ItemFlux.Any(a => a.CodDoc.Contains(SearchVal))
|
|
);
|
|
return answ;
|
|
}
|
|
/// <summary>
|
|
/// Ricerca con selezione parametri
|
|
/// </summary>
|
|
/// <param name="SearchVal"></param>
|
|
/// <param name="OrderBy"></param>
|
|
/// <param name="Sort"></param>
|
|
/// <returns></returns>
|
|
public static IEnumerable<Item> Order(string SearchVal, string OrderBy, string Sort)
|
|
{
|
|
IEnumerable<Item> answ = Select(SearchVal);
|
|
switch (OrderBy)
|
|
{
|
|
case "codint":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.CodInt);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.CodInt);
|
|
}
|
|
break;
|
|
case "codext":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.CodExt);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.CodExt);
|
|
}
|
|
break;
|
|
case "descrext":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.DescrExt);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.DescrExt);
|
|
}
|
|
break;
|
|
case "family":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.ItemFamilyID);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.ItemFamilyID);
|
|
}
|
|
break;
|
|
case "qtapend":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.QtaPend);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.QtaPend);
|
|
}
|
|
break;
|
|
case "currvalue":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.CurrValue);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.CurrValue);
|
|
}
|
|
break;
|
|
case "totval":
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.CurrValue * x.QtaPend);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.CurrValue * x.QtaPend);
|
|
}
|
|
break;
|
|
case "descr":
|
|
default:
|
|
if (Sort == "dsc")
|
|
{
|
|
answ = answ.OrderByDescending(x => x.Descr);
|
|
}
|
|
else
|
|
{
|
|
answ = answ.OrderBy(x => x.Descr);
|
|
}
|
|
break;
|
|
}
|
|
return answ;
|
|
//return Select(SearchVal).OrderBy(x => x.Descr);
|
|
}
|
|
/// <summary>
|
|
/// Ricerca con paginazione
|
|
/// </summary>
|
|
/// <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<Item> SelectPage(string SearchVal, string OrderBy, string Sort, int startRowIndex, int maximumRows)
|
|
{
|
|
return Order(SearchVal, OrderBy, Sort).Skip(startRowIndex * maximumRows).Take(maximumRows);
|
|
}
|
|
/// <summary>
|
|
/// Elenco x famiglia ordine qta desc
|
|
/// </summary>
|
|
/// <param name="FamilyID"></param>
|
|
/// <param name="startRowIndex"></param>
|
|
/// <param name="maximumRows"></param>
|
|
/// <returns></returns>
|
|
public ActionResult ListByFamily(string FamilyID)
|
|
{
|
|
|
|
if (FamilyID == null) FamilyID = "";
|
|
var item = db.Item.Where(s => s.ItemFamilyID == FamilyID).OrderByDescending(x => x.QtaPend);
|
|
return PartialView("ListByFamily", item);
|
|
}
|
|
|
|
// GET: Items/Consolidate/5?caller=callingController
|
|
public ActionResult Consolidate(int? id, string caller)
|
|
{
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
// chiamo stored x consolidamento flussi (da movimenti a giacenza confermata)
|
|
using (var ctx = new StockManEntities())
|
|
{
|
|
// esegue stored procedure come function, SE id == 0 processa TUTTI...
|
|
int rowMod = ctx.stp_ItemConsolidate(id);
|
|
}
|
|
|
|
// se non specificati rimando a /Items/Details
|
|
if (caller == "") caller = "Items";
|
|
|
|
// rimanda alla view principale da cui è stata fatta la chiamata...
|
|
if (caller == "Items")
|
|
{
|
|
return RedirectToAction("Details", "Items", new { ID = id, StockItemID = id });
|
|
}
|
|
else
|
|
{
|
|
return RedirectToAction("Index", "vItemFlux2Save");
|
|
}
|
|
}
|
|
|
|
// GET: Items/ShrinkHistory/5?caller=callingController
|
|
public ActionResult ShrinkHistory(int? id, string caller)
|
|
{
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
// chiamo stored x consolidamento flussi (da movimenti a giacenza confermata)
|
|
using (var ctx = new StockManEntities())
|
|
{
|
|
// esegue stored procedure come function, SE id == 0 processa TUTTI...
|
|
int rowMod = ctx.stp_ItemShrinkHist(id);
|
|
}
|
|
|
|
// se non specificati rimando a /Items/Details
|
|
if (caller == "") caller = "Items";
|
|
|
|
// rimanda alla view principale da cui è stata fatta la chiamata...
|
|
if (caller == "Items")
|
|
{
|
|
return RedirectToAction("Details", "Items", new { ID = id, StockItemID = id });
|
|
}
|
|
else
|
|
{
|
|
return RedirectToAction("Index", "vItemFlux2Save");
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// calcolo num risultati
|
|
/// </summary>
|
|
/// <param name="SearchVal"></param>
|
|
/// <returns></returns>
|
|
public static int SelectCount(string SearchVal)
|
|
{
|
|
return Select(SearchVal).Count();
|
|
}
|
|
|
|
// GET: Items
|
|
public ActionResult Index(int? id)
|
|
{
|
|
var item = db.Item.Include(i => i.ItemFamily);
|
|
if (id == null) id = 0;
|
|
ViewBag.ItemID = (int)id;
|
|
return View(item.ToList());
|
|
}
|
|
|
|
|
|
public ActionResult Grid()
|
|
{
|
|
var item = db.Item.Include(i => i.ItemFamily);
|
|
return View(item.ToList());
|
|
}
|
|
|
|
// GET: Items/Details/5
|
|
public ActionResult Details(int? id, int? page, int? pageSize, string enabFR)
|
|
{
|
|
if (page == null) page = 1;
|
|
if (pageSize == null) pageSize = 10;
|
|
ViewBag.page = page;
|
|
ViewBag.pageSize = pageSize;
|
|
ViewBag.BaseUrl = System.Web.Configuration.WebConfigurationManager.AppSettings["BaseUrl"];
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
Item item = db.Item.Find(id);
|
|
if (item == null)
|
|
{
|
|
return HttpNotFound();
|
|
}
|
|
|
|
// !!!FIXME!!! modificare x abilitare SOLO con ruoli
|
|
// 2017.01.03 aggiunto controllo x permesso a resettare INTERA catena flussi + stock... SE in URL si trova comando enabFR=enabFR_key (da webconfig)...
|
|
ViewBag.DisplFR = "disabled invisible zeroWidth";
|
|
bool enableAll = false;
|
|
bool.TryParse(WebConfigurationManager.AppSettings["enabFR_all"], out enableAll);
|
|
if (enabFR != null || enableAll)
|
|
{
|
|
string enabFR_key = WebConfigurationManager.AppSettings["enabFR_key"];
|
|
if (enabFR == enabFR_key || enableAll) ViewBag.DisplFR = "";
|
|
}
|
|
// restituisco vista parziale
|
|
return View(item);
|
|
}
|
|
|
|
|
|
// GET: Items/CurrItemDetail/5
|
|
public ActionResult CurrItemDetail(int? id)
|
|
{
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
Item item = db.Item.Find(id);
|
|
if (item == null)
|
|
{
|
|
return HttpNotFound();
|
|
}
|
|
return PartialView("_ItemDetail", item);
|
|
}
|
|
|
|
// GET: Items/ResetAll/5
|
|
public ActionResult ResetAll(int? id)
|
|
{
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
Item item = db.Item.Find(id);
|
|
if (item == null)
|
|
{
|
|
return HttpNotFound();
|
|
}
|
|
// se ha trovato l'item ORA RESETTA TUTTO sia in stock che in flussi (toglie registrazione di tutti i movimenti)
|
|
// chiamo stored x consolidamento flussi (da movimenti a giacenza confermata)
|
|
using (var ctx = new StockManEntities())
|
|
{
|
|
// esegue stored procedure come function...
|
|
ctx.stp_ItemResetAll(id);
|
|
}
|
|
// restituisco view!
|
|
//return PartialView("_ItemDetail", item);
|
|
return RedirectToAction("Details", "Items", new { ID = id, StockItemID = id });
|
|
}
|
|
|
|
|
|
|
|
// GET: Items/Create (mode=std|full, opzionale)
|
|
public ActionResult Create(string mode)
|
|
{
|
|
if (mode == null)
|
|
{
|
|
mode = "full";
|
|
}
|
|
ViewBag.ItemFamilyID = new SelectList(db.ItemFamily, "ID", "Descr");
|
|
if (mode == "std")
|
|
{
|
|
return PartialView();
|
|
}
|
|
else
|
|
{
|
|
return View();
|
|
}
|
|
}
|
|
|
|
// POST: Items/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,Descr,CodInt,ItemFamilyID,CodExt,DescrExt,QtaMin,QtaBatch,CurrValue,UM")] Item item)
|
|
{
|
|
if (item.CodExt == null) item.CodExt = "";
|
|
if (item.DescrExt == null) item.DescrExt = "";
|
|
if (item.UM == null) item.UM = "";
|
|
if (ModelState.IsValid)
|
|
{
|
|
db.Item.Add(item);
|
|
db.SaveChanges();
|
|
return RedirectToAction("Index");
|
|
}
|
|
|
|
ViewBag.ItemFamilyID = new SelectList(db.ItemFamily, "ID", "Descr", item.ItemFamilyID);
|
|
return View(item);
|
|
}
|
|
|
|
|
|
// GET: Items/Duplicate/5
|
|
public ActionResult Duplicate(int? id)
|
|
{
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
int newId = 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 newItem = ctx.stp_ItemDuplicate(id).ToList();
|
|
newId = newItem[0].ID;
|
|
}
|
|
|
|
// rimando in editing!
|
|
return RedirectToAction("Edit", "Items", new { ID = newId, mode = "full" });
|
|
}
|
|
|
|
// GET: Items/Edit/5
|
|
public ActionResult Edit(int? id, string mode)
|
|
{
|
|
|
|
if (mode == null)
|
|
{
|
|
mode = "std";
|
|
}
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
Item item = db.Item.Find(id);
|
|
if (item == null)
|
|
{
|
|
return HttpNotFound();
|
|
}
|
|
ViewBag.ItemFamilyID = new SelectList(db.ItemFamily, "ID", "Descr", item.ItemFamilyID);
|
|
ViewBag.mode = mode;
|
|
if (mode == "std")
|
|
{
|
|
return PartialView("_Edit", item);
|
|
}
|
|
else
|
|
{
|
|
return View("Edit", item);
|
|
}
|
|
}
|
|
|
|
// POST: Items/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,Descr,CodInt,ItemFamilyID,CodExt,DescrExt,QtaMin,QtaBatch,CurrValue,UM")] Item item)
|
|
{
|
|
if (item.CodExt == null) item.CodExt = "";
|
|
if (item.DescrExt == null) item.DescrExt = "";
|
|
if (ModelState.IsValid)
|
|
{
|
|
db.Entry(item).State = EntityState.Modified;
|
|
db.SaveChanges();
|
|
return RedirectToAction("Details", "Items", new { ID = item.ID, StockItemID = item.ID });
|
|
}
|
|
ViewBag.ItemFamilyID = new SelectList(db.ItemFamily, "ID", "Descr", item.ItemFamilyID);
|
|
return View("Edit", item);
|
|
}
|
|
|
|
// GET: Items/Delete/5
|
|
public ActionResult Delete(int? id, string mode)
|
|
{
|
|
if (mode == null)
|
|
{
|
|
mode = "std";
|
|
}
|
|
if (id == null)
|
|
{
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
Item item = db.Item.Find(id);
|
|
if (item == null)
|
|
{
|
|
return HttpNotFound();
|
|
}
|
|
if (mode == "std")
|
|
{
|
|
return PartialView("_Delete", item);
|
|
}
|
|
else
|
|
{
|
|
return View("Delete", item);
|
|
}
|
|
}
|
|
|
|
// POST: Items/Delete/5
|
|
[HttpPost, ActionName("Delete")]
|
|
[ValidateAntiForgeryToken]
|
|
public ActionResult DeleteConfirmed(int id)
|
|
{
|
|
Item item = db.Item.Find(id);
|
|
db.Item.Remove(item);
|
|
db.SaveChanges();
|
|
return RedirectToAction("Index");
|
|
}
|
|
|
|
protected override void Dispose(bool disposing)
|
|
{
|
|
if (disposing)
|
|
{
|
|
db.Dispose();
|
|
}
|
|
base.Dispose(disposing);
|
|
}
|
|
}
|
|
}
|