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