Exemple #1
0
        private void LoadReportQueriesCompleted(LoadOperation <ReportCategory> lo)
        {
            var ReportCategories = new ObservableCollection <ReportCategory>(lo.Entities);
            var dialog           = SimpleServiceLocator.Instance.Get <IModalWindow>("PublishToUcbDialog");

            this.modalDialogService = SimpleServiceLocator.Instance.Get <IModalDialogService>();
            this.modalDialogService.ShowDialog(dialog, new PublishToUcbViewModel(ReportCategories, SelectedReport != null ? SelectedReport.Name : null, SelectedReport != null ? SelectedReport.Description : null),
                                               returnedViewModelInstance =>
            {
                if (dialog.DialogResult.HasValue && dialog.DialogResult.Value)
                {
                    StandardReport spToPublish      = new StandardReport();
                    spToPublish.IsExportable        = returnedViewModelInstance.IsExportAllowed;
                    spToPublish.IsPrintable         = returnedViewModelInstance.IsPrintAllowed;
                    spToPublish.ReportCategoryCode  = returnedViewModelInstance.SelectedCategory.Code;
                    spToPublish.ReportToPublishCode = selectedReport.Code;
                    spToPublish.ReportName          = returnedViewModelInstance.Name;
                    spToPublish.ReportDescription   = returnedViewModelInstance.Description;
                    spToPublish.Code    = Guid.NewGuid();
                    IsPublishing        = true;
                    IsSubmittingContext = true;
                    myContext.StandardReports.Add(spToPublish);
                    myContext.SubmitChanges(ReportPublishedCallback, spToPublish);
                }
            });
        }
Exemple #2
0
        /// <summary>
        /// Gets the report by id.
        /// </summary>
        /// <param name="id">The id.</param>
        /// <param name="parameter">The parameter.</param>
        /// <returns></returns>
        public BaseReport GetReportById(int reportId, ReportParameter parameter)
        {
            if (reportId > 0)
            {
                var standardReport = new StandardReport(reportId)
                {
                    ResultDataTable       = StandardReportRepository.GetReportById(reportId, parameter),
                    Columns               = StandardReportRepository.GetReportColumns(reportId).ToList(),
                    ExtraHeaderCollection = StandardReportRepository.GetExtraHeaderById(reportId).ToList()
                };

                if (parameter.Unit != null && parameter.Unit != ConstValues.Unit_100M)
                {
                    foreach (var c in standardReport.Columns)
                    {
                        if (c.ColumnType == null || !c.ColumnType.Equals("decimal"))
                        {
                            continue;
                        }
                        foreach (var r in standardReport.ResultDataTable.AsEnumerable())
                        {
                            if (r[c.ColumnName] != null && r[c.ColumnName].GetType() != typeof(DBNull))
                            {
                                r[c.ColumnName] = Convert.ToDecimal(SwitchAmountUnit(parameter.Unit, Convert.ToDouble(r[c.ColumnName])));
                            }
                        }
                    }
                }
                return(standardReport);
            }
            return(new StandardReport(reportId));
        }
        public static void _Main()
        {
            Simulation simulation = new Simulation(new TheModel());

            StandardReport.PrintReport(simulation);
            Console.WriteLine();
        }
Exemple #4
0
        private void ReportPublishedCallback(SubmitOperation so)
        {
            StandardReport spToPublish = so.UserState as StandardReport;

            //DeleteFolderCommand.UpdateCanExecuteCommand();
            IsPublishing        = false;
            IsSubmittingContext = false;
        }
Exemple #5
0
        public void GenerateAndShow()
        {
            var reportModel = DataSource.GetReport();
            var report      = new StandardReport(reportModel);

            var path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, $"test_result.pdf");

            using var stream = new FileStream(path, FileMode.Create);
            report.GeneratePdf(stream);

            Process.Start("explorer.exe", path);
        }
 public StatisticalReportViewModel(int id, StandardReport sumStandardReport, StandardReport detailStandardReport)
     : base(id, detailStandardReport)
 {
     TopChart = new ChartViewModel {
         ChartName = "Top Chart" + id
     };
     BottomChart = new ChartViewModel {
         ChartName = "Bottom Chart" + id
     };
     SumGrid    = sumStandardReport;
     DetailGrid = detailStandardReport;
 }
