// Fetch details of a publication
public Publication FetchPublicationDetails(string doi)
{
//doi, title, authors, year, type, cite_as, available
Publication pub = new Publication();
string sql = "select * from publication where doi='" + doi + "';";
cmd = new MySqlCommand(sql, conn);
rdr = cmd.ExecuteReader();
rdr.Read();
pub.DOI = doi;
pub.Title = rdr["title"].ToString();
pub.Authors = rdr["authors"].ToString();
pub.Year = Int32.Parse(rdr["year"].ToString());
pub.Type = Outputtype.Conference;
switch (rdr["type"].ToString())
{
case "Conference":
pub.Type = Outputtype.Conference;
break;
case "Journal":
pub.Type = Outputtype.Journal;
break;
default:
pub.Type = Outputtype.Other;
break;
}
pub.CiteAs = rdr["cite_as"].ToString();
pub.Availability = rdr.GetDateTime("available");
pub.Age = pub.GetAge();
rdr.Close();
return(pub);
}
