public ActionResult Create()
{
PermisoModelo Permiso = new PermisoModelo();
ViewBag.Permiso = Permiso.findAll().OrderBy(pm => pm.Id).ToList();
return(View());
}
public ActionResult Edit(int id)
{
RolModelo Rol = new RolModelo();
ViewBag.Rol = Rol.find(id);
PermisosRolModelo PermisosRol = new PermisosRolModelo();
ViewBag.PermisosRol = PermisosRol.findRol(id).OrderBy(pr => pr.Permiso.Id).ToList();
PermisoModelo Permiso = new PermisoModelo();
ViewBag.Permiso = Permiso.findAll().OrderBy(pm => pm.Id).ToList();
return(View());
}
public async Task Insert(PermisoModelo permisoModelo)
{
using (SqlConnection sql = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("PA_Insertar_permiso", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@S_Nombre_permiso", permisoModelo.S_Nombre_permiso));
cmd.Parameters.Add(new SqlParameter("@S_descripcion_permiso", permisoModelo.S_descripcion_permiso));
await sql.OpenAsync();
await cmd.ExecuteNonQueryAsync();
return;
}
}
}
public async Task <PermisoModelo> GetById(int Id)
{
using (SqlConnection sql = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("PA_obtener_permiso_id", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Id", Id));
PermisoModelo response = null;
await sql.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
response = MapToPermiso(reader);
}
}
return(response);
}
}
}
public async Task Post([FromBody] PermisoModelo rolModelo)
{
await _permisodata.Insert(rolModelo);
}
