public void AddOrUpdateUser(User user) { using (var context = new CleanCityContext()) { var sqlUser = context.Users.SingleOrDefault(x => x.UserId == user.UserId); if (sqlUser == null) { context.Users.Add(new UserSql { Email = user.Email, UserId = user.UserId, Address = user.Address, Username = user.Username, }); context.SaveChanges(); } else { sqlUser.Email = user.Email; sqlUser.Username = user.Username; sqlUser.Address = user.Address; context.Update(sqlUser); context.SaveChanges(); } } }
public Guid AddResponsible(Responsible responsible) { using (var context = new CleanCityContext()) { // todo(sivukhin, 18.05.2019): Fix data race here var sqlResponsible = context.ResponsibleList.SingleOrDefault(x => x.Id == responsible.Id); if (sqlResponsible != null) { sqlResponsible.Name = responsible.Name; sqlResponsible.Email = responsible.Email; sqlResponsible.ResponseRegion = responsible.ResponseRegion; context.Update(sqlResponsible); } else { context.ResponsibleList.Add(new ResponsibleSql { Id = responsible.Id, Name = responsible.Name, Email = responsible.Email, IsActive = responsible.IsActive, ResponseRegion = responsible.ResponseRegion, }); } context.SaveChanges(); return(responsible.Id); } }