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 Index()
{
MVC_Alytalo_dbEntities db = new MVC_Alytalo_dbEntities();
return(View(db.Valot));
//return View();
}
public ActionResult HaeLammot(int?id)
//public ActionResult HaeValot(string id)
{
MVC_Alytalo_dbEntities entities = new MVC_Alytalo_dbEntities();
List <Lampotilat> lampotilat = (from l in entities.Lampotilat
where l.Huone == id
select l).ToList();
entities.Dispose();
List <SimpleLampotilaData> lammot = new List <SimpleLampotilaData>();
foreach (Lampotilat lampotila in lampotilat)
{
SimpleLampotilaData data = new SimpleLampotilaData();
data.Lampotila_id = lampotila.Lampotila_id;
//data.Huone = Int32.Parse(valo.Huone);
data.Huone = lampotila.Huone;
data.NykyLampotila = lampotila.NykyLampotila;
data.TavoiteLampotila = lampotila.TavoiteLampotila;
lammot.Add(data);
}
return(Json(lammot, 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));
}
//[HttpPost]
//public PartialViewResult All(string etsiTermi)
//{
// //List<Valot> model = db.Valot.ToList();
// MVC_Alytalo_dbEntities db = new MVC_Alytalo_dbEntities();
// List<Valot> model;
// if (string.IsNullOrEmpty(etsiTermi))
// {
// model = db.Valot.ToList();
// }
// else
// {
// model = db.Valot.Where(x => x.Valaisin.StartsWith(etsiTermi)).ToList();
// }
// return PartialView("_Valot", model);
//}
public JsonResult HaeppaValot(string term)
{
MVC_Alytalo_dbEntities db = new MVC_Alytalo_dbEntities();
List <string> malli;
malli = db.Valot.Where(x => x.Valaisin.StartsWith(term)).Select(y => y.Valaisin).ToList();
return(Json(malli, JsonRequestBehavior.AllowGet));
}
public ActionResult Tallenna(int?Valo_id, string ValonTila)
{
using (var db = new MVC_Alytalo_dbEntities())
{
var valaisin = db.Valot.First(c => c.Valo_id == Valo_id);
valaisin.ValonTila = ValonTila;
db.SaveChanges();
}
return(new EmptyResult());
//return View(ValonTila);
}
public PartialViewResult HaePaallaValot()
{
using (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();
return(PartialView("_Valot", valot));
//return Json(valotpaalla, JsonRequestBehavior.AllowGet);
}
}
public ActionResult Index(string etsiTermi)
{
//List<Valot> model = db.Valot.ToList();
MVC_Alytalo_dbEntities db = new MVC_Alytalo_dbEntities();
List <Valot> malli;
if (string.IsNullOrEmpty(etsiTermi))
{
malli = db.Valot.ToList();
}
else
{
malli = db.Valot.Where(x => x.Valaisin.StartsWith(etsiTermi)).ToList();
}
return(View(malli));
}
