public void TestRecalculateBallance() { var srv = new Servise(); srv.RecalculateBallance("5111111111111111"); srv.RecalculateBallance("5111111111111112"); using (var ctx = new Bank1Entities()) { var card1 = ctx.Card.Single(c => c.CadrID == "5111111111111111"); var card2 = ctx.Card.Single(c => c.CadrID == "5111111111111112"); Assert.AreEqual(0, card1.Ballance + card2.Ballance); } }
public void RecalculateBallance(string cardNo) { using (var ctx = new Bank1Entities()) { var card = ctx.Card.SingleOrDefault(c => c.CadrID == cardNo); ctx.Entry(card).Collection(c => c.Operations).Load(); ctx.Entry(card).Collection(c => c.Operations1).Load(); card.Ballance = card.Operations.Sum(o => o.Amount) - card.Operations1.Sum(o => o.Amount); ctx.SaveChanges(); } }