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));
}
