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