public void Save()
{
List <PBScrape> allData = PBScrape.GetAll();
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
//Write section to get last existing id and add 1
//cmd.Parameters.AddWithValue("@id", (int) cmd.LastInsertedId);
cmd.Parameters.AddWithValue("@keyword", this._keyword);
cmd.Parameters.AddWithValue("@url", this._url);
cmd.Parameters.AddWithValue("@email", this._email);
cmd.Parameters.AddWithValue("@phone", this._phone);
cmd.CommandText = @"INSERT INTO pbscrape ( keyword, url, email, phone)
VALUES ( @keyword, @url, @email, @phone);";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
cmd.ExecuteNonQuery();
_id = (int)cmd.LastInsertedId;
if (conn != null)
{
conn.Dispose();
}
conn.Close();
//write get all
}
public void Save()
{
List <PBScrape> allData = PBScrape.GetAll();
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO pbscrape ( keyword, url, email, phone)
VALUES ( @keyword, @url, @email, @phone);";
cmd.Parameters.Add(new MySqlParameter("@keyword", this._keyword));
cmd.Parameters.Add(new MySqlParameter("@url", this._url));
cmd.Parameters.Add(new MySqlParameter("@email", this._email));
cmd.Parameters.Add(new MySqlParameter("@phone", this._phone));
cmd.ExecuteNonQuery();
_id = (int)cmd.LastInsertedId;
conn.Close();
if (conn != null)
{
conn.Dispose();
}
//write get all
}