public ActionResult Edit(int?id)
{
List <Ent_Roles> listroles = (List <Ent_Roles>)Session[_session_listroles_private];
if (id == null || listroles == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ent_Roles filaroles = listroles.Find(x => x.rol_id == id.ToString());
return(View(filaroles));
}
public ActionResult Nuevo(string nombre)
{
if (nombre == null)
{
return(Json(new { estado = "0" }));
}
Ent_Roles _roles = new Ent_Roles();
_roles.rol_nombre = nombre;
Dat_Roles roles = new Dat_Roles();
roles.rol = _roles;
Boolean _valida_nuevo = roles.InsertarRoles();
return(Json(new { estado = (_valida_nuevo) ? "1" : "-1", desmsg = (_valida_nuevo) ? "Se actualizo satisfactoriamente." : "Hubo un error al actualizar." }));
}
public ActionResult Funcion(Decimal id)
{
List <Ent_Roles> listroles = (List <Ent_Roles>)Session[_session_listroles_private];
if (listroles == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ent_Roles filaroles = listroles.Find(x => x.rol_id == id.ToString());
ViewBag.rolid = id.ToString();
ViewBag.rolnombre = filaroles.rol_nombre.ToString();
Dat_Funcion funciones = new Dat_Funcion();
ViewBag.funciones = funciones.get_lista(true);
return(View(lista_rol_fun(id)));
}
public ActionResult Edit(string id, string nombre)
{
if (id == null)
{
return(Json(new { estado = "0" }));
}
Ent_Roles _roles = new Ent_Roles();
_roles.rol_id = id;
_roles.rol_nombre = nombre;
Dat_Roles roles = new Dat_Roles();
roles.rol = _roles;
Boolean _valida_editar = roles.EditarRoles();
return(Json(new { estado = (_valida_editar) ? "1" : "-1", desmsg = (_valida_editar) ? "Se actualizo satisfactoriamente." : "Hubo un error al actualizar." }));
}
public List <Ent_Roles> get_lista()
{
List <Ent_Roles> list = null;
string sqlquery = "USP_LEER_ROLES_MVC";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Roles>();
while (dr.Read())
{
Ent_Roles rol = new Ent_Roles();
rol.rol_id = dr["rol_id"].ToString();
rol.rol_nombre = dr["rol_nombre"].ToString();
rol.rol_descripcion = dr["rol_Descripcion"].ToString();
list.Add(rol);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
public List <Ent_Roles> get_lista(decimal usu_id)
{
string sqlquery = "USP_Leer_Roles_Usuario";
List <Ent_Roles> list = null;
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@usu_id", usu_id);
SqlDataReader dr = cmd.ExecuteReader();
list = new List <Ent_Roles>();
if (dr.HasRows)
{
while (dr.Read())
{
Ent_Roles fila = new Ent_Roles();
fila.rol_id = dr["rol_id"].ToString();
fila.rol_nombre = dr["rol_nombre"].ToString();
list.Add(fila);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
