public ActionResult Create(Station station)
{
if (ModelState.IsValid)
{
db.Stations.Add(station);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(station);
}
private Station GetClosestStation(string lat, string lng)
{
string queryString =
String.Format(@"SELECT TOP(1) Location.ToString(), Id, StationName, latitude, longitude FROM DivvyStations
WHERE Location.STDistance(geography::Point(@lat, @lng, 4326)) IS NOT NULL
ORDER BY Location.STDistance(geography::Point(@lat, @lng, 4326))");
var station = new Station();
using (SqlConnection connection =
new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("@lat", lat);
command.Parameters.AddWithValue("@lng", lng);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//Console.WriteLine("\t{0}\t{1}\t{2}",
//reader[0], reader[1], reader[2]);
station = new Station
{
id = (int)reader["Id"],
stationName = reader["StationName"].ToString(),
latitude = (double)reader["latitude"],
longitude = (double)reader["longitude"]
};
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
return station;
}
public ActionResult Edit(Station station)
{
if (ModelState.IsValid)
{
db.Entry(station).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(station);
}