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