private DataMenuSettingDTO ToDataMenuSettingDTO(DR_Requester requester, DataMenuSetting entity, bool withDetails) { var result = new DataMenuSettingDTO(); if (withDetails) { foreach (var item in entity.DataMenuSearchableReportRelationship) { //دسترسی به خود گزارش هم کنترل شود if (bizEntityRelationshipTail.DataIsAccessable(requester, item.EntityRelationshipTail)) { if (bizEntityReport.DataIsAccessable(requester, item.EntitySearchableReport.EntityReport)) { var tail = bizEntityRelationshipTail.ToEntityRelationshipTailDTO(item.EntityRelationshipTail); var entityReportDTO = new EntitySearchableReportDTO(); bizEntitySearchableReport.ToEntitySearchableReportDTO(item.EntitySearchableReport, entityReportDTO, withDetails); result.SearchableReportRelationships.Add(ToDataMenuSearchableReportRelationshipDTO(item, tail, entityReportDTO)); } } } foreach (var item in entity.DataMenuDataViewRelationship) { if (bizEntityRelationshipTail.DataIsAccessable(requester, item.EntityRelationshipTail)) { var tail = bizEntityRelationshipTail.ToEntityRelationshipTailDTO(item.EntityRelationshipTail); result.DataViewRelationships.Add(ToDataMenuDataViewRelationshipDTO(item, tail)); } } foreach (var item in entity.DataMenuGridViewRelationship) { if (bizEntityRelationshipTail.DataIsAccessable(requester, item.EntityRelationshipTail)) { var tail = bizEntityRelationshipTail.ToEntityRelationshipTailDTO(item.EntityRelationshipTail); result.GridViewRelationships.Add(ToDataMenuGridViewRelationshipDTO(item, tail)); } } foreach (var item in entity.DataMenuDataItemReportRelationship) { if (bizEntityReport.DataIsAccessable(requester, item.EntityDataItemReportID)) { var entityReportDTO = new EntityDataItemReportDTO(); bizEntityDataItemReport.ToEntityDataItemReportDTO(item.EntityDataItemReport, entityReportDTO, false); result.DataItemReports.Add(ToDataMenuDataItemReportRelationshipDTO(item, entityReportDTO)); } } } result.EntityID = entity.TableDrivedEntityID; result.EntityListViewID = entity.EntityListViewID; result.Name = entity.Name; if (entity.DataMenuForViewEntity.Any()) { result.RelationshipID = entity.DataMenuForViewEntity.First().RelationshipID; if (withDetails) { if (bizRelationship.DataIsAccessable(requester, entity.DataMenuForViewEntity.First().Relationship, false, true)) { result.Relationship = bizRelationship.ToRelationshipDTO(entity.DataMenuForViewEntity.First().Relationship); } } result.TargetDataMenuSettingID = entity.DataMenuForViewEntity.First().TargetDataMenuSettingID; if (withDetails) { result.DataMenuSetting = ToDataMenuSettingDTO(requester, entity.DataMenuForViewEntity.First().DataMenuSetting1, false); } } result.ID = entity.ID; if (withDetails) { result.IconContent = entity.IconContent; } return(result); }
//public List<EntityReportDataMenuRelationshipsDTO> GetEntityRelationshipReports(int entityID, bool withDetails) //{ // List<EntityReportDataMenuRelationshipsDTO> result = new List<EntityReportDataMenuRelationshipsDTO>(); // using (var projectContext = new DataAccess.MyProjectEntities()) // { // var entityReportSetting = projectContext.EntityReportDataMenuSetting.FirstOrDefault(x => x.ID == entityID); // if (entityReportSetting != null) // { // foreach (var item in entityReportSetting.EntityReportDataMenuRelationships) // { // result.Add(ToEntityReportDataMenuRelationshipsDTO(item, withDetails)); // } // } // } // return result; //} //private EntityReportDataMenuRelationshipsDTO ToEntityReportDataMenuRelationshipsDTO(EntityReportDataMenuRelationships dbRel, bool withDetails) //{ //} public void UpdateEntityReportDataMenuSettings(DataMenuSettingDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { DataMenuSetting dbEntity = null; if (message.ID != 0) { dbEntity = projectContext.DataMenuSetting.First(x => x.ID == message.ID); } else { dbEntity = new DataMenuSetting(); projectContext.DataMenuSetting.Add(dbEntity); } while (dbEntity.DataMenuSearchableReportRelationship.Any()) { projectContext.DataMenuSearchableReportRelationship.Remove(dbEntity.DataMenuSearchableReportRelationship.First()); } foreach (var item in message.SearchableReportRelationships) { DataMenuSearchableReportRelationship dbRel = new DataMenuSearchableReportRelationship(); // dbRel.RelationshipID = (item.RelationshipID == 0 ? (int?)null : item.RelationshipID); dbRel.EntityRelationshipTailID = item.RelationshipTailID; dbRel.EntitySearchableReportID = item.EntitySearchableReportID; dbRel.Group1 = item.Group1; dbEntity.DataMenuSearchableReportRelationship.Add(dbRel); } while (dbEntity.DataMenuDataViewRelationship.Any()) { projectContext.DataMenuDataViewRelationship.Remove(dbEntity.DataMenuDataViewRelationship.First()); } foreach (var item in message.DataViewRelationships) { DataMenuDataViewRelationship dbRel = new DataMenuDataViewRelationship(); dbRel.EntityRelationshipTailID = item.RelationshipTailID; dbRel.Group1 = item.Group1; if (item.TargetDataMenuSettingID != 0) { dbRel.TargetDataMenuSettingID = item.TargetDataMenuSettingID; } else { dbRel.TargetDataMenuSettingID = null; } dbEntity.DataMenuDataViewRelationship.Add(dbRel); } while (dbEntity.DataMenuGridViewRelationship.Any()) { projectContext.DataMenuGridViewRelationship.Remove(dbEntity.DataMenuGridViewRelationship.First()); } foreach (var item in message.GridViewRelationships) { DataMenuGridViewRelationship dbRel = new DataMenuGridViewRelationship(); dbRel.EntityRelationshipTailID = item.RelationshipTailID; dbRel.Group1 = item.Group1; if (item.TargetDataMenuSettingID != 0) { dbRel.TargetDataMenuSettingID = item.TargetDataMenuSettingID; } else { dbRel.TargetDataMenuSettingID = null; } dbEntity.DataMenuGridViewRelationship.Add(dbRel); } while (dbEntity.DataMenuDataItemReportRelationship.Any()) { projectContext.DataMenuDataItemReportRelationship.Remove(dbEntity.DataMenuDataItemReportRelationship.First()); } foreach (var item in message.DataItemReports) { DataMenuDataItemReportRelationship dbRel = new DataMenuDataItemReportRelationship(); dbRel.EntityDataItemReportID = item.EntityDataItemReportID; dbRel.Group1 = item.Group1; dbEntity.DataMenuDataItemReportRelationship.Add(dbRel); } while (dbEntity.DataMenuForViewEntity.Any()) { projectContext.DataMenuForViewEntity.Remove(dbEntity.DataMenuForViewEntity.First()); } if (message.RelationshipID != 0 && message.TargetDataMenuSettingID != 0) { DataMenuForViewEntity dbRel = new DataMenuForViewEntity(); dbRel.RelationshipID = message.RelationshipID; dbRel.TargetDataMenuSettingID = message.TargetDataMenuSettingID; dbEntity.DataMenuForViewEntity.Add(dbRel); } dbEntity.TableDrivedEntityID = message.EntityID; dbEntity.Name = message.Name; dbEntity.EntityListViewID = message.EntityListViewID; dbEntity.IconContent = message.IconContent; //dbEntity.EntityReportDataMenuSetting.IconContent = message.IconContent; projectContext.SaveChanges(); } }