public ActionResult Index(List <Filtri_Parametri> filtri_parametri, int idStampa, string RptFormat) { int ID = 0; int i = 0; object[] args = new object[filtri_parametri.Count()]; foreach (Filtri_Parametri Fp in filtri_parametri) { Filtri_Parametri Existed_Fp = db.Filtri_Parametri.Find(Fp.IDFiltro, Fp.Ordine, Fp.IDP); Existed_Fp.Valore = Fp.Valore; if (Existed_Fp.TabParametriFiltri.TipoParametro == "Date") { Fp.Valore = "DateTime(" + Convert.ToDateTime(Fp.Valore).Date.Year.ToString() + "," + Convert.ToDateTime(Fp.Valore).Date.Month.ToString() + "," + Convert.ToDateTime(Fp.Valore).Date.Day.ToString() + ")"; } ID = Fp.IDFiltro; args[i++] = Fp.Valore; } db.SaveChanges(); Stampe stampa = db.Stampe.Find(idStampa); String filter = String.Format(stampa.Filtro, args); // richiama la produzione del report return(RedirectToAction("Rpt", "Stampe", new { id = RptFormat, query = stampa.QueryAmmesse, reportname = stampa.NomeReport, filter = filter, orderby = stampa.Ordinamento })); }
public ActionResult Seleziona([Bind(Include = "ID,Nome,NomeReport,Descrizione,IDFiltro,Filtro,IDOrdinamento,Ordinamento,Filtrabile,Ordinabile,Selezionato,QueryAmmesse")] Stampe stampe) { if (ModelState.IsValid) { var sql = (from r in db.Filtri where r.IDFiltro == stampe.IDFiltro select r.SQL).SingleOrDefault(); stampe.Filtro = sql.ToString(); var criterioo = (from r in db.Ordinamenti where r.IDO == stampe.IDOrdinamento select r.CriterioO).SingleOrDefault(); stampe.Ordinamento = criterioo.ToString(); db.Entry(stampe).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "Filtri_Parametri", new { id = stampe.IDFiltro, idStampa = stampe.ID })); // return RedirectToAction("Rpt","RptMems",new { query=stampe.QueryAmmesse, reportname=stampe.NomeReport, filter=stampe.Filtro, orderby=stampe.Ordinamento}); } ViewBag.Filtri = db.Filtri.Select(q => new SelectListItem { Value = q.IDFiltro.ToString(), Text = q.NomeFiltro }).ToList(); ViewBag.Ordinamenti = db.Ordinamenti.Select(q => new SelectListItem { Value = q.IDO.ToString(), Text = q.NomeOrdinamentoO }).ToList(); return(View(stampe)); }
public ActionResult DeleteConfirmed(int id) { Stampe stampe = db.Stampe.Find(id); db.Stampe.Remove(stampe); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult RptSel([Bind(Include = "ID,Nome,NomeReport,Descrizione,IDFiltro,Filtro,IDOrdinamento,Ordinamento,Filtrabile,Ordinabile,Selezionato,QueryAmmesse")] Stampe stampe) { if (ModelState.IsValid) { db.Entry(stampe).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IDFiltro = new SelectList(db.Filtri, "IDFiltro", "NomeFiltro"); ViewBag.IDOrdinamento = new SelectList(db.Ordinamenti, "IDO", "NomeOrdinamentoO"); return(View(stampe)); }
// GET: Stampes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Stampe stampe = db.Stampe.Find(id); if (stampe == null) { return(HttpNotFound()); } return(View(stampe)); }
// GET: Stampes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Stampe stampa = db.Stampe.Find(id); if (stampa == null) { return(HttpNotFound()); } ViewBag.IDFiltro = new SelectList(db.Filtri, "IDFiltro", "NomeFiltro"); ViewBag.IDOrdinamento = new SelectList(db.Ordinamenti, "IDO", "NomeOrdinamentoO"); return(View(stampa)); }