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 Edit([Bind(Include = "CodSex,DescrSex,SelSex")] TabSex tabSex)
{
if (ModelState.IsValid)
{
db.Entry(tabSex).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabSex));
}
public ActionResult Edit([Bind(Include = "CodCarica,DescrCarica,SelCarica")] TabCarica tabCarica)
{
if (ModelState.IsValid)
{
db.Entry(tabCarica).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabCarica));
}
public ActionResult Edit([Bind(Include = "Codice,Descrizione,smtpServer,smtpServerPort,sendUsing,AutenticationType,SendUsername,SendPassword,Sender,NotificationTo,ReceiptTo")] TabPosta tabPosta)
{
if (ModelState.IsValid)
{
db.Entry(tabPosta).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabPosta));
}
public ActionResult Edit([Bind(Include = "IDFiltro,IDP,Prompt,Ordine,Valore")] Filtri_Parametri filtri_Parametri)
{
if (ModelState.IsValid)
{
db.Entry(filtri_Parametri).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDFiltro = new SelectList(db.Filtri, "IDFiltro", "NomeFiltro", filtri_Parametri.IDFiltro);
ViewBag.IDP = new SelectList(db.TabParametriFiltri, "Idp", "NomeParametro", filtri_Parametri.IDP);
return(View(filtri_Parametri));
}
public ActionResult Edit([Bind(Include = "AnnoP,CodP,CodGru")] Gruppi gruppi)
{
if (ModelState.IsValid)
{
db.Entry(gruppi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CodP = new SelectList(db.Pag, "CodP", "Tiscr", gruppi.CodP);
ViewBag.AnnoP = new SelectList(db.TabGru, "AnnoGru", "NCodGru", gruppi.AnnoP);
return(View(gruppi));
}
public ActionResult Edit([Bind(Include = "AnnoP,CodP,CodRiv,Ncopie")] Riviste riviste)
{
if (ModelState.IsValid)
{
db.Entry(riviste).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CodP = new SelectList(db.Pag, "CodP", "Tiscr", riviste.CodP);
ViewBag.AnnoP = new SelectList(db.TabRiv, "AnnoRiv", "NCodRiv", riviste.AnnoP);
return(View(riviste));
}
public ActionResult Edit([Bind(Include = "AnnoP,CodP,CodDiv,Effettiva")] Divisioni divisioni)
{
if (ModelState.IsValid)
{
db.Entry(divisioni).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CodP = new SelectList(db.Pag, "CodP", "Tiscr", divisioni.CodP);
ViewBag.AnnoP = new SelectList(db.TabDiv, "AnnoDiv", "NCodDiv", divisioni.AnnoP);
return(View(divisioni));
}
public ActionResult Edit([Bind(Include = "Cod,Sesso,Nom,Titolo,Nome,Cognome,Ist,Via,CAP,Cit,Naz,DaNa,Tel,Fax,Email,DimAn,NoStampa,Modificato,PresentatoDa,FlagRegalo,PresentatoDa2,FlagRegalo2,AnnoPresentazione,CodTitStu")] Mem mem)
{
if (ModelState.IsValid)
{
db.Entry(mem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Naz = new SelectList(db.TabNaz, "CodNaz", "DescrNaz", mem.Naz);
ViewBag.Sesso = new SelectList(db.TabSex, "CodSex", "DescrSex", mem.Sesso);
ViewBag.CodTitStu = new SelectList(db.TabTitStu, "TCodTitStu", "DescrTitStu", mem.CodTitStu);
return(View(mem));
}
public ActionResult Edit([Bind(Include = "Codice,CodiceConn,Sender,NotificationTO,ReceiptTo,Subject,Header,Message,Footer,CC,BCC,emailtest,Allegati,Azione,FullMessage")] Posta_Prototipi posta_prototipi, string submit)
{
if (ModelState.IsValid)
{
db.Entry(posta_prototipi).State = EntityState.Modified;
db.SaveChanges();
switch (submit)
{
case "Salva":
return(RedirectToAction("Edit", "Mailing", new { id = posta_prototipi.Codice }));
case "SendMail":
return(RedirectToAction("SendMail", "Mailing", new { id = posta_prototipi.Codice }));
default:
throw new Exception();
}
return(RedirectToAction("Index"));
}
return(View(posta_prototipi));
}
public ActionResult Edit([Bind(Include = "CodP,AnnoP,Tiscr,Cat,Pagato,Dovuto,DatPag,DatReg,DatCassa,Tpag,Fuori,Lode,Carica,Sez,Sett,Pos,Ent,CodSocCol")] Pag pag)
{
if (ModelState.IsValid)
{
db.Entry(pag).State = EntityState.Modified;
db.SaveChanges();
UpdateDovuto(pag.AnnoP, pag.CodP);
ViewBag.Cat = new SelectList(db.TabCat.Where(m => m.AnnoCat == pag.AnnoP), "CodCat", "DescrCat", pag.Cat);
ViewBag.Carica = new SelectList(db.TabCarica, "CodCarica", "DescrCarica", pag.Carica);
ViewBag.Ent = new SelectList(db.TabEnt, "CodEnt", "DescrEnt", pag.Ent);
ViewBag.Pos = new SelectList(db.TabPos, "CodPos", "DescrPos", pag.Pos);
ViewBag.Sett = new SelectList(db.TabSet, "CodSet", "DescrSet", pag.Sett);
ViewBag.Sez = new SelectList(db.TabSez, "CodSez", "DescrSez", pag.Sez);
ViewBag.Tiscr = new SelectList(db.TabTIscr, "CodTIscr", "DescrTIscr", pag.Tiscr);
ViewBag.Tpag = new SelectList(db.TabTPag, "CodTPag", "DescrTPag", pag.Tpag);
TempData["msg-ok"] = "Aggiornamento effettuato";
}
else
{
TempData["msg"] = "Aggiornamento non riuscito";
}
return(RedirectToAction("Edit", new { codp = pag.CodP, annop = pag.AnnoP }));
}
