// Adds the given hype to the database.
private static bool AddHype(Hype hype)
{
MySqlConnection conn = new MySqlConnection(connStr);
try
{
conn.Open();
AddHype(hype, conn);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
return false;
}
conn.Close();
return true;
}
private static void AddHype(Hype hype, MySqlConnection conn)
{
string query = "REPLACE INTO old_hype VALUES (@url, @handle, @name, @date, @body)";
MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn);
adapter.InsertCommand = new MySqlCommand(query, conn);
adapter.InsertCommand.Parameters.Add(new MySqlParameter("@handle", hype.handle));
adapter.InsertCommand.Parameters.Add(new MySqlParameter("@name", hype.name));
adapter.InsertCommand.Parameters.Add(new MySqlParameter("@url", hype.url));
adapter.InsertCommand.Parameters.Add(new MySqlParameter("@body", hype.body));
adapter.InsertCommand.Parameters.Add(new MySqlParameter("@date", hype.date));
adapter.InsertCommand.ExecuteNonQuery();
}
// Seaches the database for the given URL and returns the associated Hype if found.
public static Hype GetHype(string url)
{
MySqlConnection conn = new MySqlConnection(connStr);
try
{
conn.Open();
string query = "SELECT * FROM old_hype WHERE url=@url";
MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn);
adapter.SelectCommand = new MySqlCommand(query, conn);
adapter.SelectCommand.Parameters.AddWithValue("@url", url);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
DataTable table = dataSet.Tables[0];
if (table.Rows.Count > 0)
{
DataRow r = table.Rows[0];
Hype hype = new Hype((string)r["handle"], (string)r["name"], url, (string)r["body"], (DateTime)r["date"]);
return hype;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
return null;
}