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);
}
}
