コード例 #1
0
ファイル: Program.cs プロジェクト: qwv4851/HypeBot
 // 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;
 }
コード例 #2
0
ファイル: Program.cs プロジェクト: qwv4851/HypeBot
 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();
 }
コード例 #3
0
ファイル: Program.cs プロジェクト: qwv4851/HypeBot
 // 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;
 }