public void UpdateUserReport(int userReportID, int reportLayoutStyleID, int formatTypeID, string userReportName, bool isSummaryOnly, List <RptParameter> parameters, bool isTurnOffPageBreak, bool includeTitlePage)
{
bool reportLayoutStyleChanged = false;
ReportProjectDBEntities entities = new ReportProjectDBEntities();
ReportLayoutStyle reportLayoutStyle = entities.ReportLayoutStyle.FirstOrDefault(rs => rs.ReportLayoutStyleID == reportLayoutStyleID);
UserReport ur = entities.UserReport.First(r => r.UserReportID == userReportID);
ur.ModifiedDate = DateTime.Now;
ur.UserReportName = userReportName;
ur.IsSummaryOnly = isSummaryOnly;
ur.IsTurnOffPageBreak = isTurnOffPageBreak;
ur.IncludeTitlePage = includeTitlePage;
ur.IsCustom = reportLayoutStyle.IsCustom;
if (ur.ReportLayoutStyleID != reportLayoutStyleID)
{
reportLayoutStyleChanged = true;
}
ur.ReportLayoutStyle = reportLayoutStyle;
ur.FormatType = entities.FormatType.FirstOrDefault(f => f.FormatTypeID == formatTypeID);
entities.SaveChanges();
var userReportParameters = from urp in entities.UserReportParameter
.Include("UserReport")
where urp.UserReport.UserReportID == userReportID
select urp;
foreach (var val in userReportParameters)
{
val.ParameterValue = parameters.First(v => v.UserReportParameterID == val.UserReportParameterID).DefaultValue;
}
if (!ur.IsCustom)
{
deleteUserReportSummarizeFields(userReportID);
deleteUserReportFields(userReportID);
}
entities.SaveChanges();
ReportDomainService domainService = new ReportDomainService();
if (reportLayoutStyleChanged)
{
domainService.RelocateSchedulesForUserReport(ur.UserReportID);
}
else
{
domainService.SynchronizeSchedulesForUserReport(ur.UserReportID);
}
}
private int saveUserReportFields(int userReportID, List <RptField> fields, int userId, List <RptField> summarizeFields)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
UserReport ur = entities.UserReport.Where(urp => urp.UserReportID == userReportID).First();
foreach (var field in fields)
{
string sortdir = "A";
if (field.SortDirection == SortDirectionEnum.Descending)
{
sortdir = "D";
}
UserReportField urf = new UserReportField();
urf.UserReport = ur;
urf.ReportField = entities.ReportField.Where(r => r.ReportFieldID == field.ReportFieldID).First();
urf.CreatedByUserID = userId;
urf.CreatedDate = DateTime.Now;
urf.ColumnOrder = field.ColumnOrder;
urf.CustomName = field.Name;
urf.SortDirection = sortdir;
urf.SortOrder = field.SortOrder;
urf.GroupOrder = field.GroupOrder;
urf.IncludePageBreak = field.IncludePageBreak;
urf.CoverageCode = field.CoverageCode;
entities.AddToUserReportField(urf);
}
entities.SaveChanges();
saveUserReportSummarizeFields(summarizeFields, entities, ur, userId);
return(ur.UserReportID);
}
private int saveUserReport(int reportID, int reportLayoutStyleID, string userReportName, bool isSummaryOnly, int userId, bool isCustom, string associationNumber, int formatTypeID, bool isTransient, bool isTurnOffPageBreak, bool includeTitlePage)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
ReportLayoutStyle reportLayoutStyle = entities.ReportLayoutStyle.FirstOrDefault(rl => rl.ReportLayoutStyleID == reportLayoutStyleID);
UserReport ur = new UserReport();
ur.ReportLayoutStyleID = reportLayoutStyle.ReportLayoutStyleID;
ur.FormatTypeID = formatTypeID;
ur.ReportID = reportID;
ur.UserID = userId;
ur.CreatedByUserID = userId;
ur.CreatedDate = DateTime.Now;
ur.ModifiedDate = DateTime.Now;
ur.UserReportName = userReportName;
ur.ModifiedByUserID = userId;
ur.IsCustom = isCustom;
ur.ClientNumber = associationNumber;
ur.IsSummaryOnly = isSummaryOnly;
ur.IsTransient = isTransient;
ur.IsTurnOffPageBreak = isTurnOffPageBreak;
ur.IncludeTitlePage = includeTitlePage;
entities.AddToUserReport(ur);
entities.SaveChanges();
return(ur.UserReportID);
}
private void deleteTransientUserReport(UserReport userReport, ReportProjectDBEntities entities)
{
// delete the summarize fields
var sumFields = (from ursf in entities.UserReportSummarizeField
where ursf.UserReportID == userReport.UserReportID
select ursf).ToList();
foreach (UserReportSummarizeField sumField in sumFields)
{
entities.DeleteObject(sumField);
}
// delete the fields
//TODO: NOt necessary, must be a cascade delete in the database
// delete the parameters
var userReportParms = (from urp in entities.UserReportParameter
where urp.UserReportID == userReport.UserReportID
select urp).ToList();
foreach (UserReportParameter userReportParameter in userReportParms)
{
entities.DeleteObject(userReportParameter);
}
// delete the user report
entities.DeleteObject(userReport);
entities.SaveChanges();
}
public void SetReportTypeCheckpoints(List <Rpt> reportTypes, string checkpointID)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
var removeReport_ICESecurityCheckpoint = from rptj in entities.Report_ICESecurityCheckpoint
where rptj.CheckpointID.Trim() == checkpointID.Trim()
select rptj;
foreach (Report_ICESecurityCheckpoint Report_ICESecurityCheckpoint in removeReport_ICESecurityCheckpoint)
{
entities.DeleteObject(Report_ICESecurityCheckpoint);
}
entities.SaveChanges();
foreach (Rpt rpt in reportTypes)
{
entities.AddToReport_ICESecurityCheckpoint(new Report_ICESecurityCheckpoint {
CheckpointID = checkpointID, ReportID = rpt.ID
});
}
entities.SaveChanges();
}
public void UpdateCustomUserReport(int userReportID, List <RptField> fields, int userId, List <RptField> summarizeFields)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
UserReport ur = entities.UserReport.First(r => r.UserReportID == userReportID);
ur.ModifiedDate = DateTime.Now;
deleteUserReportSummarizeFields(userReportID);
updateUserReportFields(userReportID, fields, userId, summarizeFields);
entities.SaveChanges();
}
private void createReportDeliveryLogRecord(int scheduleID, int?scheduleRecipientID, int?userReportOutputID)
{
using (ReportProjectDBEntities entities = new ReportProjectDBEntities())
{
ReportDeliveryLog rdl = new ReportDeliveryLog()
{
ScheduleID = scheduleID,
ScheduleRecipientID = scheduleRecipientID,
UserReportOutputID = userReportOutputID,
DeliveryDate = DateTime.Now
};
entities.AddToReportDeliveryLog(rdl);
entities.SaveChanges();
}
}
private void deleteUserReportSummarizeFields(int userReportID)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
var sumfields = from f in entities.UserReportSummarizeField
where f.UserReport.UserReportID == userReportID
select f;
if (sumfields != null && sumfields.Count() > 0)
{
foreach (UserReportSummarizeField field in sumfields)
{
entities.UserReportSummarizeField.DeleteObject(field);
}
entities.SaveChanges();
}
}
private void deleteUserReportFields(int userReportID)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
var userReportfieldList = from f in entities.UserReportField
where f.UserReport.UserReportID == userReportID
select f;
if (userReportfieldList != null && userReportfieldList.Count() > 0)
{
foreach (UserReportField field in userReportfieldList)
{
entities.UserReportField.DeleteObject(field);
}
entities.SaveChanges();
}
}
private void saveUserReportSummarizeFields(List <RptField> summarizeFields, ReportProjectDBEntities entities, UserReport userRpt, int userId)
{
if (summarizeFields != null)
{
foreach (RptField sumfield in summarizeFields)
{
UserReportField urfs = entities.UserReportField.First(urf => urf.UserReport.UserReportID == userRpt.UserReportID && urf.ReportField.ReportFieldID == sumfield.ReportFieldID);
UserReportSummarizeField ursf = new UserReportSummarizeField();
ursf.CreatedByUserID = userId;
ursf.CreatedDate = DateTime.Now;
ursf.UserReport = userRpt;
ursf.UserReportFieldID = urfs.UserReportFieldID;
entities.AddToUserReportSummarizeField(ursf);
}
}
entities.SaveChanges();
}
private void saveUserReportParameters(int userReportID, int userId, List <RptParameter> parameters)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
UserReport ur = entities.UserReport.Where(urp => urp.UserReportID == userReportID).First();
foreach (var parm in parameters)
{
UserReportParameter urp = new UserReportParameter();
urp.UserReport = ur;
urp.ReportParameter = entities.ReportParameter.Where(r => r.ReportParameterID == parm.ID).FirstOrDefault();
urp.ParameterValue = parm.DefaultValue;
urp.CreatedByUserID = userId;
urp.CreatedDate = DateTime.Now;
urp.FilterString = parm.FilterString;
entities.AddToUserReportParameter(urp);
}
entities.SaveChanges();
}
private int createUserReportOutputRecord(CcmsiUser user, UserReport userReport, DeliveredReportInfo info, string filename, ScheduleRecipient recipient)
{
using (ReportProjectDBEntities entities = new ReportProjectDBEntities())
{
UserReportOutput rpt = new UserReportOutput()
{
UserReport = entities.UserReport.Where(r => r.UserReportID == userReport.UserReportID).First(),
UserID = recipient.UserID,
FileName = filename,
ClientNumber = userReport.ClientNumber,
ReportRunDate = info.ExecutionDate,
CreatedDate = DateTime.Now,
CreatedByUserID = Convert.ToInt32(userReport.CreatedByUserID)
};
entities.AddToUserReportOutput(rpt);
entities.SaveChanges();
return(rpt.UserReportOutputID);
}
}
private int updateUserReportFields(int userReportID, List <RptField> fields, int userId, List <RptField> summarizeFields)
{
ReportProjectDBEntities entities = new ReportProjectDBEntities();
UserReport ur = entities.UserReport.Where(urp => urp.UserReportID == userReportID).First();
var userReportFielList = from fv in entities.UserReportField
.Include("UserReport")
where fv.UserReport.UserReportID == userReportID
select fv;
foreach (var field in userReportFielList)
{
if (!fields.Any(f => f.RptFieldID == field.UserReportFieldID))
{
entities.UserReportField.DeleteObject(field);
}
else
{
RptField myfield = fields.First(f => f.RptFieldID == field.UserReportFieldID);
string sortdir = "A";
if (myfield.SortDirection == SortDirectionEnum.Descending)
{
sortdir = "D";
}
UserReportField urf = new UserReportField();
field.ColumnOrder = myfield.ColumnOrder;
field.SortOrder = myfield.SortOrder;
field.SortDirection = sortdir;
field.GroupOrder = myfield.GroupOrder;
field.CustomName = myfield.Name;
field.IncludePageBreak = myfield.IncludePageBreak;
field.CoverageCode = myfield.CoverageCode;
}
}
//Add New UserReportFields
foreach (RptField field in fields)
{
if (field.RptFieldID == field.ReportFieldID)
{
if (field.IsUsed || field.SortOrder > 0)
{
string sortdir = "A";
if (field.SortDirection == SortDirectionEnum.Descending)
{
sortdir = "D";
}
UserReportField urf = new UserReportField();
urf.UserReport = ur;
urf.ReportField = entities.ReportField.Where(r => r.ReportFieldID == field.RptFieldID).First();
urf.CreatedByUserID = userId;
urf.CreatedDate = DateTime.Now;
urf.ColumnOrder = field.ColumnOrder;
urf.CustomName = field.Name;
urf.SortDirection = sortdir;
urf.SortOrder = field.SortOrder;
urf.GroupOrder = field.GroupOrder;
urf.IncludePageBreak = field.IncludePageBreak;
urf.CoverageCode = field.CoverageCode;
entities.AddToUserReportField(urf);
}
}
}
entities.SaveChanges();
saveUserReportSummarizeFields(summarizeFields, entities, ur, userId);
return(ur.UserReportID);
}
