public PartialViewResult PaallaValot() { MVC_Alytalo_dbEntities entities = new MVC_Alytalo_dbEntities(); List <Valot> valot = (from v in entities.Valot where v.ValonTila == "1" select v).ToList(); entities.Dispose(); List <SimpleValoData> valotpaalla = new List <SimpleValoData>(); foreach (Valot valo in valot) { SimpleValoData data = new SimpleValoData(); data.Valo_id = valo.Valo_id; //data.Huone = Int32.Parse(valo.Huone); data.Huone = valo.Huone; data.Valaisin = valo.Valaisin; data.ValonTila = valo.ValonTila; data.ValonMaara = valo.ValonMaara; valotpaalla.Add(data); } return(PartialView("_Valot", valot)); //return Json(valotpaalla, JsonRequestBehavior.AllowGet); }
public ActionResult HaeValot(int id) //public ActionResult HaeValot(string id) { MVC_Alytalo_dbEntities entities = new MVC_Alytalo_dbEntities(); List <Valot> valot = (from v in entities.Valot where v.Huone == id select v).ToList(); entities.Dispose(); List <SimpleValoData> tulos = new List <SimpleValoData>(); foreach (Valot valo in valot) { SimpleValoData data = new SimpleValoData(); data.Valo_id = valo.Valo_id; //data.Huone = Int32.Parse(valo.Huone); data.Huone = valo.Huone; data.Valaisin = valo.Valaisin; data.ValonTila = valo.ValonTila; data.ValonMaara = valo.ValonMaara; tulos.Add(data); } return(Json(tulos, JsonRequestBehavior.AllowGet)); }