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 Create([Bind(Include = "CodSex,DescrSex,SelSex")] TabSex tabSex)
{
if (ModelState.IsValid)
{
db.TabSex.Add(tabSex);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabSex));
}
public ActionResult Create([Bind(Include = "CodNaz,DescrNaz,SelNaz")] TabNaz tabNaz)
{
if (ModelState.IsValid)
{
db.TabNaz.Add(tabNaz);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabNaz));
}
public ActionResult Create([Bind(Include = "CodCarica,DescrCarica,SelCarica")] TabCarica tabCarica)
{
if (ModelState.IsValid)
{
db.TabCarica.Add(tabCarica);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabCarica));
}
public ActionResult Create([Bind(Include = "Codice,Descrizione,smtpServer,smtpServerPort,sendUsing,AutenticationType,SendUsername,SendPassword,Sender,NotificationTo,ReceiptTo")] TabPosta tabPosta)
{
if (ModelState.IsValid)
{
db.TabPosta.Add(tabPosta);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabPosta));
}
public ActionResult Create([Bind(Include = "AnnoP,CodP,CodGru")] Gruppi gruppi)
{
if (ModelState.IsValid)
{
db.Gruppi.Add(gruppi);
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 Create([Bind(Include = "ID,Nome,NomeReport,Descrizione,IDFiltro,Filtro,IDOrdinamento,Ordinamento,Filtrabile,Ordinabile,Selezionato,QueryAmmesse")] Stampe stampe)
{
if (ModelState.IsValid)
{
db.Stampe.Add(stampe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDFiltro = new SelectList(db.Filtri, "IDFiltro", "NomeFiltro");
ViewBag.IDOrdinamento = new SelectList(db.Ordinamenti, "IDO", "NomeOrdinamentoO");
return(View(stampe));
}
public ActionResult Create([Bind(Include = "AnnoP,CodP,CodRiv,Ncopie")] Riviste riviste)
{
if (ModelState.IsValid)
{
db.Riviste.Add(riviste);
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 Create([Bind(Include = "AnnoP,CodP,CodDiv,Effettiva")] Divisioni divisioni)
{
if (ModelState.IsValid)
{
db.Divisioni.Add(divisioni);
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 Create([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.Mem.Add(mem);
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 Create([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.Pag.Add(pag);
db.SaveChanges();
UpdateDovuto(pag.AnnoP, pag.CodP);
return(RedirectToAction("Edit", new { codp = pag.CodP, annop = pag.AnnoP }));
}
ViewBag.CodP = new SelectList(db.Mem, "Cod", "Cod", pag.Mem.Cod);
ViewBag.AnnoP = new SelectList(db.TabCat, "AnnoCat", "AnnoCat", pag.AnnoP);
ViewBag.Cat = new SelectList(db.TabCat, "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);
return(View(pag));
}
