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