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 }