public void ChangeDeadLineDb(Referendum edittedReferendum)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "UPDATE Referendum SET DeadLine = @DeadLine WHERE Id = @Id";
db.Execute(sqlQuery, edittedReferendum);
}
}
public void AddReferendum(Referendum referendum)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "INSERT INTO Referendum VALUES(@Proposition, @Autor, @Active, @Published, @MaxOwnAnswers, @MaxAmountAnswers, @DeadLine, @PublishDate)";
db.Execute(sqlQuery, referendum);
}
}
public void ChangeMaxAmountAnswersDb(Referendum edittedReferendum)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "UPDATE Referendum SET MaxAmountAnswers = @MaxAmountAnswers WHERE Id = @Id";
db.Execute(sqlQuery, edittedReferendum);
}
}
