/// <summary>
/// Add the <paramref name="newStrawPoll"/> in the database
/// </summary>
/// <remarks>URLs of the strawpoll ain't inserted</remarks>
/// <param name="newStrawPoll">The strawpoll object to insert</param>
/// <returns>The ID of the strawpoll</returns>
public int addStrawPollInDataBase(Models.StrawPoll newStrawPoll)
{
String queryAddStrawPoll;
ConnectionQuery newDataBaseTask = new ConnectionQuery();
queryAddStrawPoll = "INSERT INTO StrawPoll(MultipleChoices, Question, NbrVotes, isActive, GUID, NumCreator) " +
"VALUES(@MultipleChoices, @StrawPollQuestion, @NbrVotesStrawPoll, @IsActive, @GUID, @NumCreator); " +
"SELECT scope_identity()";
newDataBaseTask.OpenConnection();
SqlCommand cmd = new SqlCommand(queryAddStrawPoll, newDataBaseTask.getSqlConnection());
cmd.Parameters.AddWithValue("@MultipleChoices", newStrawPoll.getMultipleChoices());
cmd.Parameters.AddWithValue("@StrawPollQuestion", newStrawPoll.getStrawPollQuestion());
cmd.Parameters.AddWithValue("@NbrVotesStrawPoll", newStrawPoll.getNbrVotesStrawPoll());
cmd.Parameters.AddWithValue("@IsActive", newStrawPoll.getIsActive());
cmd.Parameters.AddWithValue("@GUID", newStrawPoll.getGuidStrawPoll());
bool connected = false;
if (!connected)
{
cmd.Parameters.AddWithValue("@NumCreator", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@NumCreator", 4);
}
int ID = Convert.ToInt32(cmd.ExecuteScalar());
newDataBaseTask.CloseConnection();
return(ID);
}
//METHODS//
public int addStrawPollInDataBase(Models.StrawPoll newStrawPoll)
{
String queryAddStrawPoll;
ConnectionQuery newDataBaseTask = new ConnectionQuery();
//Changer les noms
queryAddStrawPoll = "INSERT INTO StrawPoll(MultipleChoices, Question, NbrVotes) " +
"VALUES(@multipleChoices, @strawPollQuestion, @NbrVotesStrawPoll); " +
"SELECT scope_identity()";
newDataBaseTask.OpenConnection();
SqlCommand cmd = new SqlCommand(queryAddStrawPoll, newDataBaseTask.getSqlConnection());
cmd.Parameters.AddWithValue("@multipleChoices", newStrawPoll.getMultipleChoices());
cmd.Parameters.AddWithValue("@strawPollQuestion", newStrawPoll.getStrawPollQuestion());
cmd.Parameters.AddWithValue("@NbrVotesStrawPoll", newStrawPoll.getNbrVotesStrawPoll());
int ID = (int)cmd.ExecuteNonQuery();
newDataBaseTask.CloseConnection();
return(ID);
}
