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