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