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); } }