public int getCountUnreadMessages(Guid UserId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, open up a Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from TwitterMessage where ReadStatus=0 and UserId= :userid")
.SetParameter("userid", UserId);
int i = 0;
foreach (TwitterMessage item in query.Enumerable <TwitterMessage>())
{
i++;
}
return(i);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
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);
}
//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
}
/// <getAllFacebookMessagesOfUsers>
/// Get all Facebook Message of all User by UserId(Guid) and profileId(String).
/// </summary>
/// <param name="UserId">UserId FacebookMessage(Guid)</param>
/// <param name="profileId">profileId FacebookMessage(string)</param>
public void getAllFacebookMessagesOfUsers(Guid UserId, 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 all Facebook Message of all User.
NHibernate.IQuery query = session.CreateQuery("from FacebookMessage where UserId = :userid and ProfileId = :profileId");
query.SetParameter("userid", UserId);
query.SetParameter("profileId", profileId);
foreach (var item in query.Enumerable())
{
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End session
}
/// <getUserDetails>
/// Get the details of account by Google plus Id.
/// </summary>
/// <param name="GpUserId">Id of goole plus account(String)</param>
/// <param name="gpaccount">Set Values in a GooglePlusAccount Class Property and Pass the same Object of GooglePlusAccount Class.(Domain.GooglePlusAccount)</param>
public Domain.Socioboard.Domain.GooglePlusAccount getUserDetails(string GpUserId)
{
//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 detail by google id.
NHibernate.IQuery query = session.CreateQuery("from GooglePlusAccount where GpUserId = :gpuserid");
query.SetParameter("gpuserid", GpUserId);
List <Domain.Socioboard.Domain.GooglePlusAccount> lst = new List <Domain.Socioboard.Domain.GooglePlusAccount>();
foreach (Domain.Socioboard.Domain.GooglePlusAccount item in query.Enumerable())
{
lst.Add(item);
break;
}
Domain.Socioboard.Domain.GooglePlusAccount fbacc = lst[0];
return(fbacc);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <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
}
public List <TwitterMessage> getUnreadMessages(string Profileid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, open up a Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from TwitterMessage where ReadStatus=0 and ProfileId =:profid")
.SetParameter("profid", Profileid);
List <TwitterMessage> lsttwtMessage = new List <TwitterMessage>();
foreach (TwitterMessage item in query.Enumerable <TwitterMessage>())
{
lsttwtMessage.Add(item);
}
return(lsttwtMessage);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <getGoogelAnalyticsAccountHomeDetailsById>
/// Get the 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(Guid userId, string gauserid)
{
//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 GoogleAnalyticsAccount where GaAccountId = :GaAccountId and UserId=:userId");
query.SetParameter("GaAccountId", gauserid);
query.SetParameter("userId", userId);
GoogleAnalyticsAccount result = new GoogleAnalyticsAccount();
foreach (GoogleAnalyticsAccount item in query.Enumerable <GoogleAnalyticsAccount>())
{
result = item;
break;
}
return(result);
}
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
}
/// <summary>
/// Not used Now.
/// </summary>
/// <param name="str"></param>
/// <returns>Return all Comment By BlogId in the form of List type.</returns>
public List <Blog_Comments> GetAllCommentByBlogId(string str)
{
//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 data.
NHibernate.IQuery query = session.CreateQuery("from User");
List <Blog_Comments> alstUser = new List <Blog_Comments>();
foreach (Blog_Comments item in query.Enumerable())
{
alstUser.Add(item);
}
return(alstUser);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
public List <CmpFanPageLiker> GetCmpFanPageLikerDataUsingCmpName(CmpFanPageLiker cmpFanPageLiker)
{
List <CmpFanPageLiker> lstCmpFanPageLiker = new List <CmpFanPageLiker>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
NHibernate.IQuery nIquery = session.CreateQuery("from CmpFanPageLiker s where s.CampaignName = :CampaignName");
nIquery.SetParameter("CampaignName", cmpFanPageLiker.CampaignName);
foreach (CmpFanPageLiker item in nIquery.Enumerable <CmpFanPageLiker>())
{
try
{
lstCmpFanPageLiker.Add(item);
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(lstCmpFanPageLiker);
}
public int getTweetsCount(Guid userid, string twtuserid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("Select Count(ID) as Tweets from TwitterMessage where UserId=:userid and profileId=:Twtuserid And Type='twt_usertweets'");
query.SetParameter("userid", userid);
query.SetParameter("Twtuserid", twtuserid);
int tweetCount = 0;
foreach (var item in query.Enumerable())
{
tweetCount = int.Parse(item.ToString());
}
return(tweetCount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
public int getFollowersFollowingCount(Guid userid, string twtuserid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("Select FollowersCount,FollowingCount,'','' From TwitterAccount where UserId=:userid and profileId=:Twtuserid");
query.SetParameter("userid", userid);
query.SetParameter("Twtuserid", twtuserid);
int feedCount = 0;
foreach (var item in query.Enumerable())
{
feedCount = int.Parse(item.ToString());
}
return(feedCount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
public ArrayList calculteStats(Guid userid, string twtuserid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from TwitterStats where UserId=:userid and TwitterUserId = :Twtuserid");
query.SetParameter("userid", userid);
query.SetParameter("Twtuserid", twtuserid);
ArrayList alstTwtStats = new ArrayList();
foreach (Domain.Socioboard.Domain.TwitterStats item in query.Enumerable())
{
alstTwtStats.Add(item);
}
return(alstTwtStats);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
/// <getPagelikebyUserId>
/// Get all like from facebookaccount by UserId(Guid) and TYPE.
/// </summary>
/// <param name="UserId">UserId User(Guid)</param>
/// <returns> integer </returns>
public int getPagelikebyUserId(Guid UserId)
{
int TotalLikes = 0;
//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 Get all like from facebookaccount by UserId(Guid) and TYPE.
NHibernate.IQuery query = session.CreateQuery("SELECT SUM(Friends) FROM FacebookAccount WHERE TYPE=:PageType AND UserId =:userid")
.SetParameter("userid", UserId)
.SetParameter("PageType", "page");
ArrayList alstFBAccounts = new ArrayList();
foreach (var item in query.Enumerable())
{
TotalLikes = Convert.ToInt32(item);
break;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End session
return(TotalLikes);
}
/// <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.Myfashion.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.Myfashion.Domain.FacebookAccount> lst = new List <Domain.Myfashion.Domain.FacebookAccount>();
foreach (Domain.Myfashion.Domain.FacebookAccount item in query.Enumerable())
{
lst.Add(item);
break;
}
Domain.Myfashion.Domain.FacebookAccount fbacc = lst[0];
return(fbacc);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
public List <User> getAllUsers()
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User where Id !=null");
List <User> alstUser = new List <User>();
foreach (User item in query.Enumerable())
{
alstUser.Add(item);
}
return(alstUser);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
//public int updateFacebookFeedStatus(string fbfeed)
//{
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// }
// }
//}
/// <countUnreadMessages>
/// Get the total counts of Unread Messages of user from facebook feed.
/// </summary>
/// <param name="UserId">User id(Guid)</param>
/// <returns>Todal number of messages(Int)</returns>
public int countUnreadMessages(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 Unread messages of related user.
NHibernate.IQuery query = session.CreateQuery("from FacebookFeed where ReadStatus = 0 and UserId=:userid")
.SetParameter("userid", UserId);
int i = 0;
//Count rows
foreach (var item in query.Enumerable <Domain.Myfashion.Domain.FacebookFeed>())
{
i++;
}
return(i);
}
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 Domain.Socioboard.Domain.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);
Domain.Socioboard.Domain.LinkedInAccount result = new Domain.Socioboard.Domain.LinkedInAccount();
foreach (Domain.Socioboard.Domain.LinkedInAccount item in query.Enumerable <Domain.Socioboard.Domain.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
}
/// <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;
//Check the limit is not zero
//if (limit == 0)
// maxResult = 2;
//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
}
/// <getAllTwitterMessagesOfUser>
/// Get All Twitter Messages Of User
/// </summary>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="profileid">Profile id.(String)</param>
/// <returns>Return object of TwitterMessage Class with value of each member in the form of list.(List<TwitterMessage>)</returns>
public List <TwitterMessage> getAllTwitterMessagesOfUser(Guid UserId, string profileid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, open up a Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get messages of profile by profile id and user id.
NHibernate.IQuery query = session.CreateQuery("from TwitterMessage where UserId = :userid and ProfileId = :profid");
query.SetParameter("userid", UserId);
query.SetParameter("profid", profileid);
List <TwitterMessage> lstmsg = new List <TwitterMessage>();
foreach (TwitterMessage item in query.Enumerable <TwitterMessage>().OrderByDescending(x => x.MessageDate))
{
lstmsg.Add(item);
}
return(lstmsg);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public List <Setting> GetFilePath(Setting setting)
{
List <Setting> lstSetting = new List <Setting>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//NHibernate.ISQLQuery nHquery = session.CreateSQLQuery("Select FilePath from setting where Module ='" + setting.Module + "'");// and FileType='" + setting.FileType + "'
NHibernate.IQuery nIquery = session.CreateQuery("from Setting s where s.Module = :module").SetParameter("module", setting.Module);
foreach (Setting item in nIquery.Enumerable <Setting>())
{
try
{
lstSetting.Add(item);
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
//nHquery.Enumerable<Setting>
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(lstSetting);
}
/// <getAllTwitterAccounts>
/// Get All Twitter Accounts
/// </summary>
/// <returns>Return values in the form of array list.(ArrayList)</returns>
public System.Collections.ArrayList getAllTwitterAccounts()
{
//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())
{
//Proceed action, to get all twitter accounts.
NHibernate.IQuery query = session.CreateQuery("from TwitterAccount");
ArrayList alstTwtAccounts = new ArrayList();
foreach (var item in query.Enumerable())
{
alstTwtAccounts.Add(item);
}
return(alstTwtAccounts);
} //End Transaction
} //End Session
}
/// <getAllGooglePlusAccounts>
/// Get the all google plus account details
/// </summary>
/// <returns></returns>
public ArrayList getAllGooglePlusAccounts()
{
//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())
{
//Proceed action, to get all details of google plus account
NHibernate.IQuery query = session.CreateQuery("from GooglePlusAccount");
ArrayList alstFBAccounts = new ArrayList();
foreach (var item in query.Enumerable())
{
alstFBAccounts.Add(item);
}
return(alstFBAccounts);
} //End transaction
} //End Session
}
public List <Object> SelectQuery(string TableName, string[] parameters, string[] values)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
string hqlquery = string.Empty;
hqlquery = "from " + TableName + " where ";
for (int i = 0; i < parameters.Length; i++)
{
if (i < parameters.Length - 1)
{
hqlquery += "" + parameters[i] + " = :" + parameters[i] + " and ";
}
else
{
hqlquery += "" + parameters[i] + " = :" + parameters[i];
}
}
NHibernate.IQuery query = session.CreateQuery(hqlquery);
for (int i = 0; i < parameters.Length; i++)
{
query.SetParameter("" + parameters[i] + "", values[i]);
}
List <Object> lstobj = new List <Object>();
foreach (Object item in query.Enumerable())
{
lstobj.Add(item);
}
return(lstobj);
}
}
}
/// <getUserInfo>
/// getUserAccount Information by profile id.
/// </summary>
/// <param name="profileid">Account profile id.(String)</param>
/// <returns>Return the object of TwitterAccount class with value.(Domain.TwitterAccount)</returns>
public Domain.Myfashion.Domain.TwitterAccount getUserInfo(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
{
try
{
//Proceed action, to get account details by profile id.
NHibernate.IQuery query = session.CreateQuery("from TwitterAccount where TwitterUserId = :Twtuserid");
query.SetParameter("Twtuserid", profileid);
Domain.Myfashion.Domain.TwitterAccount twtAccount = new Domain.Myfashion.Domain.TwitterAccount();
foreach (Domain.Myfashion.Domain.TwitterAccount item in query.Enumerable <Domain.Myfashion.Domain.TwitterAccount>())
{
twtAccount = item;
break;
}
return(twtAccount);
//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);
}
}
catch
{
return(null);
}
} //End Transaction
} //End Session
}
public List <Domain.Socioboard.Domain.InstagramAccount> GetAllInstagramAccountsOfUser(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())
{
//Proceed action, To get linkedin account by user id.
NHibernate.IQuery query = session.CreateQuery("from InstagramAccount where UserId = :userid");
query.SetParameter("userid", UserId);
List <Domain.Socioboard.Domain.InstagramAccount> alstLIAccounts = new List <Domain.Socioboard.Domain.InstagramAccount>();
foreach (var item in query.Enumerable())
{
alstLIAccounts.Add((Domain.Socioboard.Domain.InstagramAccount)item);
}
return(alstLIAccounts);
} //End Transaction
} //End Session
}
/// <getAllGoogleAnalyticsStatsOfUser>
/// Get All Google Analytics Stats Of User
/// </summary>
/// <param name="UserId">Id of user(Guid)</param>
/// <param name="days">Number of days.(int)</param>
/// <returns>List of array</returns>
public ArrayList getAllGoogleAnalyticsStatsOfUser(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())
{
//Proceed action, to get all data by user id.
NHibernate.IQuery query = session.CreateQuery("from GoogleAnalyticsStats where UserId = :userid");
query.SetParameter("userid", UserId);
ArrayList alstgaStats = new ArrayList();
foreach (var item in query.Enumerable())
{
alstgaStats.Add(item);
}
return(alstgaStats);
} //End Transaction
} //End Session
}
/// <getAllFacebookInsightStatsOfUser>
/// Get all FacebookinsightStats of user from Database by UserId(Guid).
/// </summary>
/// <param name="UserId">UserId FacebookInsightStats(Guid).</param>
/// <returns>Return all Facebookinsight Stats in form of Array List.</returns>
public ArrayList getAllFacebookInsightStatsOfUser(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())
{
//Proceed action, to get all FacebookinsightSatats of user from Database by UserId(Guid).
NHibernate.IQuery query = session.CreateQuery("from FacebookInsightStats where UserId = :userid");
query.SetParameter("userid", UserId);
ArrayList alstFBInsightStats = new ArrayList();
foreach (var item in query.Enumerable())
{
alstFBInsightStats.Add(item);
}
return(alstFBInsightStats);
} //End Transaction
} //End session
}