public async Task <ActionResult> DeleteConfirmed(int id)
{
tReportCategorieMeseIpase tReportCategorieMeseIpase = await db.tReportCategorieMeseIpase.FindAsync(id);
db.tReportCategorieMeseIpase.Remove(tReportCategorieMeseIpase);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public static void Main(string[] args)
{
MyMoneyManagerEntities context = new MyMoneyManagerEntities();
#region Calcolo report IPASE
//var calcolo = context.Movimenti.Where(q => q.IDCategoriaIphase != null).GroupBy(q => q.IDCategoriaIphase).Sum(q => new { q. }q.Sum(e => e.Importo)).;
//var calcoloipase = context.Movimenti.Where(q => q.IDCategoriaIphase != null).GroupBy(x => new { x.IDCategoriaIphase, DbFunctions.CreateDateTime(x.DataValuta.Value.Year, x.DataValuta.Value.Month, x.DataValuta.Value.Day, 0, 0, 0).Value.Year, DbFunctions.CreateDateTime(x.DataValuta.Value.Year, x.DataValuta.Value.Month, x.DataValuta.Value.Day, 0, 0, 0).Value.Month }).SelectMany(rr => rr.Select(r => new { IDCategoria = rr.Key.IDCategoriaIphase, Anno = rr.Key.Year, Mese = rr.Key.Month, Totale = rr.Sum(t => t.Importo) }));
//foreach (var item in calcoloipase)
//{
// tReportCategorieMeseIpase rep = new tReportCategorieMeseIpase();
// rep.IDCategoria = item.IDCategoria;
// rep.Anno = item.Anno;
// rep.Mese = item.Mese;
// rep.Importo = item.Totale;
// context.tReportCategorieMeseIpase.Add(rep);
//}
var collection = context.vReportCategorieUbi;
foreach (var item in collection)
{
tReportCategorieMeseUbi rep = new tReportCategorieMeseUbi();
rep.IDCategoria = item.IDCategoria;
rep.Anno = item.Anno;
rep.Mese = item.Mese;
rep.Importo = item.Totale;
context.tReportCategorieMeseUbi.Add(rep);
}
context.SaveChanges();
var collection2 = context.v_ReportCategorieIpase;
foreach (var item in collection2)
{
tReportCategorieMeseIpase rep1 = new tReportCategorieMeseIpase();
rep1.IDCategoria = item.IDCategoriaIphase;
rep1.Anno = item.Anno;
rep1.Mese = item.Mese;
rep1.Importo = item.Totale;
context.tReportCategorieMeseIpase.Add(rep1);
}
context.SaveChanges();
#endregion
#region Calcolo report UBI
//var calcolo = context.Movimenti.Where(q => q.IDCategoriaIphase != null).GroupBy(q => q.IDCategoriaIphase).Sum(q => new { q. }q.Sum(e => e.Importo)).;
var calcoloubi = context.Movimenti.Where(q => q.IDCategoria != null).GroupBy(x => new { x.IDCategoria, DbFunctions.CreateDateTime(x.DataContabile.Value.Year, x.DataContabile.Value.Month, x.DataContabile.Value.Day, 0, 0, 0).Value.Year, DbFunctions.CreateDateTime(x.DataContabile.Value.Year, x.DataContabile.Value.Month, x.DataContabile.Value.Day, 0, 0, 0).Value.Month }).SelectMany(rr => rr.Select(r => new { IDCategoria = rr.Key.IDCategoria, Anno = rr.Key.Year, Mese = rr.Key.Month, Totale = rr.Sum(t => t.Importo) }));
foreach (var item in calcoloubi)
{
tReportCategorieMeseUbi rep = new tReportCategorieMeseUbi();
rep.IDCategoria = item.IDCategoria;
rep.Anno = item.Anno;
rep.Mese = item.Mese;
rep.Importo = item.Totale;
context.tReportCategorieMeseUbi.Add(rep);
}
context.SaveChanges();
#endregion
}
public async Task <ActionResult> Edit([Bind(Include = "ID,IDCategoria,Anno,Mese,Importo")] tReportCategorieMeseIpase tReportCategorieMeseIpase)
{
if (ModelState.IsValid)
{
db.Entry(tReportCategorieMeseIpase).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.IDCategoria = new SelectList(db.CategorieIphase, "IDVoce", "Descrizione", tReportCategorieMeseIpase.IDCategoria);
return(View(tReportCategorieMeseIpase));
}
// GET: tReportCategorieMeseIpases/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tReportCategorieMeseIpase tReportCategorieMeseIpase = await db.tReportCategorieMeseIpase.FindAsync(id);
if (tReportCategorieMeseIpase == null)
{
return(HttpNotFound());
}
return(View(tReportCategorieMeseIpase));
}
// GET: tReportCategorieMeseIpases/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tReportCategorieMeseIpase tReportCategorieMeseIpase = await db.tReportCategorieMeseIpase.FindAsync(id);
if (tReportCategorieMeseIpase == null)
{
return(HttpNotFound());
}
ViewBag.IDCategoria = new SelectList(db.CategorieIphase, "IDVoce", "Descrizione", tReportCategorieMeseIpase.IDCategoria);
return(View(tReportCategorieMeseIpase));
}
// GET: tReportCategorieMeseIpases/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tReportCategorieMeseIpase tReportCategorieMeseIpase = await db.tReportCategorieMeseIpase.FindAsync(id);
if (tReportCategorieMeseIpase == null)
{
return(HttpNotFound());
}
int?idcat = tReportCategorieMeseIpase.IDCategoria;
System.DateTime stdate = System.DateTime.Parse("01/" + tReportCategorieMeseIpase.Mese.ToString() + "/" + tReportCategorieMeseIpase.Anno.ToString());
System.DateTime enddate = System.DateTime.Parse(System.DateTime.DaysInMonth(tReportCategorieMeseIpase.Anno.Value, tReportCategorieMeseIpase.Mese.Value) + "/" + tReportCategorieMeseIpase.Mese.ToString() + "/" + tReportCategorieMeseIpase.Anno.ToString());
var mov = db.Movimenti.Where(q => q.IDCategoriaIphase == idcat && q.DataContabile > stdate && q.DataContabile < enddate);
return(View(mov));
}
