//Use this when implement delete feature
public void DeleteContributor(int id)
{
using (var context = new ContributionDataContext(_connectionString))
{
context.ExecuteCommand("DELETE FROM Contributors WHERE Id = {0}", id); //can do with context.Delete but that requires 2 database hits
}
}
public void UpdateSimchaContributions(int simchaId, List <ContributionInclusion> contributors)
{
using (var context = new ContributionDataContext(_connectionString))
{
context.ExecuteCommand("DELETE FROM Contributions WHERE SimchaId = {0}", simchaId); //can do with context.Delete but that requires 2 database hits
foreach (var c in contributors)
{
context.Contributions.InsertOnSubmit(new Contribution
{
SimchaId = simchaId,
ContributorId = c.ContributorId,
Amount = c.Amount
});
}
}
}
