public ActionResult updateContributions(List <Contributing> contributing, int SimchaId)
{
ContributorsDB cdb = new ContributorsDB(Properties.Settings.Default.ConStr);
cdb.UpdateContribution(contributing, SimchaId);
return(Redirect("/simcha/index"));
}
public ActionResult AddDeposit(int deposit, int ContributorId)
{
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
CDB.AddDeposit(deposit, ContributorId);
return(RedirectToAction("/index"));
}
public ActionResult Contributors(int SimchaId)
{
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
SimchasDB SDB = new SimchasDB(Properties.Settings.Default.ConStr);
UpdateViewModel uvm = new UpdateViewModel();
uvm.Simcha = SDB.GetById(SimchaId);
IEnumerable <Contributor> contributors = CDB.GetAllContributors();
List <SimchaContributor> result = new List <SimchaContributor>();
foreach (Contributor c in contributors)
{
SimchaContributor sc = new SimchaContributor
{
ContributorId = c.Id,
Name = c.FirstName + " " + c.LastName,
AlwaysInclude = c.AlwaysInclude,
Balance = CDB.GetBalance(c.Id),
Include = CDB.ContributedAlready(SimchaId, c.Id),
Amount = CDB.ContributedAmount(SimchaId, c.Id)
};
result.Add(sc);
}
uvm.SimchaContributorList = result;
return(View(uvm));
}
public ActionResult Index()
{
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
ContributorsViewModel cvm = new ContributorsViewModel();
IEnumerable <Contributor> contributors = CDB.GetAllContributors();
cvm.Contributors = ContributorToContributorPlus(contributors);
return(View(cvm));
}
public ActionResult showHistory(int ContributorId)
{
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
HistoryViewModel hvm = new HistoryViewModel();
IEnumerable <Deposit> d = CDB.GetDepositsForContributor(ContributorId);
IEnumerable <Contribution> c = CDB.GetContributionsForContributor(ContributorId);
hvm.Transactions = Transactions(c, d).OrderBy(t => t.Date);
hvm.Balance = CDB.GetBalance(ContributorId);
hvm.Contributor = CDB.GetById(ContributorId);
return(View(hvm));
}
public ActionResult Index()
{
SimchasDB SDB = new SimchasDB(Properties.Settings.Default.ConStr);
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
SimchasViewModel svm = new SimchasViewModel();
IEnumerable <Simcha> simchas = SDB.GetAllSimchas();
svm.Simchas = SimchaToSimchaPlus(simchas);
svm.ContributorsCount = CDB.TotalNumberContributors();
if (TempData["SimchaAdded"] != null)
{
svm.NewSimcha = (Simcha)TempData["SimchaAdded"];
}
return(View(svm));
}
private IEnumerable <SimchaPlus> SimchaToSimchaPlus(IEnumerable <Simcha> simchas)
{
SimchasDB SDB = new SimchasDB(Properties.Settings.Default.ConStr);
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
List <SimchaPlus> result = new List <SimchaPlus>();
foreach (Simcha s in simchas)
{
SimchaPlus sp = new SimchaPlus
{
Id = s.Id,
Name = s.Name,
Date = s.Date,
TotalDonations = SDB.GetTotalDeposits(s.Id),
Contributors = CDB.NumberContributorsForSimcha(s.Id)
};
result.Add(sp);
}
;
return(result);
}
private IEnumerable <ContributorPlus> ContributorToContributorPlus(IEnumerable <Contributor> contributors)
{
ContributorsDB CDB = new ContributorsDB(Properties.Settings.Default.ConStr);
List <ContributorPlus> result = new List <ContributorPlus>();
foreach (Contributor c in contributors)
{
ContributorPlus cp = new ContributorPlus
{
Id = c.Id,
FirstName = c.FirstName,
LastName = c.LastName,
DateCreated = c.DateCreated,
AlwaysInclude = c.AlwaysInclude,
PhoneNumber = c.PhoneNumber,
Balance = CDB.GetBalance(c.Id)
};
result.Add(cp);
}
;
return(result.OrderByDescending(cp => cp.DateCreated));
}
