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