public void Delete(DataModelItemDTO dto) { try { _db.Connection.Open(); if (dto.Id != -1) { string sql = "DELETE FROM data_model_item WHERE id = @id"; MySqlCommand comm = _db.Connection.CreateCommand(); comm.CommandText = sql; comm.Parameters.AddWithValue("@id", dto.Id); comm.ExecuteNonQuery(); } } catch (MySqlException ex) { throw new Exception(ex.ToString()); } finally { _db.Close(); } }
public void Insert(DataModelItemDTO dto) { try { _db.Connection.Open(); string sql = "INSERT INTO data_model_item (id, name, id_data_model) VALUES (@id, @name, @id_dm)"; MySqlCommand comm = _db.Connection.CreateCommand(); comm.CommandText = sql; comm.Parameters.AddWithValue("@id", dto.Id); comm.Parameters.AddWithValue("@name", dto.Name); comm.Parameters.AddWithValue("@id_dm", dto.DataModel.Id); comm.ExecuteNonQuery(); } catch (MySqlException ex) { throw new Exception(ex.ToString()); } finally { _db.Close(); } }