public IEnumerable <SimchaContributor> GetSimchaContributors(int simchaId) { IEnumerable <Contributors> contributors = GetContributors(); var connection = new SqlConnection(_connectionString); var cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = "SELECT * FROM Contributors WHERE Id = @id"; cmd.Parameters.AddWithValue("@id", simchaId); var reader = cmd.ExecuteReader(); List <Contributions> contributions = new List <Contributions>(); while (reader.Read()) { Contributions contribution = new Contributions { Amount = (decimal)reader["Amount"], SimchaId = simchaId, ContributorId = (int)reader["ContributorId"] }; contributions.Add(contribution); } return(contributors.Select(contributor => { var sc = new SimchaContributor(); sc.FirstName = contributor.FirstName; sc.LastName = contributor.LastName; sc.AlwaysInclude = contributor.AlwaysInclude; sc.ContributorId = contributor.Id; sc.Balance = contributor.Balance; Contributions contribution = contributions.FirstOrDefault(c => c.ContributorId == contributor.Id); if (contribution != null) { sc.Amount = contribution.Amount; } return sc; })); }
public IEnumerable <Contributions> GetContributionsById(int contribId) { var contributions = new List <Contributions>(); var connection = new SqlConnection(_connectionString); var cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = "SELECT * FROM Contributions WHERE ContributorId = @id"; cmd.Parameters.AddWithValue("@id", contribId); var reader = cmd.ExecuteReader(); while (reader.Read()) { var contribution = new Contributions(); contribution.SimchaId = (int)reader["SimchaId"]; contribution.SimchaName = (string)reader["SimchaName"]; contribution.ContributorId = (int)reader["ContributorId"]; contribution.Amount = (int)reader["Amount"]; contribution.Date = (DateTime)reader["Date"]; contributions.Add(contribution); } return(contributions); }