public async Task <bool> UpGradeMemberShip(MemberShip memberShip) { MemberShip entity = context.MemberShip.FirstOrDefault(u => u.MembershipId == memberShip.MembershipId); if (entity != null) { entity.Name = memberShip.Name; entity.IsActive = memberShip.IsActive; entity.DeactiveDate = memberShip.DeactiveDate; entity.Email = memberShip.Email; context.Entry(memberShip).State = EntityState.Modified; try { await context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!(await IsMembershipExists(memberShip.Email))) { return(false); } else { throw; } } return(true); } else { return(false); } }
public async Task <bool> MembershipPayment(Payment payment, MemberShip memberShip, Char ActionType) { using (var transaction = context.Database.BeginTransaction()) { try { context.Payment.Add(payment); context.SaveChanges(); if (ActionType == 'S') { if (payment.PaymentId > 0) { context.MemberShip.Add(memberShip); context.SaveChanges(); } } if (ActionType == 'U') { if (payment.PaymentId > 0) { var entity = context.MemberShip.Where(a => a.MembershipId == memberShip.MembershipId).FirstOrDefault(); if (entity != null) { context.Entry(memberShip).State = EntityState.Modified; } context.SaveChanges(); } } transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } } }