public IHttpActionResult GetAllProjectImpact(PROJECT_IMPACTDto searchDto)
{
var repos = new TDAssetRespository();
var estimateData = repos.GetPROJECT_IMPACT(searchDto);
return(Json(estimateData));
}
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));
}