public ChartDataReponse GetTopUserSummaryChartData(List <int> smartChartIds)
{
var response = new ChartDataReponse();
try
{
var context = new SmartSocialContext();
if (smartChartIds.Count == 1)
{
int pastDeliveryChart = GetPastDeliveryChart(smartChartIds[0]);
if (pastDeliveryChart != 0)
{
response.PastDelivery = context.spGetChartData_TermXCount(pastDeliveryChart).FirstOrDefault();
}
}
var listOfTermCount = new List <TermCountObject>();
foreach (var id in smartChartIds)
{
var result = context.spGetChartData_TermXCount(id).FirstOrDefault();
listOfTermCount.Add(new TermCountObject()
{
Term = result.Term,
theCount = Convert.ToInt32(result.theCount)
});
}
response.ChartData = (dynamic)listOfTermCount.OrderByDescending(x => x.theCount).First();
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting TopUser Summary exception:" + ex.Message;
}
return(response);
}
public ChartDataReponse GetWordCloudChartData(List <int> smartChartIds)
{
var response = new ChartDataReponse();
try
{
var context = new SmartSocialContext();
var containerList = new List <dynamic>();
foreach (var id in smartChartIds)
{
containerList.AddRange(context.spGetChartData_TermXCount(id).ToList());
}
var listOfTermCount = new List <TermCountObject>();
var series = containerList.Select(x => x.Term).Distinct();
foreach (var serie in series)
{
listOfTermCount.Add(new TermCountObject()
{
Term = serie,
theCount = 0
});
}
foreach (var item in containerList)
{
listOfTermCount.FirstOrDefault(x => x.Term == item.Term).theCount = listOfTermCount.FirstOrDefault(x => x.Term == item.Term).theCount + int.Parse(item.theCount);
}
response.ChartData = (dynamic)listOfTermCount.OrderByDescending(x => x.theCount);
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting WordCloud Data exception:" + ex.Message;
}
return(response);
}