public void Insert(MortgageRate mrate)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO MortgageRate (Date, Value)
VALUES (@date, @value)";
cmd.Parameters.AddWithValue("@date", mrate.Date);
cmd.Parameters.AddWithValue("@value", mrate.Value);
cmd.ExecuteNonQuery();
}
}
}
public async Task <bool> SaveMortgageRateAsync(MortgageRate rate)
{
if (_context.Entry(rate).State == EntityState.Detached)
{
_context.Add(rate);
}
else if (_context.Entry(rate).State == EntityState.Modified)
{
_context.Update(rate);
}
if (_context.Entry(rate).State == EntityState.Unchanged)
{
return(true);
}
return(await _context.SaveChangesAsync() > 0);
}
public async Task <(bool Success, string Error)> SaveMortgageRateAsync(CreateMortgageRateViewModel model, string userId)
{
var success = false;
var error = "";
try
{
var rate = await _mortgageRepository.FetchMortgageRateAsync();
if (rate == null)
{
rate = new MortgageRate
{
CreatedUtc = DateTime.UtcNow,
CreatedUserId = userId
};
}
else
{
rate.AuditUserId = userId;
rate.AuditUtc = DateTime.UtcNow;
}
rate.Rate = model.Rate;
await _mortgageRepository.SaveMortgageRateAsync(rate);
success = true;
}
catch (Exception ex)
{
error = "Unexpected error occurred while processing your request";
_logger.LogError("MortgageService.SaveMortgageRateAsync - exception:{@Ex}", new object[] { ex });
}
return(success, error);
}
