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