public void UpdateIndicator(E_Indicador e_Indicador)
{
connectionBD = new D_ConnectionBD();
cmd = new SqlCommand("UpdateIndicator", connectionBD.OpenConnection());
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IdIndicador", e_Indicador.IdIndicador));
cmd.Parameters.Add(new SqlParameter("@Indicador", e_Indicador.Indicador));
cmd.Parameters.Add(new SqlParameter("@IdTipoValor", e_Indicador.IdTipoValor));
cmd.Parameters.Add(new SqlParameter("@IdMaxMin", e_Indicador.IdMaxMin));
cmd.Parameters.Add(new SqlParameter("@IdPerspectiva", e_Indicador.IdPerspectiva));
cmd.Parameters.Add(new SqlParameter("@Activo", e_Indicador.Activo));
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection = connectionBD.CloseConnection();
cmd.Dispose();
}
}
public void DeleteIndicator(E_Indicador e_Indicador)
{
string command = "delete from Indicador where IdIndicador = @IdIndicador";
try
{
connectionBD = new D_ConnectionBD();
cmd = new SqlCommand(command, connectionBD.OpenConnection());
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@IdIndicador", e_Indicador.IdIndicador));
cmd.CommandTimeout = 0;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection = connectionBD.CloseConnection();
cmd.Dispose();
}
}
