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); }