public int GetContributorCount()
{
using (var context = new ContributorDataContext(_connectionString))
{
return(context.Contributors.Count());
}
}
public Contributor GetContributorById(int id)
{
using (var context = new ContributorDataContext(_connectionString))
{
return(context.Contributors.FirstOrDefault(c => c.Id == id));
}
}
public void AddContributor(Contributor contributor)
{
using (var context = new ContributorDataContext(_connectionString))
{
context.Contributors.InsertOnSubmit(contributor);
context.SubmitChanges();
}
}
public void UpdateContributor(Contributor contributor)
{
using (var context = new ContributorDataContext(_connectionString))
{
context.Contributors.Attach(contributor);
context.Refresh(RefreshMode.KeepCurrentValues, contributor);
context.SubmitChanges();
}
}
public IEnumerable <Contributor> GetContributors()
{
List <Contributor> contributors = new List <Contributor>();
using (var context = new ContributorDataContext(_connectionString))
{
contributors = context.Contributors.ToList();
}
foreach (Contributor c in contributors)
{
c.Balance = GetContributorBalance(c.Id);
}
return(contributors.AsEnumerable());
}