public PublishReportResponse DeleteReport(PublishReportRequest Request)
{
try
{
PublishReportResponse result = new PublishReportResponse();
Epi.Web.Interfaces.DataInterfaces.IReportDao IReportDao = new EF.EntityReportDao();
Epi.Web.BLL.Report Implementation = new Epi.Web.BLL.Report(IReportDao);
ReportInfoBO ReportInfoBO = Mapper.ToReportInfoBO(Request.ReportInfo);
Implementation.DeleteReport(ReportInfoBO);
result.Message = "The report was successfully Deleted";
return(result);
}
catch (Exception ex)
{
CustomFaultException customFaultException = new CustomFaultException();
customFaultException.CustomMessage = ex.Message;
customFaultException.Source = ex.Source;
customFaultException.StackTrace = ex.StackTrace;
customFaultException.HelpLink = ex.HelpLink;
throw new FaultException <CustomFaultException>(customFaultException);
}
}
internal static ReportInfoBO ToReportInfoBO(SurveyReportsInfo reportInfo)
{
ReportInfoBO ReportInfoBO = new ReportInfoBO();
ReportInfoBO.CreatedDate = reportInfo.DateCreated;
ReportInfoBO.EditedDate = (DateTime)reportInfo.DateEdited;
if (!string.IsNullOrEmpty(reportInfo.ReportId.ToString()))
{
ReportInfoBO.ReportId = reportInfo.ReportId.ToString();
}
if (!string.IsNullOrEmpty(reportInfo.SurveyId.ToString()))
{
ReportInfoBO.SurveyId = reportInfo.SurveyId.ToString();
}
ReportInfoBO.ReportVersion = reportInfo.ReportVersion;
ReportInfoBO.DataSource = reportInfo.DataSource;
ReportInfoBO.Gadgets = new List <GadgetBO>();
foreach (var item in reportInfo.SurveyReports.OrderBy(x => x.GadgetNumber))
{
ReportInfoBO.Gadgets.Add(ToGadgetBO(item));
}
ReportInfoBO.RecordCount = reportInfo.RecordCount;
return(ReportInfoBO);
}
public PublishReportResponse PublishReport(PublishReportRequest Request)
{
try
{
PublishReportResponse result = new PublishReportResponse();
Epi.Web.Interfaces.DataInterfaces.IReportDao IReportDao = new EF.EntityReportDao();
Epi.Web.BLL.Report Implementation = new Epi.Web.BLL.Report(IReportDao);
ReportInfoBO ReportInfoBO = Mapper.ToReportInfoBO(Request.ReportInfo);
Implementation.PublishReport(ReportInfoBO);
result.Message = "The report was successfully published";
var ReportInfo = new ReportInfoDTO();
ReportInfo.ReportURL = ConfigurationManager.AppSettings["ReportURL"] + Request.ReportInfo.ReportId;
result.Reports = new List <ReportInfoDTO>();
result.Reports.Add(ReportInfo);
return(result);
}
catch (Exception ex)
{
CustomFaultException customFaultException = new CustomFaultException();
customFaultException.CustomMessage = ex.Message;
customFaultException.Source = ex.Source;
customFaultException.StackTrace = ex.StackTrace;
customFaultException.HelpLink = ex.HelpLink;
throw new FaultException <CustomFaultException>(customFaultException);
}
}
public List <ReportInfoBO> GetReport(string ReportID)
{
List <ReportInfoBO> ReportInfoBOList = new List <ReportInfoBO>();
try
{
ReportInfoBO ReportInfoBO = new ReportInfoBO();
var reportid = Guid.Parse(ReportID);
using (var Context = DataObjectFactory.CreateContext())
{
var Query = Context.SurveyReportsInfoes.Where(x => x.ReportId == reportid);//.OrderBy(x=>x.GadgetNumber);
foreach (var item in Query)
{
ReportInfoBO = Mapper.ToReportInfoBO(item);
ReportInfoBOList.Add(ReportInfoBO);
}
}
return(ReportInfoBOList);
}
catch (Exception ex)
{
throw (ex);
}
}
internal static SurveyReportsInfo ToReportInfoEF(ReportInfoBO reportInfo)
{
SurveyReportsInfo SurveyReport = new SurveyReportsInfo();
SurveyReport.DateCreated = reportInfo.CreatedDate;
SurveyReport.DateEdited = reportInfo.EditedDate;
if (!string.IsNullOrEmpty(reportInfo.ReportId.ToString()))
{
SurveyReport.ReportId = Guid.Parse(reportInfo.ReportId);
}
if (!string.IsNullOrEmpty(reportInfo.SurveyId.ToString()))
{
SurveyReport.SurveyId = Guid.Parse(reportInfo.SurveyId);
}
SurveyReport.ReportVersion = reportInfo.ReportVersion;
SurveyReport.DataSource = reportInfo.DataSource;
SurveyReport.RecordCount = reportInfo.RecordCount;
SurveyReport.SurveyReports = ToGadgetsEF(reportInfo.Gadgets);
return(SurveyReport);
}
public static ReportInfoBO ToReportInfoBO(ReportInfoDTO reportInfo)
{
ReportInfoBO ReportInfoBO = new ReportInfoBO();
ReportInfoBO.CreatedDate = reportInfo.CreatedDate;
ReportInfoBO.EditedDate = reportInfo.EditedDate;
ReportInfoBO.ReportId = reportInfo.ReportId;
ReportInfoBO.ReportVersion = reportInfo.ReportVersion;
ReportInfoBO.SurveyId = reportInfo.SurveyId;
ReportInfoBO.ReportURL = reportInfo.ReportURL;
ReportInfoBO.Gadgets = ToReportInfoBOList(reportInfo.Gadgets);
ReportInfoBO.RecordCount = reportInfo.RecordCount;
ReportInfoBO.DataSource = reportInfo.DataSource;
return(ReportInfoBO);
}
public List <ReportInfoBO> GetSurveyReports(string SurveyID, bool IncludHTML)
{
try
{
var surveyid = Guid.Parse(SurveyID);
List <ReportInfoBO> List = new List <ReportInfoBO>();
using (var Context = DataObjectFactory.CreateContext())
{
if (IncludHTML)
{
var Query = Context.SurveyReportsInfoes.Where(x => x.SurveyId == surveyid);
foreach (var item in Query)
{
List.Add(Mapper.ToReportInfoBO(item));
}
}
else
{
var NoHtmlQuery = (from response in Context.SurveyReportsInfoes
where response.SurveyId == surveyid
select new { response.ReportId, response.ReportVersion, response.DateCreated, response.DateEdited, response.DataSource, response.RecordCount });
foreach (var reportInfo in NoHtmlQuery)
{
ReportInfoBO ReportInfoBO = new ReportInfoBO();
ReportInfoBO.CreatedDate = reportInfo.DateCreated;
ReportInfoBO.EditedDate = (DateTime)reportInfo.DateEdited;
if (!string.IsNullOrEmpty(reportInfo.ReportId.ToString()))
{
ReportInfoBO.ReportId = reportInfo.ReportId.ToString();
}
ReportInfoBO.DataSource = reportInfo.DataSource;
ReportInfoBO.RecordCount = reportInfo.RecordCount;
ReportInfoBO.ReportVersion = reportInfo.ReportVersion;
List.Add(ReportInfoBO);
}
}
}
return(List);
}
catch (Exception ex)
{
throw (ex);
}
}
public static ReportInfoDTO ToReportInfoDTO(ReportInfoBO reportInfo)
{
ReportInfoDTO ReportDTO = new ReportInfoDTO();
ReportDTO.CreatedDate = reportInfo.CreatedDate;
ReportDTO.EditedDate = reportInfo.EditedDate;
ReportDTO.ReportId = reportInfo.ReportId;
ReportDTO.ReportVersion = reportInfo.ReportVersion;
ReportDTO.SurveyId = reportInfo.SurveyId;
ReportDTO.DataSource = reportInfo.DataSource;
ReportDTO.RecordCount = reportInfo.RecordCount;
if (reportInfo.Gadgets != null)
{
ReportDTO.Gadgets = ToGadgetsListDTO(reportInfo.Gadgets);
}
return(ReportDTO);
}
public void DeleteReport(ReportInfoBO Report)
{
if (ReportExist2(Guid.Parse(Report.ReportId)))
{
Guid ReportId = Guid.Parse(Report.ReportId);
using (var Context = DataObjectFactory.CreateContext())
{
var Query = from SurveyReport in Context.SurveyReports
where SurveyReport.ReportId == ReportId && SurveyReport.GadgetVersion == Report.ReportVersion
select SurveyReport;
foreach (var item in Query)
{
Context.SurveyReports.Remove(item);
}
Context.SaveChanges();
}
}
}
public void PublishReport(ReportInfoBO reportBO)
{
this.ReportDao.PublishReport(reportBO);
}
public void DeleteReport(ReportInfoBO reportBO)
{
this.ReportDao.DeleteReport(reportBO);
}
public void PublishReport(ReportInfoBO ReportInfo)
{
try
{
var SurveyId = Guid.Parse(ReportInfo.SurveyId);
//var GadgetId = Guid.Parse(ReportInfo.GadgetId);
var ReportId = Guid.Parse(ReportInfo.ReportId);
using (var Context = DataObjectFactory.CreateContext())
{
if (!ReportExist(SurveyId, ReportId))
{
SurveyReportsInfo ReportEntity = Mapper.ToReportInfoEF(ReportInfo);
Context.SurveyReportsInfoes.Add(ReportEntity);
Context.SaveChanges();
}
else
{
var Query = from SurveyReportInfo in Context.SurveyReportsInfoes
where SurveyReportInfo.ReportId == ReportId
select SurveyReportInfo;
var DataRow = Query.Single();
DataRow.DateEdited = DateTime.Now;
DataRow.RecordCount = ReportInfo.RecordCount;
DataRow.ReportVersion = ReportInfo.ReportVersion + 1;
DataRow.DataSource = ReportInfo.DataSource;
Context.SaveChanges();
// update Gadget
foreach (var gadget in ReportInfo.Gadgets)
{
var GadgetId = Guid.Parse(gadget.GadgetId);
var GadgetQuery = from SurveyReport in Context.SurveyReports
where SurveyReport.ReportId == ReportId && SurveyReport.GadgetId == GadgetId
select SurveyReport;
if (GadgetQuery != null && GadgetQuery.Count() > 0)
{
var GadgetDataRow = GadgetQuery.Single();
GadgetDataRow.DateEdited = DateTime.Now;
GadgetDataRow.GadgetVersion = gadget.GadgetVersion + 1;
GadgetDataRow.ReportHtml = gadget.ReportHtml;
Context.SaveChanges();
}
else
{
List <SurveyReport> ReportEntity = Mapper.ToGadgetsEF(ReportInfo.Gadgets);
foreach (var item in ReportEntity)
{
Context.SurveyReports.Add(item);
}
Context.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
