public JsonResult GetTapahtuma(int id) { using (PuistoonContext db = new PuistoonContext()) { var tapahtumadata = db.Tapahtumat.Where(x => x.PuistonId == id).ToList(); return(Json(tapahtumadata)); } }
// GET: Tapahtumat public ActionResult Index() { using (PuistoonContext db = new PuistoonContext()) { var tapahtuma = db.Tapahtumat.ToList(); return(View(tapahtuma)); } }
public ActionResult Create(Tapahtumat tapahtuma) { using (PuistoonContext db = new PuistoonContext()) if (ModelState.IsValid) { db.Tapahtumat.Add(tapahtuma); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tapahtuma)); }
public ActionResult Edit(Tapahtumat tapahtuma) { using (PuistoonContext db = new PuistoonContext()) { if (ModelState.IsValid) { db.Entry(tapahtuma).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tapahtuma)); } }
// GET: Tapahtumat/Details/5 public ActionResult Details(int?id) { using (PuistoonContext db = new PuistoonContext()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var tapahtuma = db.Tapahtumat.SingleOrDefault(e => e.TapahtumanId == id); if (tapahtuma == null) { return(HttpNotFound()); } return(View(tapahtuma)); } }
public ActionResult Delete(int id) { using (PuistoonContext db = new PuistoonContext()) { try { Tapahtumat tapahtumat = db.Tapahtumat.Find(id); db.Tapahtumat.Remove(tapahtumat); db.SaveChanges(); } catch (DataException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log. return(RedirectToAction("Delete", new { id = id, saveChangesError = true })); } return(RedirectToAction("Index")); } }
public ActionResult Delete(int?id, bool?saveChangesError = false) { using (PuistoonContext db = new PuistoonContext()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (saveChangesError.GetValueOrDefault()) { ViewBag.ErrorMessage = "Delete failed. Try again, and if the problem persists see your system administrator."; } Tapahtumat tapahtumat = db.Tapahtumat.Find(id); if (tapahtumat == null) { return(HttpNotFound()); } return(View(tapahtumat)); } }
// GET: Tapahtumat/Edit/5 public ActionResult Edit(int?id) { using (PuistoonContext db = new PuistoonContext()) { if (id == null) { //return HttpNotFoundResult("Not Found"); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var tapahtuma = db.Tapahtumat.SingleOrDefault(e => e.TapahtumanId == id); if (tapahtuma == null) { return(HttpNotFound()); } ViewBag.PuistonId = tapahtuma.PuistonId; ViewBag.KategorianId = tapahtuma.KategorianId; ViewBag.KäyttäjänId = tapahtuma.KäyttäjänId; return(View(tapahtuma)); } }
// GET: Home public IActionResult PuistonTapahtumat() { CultureInfo ci = new CultureInfo("en-US"); string Markers = "["; string conString = ""; SqlCommand cmd = new SqlCommand("SELECT * FROM Puistot"); using (SqlConnection con = new SqlConnection(conString)) { cmd.Connection = con; con.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { Markers += "{"; Markers += string.Format("'id': '{0}',", sdr["PuistonID"]); Markers += string.Format("'nimi': '{0}',", sdr["PuistonNimi"]); Markers += string.Format(ci, "'lat': '{0}',", sdr["Lat"]); Markers += string.Format(ci, "'lng': '{0}',", sdr["Long"]); Markers += string.Format("'kuvaus': '{0}',", sdr["PuistonKuvaus"]); Markers += string.Format("'url': '{0}',", sdr["PuistonURL"]); Markers += string.Format("'zoom': '{0}'", sdr["ZoomLevel"]); Markers += "},"; } } con.Close(); } Markers += "];"; ViewBag.Markers = Markers; string merkit = "["; string conString2 = ""; SqlCommand cmd2 = new SqlCommand("SELECT * FROM Palvelut WHERE TyyppiID = 1"); // hakee alepat using (SqlConnection con = new SqlConnection(conString2)) { cmd2.Connection = con; con.Open(); using (SqlDataReader sdr = cmd2.ExecuteReader()) { while (sdr.Read()) { merkit += "{"; merkit += string.Format("'id': '{0}',", sdr["PalvelutID"]); merkit += string.Format("'tyyppi': '{0}',", sdr["TyyppiID"]); merkit += string.Format(ci, "'lat': '{0}',", sdr["Lat"]); merkit += string.Format(ci, "'lng': '{0}',", sdr["Long"]); merkit += string.Format("'nimi': '{0}',", sdr["Kuvaus"]); merkit += string.Format("'url': '{0}',", sdr["Lisätietoja"]); merkit += "},"; } } con.Close(); } merkit += "];"; ViewBag.Merkit = merkit; string vessat = "["; string conString3 = ""; SqlCommand cmd3 = new SqlCommand("SELECT * FROM Palvelut WHERE TyyppiID = 2"); // hakee vessat using (SqlConnection con = new SqlConnection(conString3)) { cmd3.Connection = con; con.Open(); using (SqlDataReader sdr = cmd3.ExecuteReader()) { while (sdr.Read()) { vessat += "{"; vessat += string.Format("'id': '{0}',", sdr["PalvelutID"]); vessat += string.Format("'tyyppi': '{0}',", sdr["TyyppiID"]); vessat += string.Format(ci, "'lat': '{0}',", sdr["Lat"]); vessat += string.Format(ci, "'lng': '{0}',", sdr["Long"]); vessat += string.Format("'nimi': '{0}',", sdr["Kuvaus"]); vessat += string.Format("'url': '{0}',", sdr["Lisätietoja"]); vessat += "},"; } } con.Close(); } vessat += "];"; ViewBag.Vessat = vessat; string pyorat = "["; string conString4 = ""; SqlCommand cmd4 = new SqlCommand("SELECT * FROM Palvelut WHERE TyyppiID = 3"); // hakee pyörät using (SqlConnection con = new SqlConnection(conString4)) { cmd4.Connection = con; con.Open(); using (SqlDataReader sdr = cmd4.ExecuteReader()) { while (sdr.Read()) { pyorat += "{"; pyorat += string.Format("'id': '{0}',", sdr["PalvelutID"]); pyorat += string.Format("'tyyppi': '{0}',", sdr["TyyppiID"]); pyorat += string.Format(ci, "'lat': '{0}',", sdr["Lat"]); pyorat += string.Format(ci, "'lng': '{0}',", sdr["Long"]); pyorat += string.Format("'nimi': '{0}',", sdr["Kuvaus"]); pyorat += string.Format("'url': '{0}',", sdr["Lisätietoja"]); pyorat += "},"; } } con.Close(); } pyorat += "];"; ViewBag.Pyorat = pyorat; PuistoonContext db = new PuistoonContext(); return(View(db.Tapahtumat.ToList())); }