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