public void AddContribution(Contribution c) { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = @"INSERT INTO Contributions(Contributorid,Amount,Date) VALUES(@contributorid,@amount,@date); SELECT @@Identity"; command.Parameters.AddWithValue("@contributorid", c.Contributorid); command.Parameters.AddWithValue("@amount", c.Amount); command.Parameters.AddWithValue("@date", c.Date); connection.Open(); c.id = (int)(decimal)command.ExecuteScalar(); }
public IEnumerable <Contribution> GetAllContributions() { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT * FROM Contributions"; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <Contribution> contributions = new List <Contribution>(); while (reader.Read()) { Contribution contribution = new Contribution { id = (int)reader["id"], Contributorid = (int)reader["ContributorId"], Amount = (Decimal)reader["Amount"], Date = (DateTime)reader["Date"], }; contributions.Add(contribution); } return(contributions); }
public IEnumerable <Contribution> GetContributionsForid(int id) { SqlConnection connection = new SqlConnection(_connectionstring); SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT Amount, Date FROM Contributions Where contributorid = @id"; command.Parameters.AddWithValue("@id", id); connection.Open(); List <Contribution> contribution = new List <Contribution>(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Contribution c = new Contribution { Amount = (Decimal)reader["Amount"], Date = (DateTime)reader["Date"], }; contribution.Add(c); } command.CommandText = @"select sc.Amount, s.Date from SimchaContributions sc Join Simchas s on sc.simchaid=s.id where sc.contributorid=@id"; while (reader.Read()) { Contribution c2 = new Contribution { Amount = (Decimal)reader["Amount"], Date = (DateTime)reader["Date"], }; contribution.Add(c2); } return(contribution); }