Esempi in C# (CSharp) per p1p.Data P1PContext.sp_Links_Aggregates

Esempio n. 1

        public List <AggregateDTO> AggregateSearch(int projectId, int status, int linkStrategy, bool onlyMine, string userName, Nullable <DateTime> startDate, Nullable <DateTime> endDate, bool includeNotInUse, int teamId, bool isActive)
        {
            List <AggregateDTO> aggregates = new List <AggregateDTO>();
            ObjectResult <p1p.Data.sp_Links_Aggregates_Result2> aggregateResults;

            using (P1PContext ctx = new P1PContext())
            {
                aggregateResults = ctx.sp_Links_Aggregates(projectId, status, linkStrategy, onlyMine, userName, startDate, endDate, includeNotInUse, teamId, isActive);
                foreach (sp_Links_Aggregates_Result2 a in aggregateResults)
                {
                    if (a.ProjectAggregate != null && a.ProjectAggregate > 0)
                    {
                        aggregates.Add(new AggregateDTO()
                        {
                            Name      = a.Name,
                            Aggregate = (double)a.ProjectAggregate
                        });
                    }
                }
            }



            return(aggregates);
        }