public int Create(PersonEntity personEntity)
{
PersonContext personContext = new PersonContext();
personContext.Persons.Add(personEntity);
personContext.SaveChanges();
return(1);
}
public PersonEntity Update(PersonEntity person)
{
lock (_personTable)
{
var old = Get(person.Id);
old.Name = person.Name;
return(old);
}
}
public PersonEntity Insert(PersonEntity person)
{
if (Exists(person.Id))
{
throw new InvalidOperationException($"Key exists {person.Id}");
}
person.Id = ++lastId;
_personTable.Add(person);
return(person);
}
public PersonEntity Insert(PersonEntity person)
{
if (Exists(person.Id))
{
throw new InvalidOperationException($"Key exists {person.Id}");
}
lock (_personTable)
{
int lastId = _personTable.Max(m => m.Id);
person.Id = ++lastId;
_personTable.Add(person);
}
return(person);
}
public bool Exists(int personId)
{
PersonContext db = new PersonContext();
PersonEntity personEntity = new PersonEntity();
var person = db.Persons.Where(p => p.Id == personId).FirstOrDefault();
if (person != null) // update
{
return(false);
}
else
{
return(true);
}
}
private ActorPersonDto InsertOrUpdate(ActorPersonDto dto)
{
using (var adapter = new DataAccessAdapter())
{
var data = new LinqMetaData(adapter);
var entity = data.Person.FirstOrDefault(ActorPersonDtoPersistence.CreatePkPredicate(dto));
if (entity == null)
{
entity = new PersonEntity();
}
entity.UpdateFromActorPersonDto(dto);
adapter.SaveEntity(entity, true);
//We need to do this extra call as per https://www.llblgen.com/Documentation/5.3/Derived%20Models/dto_llblgen.htm#example-projection-on-database-query
var result = data.Person.Where(x => x.Id == entity.Id).ProjectToActorPersonDto().ToList();
return(result[0]);
}
}