Exemple #7
0
        public BaseReport GetStructureReportById(int reportId, ReportParameter parameter)
        {
            if (reportId > 0)
            {
                var standardReport = new StandardReport(reportId)
                {
                    ResultDataTable       = StandardReportRepository.GetStructureReportById(reportId, parameter),
                    Columns               = StandardReportRepository.GetReportColumns(reportId).ToList(),
                    ExtraHeaderCollection = StandardReportRepository.GetExtraHeaderById(reportId).ToList()
                };


                return(standardReport);
            }
            return(new StandardReport(reportId));
        }
Exemple #8
0
        public void SetUp()
        {
            var model = DataSource.GetReport();

            Report = new StandardReport(model);
        }
        /// <summary>
        ///  Create a StandardReport
        /// </summary>
        /// <param name="currentUser"></param>
        /// <param name="user"></param>
        /// <param name="appID"></param>
        /// <param name="overrideID"></param>
        /// <param name="dc"></param>
        /// <param name="dataRepository"></param>
        /// <param name="uow"></param>
        public StandardReportVMDC CreateStandardReport(string currentUser, string user, string appID, string overrideID, StandardReportDC dc, IRepository <StandardReport> dataRepository, IUnitOfWork uow, IExceptionManager exceptionManager, IMappingService mappingService)
        {
            try
            {
                #region Parameter validation

                // Validate parameters
                if (string.IsNullOrEmpty(currentUser))
                {
                    throw new ArgumentOutOfRangeException("currentUser");
                }
                if (string.IsNullOrEmpty(user))
                {
                    throw new ArgumentOutOfRangeException("user");
                }
                if (string.IsNullOrEmpty(appID))
                {
                    throw new ArgumentOutOfRangeException("appID");
                }
                if (null == dc)
                {
                    throw new ArgumentOutOfRangeException("dc");
                }
                if (null == dataRepository)
                {
                    throw new ArgumentOutOfRangeException("dataRepository");
                }
                if (null == uow)
                {
                    throw new ArgumentOutOfRangeException("uow");
                }
                if (null == exceptionManager)
                {
                    throw new ArgumentOutOfRangeException("exceptionManager");
                }
                if (null == mappingService)
                {
                    throw new ArgumentOutOfRangeException("mappingService");
                }

                #endregion

                using (uow)
                {
                    // Create a new ID for the StandardReport item
                    dc.Code = Guid.NewGuid();

                    // Map data contract to model
                    StandardReport destination = mappingService.Map <StandardReportDC, StandardReport>(dc);

                    // Add the new item
                    dataRepository.Add(destination);

                    // Commit unit of work
                    uow.Commit();

                    // Map model back to data contract to return new row id.
                    dc = mappingService.Map <StandardReport, StandardReportDC>(destination);
                }

                // Create aggregate data contract
                StandardReportVMDC returnObject = new StandardReportVMDC();

                // Add new item to aggregate
                returnObject.StandardReportItem = dc;

                return(returnObject);
            }
            catch (Exception e)
            {
                //Prevent exception from propogating across the service interface
                exceptionManager.ShieldException(e);

                return(null);
            }
        }
        /// <summary>
        /// Retrieve a StandardReport with associated lookups
        /// </summary>
        /// <param name="currentUser"></param>
        /// <param name="user"></param>
        /// <param name="appID"></param>
        /// <param name="overrideID"></param>
        /// <param name="code"></param>
        /// <param name="dataRepository"></param>
        /// <param name="uow"></param>
        /// <returns></returns>
        public StandardReportVMDC GetStandardReport(string currentUser, string user, string appID, string overrideID, string code, IUnitOfWork uow, IRepository <StandardReport> dataRepository
                                                    , IRepository <ReportCategory> reportCategoryRepository
                                                    , IExceptionManager exceptionManager, IMappingService mappingService)

        {
            try
            {
                #region Parameter validation

                // Validate parameters
                if (string.IsNullOrEmpty(currentUser))
                {
                    throw new ArgumentOutOfRangeException("currentUser");
                }
                if (string.IsNullOrEmpty(user))
                {
                    throw new ArgumentOutOfRangeException("user");
                }
                if (string.IsNullOrEmpty(appID))
                {
                    throw new ArgumentOutOfRangeException("appID");
                }
                if (null == dataRepository)
                {
                    throw new ArgumentOutOfRangeException("dataRepository");
                }
                if (null == uow)
                {
                    throw new ArgumentOutOfRangeException("uow");
                }
                if (null == exceptionManager)
                {
                    throw new ArgumentOutOfRangeException("exceptionManager");
                }
                if (null == mappingService)
                {
                    throw new ArgumentOutOfRangeException("mappingService");
                }

                #endregion

                using (uow)
                {
                    StandardReportDC destination = null;

                    // If code is null then just return supporting lists
                    if (!string.IsNullOrEmpty(code))
                    {
                        // Convert code to Guid
                        Guid codeGuid = Guid.Parse(code);

                        // Retrieve specific StandardReport
                        StandardReport dataEntity = dataRepository.Single(x => x.Code == codeGuid);

                        // Convert to data contract for passing through service interface
                        destination = mappingService.Map <StandardReport, StandardReportDC>(dataEntity);
                    }

                    IEnumerable <ReportCategory> reportCategoryList = reportCategoryRepository.GetAll(x => new { x.Description });

                    List <ReportCategoryDC> reportCategoryDestinationList = mappingService.Map <List <ReportCategoryDC> >(reportCategoryList);

                    // Create aggregate contract
                    StandardReportVMDC returnObject = new StandardReportVMDC();

                    returnObject.StandardReportItem = destination;
                    returnObject.ReportCategoryList = reportCategoryDestinationList;

                    return(returnObject);
                }
            }
            catch (Exception e)
            {
                //Prevent exception from propogating across the service interface
                exceptionManager.ShieldException(e);

                return(null);
            }
        }
        /// <summary>
        /// Update a StandardReport
        /// </summary>
        /// <param name="currentUser"></param>
        /// <param name="user"></param>
        /// <param name="appID"></param>
        /// <param name="overrideID"></param>
        /// <param name="code"></param>
        /// <param name="lockID"></param>
        /// <param name="dataRepository"></param>
        /// <param name="uow"></param>
        public void DeleteStandardReport(string currentUser, string user, string appID, string overrideID, string code, string lockID, IRepository <StandardReport> dataRepository, IUnitOfWork uow, IExceptionManager exceptionManager, IMappingService mappingService)
        {
            try
            {
                #region Parameter validation

                // Validate parameters
                if (string.IsNullOrEmpty(currentUser))
                {
                    throw new ArgumentOutOfRangeException("currentUser");
                }
                if (string.IsNullOrEmpty(user))
                {
                    throw new ArgumentOutOfRangeException("user");
                }
                if (string.IsNullOrEmpty(appID))
                {
                    throw new ArgumentOutOfRangeException("appID");
                }
                if (string.IsNullOrEmpty(code))
                {
                    throw new ArgumentOutOfRangeException("code");
                }
                if (string.IsNullOrEmpty(lockID))
                {
                    throw new ArgumentOutOfRangeException("lockID");
                }
                if (null == dataRepository)
                {
                    throw new ArgumentOutOfRangeException("dataRepository");
                }
                if (null == uow)
                {
                    throw new ArgumentOutOfRangeException("uow");
                }
                if (null == exceptionManager)
                {
                    throw new ArgumentOutOfRangeException("exceptionManager");
                }
                if (null == mappingService)
                {
                    throw new ArgumentOutOfRangeException("mappingService");
                }

                #endregion

                using (uow)
                {
                    // Convert string to guid
                    Guid codeGuid = Guid.Parse(code);

                    // Find item based on ID
                    StandardReport dataEntity = dataRepository.Single(x => x.Code == codeGuid);

                    // Delete the item
                    dataRepository.Delete(dataEntity);

                    // Commit unit of work
                    uow.Commit();
                }
            }
            catch (Exception e)
            {
                //Prevent exception from propogating across the service interface
                exceptionManager.ShieldException(e);
            }
        }
