public void PopulateRelations() { using (RelationEntities dbEntities = new RelationEntities()) { var raltionList = dbEntities.RelationShipTypes.ToList(); foreach (var relation in raltionList) { RelationShipModel item = new RelationShipModel { RelationName = relation.Name, RelationId = Convert.ToInt32(relation.ID) }; _relationList.Add(item); } } }
public void PopulatePerson() { using (RelationEntities dbEntities = new RelationEntities()) { var raltionList = dbEntities.People.ToList(); foreach (var relation in raltionList) { PersonModel item = new PersonModel { PersonName = relation.Name, PersonId = Convert.ToInt32(relation.PersonID) }; _personList.Add(item); } } }
private void AddRelation(object obj) { using (RelationEntities dbEntities = new RelationEntities()) { try { /***ADD RELATION ***/ var relation = new Relationship(); relation.RelationTypeID = _selectedRelation.RelationId; relation.FirstPersonID = _selectedPerson.PersonId; relation.SecondPersonID = _secondSelectedPerson.PersonId; dbEntities.Relationships.Add(relation); dbEntities.SaveChanges(); /****END**/ this.Message = "Relation Added Successfully."; } catch (Exception ex) { this.Message = ex.Message; } } }
public void AddRecord(object obj) { try { using (RelationEntities dbEntities = new RelationEntities()) { /*** ADD PERSON **/ perObject.Gender = _selectedGender.GenderName; perObject.Name = PersonFirstName; perObject.MaidenName = PersonMaidenName; perObject.LastName = PersonLastName; dbEntities.People.Add(perObject); dbEntities.SaveChanges(); /***END***/ /***ADD RELATION ***/ var relation = new Relationship(); relation.RelationTypeID = _selectedRelation.RelationId; relation.FirstPersonID = perObject.PersonID; relation.SecondPersonID = _selectedPerson.PersonId; dbEntities.Relationships.Add(relation); dbEntities.SaveChanges(); /****END**/ ClearControls(); this.Message= "Person Added Successfully."; } } catch (Exception ex) { this.Message = ex.Message; } }
public void PopulateNetworkView() { using (RelationEntities dbEntities = new RelationEntities()) { var relationList = dbEntities.Relationships.Where(x=>x.FirstPersonID== _selectedPerson.PersonId || x.SecondPersonID==_selectedPerson.PersonId).ToList(); foreach (var relation in relationList) { //RelationShipModel item = new RelationShipModel //{ // PersonName = relation.Name, // PersonId = Convert.ToInt32(relation.PersonID) //}; //_personList.Add(item); } } }