public ActionResult Editsens(tbl_sensors t) { if (Session["UserName"] != null) { var q = (from a in db.tbl_sensors where a.ID.Equals(t.ID) select a).SingleOrDefault(); tbl_sensorinformation info = new tbl_sensorinformation(); string username = Session["username"].ToString(); var quser = (from a in db.tbl_users where a.Username.Equals(username) select a).SingleOrDefault(); info.BaseID_ago = q.BaseID; info.BaseID_new = t.BaseID; info.Date = DateTime.Now; info.SensorID = t.ID; info.State_ago = q.State; info.State_new = t.State; info.TypeID_ago = q.TypeID; info.TypeID_new = t.TypeID; info.UserID = quser.ID; info.x_ago = q.x; info.x_new = t.x; info.y_ago = q.y; info.y_new = t.y; db.tbl_sensorinformation.Add(info); q.State = t.State; q.BaseID = t.BaseID; q.TypeID = t.TypeID; q.x = t.x; q.y = t.y; db.tbl_sensors.Attach(q); db.Entry(q).State = System.Data.Entity.EntityState.Modified; if (Convert.ToBoolean(db.SaveChanges())) { ViewBag.Message = "Seccessfully saved."; ViewBag.style = "color:green;"; return(View(q)); } else { ViewBag.Message = "Unfortunately not saved."; ViewBag.style = "color:red;"; return(View(q)); } } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult CreateSensor(tbl_sensors t) { if (Session["UserName"] == null) { return(RedirectToAction("Index", "Home")); } if (Session["Access"].ToString() != "admin") { return(RedirectToAction("Index", "Home")); } string username = Session["username"].ToString(); var q = (from a in db.tbl_users where a.Username.Equals(username) select a).SingleOrDefault(); t.UserID = q.ID; db.tbl_sensors.Add(t); if (Convert.ToBoolean(db.SaveChanges())) { ViewBag.Message = "Seccessfully saved."; ViewBag.style = "color:green;"; return(View(t)); } else { ViewBag.Message = "Unfortunately not saved."; ViewBag.style = "color:red;"; return(View(t)); } }