public ActionResult DetailsUt(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Schede schede = db.Schedes.Find(id);
if (schede == null)
{
return(HttpNotFound());
}
int ese = Convert.ToInt16(Request.QueryString["ese"]);
var allenamenti = db.Allenamentis.Where(s => s.Scheda_Id == id & s.Numero == ese).Include(s => s.Esercizio);
ViewBag.Allenamenti = allenamenti;
ViewBag.NumeroAllenamento = ese;
var allenamentig = db.Allenamentis.Where(s => s.Scheda_Id == id && s.Numero == ese)
.GroupBy(row => new { row.Numero })
.Select(group => new AllPercViewModel {
Numero = group.Key.Numero, SommaSerieUt = group.Sum(s => s.SerieUt), SommaSerie = group.Sum(s => s.Serie)
}).ToList();
ViewBag.Allenamentig = allenamentig;
return(View(schede));
}
public async static void DeleteSchedaAsync(Schede scheda, GymDataContest context)
{
context.SchedeEsercizi.RemoveRange(context.SchedeEsercizi.Where(x => x.IdScheda == scheda.Id).ToList());
context.SchedePersonali.RemoveRange(context.SchedePersonali.Where(x => x.SchedaId == scheda.Id).ToList());
context.Remove(scheda);
await context.SaveChangesAsync();
}
public ActionResult DeleteConfirmed(int id)
{
Schede schede = db.Schedes.Find(id);
db.Schedes.Remove(schede);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Nome,User_Id,Descrizione")] Schede schede)
{
if (ModelState.IsValid)
{
db.Entry(schede).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = schede.Id }));
}
return(View(schede));
}
public ActionResult Create([Bind(Include = "Id,Nome,User_Id,Descrizione")] Schede schede)
{
if (ModelState.IsValid)
{
schede.User_Id = Request.QueryString["user"];
db.Schedes.Add(schede);
db.SaveChanges();
return(RedirectToAction("Index", new { id = Request.QueryString["user"] }));
}
return(View(schede));
}
public async Task <IActionResult> Create(Schede scheda)
{
if (ModelState.IsValid)
{
_context.Add(scheda);
await _context.SaveChangesAsync();
var idScheda = _context.Schede.ToList().Last();
var id = SchedeViewModel.CreationSchedeViewModel(idScheda.Id, _context);
return(RedirectToAction("Edit", new { id = idScheda.Id }));
}
return(RedirectToAction("Create"));
}
// GET: Schedes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Schede schede = db.Schedes.Find(id);
if (schede == null)
{
return(HttpNotFound());
}
return(View(schede));
}
public ActionResult ListUt(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Schede schede = db.Schedes.Find(id);
if (schede == null)
{
return(HttpNotFound());
}
var allenamenti = db.Allenamentis.Include(e => e.Esercizio).Where(s => s.Scheda_Id == id)
.GroupBy(row => new { row.Numero })
.Select(group => new AllPercViewModel {
Numero = group.Key.Numero, SommaSerieUt = group.Sum(s => s.SerieUt), SommaSerie = group.Sum(s => s.Serie), DataInizio = group.Min(d => d.Data), DataFine = group.Max(d => d.Data)
}).ToList();
ViewBag.Allenamenti = allenamenti;
return(View(schede));
}
public static int CreationSchedeViewModel(int id, GymDataContest context)
{
Schede scheda = context.Schede.Where(x => x.Id == id).FirstOrDefault();
var schedaEs = context.SchedeEsercizi.Where(x => x.IdScheda == scheda.Id);
if (schedaEs.Count() > 0)
{
context.SchedeEsercizi.RemoveRange(schedaEs);
}
SchedeEsercizi newScheda = new SchedeEsercizi()
{
IdEsercizio = 0,
IdScheda = scheda.Id
};
context.SchedeEsercizi.Add(newScheda);
context.SaveChanges();
var result = context.SchedeEsercizi.ToList().Last().Id;
return(result);
}
// GET: Schedes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Schede schede = db.Schedes.Find(id);
if (schede == null)
{
return(HttpNotFound());
}
var allenamenti = db.Allenamentis.Include(e => e.Esercizio_Id).Where(s => s.Scheda_Id == id)
.GroupBy(row => new { row.Esercizio })
.Select(group => new AllList1ViewModel {
Esercizio_Id = group.Key.Esercizio.Esercizio_Id, MaxNumero = group.Max(s => s.Numero), TotMovimenti = (group.Sum(s => s.Serie) + group.Sum(s => s.Ripetizioni))
}).ToList();
var allenamentiC = db.Allenamentis.Where(s => s.Scheda_Id == id).OrderBy(n => n.Numero);
ViewBag.AllenamentiCount = allenamentiC.Count();
ViewBag.Allenamenti = allenamenti;
return(View(schede));
}
