public ActionResult Create(tbl_Salones tbl_Salones) { if (Request.Cookies["RolCookie"] == null) { return(RedirectToAction("Login", "Registro")); } else { var idC = Request.Cookies["RolCookie"].Value; var c = new HttpCookie("RolCookie"); c.Value = idC; c.Expires = DateTime.Now.AddMinutes(15); Response.Cookies.Add(c); } var IdAcceso = Aletario(); tbl_Salones.IdAdministrador = Convert.ToInt32(Request.Cookies["RolCookie"].Value); var ResultadoExist = db.tbl_Salones.SqlQuery("sp_ExistIDAccesoSalon @IdAcceso", new SqlParameter("@IdAcceso", IdAcceso)).ToList(); while (ResultadoExist.Count > 0) { IdAcceso = Aletario(); ResultadoExist = db.tbl_Salones.SqlQuery("sp_ExistIDAccesoSalon @IdAcceso", new SqlParameter("@IdAcceso", IdAcceso)).ToList(); } var Reultado = db.tbl_Salones.SqlQuery("sp_CrearSalon @IdAdmin,@idAcceso", new SqlParameter("@IdAdmin", tbl_Salones.IdAdministrador), new SqlParameter("@idAcceso", IdAcceso)).ToList(); ViewBag.Error = "Salón creado con éxito, el Id de acceso es el: " + IdAcceso; return(View()); }
// GET: Salones/Delete/5 public ActionResult Delete(int?id) { if (Request.Cookies["RolCookie"] == null) { return(RedirectToAction("Login", "Registro")); } else { var idC = Request.Cookies["RolCookie"].Value; var c = new HttpCookie("RolCookie"); c.Value = idC; c.Expires = DateTime.Now.AddMinutes(15); Response.Cookies.Add(c); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Salones tbl_Salones = db.tbl_Salones.Find(id); if (tbl_Salones == null) { return(HttpNotFound()); } return(View(tbl_Salones)); }
public ActionResult Edit(tbl_Salones tbl_Salones) { if (Request.Cookies["RolCookie"] == null) { return(RedirectToAction("Login", "Registro")); } else { var idC = Request.Cookies["RolCookie"].Value; var c = new HttpCookie("RolCookie"); c.Value = idC; c.Expires = DateTime.Now.AddMinutes(15); Response.Cookies.Add(c); } var IDAc = Request["IdAcceso"]; if (IDAc == "") { return(View(tbl_Salones)); } tbl_Salones.IdAdministrador = Convert.ToInt32(Request.Cookies["RolCookie"].Value); var Reultado = db.tbl_Salones.SqlQuery("sp_ModificarSalon @idAcceso,@id", new SqlParameter("@idAcceso", tbl_Salones.IdAcceso), new SqlParameter("@id", tbl_Salones.Id)).ToList(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { if (Request.Cookies["RolCookie"] == null) { return(RedirectToAction("Login", "Registro")); } else { var idC = Request.Cookies["RolCookie"].Value; var c = new HttpCookie("RolCookie"); c.Value = idC; c.Expires = DateTime.Now.AddMinutes(15); Response.Cookies.Add(c); } tbl_Salones tbl_Salones = db.tbl_Salones.Find(id); db.tbl_Salones.Remove(tbl_Salones); db.SaveChanges(); return(RedirectToAction("Index")); }