public ActionResult deleteSchoolStation(int stationID, string callback)
{
ajaxReturnData data = new ajaxReturnData();
using (ApplicationDbContext DB = new ApplicationDbContext())
{
try
{
SchoolStation doomedStation = new SchoolStation();
doomedStation.id = stationID;
DB.Stations.Attach(doomedStation);
DB.Stations.Remove(doomedStation);
DB.SaveChanges();
if (string.IsNullOrEmpty(callback))
{
data.statusCode = (int)statusCodes.success;
}
else
{
data.statusCode = (int)statusCodes.successRun;
data.callback = callback;
}
data.message = "station removed";
return Json(data);
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "Error: " + ex.Message;
return Json(data);
}
}
}
public ActionResult editSchoolStation(int stationID, int schoolID, SchoolStation station, string callback, HttpPostedFileWrapper image)
{
ajaxReturnData data = new ajaxReturnData();
try
{
using (ApplicationDbContext DB = new ApplicationDbContext())
{
station.id = stationID;
DB.Stations.Attach(station);
DB.Entry(station).State = EntityState.Unchanged;
DB.Entry(station).Property(s => s.line).IsModified = true;
DB.Entry(station).Property(s => s.name).IsModified = true;
DB.Entry(station).Property(s => s.distance).IsModified = true;
if (image != null && image.ContentLength > 0)
{
string path = "/content/images/uploads/schools/" + schoolID;
bool exists = Directory.Exists(Server.MapPath(path));
if (!exists)
{
Directory.CreateDirectory(Server.MapPath(path));
}
path = path + "/station" + station.id + Path.GetExtension(image.FileName);
image.SaveAs(Server.MapPath(path));
station.image = path;
DB.Entry(station).Property(s => s.image).IsModified = true;
}
DB.SaveChanges();
}
if (string.IsNullOrEmpty(callback))
{
data.statusCode = (int)statusCodes.success;
}
else
{
data.statusCode = (int)statusCodes.successRun;
data.callback = callback;
}
data.message = "station updated";
return Json(data);
}
catch (Exception ex)
{
data.statusCode = (int)statusCodes.fail;
data.message = "Failed to update station; " + ex.Message;
return Json(data);
}
}