public bool updateTipoIncidencia(string codigo, TipoIncidencia tipoIncidencia) { string sql = "UPDATE TIPO_INCIDENCIA SET codigo=@codigo, descripcion=@descripcion WHERE codigo=@codigo"; try { IDbCommand command = this.connection.CreateCommand(); command.CommandText = sql; command.Parameters.Add(new SqlParameter("@codigo", tipoIncidencia.Codigo)); command.Parameters.Add(new SqlParameter("@descripcion", tipoIncidencia.Descripcion)); this.connection.Open(); int i = command.ExecuteNonQuery(); this.connection.Close(); if (i == 1) { return(true); } } catch (Exception ex) { if (!this.connection.State.Equals(ConnectionState.Closed)) { this.connection.Close(); } } return(false); }
public bool setTipoIncidencia(TipoIncidencia tipoIncidencia) { string sql = "INSERT INTO TIPO_INCIDENCIA VALUES(@codigo,@descripcion)"; try { IDbCommand command = this.connection.CreateCommand(); command.CommandText = sql; command.Parameters.Add(new SqlParameter("@codigo", tipoIncidencia.Codigo)); command.Parameters.Add(new SqlParameter("@descripcion", tipoIncidencia.Descripcion)); this.connection.Open(); int i = command.ExecuteNonQuery(); this.connection.Close(); if (i == 1) { return(true); } } catch (Exception ex) { if (!this.connection.State.Equals(ConnectionState.Closed)) { this.connection.Close(); } } return(false); }
public TipoIncidencia getTipoIncidencia(string codigo) { TipoIncidencia t = new TipoIncidencia(); string sql = "SELECT * FROM TIPO_INCIDENCIA WHERE codigo = @codigo"; try { IDbCommand command = this.connection.CreateCommand(); command.CommandText = sql; command.Parameters.Add(new SqlParameter("@codigo", codigo)); this.connection.Open(); IDataReader reader = command.ExecuteReader(); if (reader.Read()) { t.Codigo = reader.GetString(0); t.Descripcion = reader.GetString(1); } this.connection.Close(); } catch (Exception ex) { if (!this.connection.State.Equals(ConnectionState.Closed)) { this.connection.Close(); } } return(t); }
public List <TipoIncidencia> ListarTipoIncidente() { SqlConnection cn = null; SqlDataReader dr = null; SqlCommand cmd = null; List <TipoIncidencia> lista = new List <TipoIncidencia>(); try { cn = Conexion.GetInstance().ConexionDB(); cmd = new SqlCommand("SP_LISTATIPOINCIDENTE", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { TipoIncidencia ObjTipoIncidencia = new TipoIncidencia() { Descripcion = Convert.ToString(dr[0]) }; lista.Add(ObjTipoIncidencia); } } catch (Exception ex) { throw ex; } finally { cn.Close(); } return(lista); }
public async Task <IActionResult> Edit(int id, [Bind("TipoIncidenciaId,Descripccion")] TipoIncidencia tipoIncidencia) { if (id != tipoIncidencia.TipoIncidenciaId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tipoIncidencia); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TipoIncidenciaExists(tipoIncidencia.TipoIncidenciaId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(tipoIncidencia)); }
public async Task <IActionResult> Create([Bind("TipoIncidenciaId,Descripccion")] TipoIncidencia tipoIncidencia) { if (ModelState.IsValid) { _context.Add(tipoIncidencia); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tipoIncidencia)); }