/// <getTeamMemberProfile>
/// Get TeamMember Profile
/// </summary>
/// <param name="Teamid">Team id.(Guid)</param>
/// <param name="ProfileId">Profile id.(string)</param>
/// <returns>>Return the object of TeamMemberProfile class with value.(Domain.TeamMemberProfile)</returns>
public Domain.Myfashion.Domain.TeamMemberProfile getTeamMemberProfile(Guid Teamid, string ProfileId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of team profile.
NHibernate.IQuery query = session.CreateQuery("from TeamMemberProfile where TeamId = :teamid and ProfileId = :profileid");
query.SetParameter("teamid", Teamid);
query.SetParameter("profileid", ProfileId);
Domain.Myfashion.Domain.TeamMemberProfile alstFBAccounts = query.UniqueResult <Domain.Myfashion.Domain.TeamMemberProfile>();
return(alstFBAccounts);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public bool checkInboxMessageRetweetExists(Guid userid, string messageid, string fromid, string recipientid, string type)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from InboxMessages where UserId = :userid and MessageId=:messageid and FromId =:fromid and RecipientId =:recipientid and MessageType=:MessageType");
query.SetParameter("userid", userid);
query.SetParameter("fromid", fromid);
query.SetParameter("recipientid", recipientid);
query.SetParameter("messageid", messageid);
query.SetParameter("MessageType", type);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End using transaction
} //End using session
}
/// <checkFacebookGroupExists>
/// Check Exists Facebook Group By group id and profile Id.
/// </summary>
/// <param name="GroupId">Group id (String)</param>
/// <param name="ProfileId">Profile Id(String)</param>
/// <returns></returns>
public bool checkFacebookGroupExists(string GroupId, string ProfileId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Begin session trasaction and opens up.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to Check facebook feed
NHibernate.IQuery query = session.CreateQuery("from FacebookGroup where ProfileId = :profileid and GroupId = :gid");
query.SetParameter("profileid", ProfileId);
query.SetParameter("gid", GroupId);
var resutl = query.UniqueResult();
if (resutl == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <checkTeamMemberProfile>
/// Check Team Member Profile
/// </summary>
/// <param name="Teamid">Team id. (Guid)</param>
/// <param name="ProfileId">Profile id.(String)</param>
/// <returns>if profile is exist its return true , otherwise it is return false.(bool)</returns>
public bool checkTeamMemberProfile(Guid Teamid, string ProfileId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Get the details of team profile by team id and profile id.
NHibernate.IQuery query = session.CreateQuery("from TeamMemberProfile where TeamId = :teamid and ProfileId = :profileid");
query.SetParameter("teamid", Teamid);
query.SetParameter("profileid", ProfileId);
var alstFBAccounts = query.UniqueResult <TeamMemberProfile>();
if (alstFBAccounts == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
public bool checkYoutubeUserExists(YoutubeAccount YoutubeAccount)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to Check if FacebookUser is Exist in database or not by UserId and FbuserId.
// And Set the reuired paremeters to find the specific values.
NHibernate.IQuery query = session.CreateQuery("from YoutubeAccount where YtUserId = :uidd and UserId = :Userid");
query.SetParameter("uidd", YoutubeAccount.Ytuserid);
query.SetParameter("Userid", YoutubeAccount.UserId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
/// <checkGooglePlusUserExists>
/// Check the account is exist or not.
/// </summary>
/// <param name="GpUserId">Id of Google plus account.(String)</param>
/// <param name="Userid">Id of user(Guid)</param>
/// <returns>Bool (True or False)</returns>
public bool checkGooglePlusUserExists(string GpUserId, Guid Userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to find details of account.
NHibernate.IQuery query = session.CreateQuery("from GooglePlusAccount where UserId = :userid and GpUserId = :gpuserid");
query.SetParameter("userid", Userid);
query.SetParameter("gpuserid", GpUserId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <checkTeamExists>
/// Check Team Exists
/// </summary>
/// <param name="EmailId">email id.(String)</param>
/// <param name="UserId">User id.(Guid)</param>
/// <returns>True and False.(bool)</returns>
public bool checkTeamExists(string EmailId, Guid UserId, Guid gpId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get team detail by user id and email id.
NHibernate.IQuery query = session.CreateQuery("from Team where UserId = :UserId and EmailId =:EmailId and GroupId=:gpId");
query.SetParameter("UserId", UserId);
query.SetParameter("EmailId", EmailId);
query.SetParameter("gpId", gpId);
var alstFBAccounts = query.UniqueResult <Domain.Socioboard.Domain.Team>();
if (alstFBAccounts == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <checkGroupExists>
/// Check the group are exist or not.
/// </summary>
/// <param name="userid">Id of user(Guid)</param>
/// <param name="groupname">Name of group(String)</param>
/// <returns>Bool(True or False)</returns>
public bool checkGroupExists(Guid userid, string groupname)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to find group by and and group name
NHibernate.IQuery query = session.CreateQuery("from Groups where UserId = :userid and GroupName =:groupname");
// query.SetParameter("userid", group.UserId); UserId =:userid and
query.SetParameter("userid", userid);
query.SetParameter("groupname", groupname);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <getGroupDetailsbyId>
/// Get the details of Group by user id and group id.
/// </summary>
/// <param name="userid">User id (Guid)</param>
/// <param name="groupname">Id of Group(Guid)</param>
/// <returns>Return the object of group.(Domein.Group)</returns>
public Domain.Myfashion.Domain.Groups getGroupDetailsbyId(Guid userid, Guid groupid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from Groups where UserId = :userid and Id=:groupname");
query.SetParameter("userid", userid);
query.SetParameter("groupname", groupid);
Domain.Myfashion.Domain.Groups grou = query.UniqueResult <Domain.Myfashion.Domain.Groups>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public bool IsUserExist(string Emailid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email");
query.SetParameter("email", Emailid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}
}
}
/// <getGoogelAnalyticsAccountHomeDetailsById>
/// Get Googel Analytics Account Home Details By Id and Google account id.
/// </summary>
/// <param name="gauserid">Google account id (String)</param>
/// <param name="userId">Id of user(Guid)</param>
/// <returns>Return object of Google analytic class.(Domein.GoogleAnalyticsAccount)</returns>
public GoogleAnalyticsAccount getGoogelAnalyticsAccountHomeDetailsById(string gauserid, Guid userId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of account.
NHibernate.IQuery query = session.CreateQuery("from GoogleAnalyticsAccount where GaAccountId = :GaAccountId and UserId=:userId");
query.SetParameter("GaAccountId", gauserid);
query.SetParameter("userId", userId);
GoogleAnalyticsAccount result = query.UniqueResult <GoogleAnalyticsAccount>();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
/// <getNewsDetailsbyId>
/// Get News Details by Id
/// </summary>
/// <param name="newsid">News id. (Guid)</param>
/// <returns>Return object of News Class with all news info.(List<News>)</returns>
public News getNewsDetailsbyId(Guid newsid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get news info by news id.
NHibernate.IQuery query = session.CreateQuery("from News where Id=:newsid");
query.SetParameter("newsid", newsid);
News grou = query.UniqueResult <News>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <checkNewsExists>
/// Check the news details is exist or not.
/// </summary>
/// <param name="newsid">News id. (Guid)</param>
/// <returns>True or False. (bool)</returns>
public bool checkNewsExists(Guid newsid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to find news by id.
NHibernate.IQuery query = session.CreateQuery("from News where Id =:newsid");
query.SetParameter("newsid", newsid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <CheckFeedExists>
/// Check the Feed is Exists.
/// </summary>
/// <param name="FeedsUrl">Url of feed.(String)</param>
/// <param name="Message">Message of feedReader.(String)</param>
/// <param name="PublishedDate">Date and time of publishing.(String)</param>
/// <returns>True or False.(bool)</returns>
public bool CheckFeedExists(string FeedsUrl, string Message, string PublishedDate)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from RssReader where FeedsUrl =:feedurl and Description =:desc and PublishedDate=:published");
query.SetParameter("feedurl", FeedsUrl);
query.SetParameter("desc", Message);
query.SetParameter("published", PublishedDate);
RssFeeds rss = query.UniqueResult <RssFeeds>();
if (rss == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <getArchiveMessagebyId>
/// Get ArchieveMessage by UserId and ArchieveId.
/// </summary>
/// <param name="userid">UserId of the ArchieveMessage(Guid)</param>
/// <param name="archiveId">ArchieveId of the ArchieveMessage(Guid)</param>
/// <returns>Return Unique object of Ads</returns>
public ArchiveMessage getArchiveMessagebyId(Guid userid, Guid archiveid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get archive mesaages by user id and archive id.
NHibernate.IQuery query = session.CreateQuery("from ArchiveMessage where UserId = :userid and Id=:archivename");
query.SetParameter("userid", userid);
query.SetParameter("archivename", archiveid);
ArchiveMessage grou = query.UniqueResult <ArchiveMessage>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} // End using transaction
} //End Using session
}
public object getFollowersAgeCount(Guid userid, int days)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateSQLQuery("Select MAx(Age1820),MAx(Age2124),MAx(Age2534),MAx(Age3544),MAx(Age4554),MAx(Age5564),MAx(Age65) From TwitterStats where UserId=:userid and EntryDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)");
query.SetParameter("userid", userid);
// ArrayList alstTwtStats = new ArrayList();
object alstTwtStats = query.UniqueResult();
//foreach (object item in query.Enumerable())
//{
// alstTwtStats.Add(item);
//}
return(alstTwtStats);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
/// <getUserInformation>
/// Get User account Information by screen Name and user id.
/// </summary>
/// <param name="screenname">Tqitter account screen name.(String)</param>
/// <param name="userid">User id.(Guid)</param>
/// <returns>Return the object of TwitterAccount class with value.(Domain.TwitterAccount)</returns>
public Domain.Socioboard.Domain.TwitterAccount getUserInformation(string screenname, Guid userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get twitter account details by screen name and user id.
NHibernate.IQuery query = session.CreateQuery("from TwitterAccount where UserId = :userid and TwitterUserId = :Twtuserid");
query.SetParameter("userid", userid);
query.SetParameter("Twtuserid", screenname);
Domain.Socioboard.Domain.TwitterAccount result = query.UniqueResult <Domain.Socioboard.Domain.TwitterAccount>();
return(result);
//TwitterAccount result= session.QueryOver<TwitterAccount>().Where(x => x.UserId == userid).And(x=>x.TwitterUserId == twtuserid).SingleOrDefault<TwitterAccount>();
//return result;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <checkLinkedinUserExists>
/// Check linkedin user is exist or not.
/// </summary>
/// <param name="liUserId">Id of linkedin account (string).</param>
/// <param name="Userid">User id (Guid)</param>
/// <returns>True or false (bool)</returns>
public bool checkLinkedinUserExists(string liUserId, Guid Userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from LinkedInAccount where UserId = :userid and LinkedinUserId = :liuserid");
query.SetParameter("userid", Userid);
query.SetParameter("liuserid", liUserId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <getMemberByEmailId>
/// Get Team Member By Email Id.and user id.
/// </summary>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="EmailId">Member Email id.(string)</param>
/// <returns>Return the object of Team class with value.(Domain.Team)</returns>
public Domain.Socioboard.Domain.Team getMemberByEmailId(Guid UserId, string EmailId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of team by user id and email id.
NHibernate.IQuery query = session.CreateQuery("from Team where UserId = :userid and EmailId =:memberId");
query.SetParameter("userid", UserId);
query.SetParameter("memberId", EmailId);
Domain.Socioboard.Domain.Team alstFBAccounts = query.UniqueResult <Domain.Socioboard.Domain.Team>();
return(alstFBAccounts);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <getUserInformation>
/// Get user linkedin account information
/// </summary>
/// <param name="userid">User id (Guid)</param>
/// <param name="liuserid">Linkedin account Id (String)</param>
/// <returns>Return object of LinkedInAccount Class with value of each member.(Domain.LinkedInAccount)</returns>
public Domain.Socioboard.Domain.LinkedInAccount getUserInformation(Guid userid, string liuserid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of account.
NHibernate.IQuery query = session.CreateQuery("from LinkedInAccount where LinkedinUserId = :LinkedinUserId And UserId=:UserId");
query.SetParameter("UserId", userid);
query.SetParameter("LinkedinUserId", liuserid);
Domain.Socioboard.Domain.LinkedInAccount result = query.UniqueResult <Domain.Socioboard.Domain.LinkedInAccount>();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public bool checkWordpressFeedExists(string PostId, Guid Userid, string siteid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Begin session trasaction and opens up.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get all data of Wordpress feed by user feed id and User id(Guid).
NHibernate.IQuery query = session.CreateQuery("from WordpressFeeds where UserId = :userid and PostId = :PostId and SiteId = : SiteId");
query.SetParameter("userid", Userid);
query.SetParameter("PostId", PostId);
query.SetParameter("SiteId", siteid);
var resut = query.UniqueResult();
if (resut == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
/// <checkTwitterFeedExists>
/// Check Feed is Exists or not
/// </summary>
/// <param name="Id">Id of feed.(string)</param>
/// <param name="Userid">User id.(Guid)</param>
/// <param name="messageId">feed id of feed.(string) </param>
/// <returns>True or False.(bool)</returns>
public bool checkFeedExists(string ProfileId, Guid UserId, string FeedId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to find twitter feeds by user id, profile id and message id.
NHibernate.IQuery query = session.CreateQuery("from FeedSentimentAlanalysis where UserId = :UserId and ProfileId = :ProfileId and FeedId = :FeedId");
query.SetParameter("UserId", UserId);
query.SetParameter("ProfileId", ProfileId);
query.SetParameter("FeedId", FeedId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <checkInstagramCommentExists>
/// Check if instagram Comments is exist or not in database by feedid(String) and Userid(Guid).
/// </summary>
/// <param name="feedid">feedid InstagramComment(String)</param>
/// <param name="Userid">Userid InstagramComment(Guid)</param>
/// <returns>Return true or false </returns>
public bool checkInstagramCommentExists(string feedid, Guid Userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action to check if instagram Comments is exist or not in database.
NHibernate.IQuery query = session.CreateQuery("from InstagramComment where UserId = :userid and CommentId = :msgid");
query.SetParameter("userid", Userid);
query.SetParameter("msgid", feedid);
var resutl = query.UniqueResult();
if (resutl == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
public bool checkYoutubeChannelExists(string channelid, Guid Userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Begin session trasaction and opens up.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get all data of facebook feed by user feed id and User id(Guid).
NHibernate.IQuery query = session.CreateQuery("from YoutubeChannel where UserId = :userid and ChannelId = :channelid");
query.SetParameter("userid", Userid);
query.SetParameter("channelid", channelid);
var resutl = query.UniqueResult();
if (resutl == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
public bool checkExistsDirectMessages(Guid UserId, string MessageId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get message by message id.
NHibernate.IQuery query = session.CreateQuery("from TwitterDirectMessages where UserId =: userid and MessageId = :MessageId ");
query.SetParameter("MessageId", MessageId);
query.SetParameter("userid", UserId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <checkGroupProfileExists>
/// Check the existing group profile
/// </summary>
/// <param name="userid">Id of user(Guid)</param>
/// <param name="groupid">Id of Group(Guid)</param>
/// <param name="profileid">Id of profile(String)</param>
/// <returns>Bool(True or False).</returns>
public bool checkGroupProfileExists(Guid userid, Guid groupid, string profileid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to find profile is exist or not.
NHibernate.IQuery query = session.CreateQuery("from GroupProfile where GroupOwnerId = :userid and GroupId = :id and ProfileId =:profileid");
query.SetParameter("id", groupid);
query.SetParameter("userid", userid);
query.SetParameter("profileid", profileid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <checkInstagramUserExists>
/// Check if instagram user is Exist or not in Database by InUserId(String) and UserId(Guid).
/// </summary>
/// <param name="InsUserId">InUserId InstagramAccount(String)</param>
/// <param name="Userid">UserId InstagramAccount(Guid)</param>
/// <returns>Return true or false</returns>
public bool checkInstagramUserExists(string InsUserId, Guid Userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action to Check if instagram user is Exist or not in Database.
NHibernate.IQuery query = session.CreateQuery("from InstagramAccount where InstagramId = :InstagramId and UserId = :UserId");
query.SetParameter("InstagramId", InsUserId);
query.SetParameter("UserId", Userid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
/// <checkArchiveMessageExists>
/// Get all ArchieveMessage by UserId and MessageId.
/// </summary>
/// <param name="userid">Id of the ArchieveMessage(Guid)</param>
/// <param name="messageid">MessageId of the ArchieveMessage(string)</param>
/// <returns>Return true if result contain value otherwise false.</returns>
public bool checkArchiveMessageExists(Guid userid, string messageid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get Archive messages
NHibernate.IQuery query = session.CreateQuery("from ArchiveMessage where UserId = :userid and MessageId =:messageid");
// query.SetParameter("userid", group.UserId); UserId =:userid and
query.SetParameter("userid", userid);
query.SetParameter("messageid", messageid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End using transaction
} //End using session
}
public bool checkTwitterStatsExistsnew(string TwtUserId, Guid Userid, int followercount)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from TwitterStats where UserId = :userid and FollowerCount=:followercount and TwitterId = :Twtuserid and Date_format(EntryDate,'%yy-%m-%d') LIKE Date_format(Now(),'%yy-%m-%d')");
query.SetParameter("userid", Userid);
query.SetParameter("followercount", followercount);
query.SetParameter("Twtuserid", TwtUserId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}
}
}
/// <checkFacebookMessageExists>
/// Check Message is Exist in database or not.
/// </summary>
/// <param name="Id">Id FacebookMessage(String)</param>
/// <returns>Return true or false</returns>
public bool checkFacebookMessageExists(string Id)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action to Check Message is Exist or not.
NHibernate.IQuery query = session.CreateQuery("from FacebookMessage where MessageId = :msgid");
query.SetParameter("msgid", Id);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}