public ChartDataReponse GetMostProlificUsersChartData(List <int> smartChartIds)
{
var response = new ChartDataReponse();
try
{
var context = new SmartSocialContext();
var containerList = new List <dynamic>();
//var unSortedData=new List<spGetChartData_AudienceStream_Result1()>;
var unSortedData = context.spGetChartData_AudienceStream(smartChartIds.FirstOrDefault()).ToList();
foreach (var id in smartChartIds)
{
if (id != smartChartIds.FirstOrDefault())
{
unSortedData.AddRange(context.spGetChartData_AudienceStream(id).ToList());
}
//containerList.AddRange(unSortedData.OrderByDescending(x => int.Parse(x.Followers)).ToList());
}
containerList.AddRange(unSortedData.OrderByDescending(x => int.Parse(x.Followers)).ToList());
response.ChartData = (dynamic)containerList;
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting Most Profilic Users Data exception:" + ex.Message;
}
return(response);
}
public ChartDataReponse GetTopPostByProductChartData(List <int> smartChartIds)
{
var response = new ChartDataReponse();
try
{
var context = new SmartSocialContext();
var containerList = new List <dynamic>();
foreach (var id in smartChartIds)
{
//var topSocialPost = new spGetChartData_TopSocialPostByProduct_Result();
var topSocialPost = new List <dynamic>();
var products = context.spGet_SmartReportProduct(id).ToList();
foreach (var product in products)
{
topSocialPost.AddRange(context.spGetChartData_TopSocialPostByProduct(id, product).ToList());
}
containerList.AddRange(topSocialPost.OrderByDescending(x => x.dMessage).ToList());
}
response.ChartData = (dynamic)containerList;
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting Most Profilic Users Data exception:" + ex.Message;
}
return(response);
}
public ChartDataReponse GetStackedColumnChartData(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_TermXGroupedTermXCount(id).ToList());
}
var chartData = (dynamic)containerList;
foreach (var chartDataSeries in chartData)
{
if (!response.Series.groupNames.Contains(chartDataSeries.theGroup))
{
response.Series.groupNames.Add(chartDataSeries.theGroup);
}
var serie = response.Series.series.FirstOrDefault(x => x.name == chartDataSeries.Term);
if (serie != null)
{
serie.data.Add(Convert.ToInt32(chartDataSeries.theCount));
}
else
{
var newSerie = new Serie();
newSerie.name = chartDataSeries.Term;
newSerie.data.Add(Convert.ToInt32(chartDataSeries.theCount));
response.Series.series.Add(newSerie);
}
}
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting Stacked Columns Data";
}
return(response);
}
public ChartDataReponse GetLocationAnalysisChartData(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_TermXGroupedTermXCount(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;
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting Location Analysis Data exception:" + ex.Message;
}
return(response);
}
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 ConversationStreamResponse GetConversationStreamMessage(int[] reportIds, string filter, int rowsSkipped)
{
var response = new ConversationStreamResponse();
try
{
var context = new SmartSocialContext();
var containerList = new List <dynamic>();
var filterValues = filter.Split('|');
var filterParameters = filterValues.ElementAt(1).Split(',');
var smartChartId = Convert.ToInt32(filterValues.ElementAt(0));
var message = filterValues.ElementAt(1);
var socialPostList = context.spGetChartData_MessageSocialPosts(smartChartId, message).ToList();
foreach (var socialPost in socialPostList)
{
response.conversationStreamObjects.Add(new ConversationStreamObject()
{
idSocialPost = socialPost.idSocialPost.ToString(),
Message = socialPost.Message,
MessageCreatedDate = socialPost.MessageCreatedDate.ToString(),
PermaLink = socialPost.PermaLink,
SenderProfileImgUrl = socialPost.SenderProfileImgUrl,
SenderScreenName = socialPost.SenderScreenName,
SocialNetwork = socialPost.SocialNetwork
});
}
response.Acknowledgment = true;
response.Message = "Success";
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting GetConversationStreamMessage Data exception:" + ex.Message;
}
return(response);
}
public ChartTypeRepository(SmartSocialContext context) : base(context)
{
}
public ServiceDeliveryRepository(SmartSocialContext context) : base(context)
{
}
public UserProfileRepository(SmartSocialContext context) : base(context)
{
}
public EntityRepository(SmartSocialContext context)
{
this.ObjectContext = context;
this.FetchEntitySetName();
}
public CompanyRepository(SmartSocialContext context) : base(context)
{
}
public LeadRepository(SmartSocialContext context) : base(context)
{
}
public ChartDataReponse GetLinearChartData(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_TermXTimeXCount(id).ToList());
}
var chartData = (dynamic)containerList;
foreach (var chartDataSeries in chartData)
{
if (!response.Series.groupNames.Contains(chartDataSeries.theTime))
{
response.Series.groupNames.Add(chartDataSeries.theTime);
}
}
var series = containerList.Select(x => x.Term).Distinct();
foreach (var serie in series)
{
var newSerie = new Serie();
newSerie.name = serie;
newSerie.data = new ArrayList(response.Series.groupNames.Count());
for (int i = 0; i < newSerie.data.Capacity; i++)
{
newSerie.data.Insert(i, null);
}
response.Series.series.Add(newSerie);
}
int index = 0;
foreach (var value in response.Series.groupNames)
{
var items = containerList.Where(x => x.theTime == value).ToList();
foreach (var item in items)
{
var addToSerie = response.Series.series.FirstOrDefault(x => x.name == item.Term);
if (addToSerie.data[index] == null)
{
addToSerie.data[index] = Convert.ToInt32(item.theCount);
}
else
{
addToSerie.data[index] = Convert.ToInt32(addToSerie.data[index]) + Convert.ToInt32(item.theCount);
}
}
index++;
}
response.Acknowledgment = true;
response.Message = "Success";
context.Dispose();
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting Columns Data";
}
return(response);
}
public UsersXSubscriptionRepository(SmartSocialContext context) : base(context)
{
}
public ServiceSubscriptionRepository(SmartSocialContext context) : base(context)
{
}
public ConversationStreamResponse GetConversationStream(int[] reportIds, string filter, int rowsSkipped)
{
var response = new ConversationStreamResponse();
var topN = Convert.ToInt32(Resource.TopN.ToString());
string conStr = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
try
{
foreach (var reportId in reportIds)
{
using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand("spGetChartData_SocialPostXIdXTopNXFilterXSkipRows", con))
{
var filterWhere = "";
using (var myDd = new SmartSocialContext())
{
var filterValues = filter.Split('|');
var filterParameters = filterValues.ElementAt(1).Split(',');
var smartChartId = Convert.ToInt32(filterValues.ElementAt(0));
filterWhere = myDd.SmartCharts.FirstOrDefault(x => x.idSmartChart == smartChartId).SocialPostFilter.Replace("SOCIALPOSTPARAM1", filterParameters.ElementAt(0));
if (filterParameters.Count() > 1)
{
if (filterWhere.Contains("And [MessageCreatedDate] = 'SOCIALPOSTPARAM2'"))
{
var dateFrom = DateTime.Parse(filterParameters.ElementAt(1)).Date;
var dateTo = DateTime.Parse(filterParameters.ElementAt(1)).Date.AddDays(1).AddTicks(-1);
filterWhere = filterWhere.Replace("[MessageCreatedDate] = 'SOCIALPOSTPARAM2'", "[MessageCreatedDate] BETWEEN '" + dateFrom.ToString() + "' AND '" + dateTo.ToString() + "'");
}
else
{
filterWhere = filterWhere.Replace("SOCIALPOSTPARAM2", filterParameters.ElementAt(1));
}
}
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Param1IdSmartReport", SqlDbType.Int).Value = reportId;
cmd.Parameters.Add("@Param2TopN", SqlDbType.Int).Value = topN;// Solo 15
cmd.Parameters.Add("@Param3Filter", SqlDbType.NVarChar).Value = filterWhere;
cmd.Parameters.Add("@Param4SkipRows", SqlDbType.Int).Value = rowsSkipped;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
response.conversationStreamObjects.Add(new ConversationStreamObject()
{
idSocialPost = dr["idSocialPost"].ToString(),
Message = dr["Message"].ToString(),
MessageCreatedDate = dr["MessageCreatedDate"].ToString(),
PermaLink = dr["PermaLink"].ToString(),
SenderProfileImgUrl = dr["SenderProfileImgUrl"].ToString(),
SenderScreenName = dr["SenderScreenName"].ToString(),
SocialNetwork = dr["SocialNetwork"].ToString()
});
}
}
}
}
response.Acknowledgment = true;
response.Message = "Success";
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = "Error Getting Conversation Stream. Exception:" + ex.Message;
}
return(response);
}
public NotificationRepository(SmartSocialContext context) : base(context)
{
}
public SubscriptionRoleTypeRepository(SmartSocialContext context) : base(context)
{
}
public SharedReportRepository(SmartSocialContext context) : base(context)
{
}
public ChartCommentRepository(SmartSocialContext context) : base(context)
{
}
public SocialPostRepository(SmartSocialContext context) : base(context)
{
}
public WebMembershipRepository(SmartSocialContext context) : base(context)
{
}
