/// <summary>
/// Generate URLs of the <paramref name="lastStrawPoll"/> using its <paramref name="ID"/>
/// and insert them in database
/// </summary>
/// <remarks>It ain't creating a new strawpoll, the concerned strawpoll is updated</remarks>
/// <param name="lastStrawPoll">The strawpoll object holding the URLs</param>
/// <param name="ID">The ID of the strawpoll</param>
public void sendURLsInDataBase(Models.StrawPoll lastStrawPoll, int ID)
{
String queryAddURLs;
ConnectionQuery newDataBaseTask = new ConnectionQuery();
String URLStrawPoll = lastStrawPoll.generateURLStrawPoll(ID);
lastStrawPoll.setURLStrawPoll(URLStrawPoll);
String URLDeletion = lastStrawPoll.generateURLDeletion();
lastStrawPoll.setURLDeletion(URLDeletion);
String URLResult = lastStrawPoll.generateURLResults(ID);
lastStrawPoll.setURLResults(URLResult);
queryAddURLs = "UPDATE StrawPoll " +
"SET URLStrawPoll = @URLStrawPoll, URLDeletion = @URLDeletion, URLResult = @URLResult, IsActive = @IsActive " +
"WHERE NumStrawPoll=@ID";
newDataBaseTask.OpenConnection();
SqlCommand cmd = new SqlCommand(queryAddURLs, newDataBaseTask.getSqlConnection());
cmd.Parameters.AddWithValue("@URLStrawPoll", URLStrawPoll);
cmd.Parameters.AddWithValue("@URLDeletion", URLDeletion);
cmd.Parameters.AddWithValue("@URLResult", URLResult);
cmd.Parameters.AddWithValue("@IsActive", true);
cmd.Parameters.AddWithValue("@ID", ID);
newDataBaseTask.setMySqlCommand(cmd);
newDataBaseTask.ExecuteNonQuery();
newDataBaseTask.CloseConnection();
}
