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