public JsonResult GetDocsByStation(int idStation) //Obtiene la lista de documentos por estacion para mostrarlos
{
db.Configuration.ProxyCreationEnabled = false;
StationExt result = new StationExt();
result.glacier = new glacier();
result.measurementType = new measurementType();
station aux = db.stations.Include("glacier").Single(x => x.idStation == idStation);
glacier gaxu = db.glaciers.Single(i => i.idGlacier == aux.idGlacier);
measurementType maxu = db.measurementTypes.Single(i => i.idMeasurementType == aux.idMeasurementType);
var docs = db.enteredDatas.Where(x => x.idStation == idStation && x.stateR == true).Select(p => new EnteredDataSimplify
{
idDoc = p.idEnteredData,
idStation = p.idStation,
name = p.nameEnteredData,
startDate = p.startDate.ToString(),
endDate = p.endDate.ToString()
}).ToList();
result.docs = docs;
result.nameStation = aux.nameStation;
result.latitudeStation = aux.latitudeStation;
result.longitudeStation = aux.longitudeStation;
result.altitudeStation = aux.altitudeStation;
result.glacier.nameGlacier = gaxu.nameGlacier;
result.measurementType.nameMT = maxu.nameMT;
result.location = aux.location;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(FormCollection collection, glacier glacier)
{
try
{
var newGlacier = db.glaciers.Where(a => a.nameGlacier.Equals(glacier.nameGlacier)).FirstOrDefault();
if (newGlacier == null)
{
db.glaciers.Add(glacier);
db.SaveChanges();
Session.Add("message", "Glacier added successfully");
Session["error"] = null;
Session["notification"] = null;
return(RedirectToAction("Index"));
}
else
{
Session.Add("error", "This glacier already exists!");
Session["message"] = null;
Session["notification"] = null;
return(RedirectToAction("Create"));
}
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, FormCollection collection, glacier glaciar)
{
try
{
glacier glacier = db.glaciers.Single(i => i.idGlacier == id);
if (db.glaciers.Where(i => i.nameGlacier == glaciar.nameGlacier && i.idGlacier != glaciar.idGlacier &&
i.stateR == true).FirstOrDefault() == null)
{
UpdateModel(glacier);
db.SaveChanges();
Session.Add("message", "Glacier updated successfully");
Session["error"] = null;
Session["notification"] = null;
return(RedirectToAction("Index"));
}
else
{
Session.Add("error", "A glacier with the same name alreaddy exists!");
Session["message"] = null;
Session["notification"] = null;
return(RedirectToAction("Edit", id));
}
}
catch
{
Session.Add("error", "Error!");
Session["message"] = null;
Session["notification"] = null;
return(View());
}
}
// GET: glaciers/Delete/5
public ActionResult Delete(int id)
{
glacier glacier = db.glaciers.Single(i => i.idGlacier == id);
glacier.stateR = false;
db.SaveChanges();
Session.Add("message", "Glacier desactivated successfully");
Session["error"] = null;
Session["notification"] = null;
return(RedirectToAction("Index"));
}
// GET: glaciers/Details/5
public ActionResult Details(int?id)
{
Session["error"] = null;
Session["notification"] = null;
Session["message"] = null;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
glacier glacier = db.glaciers.Find(id);
if (glacier == null)
{
return(HttpNotFound());
}
//Session["error"] = null;
//Session["message"] = null;
return(View(glacier));
}