Exemple #12
0
 /// <summary>
 /// Initializes a new instance of the <see cref="BasicReportViewModel"/> class.
 /// </summary>
 /// <param name="id">The id.</param>
 public BasicReportViewModel(int id, StandardReport report)
     : base(id)
 {
     this.standardReport = report;
     this.standardReport.IsStatisticalReport = false;
 }
        public ActionResult IndexStandardReport(int? page, int? pagesize, string name,string first)
        {
            dynamic data = new System.Dynamic.ExpandoObject();
            if (name == null) name = "";
            var list = _StandardReportRepos.GetAllStandardReport(name);

            int _page = page.HasValue ? page.Value : 1;
            int _pagesize = pagesize.HasValue ? pagesize.Value : 12;
            var vs = list.ToPagedList(_page, _pagesize);
            var firstone = new StandardReport();
            if (first != null && first != "")
            {
                firstone = list.FirstOrDefault(p => p.StandardReportCode == first);
                var firspage = vs.IndexOf(firstone);
                if (firspage == -1)
                {
                    vs.Insert(0, firstone);
                }
                else if (firspage > 0)
                {
                    vs.Remove(firstone);
                    vs.Insert(0, firstone);
                }
            }
            data.name = name;
            data.list = vs;
            data.pageSize = _pagesize;
            data.pageIndex = _page;
            data.totalCount = vs.TotalCount;
            string otherparam = "";
            if (name != "") otherparam += "&name=" + name;
            data.otherParam = otherparam;
            return PartialView(data);
        }
