public async Task <bool> AddPayment(Payment payment) { var output = JsonConvert.SerializeObject(payment); try { var response = _context.Payments.Where(x => (x.Funeral == payment.Funeral && x.ProfileNumber == payment.ProfileNumber)).FirstOrDefault(); if (response != null) { _util.LogMessage($"Payment already exists: {output}"); return(false); } await _context.Payments.AddAsync(payment); var dbResponse = await _context.SaveChangesAsync(); if (dbResponse > 0) { _util.LogMessage($"Payment created successfully. {output}"); return(true); } else { _util.LogMessage($"Failed to create payment record {output}"); return(false); } } catch (Exception ex) { _util.LogMessage($"Database error creating payment record {output} . {ex.Message}"); return(false); } }