public static Researcher.Publication completePublicationDetails(Researcher.Publication p)
{
string doi = p.DOI;
//Fetch Positions
MySqlDataReader rdr = null;
GetConnection();
try
{
// Open the connection
conn.Open();
// 1. Instantiate a new command with a query and connection
MySqlCommand cmd = new MySqlCommand("select * from publication where DOI = \"" + doi + "\";", conn);
// 2. Call Execute reader to get query results
rdr = cmd.ExecuteReader();
// print the CategoryName of each record
while (rdr.Read())
{
//This illustrates how the raw data can be obtained using an indexer [] or a particular data type can be obtained using a GetTYPENAME() method.
//Console.WriteLine("{0} {1}", rdr[0], rdr.GetString(1));
//https://stackoverflow.com/questions/20547261/database-field-enum-to-c-sharp-list
p.Authors = rdr.GetString(2);
p.Type = (Researcher.OutputType)Enum.Parse(typeof(Researcher.OutputType), rdr.GetString(4));
p.Available = rdr.GetDateTime(6);
p.CiteAs = rdr.GetString(5);
return(p);
}
}
finally
{
// close the reader
if (rdr != null)
{
rdr.Close();
}
// Close the connection
if (conn != null)
{
conn.Close();
}
}
return(p);
}
public Researcher.Publication loadPublicationDetails(Researcher.Publication p)
{
return(Adapters.ERDAdapter.completePublicationDetails(p));
}
public void loadFullPublications(Researcher.Publication p)
{
publication = loadPublicationDetails(p);
}
