public static ObservableListSource <ConfigValCue> FetchList(int n_idconfigval) { ObservableListSource <ConfigValCue> m_listentidad = new ObservableListSource <ConfigValCue>(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "con_configvalcue_listar"; command.Parameters.Add(new MySqlParameter("@n_idconfigval", n_idconfigval)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ConfigValCue m_entidad = SetObject(reader); m_entidad.IsNew = false; m_listentidad.Add(m_entidad); } } } } return(m_listentidad); }
public static ConfigValCue Fetch(int id) { ConfigValCue m_entidad = new ConfigValCue(); using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "con_configvalcue_traerregistro"; command.Parameters.Add(new MySqlParameter("@n_id", id)); connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { m_entidad = SetObject(reader); m_entidad.IsNew = false; } } } } return(m_entidad); }
public override void Delete() { using (MySqlConnection connection = new MySqlConnection( ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { connection.Open(); using (MySqlTransaction transaction = connection.BeginTransaction()) { using (MySqlCommand command = connection.CreateCommand()) { try { ConfigValCue.DeleteAll(n_id, connection, transaction); command.Transaction = transaction; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "con_configval_eliminar"; command.Parameters.Add(new MySqlParameter("@n_id", n_id)); int rows = command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } } }