public bool CreatePoll(Entity.Poll poll)
{
string command = "INSERT INTO Poll (id_poll, creation_date, title_poll) VALUES (@idPoll, GETDATE(), @title)";
SqlCommand cmd = new SqlCommand(command);
cmd.Parameters.AddWithValue("@idPoll", poll.IdPoll);
cmd.Parameters.AddWithValue("@title", poll.title);
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public bool CreatePollOptions(Entity.Poll poll)
{
string command = "INSERT INTO Poll_options (id_option, id_poll, creation_date, question, votes) VALUES (@idOption, @idPoll, GETDATE(), @question, @votes)";
SqlCommand cmd = new SqlCommand(command);
cmd.Parameters.AddWithValue("@idOption", DbType.String);
cmd.Parameters.AddWithValue("@idPoll", DbType.String);
cmd.Parameters.AddWithValue("@question", DbType.String);
cmd.Parameters.AddWithValue("@votes", DbType.Int32);
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
try
{
conn.Open();
foreach (Entity.Option value in poll.pollOption)
{
cmd.Parameters[0].Value = value.idOption;
cmd.Parameters[1].Value = poll.IdPoll;
cmd.Parameters[2].Value = value.question;
cmd.Parameters[3].Value = 0;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
