/// <summary>
/// Delete Identifier
/// </summary>
/// <param name="context"></param>
/// <param name="personId"></param>
public void DeleteIdentifier(TestProjectDbContext context, Guid personId)
{
Person person = context.Person.AsNoTracking().FirstOrDefault(x => x.Id == personId);
if (person == null)
{
throw new ErrorException("Person Id is invalid");
}
var identifiers = context.Identifier.Where(x => x.PersonId == personId);
foreach (var identifier in identifiers)
{
context.Entry(identifier).State = EntityState.Deleted;
}
context.Identifier.RemoveRange();
context.SaveChanges();
}
/// <summary>
/// Create Identifier
/// </summary>
/// <param name="context"></param>
/// <param name="model"></param>
public void CreateIdentifier(TestProjectDbContext context, Identifier model)
{
context.Identifier.Add(model);
context.Entry(model).State = EntityState.Added;
context.SaveChanges();
}
/// <summary>
/// Create person
/// </summary>
/// <param name="context"></param>
/// <param name="model"></param>
public void CreatePerson(TestProjectDbContext context, Person model)
{
context.Person.Add(model);
context.Entry(model).State = EntityState.Added;
context.SaveChanges();
}
/// <summary> /// /// </summary> /// <param name="context"></param> /// <param name="personId"></param> /// <returns></returns> public Person GetPersonbyId(TestProjectDbContext context, Guid personId) => context.Person.FirstOrDefault(x => x.Id == personId && !x.Deleted);
/// <summary>
/// GetPersonBySpecificIdentifiers
/// </summary>
/// <param name="context"></param>
/// <param name="enumType"></param>
/// <returns></returns>
public IList <Person> GetPersonBySpecificIdentifiers(TestProjectDbContext context, IdentifiersType enumType)
{
return(context.Person.Where(x => x.Identifiers.Any(i => i.Type == enumType) && !x.Deleted).ToList());
}
/// <summary>
/// Get all Person By FirstName Or LastName
/// </summary>
/// <param name="context"></param>
/// <param name="firstname"></param>
/// <param name="lastname"></param>
/// <returns></returns>
public IList <Person> GetPersonByFirstNameOrLastName(TestProjectDbContext context, string firstname, string lastname)
{
List <Person> list = context.Person.Where(x => x.FirstName.Equals(firstname) || x.LastName.Equals(lastname) && !x.Deleted).Include(x => x.Identifiers).ToList();
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public IList <Person> GetPersonWithIdentfier(TestProjectDbContext context)
{
List <Person> list = context.Person.Include(x => x.Identifiers).Where(x => !x.Deleted).ToList();
return(list);
}
/// <summary>
/// update person
/// </summary>
/// <param name="context"></param>
/// <param name="person"></param>
public void UpdatePerson(TestProjectDbContext context, Person person)
{
context.Entry(person).State = EntityState.Modified;
context.SaveChanges();
}
/// <summary>
/// Delete Person
/// </summary>
/// <param name="context"></param>
/// <param name="person"></param>
public void DeletePerson(TestProjectDbContext context, Person person)
{
person.Deleted = true;
context.Entry(person).State = EntityState.Modified;
context.SaveChanges();
}
