public string GetSociaoQueueMessageByUserIdAndGroupIdBetweenDates(string UserId, string GroupId, string StartDate, string EndDate)
{
string profileid = string.Empty;
DateTime stDate = DateTime.Parse(StartDate);
DateTime endDate = DateTime.Parse(EndDate);
// TeamRepository objTeamRepository = new TeamRepository();
try
{
Guid userid = Guid.Parse(UserId);
Guid groupid = Guid.Parse(GroupId);
List <Domain.Socioboard.Domain.ScheduledMessage> lstfianlscoailqueue = new List <Domain.Socioboard.Domain.ScheduledMessage>();
//Domain.Socioboard.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(groupid);
//List<Domain.Socioboard.Domain.TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(objTeam.Id);
GroupProfileRepository grpProfileRepo = new GroupProfileRepository();
List <Domain.Socioboard.Domain.GroupProfile> allprofiles = new List <Domain.Socioboard.Domain.GroupProfile>();
allprofiles = grpProfileRepo.GetAllGroupProfiles(groupid);
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
List <Domain.Socioboard.Domain.ScheduledMessage> lstScheduledMessages = new List <Domain.Socioboard.Domain.ScheduledMessage>();
Dictionary <string, List <Domain.Socioboard.Domain.ScheduledMessage> > objdic = new Dictionary <string, List <Domain.Socioboard.Domain.ScheduledMessage> >();
foreach (var item in allprofiles)
{
lstScheduledMessages = objScheduledMessageRepository.getAllMessagesDetailsByDate(item.ProfileId, userid, stDate, endDate);
if (lstScheduledMessages.Count > 0)
{
objdic.Add(item.ProfileId, lstScheduledMessages);
}
}
foreach (var item in objdic)
{
foreach (var ScheduledMessage in item.Value)
{
lstfianlscoailqueue.Add(ScheduledMessage);
}
}
//FacebookAccountRepository facebookAccountRepo = new FacebookAccountRepository();
// FacebookAccount facebook = facebookAccountRepo.getFacebookAccountDetailsById(FacebookId, userid);
return(new JavaScriptSerializer().Serialize(lstfianlscoailqueue));
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.StackTrace);
return(new JavaScriptSerializer().Serialize("Please try Again"));
}
}
public string DeleteTumblrAccount(string UserId, string ProfileId, string GroupId)
{
try
{
objTumblrAccountRepository.deleteTumblrUser(ProfileId, Guid.Parse(UserId));
objTumblrFeedRepository.DeleteTumblrDataByUserid(Guid.Parse(UserId), ProfileId);
// Domain.Socioboard.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository();
objGroupProfileRepository.DeleteGroupProfile(Guid.Parse(UserId), ProfileId, Guid.Parse(GroupId), "tumblr");
//objTeamMemberProfileRepository.DeleteTeamMemberProfileByTeamIdProfileId(ProfileId, objTeam.Id);
objSocialProfilesRepository.deleteProfile(Guid.Parse(UserId), ProfileId, "tumblr");
return(new JavaScriptSerializer().Serialize("Success"));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public string DeleteTwitterAccount(string UserId, string ProfileId, string GroupId, string ProfileType)
{
try
{
objTwitterAccountRepository.deleteTwitterUser(Guid.Parse(UserId), ProfileId);
//objTwitterFeedRepository.deleteTwitterFeed(ProfileId, Guid.Parse(UserId));
//objTwtstats.deleteTwitterStats(Guid.Parse(UserId), ProfileId);
//objTwitterMessageRepository.deleteTwitterMessage(ProfileId, Guid.Parse(UserId));
//objTwitterDirectMessageRepository.deleteDirectMessage(Guid.Parse(UserId), ProfileId);
GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository();
//Domain.Socioboard.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objGroupProfileRepository.DeleteGroupProfile(Guid.Parse(UserId), ProfileId, Guid.Parse(GroupId), ProfileType);
//objTeamMemberProfileRepository.DeleteTeamMemberProfileByTeamIdProfileId(ProfileId, objTeam.Id);
objSocialProfilesRepository.deleteProfile(Guid.Parse(UserId), ProfileId, ProfileType);
return(new JavaScriptSerializer().Serialize(""));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public string GetTicketsofGroup(string GroupId, string UserId)
{
string AssignedUser = string.Empty;
try
{
GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository();
FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository();
TwitterFeedRepository objTwitterFeedRepository = new TwitterFeedRepository();
List <Domain.Socioboard.Domain.FeedSentimentalAnalysis> lstNegativeFeedsOfUser = new List <Domain.Socioboard.Domain.FeedSentimentalAnalysis>();
List <Domain.Socioboard.Domain.GroupProfile> objGroupProfile = new List <Domain.Socioboard.Domain.GroupProfile>();
List <FBTwitterFeeds> objListFBTwitterFeeds = new List <FBTwitterFeeds>();
objGroupProfile = objGroupProfileRepository.getAllGroupProfiles(Guid.Parse(UserId), Guid.Parse(GroupId));
if (objGroupProfile.Count > 0)
{
lstNegativeFeedsOfUser = _FeedSentimentalAnalysisRepository.getAllNegativeFeedsOfUser(Guid.Parse(UserId));
}
else
{
lstNegativeFeedsOfUser = _FeedSentimentalAnalysisRepository.getNegativeFeedsOfUser(Guid.Parse(UserId));
}
if (lstNegativeFeedsOfUser != null)
{
foreach (var item in lstNegativeFeedsOfUser)
{
FBTwitterFeeds objFBTwitterFeeds = new FBTwitterFeeds();
UserRepository objUserRepository = new UserRepository();
Domain.Socioboard.Domain.User user = objUserRepository.getUsersById(item.AssigneUserId);
if (objGroupProfileRepository.checkProfileExistsingroup(Guid.Parse(GroupId), item.ProfileId))
{
string Network = item.Network;
if (Network == "facebook")
{
Domain.Socioboard.Domain.FacebookFeed facebookfeed = objFacebookFeedRepository.getFacebookFeedByProfileId(item.ProfileId, item.FeedId);
if (facebookfeed != null)
{
objFBTwitterFeeds.FacebookFeed = facebookfeed;
}
}
if (Network == "twitter")
{
Domain.Socioboard.Domain.TwitterFeed twtfeed = objTwitterFeedRepository.getTwitterFeedByProfileId(item.ProfileId, item.FeedId);
if (twtfeed != null)
{
objFBTwitterFeeds.TwitterFeed = twtfeed;
}
}
if (objFBTwitterFeeds.TwitterFeed != null)
{
try
{
objFBTwitterFeeds.TicketNo = item.TicketNo;
if (user != null)
{
objFBTwitterFeeds.AssignedUser = user.UserName;
}
else
{
objFBTwitterFeeds.AssignedUser = "";
}
objListFBTwitterFeeds.Add(objFBTwitterFeeds);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
if (objFBTwitterFeeds.FacebookFeed != null)
{
try
{
objFBTwitterFeeds.TicketNo = item.TicketNo;
if (user != null)
{
objFBTwitterFeeds.AssignedUser = user.UserName;
}
else
{
objFBTwitterFeeds.AssignedUser = "";
}
objListFBTwitterFeeds.Add(objFBTwitterFeeds);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
}
return(new JavaScriptSerializer().Serialize(objListFBTwitterFeeds));
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
logger.Error(ex.Message);
Console.WriteLine(ex.StackTrace);
return("SomethingWentWrong");
}
}
