public IActionResult Deposit(decimal amount, DateTime date, int contributorId)
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
db.NewDeposit(amount, date, contributorId);
return(Redirect("/contributors/index"));
}
public IActionResult UpdateContributions(List <ContributionInclusion> contributors, int simchaId)
{
var db = new SimchaFundDb(_connectionString);
db.UpdateContributions(contributors, simchaId);
return(Redirect("/"));
}
public IActionResult AddDeposit(Deposit deposit)
{
var db = new SimchaFundDb(_connectionString);
db.AddDeposit(deposit);
return(Redirect("/home/contributors"));
}
public IActionResult AddSimcha(Simcha simcha)
{
var db = new SimchaFundDb(_connectionString);
db.AddSimcha(simcha);
return(Redirect("/"));
}
public IActionResult EditContributor(Contributor contributor)
{
var db = new SimchaFundDb(_connectionString);
db.EditContributor(contributor);
return(Redirect("/home/contributors"));
}
public IActionResult UpdateContributions(List <History> contributors, int simchaId)
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
List <History> contributors1 = contributors.Where(c => c.Include).ToList();
db.UpdateContributions(contributors1, simchaId);
return(Redirect("/simchos"));
}
public IActionResult New(Simcha simcha)
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
db.AddSimcha(simcha);
TempData["message"] = "Simcha added successfully";
return(Redirect("/simchos/index"));
}
public IActionResult New(Contributor contributor, decimal initialDeposit)
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
db.NewContributor(contributor, initialDeposit);
TempData["message"] = "Contributor added successfully";
return(Redirect("/contributors/index"));
}
public IActionResult Contributors()
{
var vm = new ContributorViewModel();
var db = new SimchaFundDb(_connectionString);
vm.Contributors = db.GetContributors();
return(View(vm));
}
public IActionResult Index()
{
var db = new SimchaFundDb(_connectionString);
var vm = new IndexViewModel
{
Simchas = db.GetAllSimchas(),
ContributorCount = db.GetContributorCount()
};
vm.Simchas = vm.Simchas.OrderBy(s => s.Date).ToList();
return(View(vm));
}
public IActionResult Contributions(int simchaId)
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
ContributionsViewModel vm = new ContributionsViewModel
{
Contributors = db.GetContributors(),
Simcha = db.GetSimcha(simchaId),
Counter = 0,
contribForSimcha = db.GetIdsForContributed(simchaId)
};
return(View(vm));
}
public IActionResult ShowHistory(int id)
{
var db = new SimchaFundDb(_connectionString);
var vm = new ShowHistoryViewModel
{
Contributor = db.GetContributorById(id),
Actions = db.GetActions(id)
};
vm.Actions = vm.Actions.OrderBy(a => a.Date).ToList <SimchaFund.Data.Action>();
return(View(vm));
}
public IActionResult ShowHistory(int id)
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
List <History> histories = db.GetHistory(id);
decimal balance = 0;
histories.ForEach(h => balance += h.Amount);
List <History> histories1 = histories.OrderByDescending(h => h.Date).ToList();
HistoryViewModel vm = new HistoryViewModel {
Histories = histories1, Name = db.Name(id), Balance = balance
};
return(View(vm));
}
public IActionResult Index()
{
SimchaFundDb db = new SimchaFundDb(_connectionString);
ContributorsViewModel vm = new ContributorsViewModel
{
Contributors = db.GetContributors()
};
if (!string.IsNullOrEmpty((string)TempData["message"]))
{
ViewBag.Message = (string)TempData["message"];
}
return(View(vm));
}
public IActionResult AddContributorAndDeposit(Contributor contributor, int amount)
{
var db = new SimchaFundDb(_connectionString);
int contributorId = db.AddContributor(contributor);
var deposit = new Deposit
{
ContributorId = contributorId,
Amount = amount,
Date = DateTime.Today
};
db.AddDeposit(deposit);
return(Redirect("/home/contributors"));
}
public IActionResult Contributions(int id)
{
var db = new SimchaFundDb(_connectionString);
ContributionsViewModel vm = new ContributionsViewModel
{
Simcha = db.GetSimchaById(id),
Contributors = db.GetContributors()
};
foreach (var contributor in vm.Contributors)
{
db.SetContributionAmountForContributorForSimcha(vm.Simcha.Id, contributor);
}
return(View(vm));
}
