public void AddDeposit(Deposit d)
{
using (var context = new SimchaContext(_connectionString))
{
context.Deposits.Add(d);
context.SaveChanges();
}
}
public void AddSimcha(Simcha s)
{
using (var context = new SimchaContext(_connectionString))
{
context.Simchas.Add(s);
context.SaveChanges();
}
}
public void AddContributor(Contributor c, Deposit d)
{
using (var context = new SimchaContext(_connectionString))
{
context.Contributors.Add(c);
d.ContributorId = c.Id;
context.Deposits.Add(d);
context.SaveChanges();
}
}
public void EditContributor(Contributor c)
{
using (var context = new SimchaContext(_connectionString))
{
context.Database.ExecuteSqlCommand("UPDATE Contributors SET FirstName = @firstName, LastName = @lastName, CellNumber = @cellNumber " +
"WHERE Id = @id",
new SqlParameter("@firstName", c.FirstName),
new SqlParameter("@lastName", c.LastName),
new SqlParameter("@cellNumber", c.CellNumber),
new SqlParameter("@id", c.Id));
context.SaveChanges();
}
}
public void UpdateContributions(int simchaId, List <SimchaContribution> contributions)
{
using (var context = new SimchaContext(_connectionString))
{
context.Database.ExecuteSqlCommand("DELETE FROM Contributions WHERE SimchaId = @simchaId", new SqlParameter("@simchaId", simchaId));
foreach (SimchaContribution sc in contributions)
{
if (sc.Include == true)
{
context.Database.ExecuteSqlCommand("INSERT INTO Contributions (SimchaId, ContributorId, Amount, Date) " +
"VALUES (@simchaId, @contributorId, @amount, @date)",
new SqlParameter("@simchaId", simchaId),
new SqlParameter("@contributorId", sc.ContributorId),
new SqlParameter("@amount", sc.Amount),
new SqlParameter("@date", System.DateTime.Now));
}
}
context.SaveChanges();
}
}