private bool AlreadyDonate(Donor donor) { using (var ctx = new SimchaDonorContext(_connectionString)) { return(ctx.SimchaDonor.Any(s => s.DonorId == donor.Id)); } }
public IEnumerable <Donor> AllDonors() { using (var ctx = new SimchaDonorContext(_connectionString)) { return(ctx.Donor.ToList()); } }
public void AddSimcha(Simcha simcha) { using (var ctx = new SimchaDonorContext(_connectionString)) { ctx.Simcha.Add(simcha); ctx.SaveChanges(); } }
public void AddDeposit(Deposit deposit) { using (var ctx = new SimchaDonorContext(_connectionString)) { ctx.Deposit.Add(deposit); ctx.SaveChanges(); } }
public void AddNewDonor(Donor donor) { using (var ctx = new SimchaDonorContext(_connectionString)) { ctx.Donor.Add(donor); ctx.SaveChanges(); } }
public void EditDonor(Donor donor) { using (var ctx = new SimchaDonorContext(_connectionString)) { ctx.Database.ExecuteSqlCommand( "UPDATE Donor SET FirstName = @firstName, Lastname = @lastName, CellNumber = @cellNumber WHERE Id = @id", new SqlParameter("@id", donor.Id), new SqlParameter("@firstName", donor.FirstName), new SqlParameter("@cellNumber", donor.CellNumber), new SqlParameter("@lastName", donor.LastName)); ctx.SaveChanges(); } }
public decimal GetBalanceForDonor(Donor donor) { using (var ctx = new SimchaDonorContext(_connectionString)) { bool donate = AlreadyDonate(donor); if (donate) { return((from d in ctx.Deposit join sd in ctx.SimchaDonor on d.DonorId equals sd.DonorId join don in ctx.Donor on sd.DonorId equals don.Id where don.Id == donor.Id select d.Amount - sd.Amount).FirstOrDefault()); } return(ctx.Deposit.Where(d => d.Id == donor.Id).Sum(d => d.Amount)); } }