public IEnumerable <SimchaContributor> GetThisSimchaContributors(int id)
{
using (var ctx = new SimchaContext(_connectionString))
{
IEnumerable <Contributor> contributors = GetAllContributors();
IEnumerable <SimchaContributor> sc = contributors.Select(c =>
{
var s = new SimchaContributor();
s.Contributor = c;
s.Contributed = AlreadyContributed(c, id);
s.SimchaId = id;
s.Balance = c.Deposits.Sum(d => d.Amount) - c.Contributions.Sum(d => d.Amount);
if (c.Contributions.FirstOrDefault(con => con.SimchaId == id) != null)
{
s.Amount = c.Contributions.FirstOrDefault(con => con.SimchaId == id).Amount;
}
else
{
s.Amount = 0;
}
return(s);
});
return(sc);
}
}
public IEnumerable <Contributor> GetAllContributors()
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Contributors.Include(c => c.Contributions).Include(c => c.Deposits).ToList());
}
}
public Simcha GetSimchaById(int id)
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Simchas.FirstOrDefault(s => s.Id == id));
}
}
public IEnumerable <Simcha> GetAllSimchas()
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Simchas.Include(s => s.Contributions).ToList());
}
}
public decimal GetTotalBalance()
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Deposits.Sum(d => d.Amount) - ctx.Contributions.Sum(c => c.Amount));
}
}
public Contributor GetContributorById(int id)
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Contributors.Include(c => c.Contributions).ThenInclude(c => c.Simcha).Include(c => c.Deposits).FirstOrDefault(c => c.Id == id));
}
}
public int GetTotalContributorsForSimcha(int id)
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Contributions.Where(s => s.SimchaId == id).Count());
}
}
//private Contribution GetAmountContributed(Contributor contributor, int simchaId)
//{
// return contributor.Contributions.FirstOrDefault(c => c.SimchaId == simchaId);
//}
public int GetTotalContributorCount()
{
using (var ctx = new SimchaContext(_connectionString))
{
return(ctx.Contributors.Count());
}
}
public void AddDeposit(Deposit deposit)
{
using (var ctx = new SimchaContext(_connectionString))
{
ctx.Deposits.Add(deposit);
ctx.SaveChanges();
}
}
public void AddContributor(Contributor contributor)
{
using (var ctx = new SimchaContext(_connectionString))
{
ctx.Contributors.Add(contributor);
ctx.SaveChanges();
}
}
public void AddSimcha(Simcha simcha)
{
using (var ctx = new SimchaContext(_connectionString))
{
ctx.Simchas.Add(simcha);
ctx.SaveChanges();
}
}
public void DeleteContributions(int simchaId)
{
using (var ctx = new SimchaContext(_connectionString))
{
ctx.Contributions.RemoveRange(ctx.Contributions.Where(c => c.SimchaId == simchaId));
ctx.SaveChanges();
}
}
public void EditContributor(Contributor contributor)
{
using (var ctx = new SimchaContext(_connectionString))
{
ctx.Database.ExecuteSqlCommand(
"UPDATE Contributors SET Name = @name, Cell = @cell, DateJoined=@datejoined, AlwaysInclude = @alwaysinclude WHERE Id = @id",
new SqlParameter("@id", contributor.Id), new SqlParameter("@name", contributor.Name),
new SqlParameter("@cell", contributor.Cell), new SqlParameter("@alwaysinclude", contributor.AlwaysInclude),
new SqlParameter("@datejoined", contributor.DateJoined));
ctx.SaveChanges();
}
}
public void UpdateContributions(IEnumerable <SimchaContributor> contributors, int simchaId)
{
IEnumerable <SimchaContributor> con = contributors.Where(c => c.Contributed);
using (var ctx = new SimchaContext(_connectionString))
{
foreach (SimchaContributor sc in con)
{
ctx.Contributions.Add(new Contribution {
ContributorId = sc.ContributorId, SimchaId = sc.SimchaId, Amount = sc.Amount
});
}
ctx.SaveChanges();
}
}