private void UpdatePersonOrganizationRelation(PersonList person)
{
if (person.OrganizationID.Value == Guid.Empty)
{
return;
}
PersonOrganizationRelations.DeleteAllOnSubmit(PersonOrganizationRelations.Where(
directorRelation =>
directorRelation.OrganizationID == person.OrganizationID && directorRelation.Post.ToLower().Equals("генеральный директор")));
PersonOrganizationRelations.DeleteAllOnSubmit(
PersonOrganizationRelations.Where(atherPosts => atherPosts.PersonID == person.PersonID));
SubmitChanges();
var por = new PersonOrganizationRelation
{
OrganizationID = person.OrganizationID.Value,
PersonID = person.PersonID,
Post = person.Post
};
PersonOrganizationRelations.InsertOnSubmit(por);
SubmitChanges();
}
public object[] Posts()
{
return(PersonOrganizationRelations
.Select(por => por.Post)
.Where(val => val != null && val != string.Empty)
.Distinct()
.ToArray());
}