Exemple #14
0
    protected override void onCorrespondenceTemplateMerge(NameValueCollection colMergeFields, string szCorrespondenceTemplate, ref bool bCancelMerge)
    {
        DailyGroupActivitiesDTO dailyGroupActivitiesDTO = (DailyGroupActivitiesDTO)(this.Parameters[0]);
        int    childId        = int.Parse(this.Parameters[1].ToString());
        string centerName     = this.Parameters[2].ToString();
        string groupName      = this.Parameters[3].ToString().ToUpper();
        string websiteAddress = this.Parameters[4].ToString();

        StringBuilder sbReport = new StringBuilder();

        var child = (from gc in dailyGroupActivitiesDTO.GroupChildren
                     where gc.Id == childId
                     select gc).FirstOrDefault();

        colMergeFields.Set("[WEBSITE]", websiteAddress);
        colMergeFields.Set("[CHILD_FIRSTNAME]", child.FirstName + " " + child.LastName.Substring(0, 1) + ".");
        colMergeFields.Set("[PARENT_FIRSTNAME]", child.ParentFirstName);
        colMergeFields.Set("[CENTER]", centerName);
        colMergeFields.Set("[GROUP_NAME]", groupName);

        //Added to track and set what child email was last processed in order to check if same email as before and to AOL
        //We want to inject a wait time before sending out the email in those cases.
        colMergeFields.Set("[LAST_EMAIL]", child.Email);

        colMergeFields.Set("[TODAY]", string.Format("{0:dddd, MM/dd/yyyy}", dailyGroupActivitiesDTO.DailyGroup.ClassDate));

        sbReport.Length = 0;

        sbReport.AppendLine("<table id='tblGroupActivity' border='1' style='border-spacing: 8px 2px; padding: 6px;'>");

        sbReport.AppendLine("<tr class='HeaderGrid'>");

        StandardReport.BuildTableCell(sbReport, "Child Name", "white-space: nowrap; text-align: left; text-decoration: underline; font-weight: bold;");

        foreach (var activityName in dailyGroupActivitiesDTO.ChildActivityValues.Select(cav => cav.ActivityName).Distinct())
        {
            StandardReport.BuildTableCell(sbReport, activityName, "text-align: left; text-decoration: underline; font-weight: bold;");
        }

        sbReport.AppendLine("</tr>");

        sbReport.AppendLine("<tr class='Grid'>");

        StandardReport.BuildTableCell(sbReport, colMergeFields.Get("[CHILD_FIRSTNAME]"), "text-align: left;");

        foreach (var activityName in dailyGroupActivitiesDTO.ChildDailyGroupActivities.Select(cav => cav.ActivityName).Distinct())
        {
            var selectedItem = (from ca in dailyGroupActivitiesDTO.ChildDailyGroupActivities
                                where ca.ActivityName == activityName && ca.ChildId == childId
                                select ca.ActivityValue).FirstOrDefault();

            StandardReport.BuildTableCell(sbReport, selectedItem, "text-align: left;");
        }

        sbReport.AppendLine("</tr>");

        sbReport.AppendLine("</table>");

        colMergeFields.Set("[REPORT]", sbReport.ToString());

        base.onCorrespondenceTemplateMerge(colMergeFields, szCorrespondenceTemplate, ref bCancelMerge);
    }