public async Task UpsertStateAsync(State state)
{
var utcNow = DateTime.UtcNow;
var query = from item in _context.States
where item.Name == state.Name
select item;
var stateInDb = query.FirstOrDefault();
if (stateInDb == null)
{
state.Id = GuidS;
state.Created = utcNow;
state.Updated = utcNow;
_context.States.Add(state);
}
else
{
// now we update.
stateInDb.Name = state.Name;
stateInDb.Updated = utcNow;
stateInDb.Abbreviation = state.Abbreviation;
}
// leaving counties alone for now.
// _context.States.Update(stateInDb);
await _context.SaveChangesAsync();
}
