public EntityDirectReportDTO ToEntityDirectReportDTO(DR_Requester requester, EntityDirectlReport dbRel, bool withDetails)
{
var result = new EntityDirectReportDTO();
bizEntityReport.ToEntityReportDTO(dbRel.EntityDataItemReport.EntityReport, result, withDetails);
result.URL = dbRel.URL;
foreach (var item in dbRel.EntityDirectlReportParameters)
{
result.EntityDirectlReportParameters.Add(new EntityDirectlReportParameterDTO()
{
ColumnID = item.ColumnID,
ID = item.ID,
ParameterName = item.ParameterName
});
}
return(result);
}
public int UpdateEntityDirectReport(EntityDirectReportDTO message)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
//BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport();
BizEntityDataItemReport bizEntityDataItemReport = new BizEntityDataItemReport();
var dbEntitySpecifiedReport = projectContext.EntityDirectlReport.FirstOrDefault(x => x.ID == message.ID);
if (dbEntitySpecifiedReport == null)
{
message.ReportType = ReportType.DataItemReport;
dbEntitySpecifiedReport = new EntityDirectlReport();
dbEntitySpecifiedReport.EntityDataItemReport = bizEntityDataItemReport.ToNewEntityDataItemReport(message);
dbEntitySpecifiedReport.EntityDataItemReport.DataItemReportType = (short)DataItemReportType.DirectReport;
}
else
{
bizEntityDataItemReport.ToUpdateEntityDataItemReport(dbEntitySpecifiedReport.EntityDataItemReport, message);
}
dbEntitySpecifiedReport.URL = message.URL;
while (dbEntitySpecifiedReport.EntityDirectlReportParameters.Any())
{
projectContext.EntityDirectlReportParameters.Remove(dbEntitySpecifiedReport.EntityDirectlReportParameters.First());
}
foreach (var item in message.EntityDirectlReportParameters)
{
dbEntitySpecifiedReport.EntityDirectlReportParameters.Add(new EntityDirectlReportParameters()
{
ColumnID = item.ColumnID,
ParameterName = item.ParameterName
});
}
if (dbEntitySpecifiedReport.ID == 0)
{
projectContext.EntityDirectlReport.Add(dbEntitySpecifiedReport);
}
projectContext.SaveChanges();
return(dbEntitySpecifiedReport.ID);
}
}
