public int Save(UnionRelationshipDTO item) { using (var projectContext = new MyIdeaEntities()) { UnionRelationshipType dbItem = null; if (item.ID == 0) { dbItem = new UnionRelationshipType(); projectContext.UnionRelationshipType.Add(dbItem); } else { dbItem = projectContext.UnionRelationshipType.First(x => x.ID == item.ID); } dbItem.Name = item.Name; dbItem.IsTolatParticipation = item.IsTolatParticipation; dbItem.UnionHoldsKeys = item.UnionHoldsKeys; projectContext.SaveChanges(); return(dbItem.ID); } }
public UnionRelationshipDTO ToUnionRelationshipDTO(UnionRelationshipType item) { UnionRelationshipDTO result = new UnionRelationshipDTO(); result.Name = item.Name; result.ID = item.ID; result.IsTolatParticipation = item.IsTolatParticipation; result.UnionHoldsKeys = item.UnionHoldsKeys; result.SuperTypeEntities = ""; foreach (var superType in item.UnionToSubUnionRelationshipType) { if (!result.SuperTypeEntities.Contains(superType.RelationshipType.Relationship.TableDrivedEntity.Name)) { result.SuperTypeEntities += (result.SuperTypeEntities == "" ? "" : ",") + superType.RelationshipType.Relationship.TableDrivedEntity.Name; } } result.SubTypeEntities = ""; foreach (var subType in item.SubUnionToUnionRelationshipType) { result.SubTypeEntities += (result.SubTypeEntities == "" ? "" : ",") + subType.RelationshipType.Relationship.TableDrivedEntity.Name; } return(result); }
public void MergeUnionRelationships(string name, List <UnionRelationshipDTO> relationships, UnionRelationshipDTO selectedOne) { using (var projectContext = new MyIdeaEntities()) { // int UnionRelationID = 0; foreach (var relationship in relationships) { //if (relationship == selectedOne) // UnionRelationID = relationship.ID; //else //{ var dbRelationship = projectContext.UnionRelationshipType.First(x => x.ID == relationship.ID); foreach (var detail in dbRelationship.UnionToSubUnionRelationshipType) { detail.UnionRelationshipTypeID = selectedOne.ID; } foreach (var detail in dbRelationship.SubUnionToUnionRelationshipType) { detail.UnionRelationshipTypeID = selectedOne.ID; } //} } projectContext.SaveChanges(); } }