Ejemplo n.º 1
0
        public IHttpActionResult GetAllProjectImpact(PROJECT_IMPACTDto searchDto)
        {
            var repos        = new TDAssetRespository();
            var estimateData = repos.GetPROJECT_IMPACT(searchDto);

            return(Json(estimateData));
        }
Ejemplo n.º 2
0
        public IHttpActionResult GetAllProjectImpactBI(SearchMap searchDto)
        {
            var repos = new TDAssetRespository();

            GetProjectImpacteBI  resultList = new GetProjectImpacteBI();
            List <string>        data       = null;
            List <BarchartValue> value      = null;
            List <BarchartValue> value2     = null;
            BarchartValue        barValue   = null;
            var barchart = new Barchart();
            int row      = 0;

            if (searchDto.SectionType == SetionType.Region)
            {
                searchDto.RegionCode = searchDto.Code;
            }
            else if (searchDto.SectionType == SetionType.Provice)
            {
                searchDto.ProvinceCode = searchDto.Code;
            }
            var estimateData = repos.GetPROJECT_IMPACT(searchDto);

            if (estimateData != null)
            {
                resultList.EstimateData = estimateData.OrderByDescending(o => o.ParcelTotal).ToList();

                data   = new List <string>();
                value  = new List <BarchartValue>();
                value2 = new List <BarchartValue>();

                foreach (PROJECT_IMPACTDto result in estimateData.OrderByDescending(o => o.ParcelTotal))
                {
                    if (row >= overMax)
                    {
                        break;
                    }


                    barValue       = new BarchartValue();
                    barValue.name  = result.SUBJECT_NAME;
                    barValue.value = Converting.ToDecimal(result.ParcelTotal);
                    barValue.key   = result.SUBJECT_ID;


                    value.Add(barValue);


                    barValue       = new BarchartValue();
                    barValue.name  = result.SUBJECT_NAME;
                    barValue.value = Converting.ToDecimal(result.Area);
                    barValue.key   = result.SUBJECT_ID;
                    value2.Add(barValue);



                    data.Add(result.SUBJECT_NAME);

                    row++;
                }

                barchart.Data   = data;
                barchart.Value  = value;
                barchart.Value2 = value2;
            }

            resultList.Barchart = barchart;


            return(Json(resultList));
        }