//private void GetInstagramMessages(string userId)
//{
// string query = "select Insta_inboxUserId,PlateformType,Message,ImageSource from TblJobFb where Fbcomment_InboxUserId='" + userId + "'";
// var dt = sql.GetDataTable(query);
// foreach (DataRow item in dt.Rows)
// {
// string InstainboxUserId = Convert.ToString(item["Insta_inboxUserId"]);
// string PlateformType = Convert.ToString(item["PlateformType"]);
// string Message = Convert.ToString(item["Message"]);
// string ImgSource = Convert.ToString(item["ImageSource"]);
// messagingInstapageListInfo.Add(new FbUserMessageInfo() { Message = Message });
// }
//}
public ObservableCollection <SocialUser> GetInstaUserList(string userId)
{
SqLiteHelper sql = new SqLiteHelper();
ObservableCollection <SocialUser> InstaListmembers = new ObservableCollection <SocialUser>();
string query = "select Insta_inboxUserId,Insta_inboxUserName,Insta_inboxUserImage,InstaInboxNavigationUrl from Tbl_Instagram where Parent_User_Id='" + userId + "'";
var dt = sql.GetDataTable(query);
foreach (DataRow item in dt.Rows)
{
string InstainboxUserId = Convert.ToString(item["Insta_inboxUserId"]);
string Insta_inboxUserName = Convert.ToString(item["Insta_inboxUserName"]);
string Insta_inboxUserImage = Convert.ToString(item["Insta_inboxUserImage"]);
string InstaInboxNavigationUrl = Convert.ToString(item["InstaInboxNavigationUrl"]);
if (!InstaListmembers.Any(m => m.InboxUserName.Equals(Insta_inboxUserName)))
{
InstaListmembers.Add(new SocialUser()
{
InboxUserId = InstainboxUserId,
InboxUserName = Insta_inboxUserName,
InboxUserImage = Insta_inboxUserImage,
InboxNavigationUrl = InstaInboxNavigationUrl,
MessageUserType = TabType.Instagram.ToString()
});
}
}
return(InstaListmembers);
}
public ObservableCollection <SocialUser> GetFacebookListData(string userId)
{
SqLiteHelper sql = GetSqliteHelper();
ObservableCollection <SocialUser> FbPageListmembers = new ObservableCollection <SocialUser>();
string query = "select Fbcomment_InboxUserId, Fbcomment_InboxUserName,Fbcomment_InboxUserImage,FBInboxNavigationUrl from TblFbComment where Parent_User_Id='" + userId + "'";
var dt = sql.GetDataTable(query);
foreach (DataRow item in dt.Rows)
{
string Fbcomment_InboxUserId = Convert.ToString(item["Fbcomment_InboxUserId"]);
string Fbcomment_InboxUserName = Convert.ToString(item["Fbcomment_InboxUserName"]);
string Fbcomment_InboxUserImage = Convert.ToString(item["Fbcomment_InboxUserImage"]);
string FBInboxNavigationUrl = Convert.ToString(item["FBInboxNavigationUrl"]);
if (!FbPageListmembers.Any(m => m.InboxUserName.Equals(Fbcomment_InboxUserName)))
{
FbPageListmembers.Add(new SocialUser()
{
InboxUserId = Fbcomment_InboxUserId,
InboxUserName = Fbcomment_InboxUserName,
InboxUserImage = Fbcomment_InboxUserImage,
InboxNavigationUrl = FBInboxNavigationUrl,
MessageUserType = TabType.Facebook.ToString()
});
}
}
return(FbPageListmembers);
}
public ObservableCollection <SocialUser> GetLeftMessengerListData(string userId, TabType tabType, string pageid)
{
SqLiteHelper sql = new SqLiteHelper();
ObservableCollection <SocialUser> userListInfo = new ObservableCollection <SocialUser>();
//string query = string.Format("select FacebookId,DisplayName,ImageUrl,NavigationUrl from FacebookUsers where Parent_User_Id='{0}' and JobType={1} ", userId, (int)tabType);
string query = "select FacebookId,DisplayName,ImageUrl,NavigationUrl,PageId from FacebookUsers where Parent_User_Id='" + userId + "' and JobType='" + (int)tabType + "' and PageId='" + pageid + "'";
var dt = sql.GetDataTable(query);
foreach (DataRow item in dt.Rows)
{
string inboxUserId = Convert.ToString(item["FacebookId"]);
string inboxUserName = Convert.ToString(item["DisplayName"]);
string inboxUserImage = Convert.ToString(item["ImageUrl"]);
string inboxNavigationUrl = Convert.ToString(item["NavigationUrl"]);
string pageId = Convert.ToString(item["PageId"]);
//if (!UserListInfo.Any(m => m.InboxUserName.Equals(M_inboxUserName)))
if (!userListInfo.Any(m => m.InboxUserId.Equals(inboxUserId)))
{
userListInfo.Add(new SocialUser()
{
InboxUserId = inboxUserId, InboxUserName = inboxUserName,
InboxUserImage = inboxUserImage,
InboxNavigationUrl = inboxNavigationUrl,
MessageUserType = tabType.ToString(),
PageId = pageId
});
}
}
return(userListInfo);
}
private void GetAllItems()
{
string query = "select * from TblMessage";
SqLiteHelper sql = new SqLiteHelper();
DtCampaign = sql.GetDataTable(query);
// dataGrid.ItemsSource = DtCampaign;
}