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