public List <SchFanPageLiker> GetSchFanPageLikerDataUsingSchName(SchFanPageLiker schFanPageLiker)
{
List <SchFanPageLiker> lstSchFanPageLiker = new List <SchFanPageLiker>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
NHibernate.IQuery nIquery = session.CreateQuery("from SchFanPageLiker s where s.SchedulerName = :SchedulerName");
nIquery.SetParameter("SchedulerName", schFanPageLiker.SchedulerName);
foreach (SchFanPageLiker item in nIquery.Enumerable <SchFanPageLiker>())
{
try
{
lstSchFanPageLiker.Add(item);
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(lstSchFanPageLiker);
}
/// <DeleteRssMessage>
/// Delete Rss feed Message.
/// </summary>
/// <param name="Id">Rssfeed id.(Guid)</param>
/// <returns>Return 1 for Deleted and 0 for not delete.(int)</returns>
public int DeleteRssMessage(Guid 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 delete rss feed by user id.
NHibernate.IQuery query = session.CreateQuery("delete from RssFeeds where Id = :userid ");
query.SetParameter("userid", Id);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
/// <getLinkedinAccountDetailsById>
/// Get linkedin account details by id
/// </summary>
/// <param name="liuserid"></param>
/// <returns>Return object of LinkedInAccount Class with value of each member.(Domain.LinkedInAccount)</returns>
public LinkedInAccount getLinkedinAccountDetailsById(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 account details.
NHibernate.IQuery query = session.CreateQuery("from LinkedInAccount where LinkedinUserId = :userid");
query.SetParameter("userid", liuserid);
LinkedInAccount result = new LinkedInAccount();
foreach (LinkedInAccount item in query.Enumerable <LinkedInAccount>())
{
result = item;
break;
}
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
} //End Transaction
} //End Session
}
/// <getInsightStatsPostDetails>
/// Get Details of Insight Stats Post.
/// </summary>
/// <param name="PostId">Post id(String)</param>
/// <returns>FacebookInsightPostStats class object (Domain.FacebookInsightPostStats) </returns>
public FacebookInsightPostStats getInsightStatsPostDetails(string PostId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Begin trasaction and opens up.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from FacebookInsightPostStats where PostId = :postId");
query.SetParameter("postId", PostId);
List <FacebookInsightPostStats> lst = new List <FacebookInsightPostStats>();
foreach (FacebookInsightPostStats item in query.Enumerable())
{
lst.Add(item);
break;
}
FacebookInsightPostStats fbacc = lst[0];
return(fbacc);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public override void SetParameters(NHibernate.IQuery query, int index)
{
if (this.Name != null)
{
query.SetParameter(GetNameParameterName(index), Name);
}
}
/// <FacebookInsightStats>
/// Get all FacebookInsightStats from database by FbUserId(String).
/// </summary>
/// <param name="Fbuserid">FbUserId FacebookInsightStats(String).</param>
/// <returns>Return a object of FacebookInsightStats Class with value of each member.</returns>
public FacebookInsightStats getInsightStatsDetails(string FbUserId)
{
//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 all FacebookInsightStats from database by FbUserId(String).
NHibernate.IQuery query = session.CreateQuery("from FacebookInsightStats where FbUserId = :fbuserid");
query.SetParameter("fbuserid", FbUserId);
List <FacebookInsightStats> lst = new List <FacebookInsightStats>();
foreach (FacebookInsightStats item in query.Enumerable())
{
lst.Add(item);
break;
}
FacebookInsightStats fbacc = lst[0];
return(fbacc);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
/// <getUserDetails>
/// Get User's all Detail from FacebookAccount by FbUserId.
/// </summary>
/// <param name="FbUserId">FbUserId of FacebookAccount(string)</param>
/// <returns>Return a object of FacebookAccount with value of each member.</returns>
public Domain.Socioboard.Domain.FacebookAccount getUserDetails(string FbUserId)
{
//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 User's all Detail from FacebookAccount by FbUserId.
NHibernate.IQuery query = session.CreateQuery("from FacebookAccount where FbUserId = :fbuserid");
query.SetParameter("fbuserid", FbUserId);
List <Domain.Socioboard.Domain.FacebookAccount> lst = new List <Domain.Socioboard.Domain.FacebookAccount>();
foreach (Domain.Socioboard.Domain.FacebookAccount item in query.Enumerable())
{
lst.Add(item);
break;
}
Domain.Socioboard.Domain.FacebookAccount fbacc = lst[0];
return(fbacc);
}
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
}
/// <checkTwitterFeedExists>
/// Check Twitter Feed Exists
/// </summary>
/// <param name="messageId">Message id.(string)</param>
/// <returns>True or False.(bool)</returns>
public bool checkTwitterFeedExists(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 feed by message id.
NHibernate.IQuery query = session.CreateQuery("from TwitterFeed where MessageId = :messid");
query.SetParameter("messid", messageId);
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
}
/// <getPackageDetailsbyId>
/// Get Package Details by Id
/// </summary>
/// <param name="packageid">Package</param>
/// <returns>Return the object of package class with value.(Domain.package)</returns>
public Package getPackageDetailsbyId(Guid packageid)
{
//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 package by id.
NHibernate.IQuery query = session.CreateQuery("from Package where Id=:packageid");
query.SetParameter("packageid", packageid);
Package grou = query.UniqueResult <Package>();
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
}
/// <checkPackageExists>
/// Check Package is Exists
/// </summary>
/// <param name="packagename">Name of package.(String)</param>
/// <returns>True or Flase.(bool)</returns>
public bool checkPackageExists(string packagename)
{
//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 package by name.
NHibernate.IQuery query = session.CreateQuery("from Package where PackageName =:packagename");
query.SetParameter("packagename", packagename);
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
}
/// <getAdsDetailsbyId>
/// get ads details by Ads Guid.
/// </summary>
/// <param name="adsid">Id of the Ads(Guid)</param>
/// <returns>Return Unique object of Ads</returns>
public Ads getAdsDetailsbyId(Guid adsid)
{
//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 the action to get data by query.
// Where we set the parameter
// And return unique result of Ad
NHibernate.IQuery query = session.CreateQuery("from Ads where Id=:adsid");
query.SetParameter("adsid", adsid);
Ads grou = query.UniqueResult <Ads>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} // End using transaction
} // End using session
}
/// <checkAdsExists>
/// To Check Existing Add bt Id..
/// </summary>
/// <param name="adsid">Id of Ads (Guid).</param>
/// <returns>Return true if result contain value otherwise false.</returns>
public bool checkAdsExists(Guid adsid)
{
//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 to Check, Ads is Exist or Not.
//And Set the reuired paremeters to find the specific values.
// Returns True and false.
NHibernate.IQuery query = session.CreateQuery("from Ads where Id =:adsid");
query.SetParameter("adsid", adsid);
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 void SetParameters(NHibernate.IQuery query, int index)
{
if (itemID.HasValue)
{
query.SetParameter("v" + index, this.itemID.Value);
}
}
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);
}
}
}
}
/// <getLimitProfilesOfUser>
/// Get Limit Profiles Of User
/// </summary>
/// <param name="userid">User id.(Guid)</param>
/// <param name="limit">Totale number required data. (int)</param>
/// <returns>Return Array list with value.(ArrayList)</returns>
public ArrayList getLimitProfilesOfUser(Guid userid, int limit)
{
//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())
{
//Set defaulr max result
int maxResult = 6;
//Proceed action, to get records by user id.
NHibernate.IQuery query = session.CreateQuery("from SocialProfile where UserId = :userid and ProfileType!='googleplus' and ProfileType!='googleanalytics' ");
query.SetFirstResult(limit);
query.SetMaxResults(maxResult);
query.SetParameter("userid", userid);
ArrayList alst = new ArrayList();
foreach (var item in query.Enumerable())
{
alst.Add(item);
}
return(alst);
} //End Transaction
} //End Session
}
public Domain.Socioboard.Domain.CompanyProfiles getCompanyProfiles(Guid Id)
{
Domain.Socioboard.Domain.CompanyProfiles companyProfile = null;
//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 CompanyProfiles where Id = :ID");
query.SetParameter("ID", Id);
Domain.Socioboard.Domain.CompanyProfiles result = (Domain.Socioboard.Domain.CompanyProfiles)query.UniqueResult();
companyProfile = result;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End session
return(companyProfile);
}
/// <getFbFeedsStatsHome>
/// Get total number of FeedId of FacebookFeed by UserId(Guid).
/// </summary>
/// <param name="userid">Id of User(Guid)</param>
/// <returns>Retutn a FeedId of FacebookFeed in form of ArrayList</returns>
public ArrayList getFbFeedsStatsHome(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 total number of FeedId of FacebookFeed by UserId(Guid).
NHibernate.IQuery query = session.CreateSQLQuery("Select Distinct Count(FeedId) from FacebookFeed where EntryDate>=DATE_ADD(NOW(),INTERVAL -7 DAY) and UserId =:userid Group by DATE_FORMAT(EntryDate,'%y-%m-%d') ");
query.SetParameter("userid", userid);
ArrayList alstFBmsgs = new ArrayList();
foreach (var item in query.List())
{
alstFBmsgs.Add(item);
}
return(alstFBmsgs);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
/// <getInstagramAccountById>
/// Get Instagram account from database by InsId(String)
/// </summary>
/// <param name="InsId"> InsId InstagramAccount(String)</param>
/// <returns>Return object of InstagramAccount Class with value of each member.</returns>
public Domain.Socioboard.Domain.InstagramAccount getInstagramAccountById(string InsId)
{
//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 Instagram account from database.
NHibernate.IQuery query = session.CreateQuery("from InstagramAccount where InstagramId = :InstagramId");
query.SetParameter("InstagramId", InsId);
Domain.Socioboard.Domain.InstagramAccount insAccount = new Domain.Socioboard.Domain.InstagramAccount();
foreach (Domain.Socioboard.Domain.InstagramAccount item in query.Enumerable <Domain.Socioboard.Domain.InstagramAccount>())
{
insAccount = item;
break;
}
return(insAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
/// <getFbMessageStats>
/// Get total number of id of FacebookMessage by UserId(Guid) and days(int).
/// </summary>
/// <param name="userid">Id of User(Guid)</param>
/// <param name="days">Int das</param>
/// <returns>Retutn a id of FacebookMessage in form of ArrayList</returns>
public ArrayList getFbMessageStats(Guid userid, int days)
{
//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
{
//Select Distinct Count(MessageId) from FacebookMessage where MessageDate>=DATE_ADD(NOW(),INTERVAL -7 DAY) and UserId =:userid Group by DATE_FORMAT(MessageDate,'%y-%m-%d')
//Proceed action to get total number of id of FacebookMessage by UserId(Guid) and days(int).
NHibernate.IQuery query = session.CreateSQLQuery("SELECT count(Id) FROM FacebookMessage WHERE EntryDate > DATE_SUB(NOW(), INTERVAL " + days + " DAY) and UserId =:userid GROUP BY WEEK(EntryDate)");
query.SetParameter("userid", userid);
ArrayList alstFBmsgs = new ArrayList();
foreach (var item in query.List())
{
alstFBmsgs.Add(item);
}
return(alstFBmsgs);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End 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);
}
}
}
}
/// <checkExistsDirectMessages>
/// Check Exist Direct Messages
/// </summary>
/// <param name="MessageId">Message id.(String)</param>
/// <returns>True and False.(bool)</returns>
public bool checkExistsDirectMessages(string MessageId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
//Proceed action, to get message by message id.
NHibernate.IQuery query = session.CreateQuery("from TwitterDirectMessages where MessageId = :userid ");
query.SetParameter("userid", MessageId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}//End Session
}
public string getAgeDiffCount(string profileid, 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 TwitterId=:profileid and EntryDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)");
query.SetParameter("profileid", profileid);
// ArrayList alstTwtStats = new ArrayList();
string alstTwtStats = string.Empty;
foreach (var item in query.List())
{
Array temp = (Array)item;
alstTwtStats = "0," + temp.GetValue(0).ToString() + "," + temp.GetValue(1).ToString() + "," + temp.GetValue(2).ToString() + "," + temp.GetValue(3).ToString() + "," + temp.GetValue(4).ToString() + "," + temp.GetValue(5).ToString();
}
//foreach (object item in query.Enumerable())
//{
// alstTwtStats.Add(item);
//}
return(alstTwtStats);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
//public bool checkFbIPageImprStatsExists(string FbUserId, Guid Userid, string countdate)
//{
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// NHibernate.IQuery query = session.CreateQuery("from FacebookInsightStats where UserId = :userid and FbUserId = :fbuserid and CountDate=:countdate");
// query.SetParameter("userid", Userid);
// query.SetParameter("fbuserid", FbUserId);
// query.SetParameter("countdate", countdate);
// var result = query.UniqueResult();
// if (result == null)
// return false;
// else
// return true;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// return true;
// }
// }
// }
//}
//public bool checkFbILocationStatsExists(string FbUserId, Guid Userid, string countdate, string location)
//{
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// NHibernate.IQuery query = session.CreateQuery("from FacebookInsightStats where UserId = :userid and FbUserId = :fbuserid and CountDate=:countdate and Location=:location");
// query.SetParameter("userid", Userid);
// query.SetParameter("fbuserid", FbUserId);
// query.SetParameter("countdate", countdate);
// query.SetParameter("location", location);
// var result = query.UniqueResult();
// if (result == null)
// return false;
// else
// return true;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// return true;
// }
// }
// }
//}
/// <getGoogleAnalyticsStatsDetails>
/// Get google analytics stats detail of account.
/// </summary>
/// <param name="gaAccountId">Id of Google analytics account .(string)</param>
/// <returns>Return object of GoogleAnalyticsStats class.(Domein.GoogleAnalyticsStats)</returns>
public GoogleAnalyticsStats getGoogleAnalyticsStatsDetails(string gaAccountId)
{
//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 google stats.
NHibernate.IQuery query = session.CreateQuery("from GoogleAnalyticsStats where GaAccountId = :gaAccountId");
query.SetParameter("gaAccountId", gaAccountId);
List <GoogleAnalyticsStats> lst = new List <GoogleAnalyticsStats>();
foreach (GoogleAnalyticsStats item in query.Enumerable())
{
lst.Add(item);
break;
}
GoogleAnalyticsStats fbacc = lst[0];
return(fbacc);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public ArrayList getFollowerFollowingCountMonth(Guid userid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("Select Distinct Max(FollowerCount),Max(FollowingCount),Month(EntryDate) from TwitterStats where UserId=:userid Group by MONTH(EntryDate)");
query.SetParameter("userid", userid);
ArrayList alstTwtStats = new ArrayList();
foreach (var item in query.List())
{
alstTwtStats.Add(item);
}
// object alstTwtStats = query.List();
return(alstTwtStats);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
public bool RssfeddExit(string message, Guid userid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from RssFeeds u where u.Message = : message and u.UserId=:userid");
query.SetParameter("message", message)
.SetParameter("userid", userid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}
}
}
public ArrayList getTwitterStByIdbeforeDay(string twtuserid, int days)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateSQLQuery("Select * from TwitterStats where TwitterId = :Twtuserid and EntryDate>= DATE_ADD(NOW(),INTERVAL -" + days + " DAY) order by EntryDate asc limit 1");
// query.SetParameter("days", days);
query.SetParameter("Twtuserid", twtuserid);
ArrayList alstTwtStats = new ArrayList();
foreach (var item in query.List())
{
alstTwtStats.Add(item);
}
return(alstTwtStats);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
public bool checkLinkedinProfileExists(string LinkedinUserId)
{
//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 LinkedinUserId = :LinkedinUserId");
query.SetParameter("LinkedinUserId", LinkedinUserId);
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
}
public bool IsAssigneeUserIdExist(Guid AssigneeUserId)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from TicketAssigneeStatus u where u.AssigneeUserId = : AssigneeUserId");
query.SetParameter("AssigneeUserId", AssigneeUserId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}
}
}