public void StoreFullObject(FullDataObject b, ISource source)
{
db_conn = source.db_conn;
ObjectCopyHelpers och = new ObjectCopyHelpers();
DataObject d = new DataObject(b);
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Insert <DataObject>(d);
}
if (b.object_instances.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_instances_helper.SaveAll(conn, b.object_instances);
}
}
if (b.object_titles.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_titles_helper.SaveAll(conn, b.object_titles);
}
}
// these are database dependent
if (source.has_object_dates && b.object_dates.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_dates_helper.SaveAll(conn, b.object_dates);
}
}
if (source.has_object_relationships && b.object_relationships.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_relationships_helper.SaveAll(conn, b.object_relationships);
}
}
if (source.has_object_rights && b.object_rights?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_rights_helper.SaveAll(conn, b.object_rights);
}
}
if (source.has_object_pubmed_set)
{
if (b.object_contributors?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_contributors_helper.SaveAll(conn, b.object_contributors);
}
}
if (b.object_topics?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_topics_helper.SaveAll(conn, b.object_topics);
}
}
if (b.object_comments?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_comments_helper.SaveAll(conn, b.object_comments);
}
}
if (b.object_descriptions?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_descriptions_helper.SaveAll(conn, b.object_descriptions);
}
}
if (b.object_identifiers?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_identifiers_helper.SaveAll(conn, b.object_identifiers);
}
}
if (b.object_db_ids?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_db_links_helper.SaveAll(conn, b.object_db_ids);
}
}
if (b.object_pubtypes?.Any() == true)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.publication_types_helper.SaveAll(conn, b.object_pubtypes);
}
}
if (b.journal_details != null)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Insert <JournalDetails>(b.journal_details);
}
}
}
}
public void StoreFullStudy(Study s, ISource source)
{
db_conn = source.db_conn;
StudyCopyHelpers sch = new StudyCopyHelpers();
ObjectCopyHelpers och = new ObjectCopyHelpers();
// store study
StudyInDB st_db = new StudyInDB(s);
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Insert <StudyInDB>(st_db);
}
// store study attributes
// these common to all databases
if (s.identifiers.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_ids_helper.SaveAll(conn, s.identifiers);
}
}
if (s.titles.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_titles_helper.SaveAll(conn, s.titles);
}
}
// these are database dependent
if (source.has_study_topics && s.topics.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_topics_helper.SaveAll(conn, s.topics);
}
}
if (source.has_study_features && s.features.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_features_helper.SaveAll(conn, s.features);
}
}
if (source.has_study_contributors && s.contributors.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_contributors_helper.SaveAll(conn, s.contributors);
}
}
if (source.has_study_references && s.references.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_references_helper.SaveAll(conn, s.references);
}
}
if (source.has_study_relationships && s.relationships.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_relationships_helper.SaveAll(conn, s.relationships);
}
}
if (source.has_study_links && s.studylinks.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_links_helper.SaveAll(conn, s.studylinks);
}
}
if (source.has_study_ipd_available && s.ipd_info.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
sch.study_avail_ipd_helper.SaveAll(conn, s.ipd_info);
}
}
// store linked data objects
if (s.data_objects.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.data_objects_helper.SaveAll(conn, s.data_objects);
}
}
// store data object attributes
// these common to all databases
if (s.object_instances.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_instances_helper.SaveAll(conn, s.object_instances);
}
}
if (s.object_titles.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_titles_helper.SaveAll(conn, s.object_titles);
}
}
// these are database dependent
if (source.has_object_datasets && s.object_datasets.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_datasets_helper.SaveAll(conn, s.object_datasets);
}
}
if (source.has_object_dates && s.object_dates.Count > 0)
{
using (var conn = new NpgsqlConnection(db_conn))
{
conn.Open();
och.object_dates_helper.SaveAll(conn, s.object_dates);
}
}
}
