public void DonateToSimcha(DonateToSimcha simcha) { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = "DELETE from SimchaContributions where @simchaid = simchaid" + "INSERT INTO SimchaContribution VALUES(@simchaid,@contributorid, @amount)"; command.Parameters.AddWithValue("@simchaid", simcha.Simchaid); command.Parameters.AddWithValue("@contributorid", simcha.Contributorid); command.Parameters.AddWithValue("@amount", simcha.Amount); connection.Open(); command.ExecuteNonQuery(); }
public IEnumerable <DonateToSimcha> GetAllSimchaDonations(int simchaid) { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT * FROM SimchaContribution where simchaid = @simchaid"; command.Parameters.AddWithValue("@simchaid", simchaid); connection.Open(); List <DonateToSimcha> donors = new List <DonateToSimcha>(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DonateToSimcha simcha = new DonateToSimcha { Simchaid = (int)reader["simchaid"], Contributorid = (int)reader["contributorid"], Amount = (Decimal)reader["Amount"] }; donors.Add(simcha); } return(donors); }