public void UpdateEntityExternalReports(DR_Requester requester, EntityExternalReportDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport(); var dbEntitySpecifiedReport = projectContext.EntityExternalReport.FirstOrDefault(x => x.ID == message.ID); if (dbEntitySpecifiedReport == null) { message.ReportType = ReportType.SearchableReport; message.SearchableReportType = SearchableReportType.ExternalReport; dbEntitySpecifiedReport = new EntityExternalReport(); dbEntitySpecifiedReport.EntitySearchableReport = bizEntitySearchableReport.ToNewEntitySearchableReport(message); } else { bizEntitySearchableReport.ToUpdateEntitySearchableReport(dbEntitySpecifiedReport.EntitySearchableReport, message); } dbEntitySpecifiedReport.URL = message.URL; if (dbEntitySpecifiedReport.ID == 0) { projectContext.EntityExternalReport.Add(dbEntitySpecifiedReport); } var entity = new BizTableDrivedEntity().GetSimpleEntityWithColumns(requester, message.TableDrivedEntityID); CreateReportTable(entity); //ساختن جدول معادل projectContext.SaveChanges(); } }
public void UpdateEntityGridViewReports(EntityGridViewReportDTO message) { BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport(); using (var projectContext = new DataAccess.MyProjectEntities()) { var dbEntitySpecifiedReport = projectContext.EntityGridViewReport.FirstOrDefault(x => x.ID == message.ID); if (dbEntitySpecifiedReport == null) { message.ReportType = ReportType.SearchableReport; message.SearchableReportType = SearchableReportType.GridView; dbEntitySpecifiedReport = new EntityGridViewReport(); dbEntitySpecifiedReport.EntitySearchableReport = bizEntitySearchableReport.ToNewEntitySearchableReport(message); } else { bizEntitySearchableReport.ToUpdateEntitySearchableReport(dbEntitySpecifiedReport.EntitySearchableReport, message); } dbEntitySpecifiedReport.DataMenuSettingID = message.DataMenuSettingID; //while (dbEntityGridViewReport.EntityGridViewReportSubs1.Any()) // projectContext.EntityGridViewReportSubs.Remove(dbEntityGridViewReport.EntityGridViewReportSubs1.First()); //foreach (var sub in message.EntityGridViewReportSubs) //{ // EntityGridViewReportSubs rColumn = new EntityGridViewReportSubs(); // rColumn.Title = sub.Title; // rColumn.ChildEntityGridViewReportID = sub.EntityGridViewReportID; // rColumn.OrderID = sub.OrderID; // rColumn.RelationshipID = sub.RelationshipID; // dbEntityGridViewReport.EntityGridViewReportSubs1.Add(rColumn); //} if (dbEntitySpecifiedReport.ID == 0) { projectContext.EntityGridViewReport.Add(dbEntitySpecifiedReport); } projectContext.SaveChanges(); } }
public void UpdateEntityDataLinkReports(EntityDataLinkReportDTO message) { BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport(); using (var projectContext = new DataAccess.MyProjectEntities()) { var dbEntityDataLinkReport = projectContext.EntityDataLinkReport.FirstOrDefault(x => x.ID == message.ID); if (dbEntityDataLinkReport == null) { dbEntityDataLinkReport = new DataAccess.EntityDataLinkReport(); dbEntityDataLinkReport.EntityReport = bizEntityReport.ToNewEntityReport(message as EntityReportDTO, ReportType.DataLink); } else { bizEntityReport.ToUpdateEntityReport(dbEntityDataLinkReport.EntityReport, message as EntityReportDTO); } dbEntityDataLinkReport.EntityReport.Title = message.ReportTitle; dbEntityDataLinkReport.DataLinkDefinitionID = message.DataLinkID; //while (dbEntityDataLinkReport.EntityDataLinkReportSubs1.Any()) // projectContext.EntityDataLinkReportSubs.Remove(dbEntityDataLinkReport.EntityDataLinkReportSubs1.First()); //foreach (var sub in message.EntityDataLinkReportSubs) //{ // EntityDataLinkReportSubs rColumn = new EntityDataLinkReportSubs(); // rColumn.Title = sub.Title; // rColumn.ChildEntityDataLinkReportID = sub.EntityDataLinkReportID; // rColumn.OrderID = sub.OrderID; // rColumn.RelationshipID = sub.RelationshipID; // dbEntityDataLinkReport.EntityDataLinkReportSubs1.Add(rColumn); //} if (dbEntityDataLinkReport.ID == 0) { projectContext.EntityDataLinkReport.Add(dbEntityDataLinkReport); } projectContext.SaveChanges(); } }
public void UpdateEntityListReportGroupeds(EntityListReportGroupedDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport(); var dbEntityListReportGrouped = projectContext.EntityListReportGrouped.FirstOrDefault(x => x.ID == message.ID); if (dbEntityListReportGrouped == null) { dbEntityListReportGrouped = new DataAccess.EntityListReportGrouped(); dbEntityListReportGrouped.EntityReport = bizEntityReport.ToNewEntityReport(message as EntityReportDTO, ReportType.ListReportGrouped); } else { bizEntityReport.ToUpdateEntityReport(dbEntityListReportGrouped.EntityReport, message as EntityReportDTO); } dbEntityListReportGrouped.EntityReport.Title = message.ReportTitle; dbEntityListReportGrouped.EntityListReportID = message.EntityListReportID; //while (dbEntityListReportGrouped.ReportGroups.Any()) // projectContext.ReportGroups.Remove(dbEntityListReportGrouped.ReportGroups.First()); //foreach (var sub in message.ReportGroups) //{ // ReportGroups rColumn = new ReportGroups(); // rColumn.EntityListViewColumnsID = sub.ListViewColumnID; // dbEntityListReportGrouped.ReportGroups.Add(rColumn); //} if (dbEntityListReportGrouped.ID == 0) { projectContext.EntityListReportGrouped.Add(dbEntityListReportGrouped); } projectContext.SaveChanges(); } }
public void UpdateEntityListReports(EntityListReportDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport(); var dbEntitySpecifiedReport = projectContext.EntityListReport.FirstOrDefault(x => x.ID == message.ID); if (dbEntitySpecifiedReport == null) { message.ReportType = ReportType.SearchableReport; message.SearchableReportType = SearchableReportType.ListReport; dbEntitySpecifiedReport = new EntityListReport(); dbEntitySpecifiedReport.EntitySearchableReport = bizEntitySearchableReport.ToNewEntitySearchableReport(message); } else { bizEntitySearchableReport.ToUpdateEntitySearchableReport(dbEntitySpecifiedReport.EntitySearchableReport, message); } dbEntitySpecifiedReport.EntityListViewID = message.EntityListViewID; while (dbEntitySpecifiedReport.EntityListReportSubs1.Any()) { while (dbEntitySpecifiedReport.EntityListReportSubs1.First().EntityListReportSubsColumns.Any()) { projectContext.EntityListReportSubsColumns.Remove(dbEntitySpecifiedReport.EntityListReportSubs1.First().EntityListReportSubsColumns.First()); } projectContext.EntityListReportSubs.Remove(dbEntitySpecifiedReport.EntityListReportSubs1.First()); } foreach (var sub in message.EntityListReportSubs) { EntityListReportSubs dbSubReport = new EntityListReportSubs(); dbSubReport.Title = sub.Title; dbSubReport.ChildEntityListReportID = sub.EntityListReportID; dbSubReport.OrderID = sub.OrderID; dbSubReport.EntityRelationshipTailID = sub.EntityRelationshipTailID; foreach (var subColumn in sub.SubsColumnsDTO) { EntityListReportSubsColumns rSubsColumn = new EntityListReportSubsColumns(); rSubsColumn.ParentEntityListViewColumnsID = subColumn.ParentEntityListViewColumnsID; rSubsColumn.ChildEntityListViewColumnsID = subColumn.ChildEntityListViewColumnsID; dbSubReport.EntityListReportSubsColumns.Add(rSubsColumn); } dbEntitySpecifiedReport.EntityListReportSubs1.Add(dbSubReport); } while (dbEntitySpecifiedReport.ReportGroups.Any()) { projectContext.ReportGroups.Remove(dbEntitySpecifiedReport.ReportGroups.First()); } foreach (var sub in message.ReportGroups) { ReportGroups rColumn = new ReportGroups(); rColumn.EntityListViewColumnsID = sub.ListViewColumnID; dbEntitySpecifiedReport.ReportGroups.Add(rColumn); } if (dbEntitySpecifiedReport.ID == 0) { projectContext.EntityListReport.Add(dbEntitySpecifiedReport); } projectContext.SaveChanges(); } }