public DataSet bindMessagesIntoDataTable(Guid id, int noOfDataToSkip, Guid UserId)
{
Api.TeamMemberProfile.TeamMemberProfile objTeamMemberProfileRepository = new Api.TeamMemberProfile.TeamMemberProfile();
List<TeamMemberProfile> alstprofiles = (List<Domain.Myfashion.Domain.TeamMemberProfile>)new JavaScriptSerializer().Deserialize(objTeamMemberProfileRepository.GetTeamMemberProfilesByTeamId(id.ToString()), typeof(List<Domain.Myfashion.Domain.TeamMemberProfile>));
Api.FacebookFeed.FacebookFeed objApiFacebookFeed = new Api.FacebookFeed.FacebookFeed();
Api.TwitterMessage.TwitterMessage objApiTwitterMessage = new Api.TwitterMessage.TwitterMessage();
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
foreach (TeamMemberProfile item in alstprofiles)
{
try
{
if (item.ProfileType == "facebook")
{
//List<Domain.Myfashion.Domain.FacebookFeed> alstfeedfb = (List<Domain.Myfashion.Domain.FacebookFeed>)new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getUnreadMessages(item.ProfileId), typeof(List<Domain.Myfashion.Domain.FacebookFeed>)); ;
//foreach (FacebookFeed facebookmsg in alstfeedfb)
//{
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
//}
//Updated by SumitGupta [09-02-2015]
//List<FacebookMessage> lstfbmsg = (List<FacebookMessage>)new JavaScriptSerializer().Deserialize(objApiFacebookMessage.getAllFacebookMessagesOfUserByProfileId(item.ProfileId), typeof(List<FacebookMessage>));
List<FacebookMessage> lstfbmsg = (List<FacebookMessage>)new JavaScriptSerializer().Deserialize(objApiFacebookMessage.getAllFacebookMessagesOfUserByProfileIdWithRange(item.ProfileId, noOfDataToSkip.ToString(), UserId.ToString()), typeof(List<FacebookMessage>));
foreach (FacebookMessage facebookmsg in lstfbmsg)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.MessageDate, facebookmsg.Message, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.MessageId, facebookmsg.Type, 1);
}
catch (Exception ex)
{
logger.Error("Exception Message : " + ex.Message);
logger.Error("Exception Message : " + ex.StackTrace);
}
}
}
else if (item.ProfileType == "twitter")
{
//List<Domain.Myfashion.Domain.TwitterMessage> lstmsgtwtuser = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getUnreadMessages(item.ProfileId), typeof(List<Domain.Myfashion.Domain.TwitterMessage>));
//List<Domain.Myfashion.Domain.TwitterMessage> lstmsgtwtuser = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.GetTwitterMessages(item.ProfileId, UserId.ToString()), typeof(List<Domain.Myfashion.Domain.TwitterMessage>));
List<Domain.Myfashion.Domain.TwitterMessage> lstmsgtwtuser = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getAllTwitterkMessagesOfUserByProfileIdWithRange(UserId.ToString(), item.ProfileId, noOfDataToSkip.ToString()), typeof(List<Domain.Myfashion.Domain.TwitterMessage>));
foreach (TwitterMessage lst in lstmsgtwtuser)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
logger.Error("Exception Message : " + ex.Message);
logger.Error("Exception Message : " + ex.StackTrace);
}
}
}
else if (item.ProfileType == "googleplus")
{
}
}
catch (Exception ex)
{
logger.Error("Exception Message : " + ex.Message);
logger.Error("Exception Message : " + ex.StackTrace);
}
}
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
try
{
facebookid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "twitter")
{
try
{
twitterid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
googleplusid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
if (facebookid != "")
{
facebookid = facebookid.Substring(0, facebookid.Length - 1);
}
if (twitterid != "")
{
twitterid = twitterid.Substring(0, twitterid.Length - 1);
}
if (googleplusid != "")
{
googleplusid = googleplusid.Substring(0, googleplusid.Length - 1);
}
// suraj===============================================================================
//List<FacebookFeed> alstfbmsgs = (List<FacebookFeed>)new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getAllReadFbFeeds(facebookid), typeof(List<FacebookFeed>));
//try
//{
// foreach (FacebookFeed facebookmsg in alstfbmsgs)
// {
// try
// {
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.StackTrace);
//}
//===============================================================================
List<TwitterMessage> lstmsgtwt = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getAlltwtMessagesOfUser(twitterid), typeof(List<TwitterMessage>));
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#region Commented G+ code, to be used later
//GooglePlusActivitiesRepository objActRepository = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggpl = objActRepository.getAllgplusOfUser(googleplusid);
//try
//{
// foreach (GooglePlusActivities lst in lstmsggpl)
// {
// try
// {
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.StackTrace);
//}
#endregion
return ds;
}
public DataSet bindMessagesIntoDataTable(Guid id, int noOfDataToSkip, Guid UserId)
{
Api.TeamMemberProfile.TeamMemberProfile objTeamMemberProfileRepository = new Api.TeamMemberProfile.TeamMemberProfile();
List <TeamMemberProfile> alstprofiles = (List <Domain.Myfashion.Domain.TeamMemberProfile>) new JavaScriptSerializer().Deserialize(objTeamMemberProfileRepository.GetTeamMemberProfilesByTeamId(id.ToString()), typeof(List <Domain.Myfashion.Domain.TeamMemberProfile>));
Api.FacebookFeed.FacebookFeed objApiFacebookFeed = new Api.FacebookFeed.FacebookFeed();
Api.TwitterMessage.TwitterMessage objApiTwitterMessage = new Api.TwitterMessage.TwitterMessage();
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
foreach (TeamMemberProfile item in alstprofiles)
{
try
{
if (item.ProfileType == "facebook")
{
//List<Domain.Myfashion.Domain.FacebookFeed> alstfeedfb = (List<Domain.Myfashion.Domain.FacebookFeed>)new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getUnreadMessages(item.ProfileId), typeof(List<Domain.Myfashion.Domain.FacebookFeed>)); ;
//foreach (FacebookFeed facebookmsg in alstfeedfb)
//{
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
//}
//Updated by SumitGupta [09-02-2015]
//List<FacebookMessage> lstfbmsg = (List<FacebookMessage>)new JavaScriptSerializer().Deserialize(objApiFacebookMessage.getAllFacebookMessagesOfUserByProfileId(item.ProfileId), typeof(List<FacebookMessage>));
List <FacebookMessage> lstfbmsg = (List <FacebookMessage>) new JavaScriptSerializer().Deserialize(objApiFacebookMessage.getAllFacebookMessagesOfUserByProfileIdWithRange(item.ProfileId, noOfDataToSkip.ToString(), UserId.ToString()), typeof(List <FacebookMessage>));
foreach (FacebookMessage facebookmsg in lstfbmsg)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.MessageDate, facebookmsg.Message, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.MessageId, facebookmsg.Type, 1);
}
catch (Exception ex)
{
logger.Error("Exception Message : " + ex.Message);
logger.Error("Exception Message : " + ex.StackTrace);
}
}
}
else if (item.ProfileType == "twitter")
{
//List<Domain.Myfashion.Domain.TwitterMessage> lstmsgtwtuser = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getUnreadMessages(item.ProfileId), typeof(List<Domain.Myfashion.Domain.TwitterMessage>));
//List<Domain.Myfashion.Domain.TwitterMessage> lstmsgtwtuser = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.GetTwitterMessages(item.ProfileId, UserId.ToString()), typeof(List<Domain.Myfashion.Domain.TwitterMessage>));
List <Domain.Myfashion.Domain.TwitterMessage> lstmsgtwtuser = (List <TwitterMessage>) new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getAllTwitterkMessagesOfUserByProfileIdWithRange(UserId.ToString(), item.ProfileId, noOfDataToSkip.ToString()), typeof(List <Domain.Myfashion.Domain.TwitterMessage>));
foreach (TwitterMessage lst in lstmsgtwtuser)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
logger.Error("Exception Message : " + ex.Message);
logger.Error("Exception Message : " + ex.StackTrace);
}
}
}
else if (item.ProfileType == "googleplus")
{
}
}
catch (Exception ex)
{
logger.Error("Exception Message : " + ex.Message);
logger.Error("Exception Message : " + ex.StackTrace);
}
}
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
try
{
facebookid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "twitter")
{
try
{
twitterid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
googleplusid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
if (facebookid != "")
{
facebookid = facebookid.Substring(0, facebookid.Length - 1);
}
if (twitterid != "")
{
twitterid = twitterid.Substring(0, twitterid.Length - 1);
}
if (googleplusid != "")
{
googleplusid = googleplusid.Substring(0, googleplusid.Length - 1);
}
// suraj===============================================================================
//List<FacebookFeed> alstfbmsgs = (List<FacebookFeed>)new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getAllReadFbFeeds(facebookid), typeof(List<FacebookFeed>));
//try
//{
// foreach (FacebookFeed facebookmsg in alstfbmsgs)
// {
// try
// {
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.StackTrace);
//}
//===============================================================================
List <TwitterMessage> lstmsgtwt = (List <TwitterMessage>) new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getAlltwtMessagesOfUser(twitterid), typeof(List <TwitterMessage>));
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#region Commented G+ code, to be used later
//GooglePlusActivitiesRepository objActRepository = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggpl = objActRepository.getAllgplusOfUser(googleplusid);
//try
//{
// foreach (GooglePlusActivities lst in lstmsggpl)
// {
// try
// {
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.StackTrace);
//}
#endregion
return(ds);
}
public DataSet bindMessagesIntoDataTable(Guid id)
{
//SocialProfilesRepository socioprofrepo = new SocialProfilesRepository();
//List<SocialProfile> alstprofiles = socioprofrepo.getAllSocialProfilesOfUser(user.Id);
//TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
//List<TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(id);
Api.TeamMemberProfile.TeamMemberProfile objTeamMemberProfileRepository = new Api.TeamMemberProfile.TeamMemberProfile();
List <TeamMemberProfile> alstprofiles = (List <Domain.Socioboard.Domain.TeamMemberProfile>) new JavaScriptSerializer().Deserialize(objTeamMemberProfileRepository.GetTeamMemberProfilesByTeamId(id.ToString()), typeof(List <Domain.Socioboard.Domain.TeamMemberProfile>));
Api.FacebookFeed.FacebookFeed objApiFacebookFeed = new Api.FacebookFeed.FacebookFeed();
Api.TwitterMessage.TwitterMessage objApiTwitterMessage = new Api.TwitterMessage.TwitterMessage();
// DataTableGenerator datatablegenerepo = new DataTableGenerator();
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
// DataSet ds = datatablegenerepo.CreateDataSetForTable(mstable);
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
////FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
//Api.FacebookFeed.FacebookFeed objApiFacebookFeed = new Api.FacebookFeed.FacebookFeed();
//List<FacebookFeed> alstfeedfb = fbfeedRepo.getUnreadMessages(item.ProfileId);
List <Domain.Socioboard.Domain.FacebookFeed> alstfeedfb = (List <Domain.Socioboard.Domain.FacebookFeed>) new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getUnreadMessages(item.ProfileId), typeof(List <Domain.Socioboard.Domain.FacebookFeed>));;
foreach (FacebookFeed facebookmsg in alstfeedfb)
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
}
else if (item.ProfileType == "twitter")
{
////TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
//Api.TwitterMessage.TwitterMessage objApiTwitterMessage = new Api.TwitterMessage.TwitterMessage();
List <Domain.Socioboard.Domain.TwitterMessage> lstmsgtwtuser = (List <TwitterMessage>) new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getUnreadMessages(item.ProfileId), typeof(List <Domain.Socioboard.Domain.TwitterMessage>));
foreach (TwitterMessage lst in lstmsgtwtuser)
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
}
else if (item.ProfileType == "googleplus")
{
}
}
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
try
{
//FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
//List<FacebookFeed> alstfbmsgs = fbfeedrepo.getAllReadFacebookFeeds(user.Id, item.ProfileId);
//foreach (FacebookFeed facebookmsg in alstfbmsgs)
//{
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type,facebookmsg.ReadStatus);
//}
facebookid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "twitter")
{
try
{
//TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
//List<TwitterMessage> lstmsgtwtuser = twtmsgrepo.getAllReadMessagesOfUser(user.Id, item.ProfileId);
//foreach (TwitterMessage lst in lstmsgtwtuser)
//{
// ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type,lst.ReadStatus);
//}
twitterid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
//GooglePlusActivitiesRepository objActRepo = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggauser = objActRepo.getAllgoogleplusActivityOfUser(user.Id, item.ProfileId);
//foreach (GooglePlusActivities lst in lstmsggauser)
//{
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
//}
googleplusid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
if (facebookid != "")
{
facebookid = facebookid.Substring(0, facebookid.Length - 1);
}
if (twitterid != "")
{
twitterid = twitterid.Substring(0, twitterid.Length - 1);
}
if (googleplusid != "")
{
googleplusid = googleplusid.Substring(0, googleplusid.Length - 1);
}
//FacebookFeedRepository fbfeedRepository = new FacebookFeedRepository();
//List<FacebookFeed> alstfbmsgs = fbfeedRepository.getAllReadFbFeeds(facebookid);
List <FacebookFeed> alstfbmsgs = (List <FacebookFeed>) new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getAllReadFbFeeds(facebookid), typeof(List <FacebookFeed>));
try
{
foreach (FacebookFeed facebookmsg in alstfbmsgs)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
//TwitterMessageRepository twtmsgRepository = new TwitterMessageRepository();
//List<TwitterMessage> lstmsgtwt = twtmsgRepository.getAlltwtMessagesOfUser(twitterid);
List <TwitterMessage> lstmsgtwt = (List <TwitterMessage>) new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getAlltwtMessagesOfUser(twitterid), typeof(List <TwitterMessage>));
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#region Commented G+ code, to be used later
//GooglePlusActivitiesRepository objActRepository = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggpl = objActRepository.getAllgplusOfUser(googleplusid);
//try
//{
// foreach (GooglePlusActivities lst in lstmsggpl)
// {
// try
// {
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.StackTrace);
//}
#endregion
return(ds);
}
public DataSet bindMessagesIntoDataTable(Guid id)
{
//SocialProfilesRepository socioprofrepo = new SocialProfilesRepository();
//List<SocialProfile> alstprofiles = socioprofrepo.getAllSocialProfilesOfUser(user.Id);
//TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
//List<TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(id);
Api.TeamMemberProfile.TeamMemberProfile objTeamMemberProfileRepository = new Api.TeamMemberProfile.TeamMemberProfile();
List<TeamMemberProfile> alstprofiles = (List<Domain.Socioboard.Domain.TeamMemberProfile>)new JavaScriptSerializer().Deserialize(objTeamMemberProfileRepository.GetTeamMemberProfilesByTeamId(id.ToString()), typeof(List<Domain.Socioboard.Domain.TeamMemberProfile>));
Api.FacebookFeed.FacebookFeed objApiFacebookFeed = new Api.FacebookFeed.FacebookFeed();
Api.TwitterMessage.TwitterMessage objApiTwitterMessage = new Api.TwitterMessage.TwitterMessage();
// DataTableGenerator datatablegenerepo = new DataTableGenerator();
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
// DataSet ds = datatablegenerepo.CreateDataSetForTable(mstable);
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
////FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
//Api.FacebookFeed.FacebookFeed objApiFacebookFeed = new Api.FacebookFeed.FacebookFeed();
//List<FacebookFeed> alstfeedfb = fbfeedRepo.getUnreadMessages(item.ProfileId);
List<Domain.Socioboard.Domain.FacebookFeed> alstfeedfb = (List<Domain.Socioboard.Domain.FacebookFeed>)new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getUnreadMessages(item.ProfileId), typeof(List<Domain.Socioboard.Domain.FacebookFeed>)); ;
foreach (FacebookFeed facebookmsg in alstfeedfb)
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
}
else if (item.ProfileType == "twitter")
{
////TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
//Api.TwitterMessage.TwitterMessage objApiTwitterMessage = new Api.TwitterMessage.TwitterMessage();
List<Domain.Socioboard.Domain.TwitterMessage> lstmsgtwtuser = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getUnreadMessages(item.ProfileId), typeof(List<Domain.Socioboard.Domain.TwitterMessage>));
foreach (TwitterMessage lst in lstmsgtwtuser)
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
}
else if (item.ProfileType == "googleplus")
{
}
}
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
try
{
//FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
//List<FacebookFeed> alstfbmsgs = fbfeedrepo.getAllReadFacebookFeeds(user.Id, item.ProfileId);
//foreach (FacebookFeed facebookmsg in alstfbmsgs)
//{
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type,facebookmsg.ReadStatus);
//}
facebookid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "twitter")
{
try
{
//TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
//List<TwitterMessage> lstmsgtwtuser = twtmsgrepo.getAllReadMessagesOfUser(user.Id, item.ProfileId);
//foreach (TwitterMessage lst in lstmsgtwtuser)
//{
// ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type,lst.ReadStatus);
//}
twitterid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
//GooglePlusActivitiesRepository objActRepo = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggauser = objActRepo.getAllgoogleplusActivityOfUser(user.Id, item.ProfileId);
//foreach (GooglePlusActivities lst in lstmsggauser)
//{
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
//}
googleplusid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
if (facebookid != "")
{
facebookid = facebookid.Substring(0, facebookid.Length - 1);
}
if (twitterid != "")
{
twitterid = twitterid.Substring(0, twitterid.Length - 1);
}
if (googleplusid != "")
{
googleplusid = googleplusid.Substring(0, googleplusid.Length - 1);
}
//FacebookFeedRepository fbfeedRepository = new FacebookFeedRepository();
//List<FacebookFeed> alstfbmsgs = fbfeedRepository.getAllReadFbFeeds(facebookid);
List<FacebookFeed> alstfbmsgs = (List<FacebookFeed>)new JavaScriptSerializer().Deserialize(objApiFacebookFeed.getAllReadFbFeeds(facebookid), typeof(List<FacebookFeed>));
try
{
foreach (FacebookFeed facebookmsg in alstfbmsgs)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
//TwitterMessageRepository twtmsgRepository = new TwitterMessageRepository();
//List<TwitterMessage> lstmsgtwt = twtmsgRepository.getAlltwtMessagesOfUser(twitterid);
List<TwitterMessage> lstmsgtwt = (List<TwitterMessage>)new JavaScriptSerializer().Deserialize(objApiTwitterMessage.getAlltwtMessagesOfUser(twitterid), typeof(List<TwitterMessage>));
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#region Commented G+ code, to be used later
//GooglePlusActivitiesRepository objActRepository = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggpl = objActRepository.getAllgplusOfUser(googleplusid);
//try
//{
// foreach (GooglePlusActivities lst in lstmsggpl)
// {
// try
// {
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.StackTrace);
//}
#endregion
return ds;
}
