public ProfileData GetUserProfile(int id) { using var userContext = new LotteryContext(); var result = userContext.Users .Include(u => u.Payments) .FirstOrDefault(user => user.Id == id) ; if (result == null) { return(null); } return(new ProfileData() { Payments = result.Payments.Select(p => new PaymentContract { cardNumber = p.cardNumber, cardType = p.cardType, Id = p.Id }).ToList(), User = new UserContract() { Address = result.Address, Avatar = result.Avatar, Id = result.Id, Mail = result.Mail, Name = result.Name, Role = result.Role } }); }
public UserEntity UpdateProfile(UserEntity user) { using var userContext = new LotteryContext(); userContext.Users.Update(user); userContext.SaveChanges(); return(user); }
public Task Save(UserEntity user) { using var userContext = new LotteryContext(); userContext.Users.Add(user); userContext.SaveChanges(); return(Task.CompletedTask); }
public void SavePayment(int id, PaymentEntity paymentEntity) { using var userContext = new LotteryContext(); var result = userContext.Users .Include(user => user.Payments) .FirstOrDefault(user => user.Id == id); if (result == null) { throw new Exception("Not found"); } result.Payments.Add(paymentEntity); userContext.SaveChanges(); }
public void RemovePayment(int id, int paymentId) { using var userContext = new LotteryContext(); var result = userContext.Users .Include(user => user.Payments) .FirstOrDefault(user => user.Id == id); if (result == null) { throw new Exception("Not found"); } var payment = result.Payments.FirstOrDefault(p => p.Id == paymentId); if (payment == null) { throw new Exception("Not found"); } result.Payments.Remove(payment); userContext.SaveChanges(); }
internal void Save(CreateLotteryEventContract contract) { using var ctx = new LotteryContext(); var lotteryEvent = new LotteryEventEntity { Name = contract.Name, DrawDate = contract.DrawDate, Price = contract.Price }; var charities = contract.Charities.Select(c => ctx.CharityEntity.First(entity => entity.Id == c.Id)); foreach (var c in charities) { lotteryEvent.LoteryCharity.Add(new CharityLotteryEntity() { Lottery = lotteryEvent, Charity = c }); } ctx.LotteryEntity.Add(lotteryEvent); ctx.SaveChanges(); }
public UserEntity GetUserByName(string name) { using var userContext = new LotteryContext(); return(userContext.Users.FirstOrDefault(user => user.Mail == name)); }