public ActionResult Create(SaunaViewModel model)
{
AlytaloEntities db = new AlytaloEntities();
Saunat sauna = new Saunat();
sauna.SaunaNimi = model.SaunaNimi;
sauna.SaunaTavoiteLampotila = model.SaunaTavoiteLampotila;
sauna.SaunaNykyLampotila = model.SaunaNykyLampotila;
sauna.SaunanTila = model.SaunanTila;
db.Saunat.Add(sauna);
//ViewBag.SaunanNimi = new SelectList((from ts in db.Saunat select new { SaunaId = ts.SaunaId, SaunaNimi = ts.SaunaNimi }), "SaunaId", "SaunaNimi", null);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create*/;
}//create*/;
// GET: Sauna/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Saunat taloSauna = db.Saunat.Find(id);
if (taloSauna == null)
{
return(HttpNotFound());
}
SaunaViewModel sauna = new SaunaViewModel();
sauna.SaunaId = taloSauna.SaunaId;
sauna.SaunaNimi = taloSauna.SaunaNimi;
sauna.SaunaTavoiteLampotila = taloSauna.SaunaTavoiteLampotila;
sauna.SaunaNykyLampotila = taloSauna.SaunaNykyLampotila;
ViewBag.SaunanNimi = new SelectList((from ts in db.Saunat select new { SaunaId = ts.SaunaId, SaunaNimi = ts.SaunaNimi }), "SaunaId", "SaunaNimi", sauna.SaunaId);
return(View(sauna));
}
// GET: Sauna/Details/5
public ActionResult Details(int?id)
{
SaunaViewModel model = new SaunaViewModel();
AlytaloEntities entities = new AlytaloEntities();
try
{
Saunat taloSauna = db.Saunat.Find(id);
if (taloSauna == null)
{
return(HttpNotFound());
}
Saunat saunadetail = entities.Saunat.Find(taloSauna.SaunaId);
SaunaViewModel sauna = new SaunaViewModel();
sauna.SaunaId = saunadetail.SaunaId;
sauna.SaunaNimi = saunadetail.SaunaNimi;
sauna.SaunaTavoiteLampotila = saunadetail.SaunaTavoiteLampotila;
sauna.SaunaNykyLampotila = saunadetail.SaunaNykyLampotila;
sauna.SaunanTila = saunadetail.SaunanTila;
model = sauna;
}
finally
{
entities.Dispose();
}
return(View(model));
}
public int?MittaaSauna(int id)
{
MobiilikantaContext db = new MobiilikantaContext();
Saunat sauna = db.Saunat.FirstOrDefault((s) => s.SaunaId == id);
Random rand = new Random();
try
{
if (sauna.SaunanTila)
{
sauna.SaunanNykylampotila = rand.Next(80, 91);
}
else
{
sauna.SaunanNykylampotila = rand.Next(18, 25);
}
sauna.Mittaushetki = DateTime.Now;
db.Entry(sauna).State = EntityState.Modified;
db.SaveChanges();
}
finally
{
db.Dispose();
}
return(sauna.SaunanNykylampotila);
}
public ActionResult DeleteConfirmed(int id)
{
Saunat saunat = db.Saunat.Find(id);
db.Saunat.Remove(saunat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SaunaID,SaunaNimi,SaunanTila,SaunanNykyLampotila")] Saunat saunat)
{
if (ModelState.IsValid)
{
db.Entry(saunat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(saunat));
}
public ActionResult Create([Bind(Include = "SaunaID,SaunaNimi,SaunanTila,SaunanNykyLampotila")] Saunat saunat)
{
if (ModelState.IsValid)
{
db.Saunat.Add(saunat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(saunat));
}
public ActionResult SaunaOff(SaunaViewModel model)
{
Saunat sauna = db.Saunat.Find(model.SaunaId);
sauna.SaunaId = model.SaunaId;
sauna.SaunanTila = false;
ViewBag.SaunanNimi = new SelectList((from ts in db.Saunat select new { SaunaId = ts.SaunaId, SaunaNimi = ts.SaunaNimi }), "SaunaId", "SaunaNimi", sauna.SaunaId);
db.SaveChanges();
return(RedirectToAction("Index"));
}//
public ActionResult Create([Bind(Include = "SaunaID,SaunanSijainti,SaunaPaalla,SaunanLampotila,PVM")] Saunat saunat)
{
if (ModelState.IsValid)
{
db.Saunat.Add(saunat);
saunat.PVM = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(saunat));
}
// GET: Sauna/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Saunat saunat = db.Saunat.Find(id);
if (saunat == null)
{
return(HttpNotFound());
}
return(View(saunat));
}
public ActionResult Edit(SaunaViewModel model)
{
Saunat sauna = db.Saunat.Find(model.SaunaId);
sauna.SaunaNimi = model.SaunaNimi;
sauna.SaunaTavoiteLampotila = model.SaunaTavoiteLampotila;
sauna.SaunaNykyLampotila = model.SaunaNykyLampotila;
ViewBag.SaunanNimi = new SelectList((from ts in db.Saunat select new { SaunaId = ts.SaunaId, SaunaNimi = ts.SaunaNimi }), "SaunaId", "SaunaNimi", sauna.SaunaId);
db.SaveChanges();
return(RedirectToAction("Index"));
}//edit
// GET: Sauna/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Saunat saunat = db.Saunat.Find(id);
saunat.PVM = DateTime.Now;
if (saunat == null)
{
return(HttpNotFound());
}
return(View(saunat));
}
public bool MuutaSaunanTilaa(Saunat uusi)
{
bool OK = false;
MobiilikantaContext db = new MobiilikantaContext();
Saunat sauna = db.Saunat.FirstOrDefault((s) => s.SaunaId == uusi.SaunaId);
sauna.SaunanTila = uusi.SaunanTila;
try
{
db.Entry(sauna).State = EntityState.Modified;
db.SaveChanges();
OK = true;
}
finally
{
db.Dispose();
}
return(OK);
}
}//
// GET: TaloSauna/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Saunat taloSauna = db.Saunat.Find(id);
if (taloSauna == null)
{
return(HttpNotFound());
}
SaunaViewModel sauna = new SaunaViewModel();
sauna.SaunaId = taloSauna.SaunaId;
sauna.SaunaNimi = taloSauna.SaunaNimi;
sauna.SaunaTavoiteLampotila = taloSauna.SaunaTavoiteLampotila;
sauna.SaunaNykyLampotila = taloSauna.SaunaNykyLampotila;
sauna.SaunanTila = taloSauna.SaunanTila;
return(View(sauna));
}
