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();
}
}
