public ActionResult Potwierdzenie_usuniecia_wyscigu(int id) { RACES rACES = db.RACES.Find(id); db.RACES.Remove(rACES); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Szczegoly_wyscigu(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RACES rACES = db.RACES.Find(id); if (rACES == null) { return(HttpNotFound()); } return(View(rACES)); }
public ActionResult Stworz_wyscig([Bind(Include = "Race_ID,Season_ID,Track,Date,Pos_1,Time_1,Pos_2,Pos_3")] RACES rACES) { if (ModelState.IsValid) { db.RACES.Add(rACES); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Season_ID = new SelectList(db.SEASONS, "Season_ID", "Year", rACES.Season_ID); ViewBag.Pos_1 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_1); ViewBag.Pos_2 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_2); ViewBag.Pos_3 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_3); ViewBag.Time_1 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Time_1); return(View(rACES)); }
public ActionResult Edytuj_wyscig(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RACES rACES = db.RACES.Find(id); if (rACES == null) { return(HttpNotFound()); } ViewBag.Season_ID = new SelectList(db.SEASONS, "Season_ID", "Year", rACES.Season_ID); ViewBag.Pos_1 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_1); ViewBag.Pos_2 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_2); ViewBag.Pos_3 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_3); ViewBag.Time_1 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Time_1); return(View(rACES)); }
public ActionResult Edytuj_wyscig([Bind(Include = "Race_ID,Season_ID,Track,Date,Pos_1,Time_1,Pos_2,Pos_3")] RACES rACES) { if (ModelState.IsValid) { if (rACES.Pos_1 != rACES.Pos_2 && rACES.Pos_1 != rACES.Pos_3 && rACES.Pos_2 != rACES.Pos_3) { //////////////////////////////////// zapis danych do tabeli RACES var bet = from b in db.BETS join r in db.RACES on b.Race_ID equals r.Race_ID where r.Race_ID == rACES.Race_ID select new { b.Pos_1, b.Pos_2, b.Pos_3, b.Bet_ID, b.User_ID }; var dri1 = from r in db.RACES from dr in db.DRIVERS where r.Pos_1 == dr.Driver_ID && r.Race_ID == rACES.Race_ID select new { dr.Driver_Name }; string pos1 = ""; foreach (var a in dri1) { pos1 = a.Driver_Name; } var dri2 = from r in db.RACES from dr in db.DRIVERS where r.Pos_2 == dr.Driver_ID && r.Race_ID == rACES.Race_ID select new { dr.Driver_Name }; string pos2 = ""; foreach (var a in dri2) { pos2 = a.Driver_Name; } var dri3 = from r in db.RACES from dr in db.DRIVERS where r.Pos_3 == dr.Driver_ID && r.Race_ID == rACES.Race_ID select new { dr.Driver_Name }; string pos3 = ""; foreach (var a in dri3) { pos3 = a.Driver_Name; } var dri4 = from r in db.RACES from dr in db.DRIVERS where r.Time_1 == dr.Driver_ID && r.Race_ID == rACES.Race_ID select new { dr.Driver_Name }; string time1 = ""; foreach (var a in dri4) { time1 = a.Driver_Name; } foreach (var x in bet) { BETS bets = db.BETS.Find(x.Bet_ID); if (bets.Pos_1 == pos1) { bets.ScorePos1 = 5; } else { bets.ScorePos1 = 0; } if (bets.Pos_2 == pos2) { bets.ScorePos2 = 3; } else { bets.ScorePos2 = 0; } if (bets.Pos_3 == pos3) { bets.ScorePos3 = 1; } else { bets.ScorePos3 = 0; } if (bets.Time_1 == time1) { bets.ScoreTime1 = 5; } else { bets.ScoreTime1 = 0; } /////////////////////////////////////////// zapis punktow do tabeli BETS bets.ScoreSum = bets.ScorePos1 + bets.ScorePos2 + bets.ScorePos3 + bets.ScoreTime1; db.Entry(bets).State = EntityState.Modified; } db.Entry(rACES).State = EntityState.Modified; var us = from u in db.USER select u; foreach (var item in us) { item.Total_score = 0; var bets1 = from be in db.BETS where be.User_ID == item.User_ID select new { be.ScoreSum }; foreach (var points in bets1) { item.Total_score += points.ScoreSum; } db.Entry(item).State = EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Dane się nie zgadzają."); } } ViewBag.Time_1 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Time_1); ViewBag.Season_ID = new SelectList(db.SEASONS, "Season_ID", "Year", rACES.Season_ID); ViewBag.Pos_1 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_1); ViewBag.Pos_2 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_2); ViewBag.Pos_3 = new SelectList(db.DRIVERS, "Driver_ID", "Driver_Name", rACES.Pos_3); return(View(rACES)); }