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