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