/// <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 }
/// <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 }
/// <checkGoogelAnalyticsProfileExists> /// Check the google account profile is exist /// </summary> /// <param name="gaUserId">Id of google account(String)</param> /// <param name="gaProfileId">Id of Google profile id(String)</param> /// <param name="Userid">Id of user (Guid)</param> /// <returns>If the propfile is exist its returns True or otherwise it retuns False(True or False)</returns> public bool checkGoogelAnalyticsProfileExists(string gaUserId, string gaProfileId, 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 GoogleAnalyticsAccount where UserId = :userid and GaAccountId = :gaUserId and GaProfileId=:gaProfileId"); query.SetParameter("userid", Userid); query.SetParameter("gaUserId", gaUserId); query.SetParameter("gaProfileId", gaProfileId); 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 }
/// <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 }
/// <DeleteGroup> /// Delete a group of user by profile id , group id and profile id. /// </summary> /// <param name="group">Set the group name and user id in a Groups Class Property and Pass the same Object of Groups Class.(Domain.Groups)</param> /// <returns>Return 1 when Data is deleted Otherwise retun 0. (int)</returns> public int DeleteGroup(Domain.Socioboard.Domain.Groups group) { //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 the group data. NHibernate.IQuery query = session.CreateQuery("delete from Groups where UserId = :userid and GroupName = :name") .SetParameter("name", group.GroupName) .SetParameter("userid", group.UserId); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //End Transaction } //End Session }
/// <checkLinkedInFeedExists> /// Check Linkedin feed is exists or not. /// </summary> /// <param name="feedid">Feed id (String)</param> /// <param name="Userid">User id(Guid)</param> /// <returns>True or False (bool)</returns> public bool checkLinkedInFeedExists(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 linkedin feed. NHibernate.IQuery query = session.CreateQuery("from LinkedInFeed where UserId = :userid and FeedId = :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 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); } } } }
/// <DeleteFacebookAccountByUserid> /// Delete FacebookAccount By userId(Guid) /// </summary> /// <param name="userid">UserId User(Guid)</param> /// <returns>Return integer 1 for true 0 for false.</returns> public int DeleteFacebookAccountByUserid(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 Delete FacebookAccount By userId(Guid) NHibernate.IQuery query = session.CreateQuery("delete from FacebookAccount where UserId = :userid") .SetParameter("userid", userid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //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 }
/// <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 }
/// <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); }
/// <checkFacebookUserExists> /// Check if FacebookUser is Exist in database or not by UserId and FbuserId. /// </summary> /// <param name="FbUserId">Fbuserid of User(String)</param> /// <param name="Userid">UserId of User(Guid)</param> /// <returns>Return true or false</returns> public bool checkFacebookUserExists(string FbUserId, 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 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 FacebookAccount where UserId = :userid and FbUserId = :fbuserid"); query.SetParameter("userid", Userid); query.SetParameter("fbuserid", FbUserId); 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 }
/// <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 }
public int updateSocialProfileStatus(Domain.Myfashion.Domain.SocialProfile socio) { //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 update existing data from new profile value. NHibernate.IQuery query = session.CreateQuery("Update SocialProfile set ProfileStatus=:profilestaus where UserId = :userid and ProfileId = :profileid") .SetParameter("profilestaus", socio.ProfileStatus) .SetParameter("userid", socio.UserId) .SetParameter("profileid", socio.ProfileId); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //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 }
/// <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.Myfashion.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.Myfashion.Domain.LinkedInAccount result = new Domain.Myfashion.Domain.LinkedInAccount(); foreach (Domain.Myfashion.Domain.LinkedInAccount item in query.Enumerable <Domain.Myfashion.Domain.LinkedInAccount>()) { result = item; break; } return(result); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } } //End Transaction } //End Session }
/// <deleteTeam> /// Delete Team /// </summary> /// <param name="team">Set Values of team id and email id in a Team Class Property and Pass the Object of Team Class.(Domein.Team)</param> /// <returns>Return 1 for success and 0 for failure.(int) </returns> public int deleteTeam(Domain.Socioboard.Domain.Team team) { //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 team by user id and email id. NHibernate.IQuery query = session.CreateQuery("delete from Team where UserId = :userid and EmailId = :emailid") .SetParameter("userid", team.UserId) .SetParameter("emailid", team.EmailId); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //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.Myfashion.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.Myfashion.Domain.LinkedInAccount result = query.UniqueResult <Domain.Myfashion.Domain.LinkedInAccount>(); return(result); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End Session }
/// <deleteAllFeedsOfUser> /// Delete All Feeds Of User /// </summary> /// <param name="Profileid">Profile id of user(string)</param> /// <param name="userid">User id(Guid)</param> /// <returns>Return integer 1 for true and 0 for false.</returns> public int deleteAllFeedsOfUser(string Profileid, 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 Delete linkedin feed NHibernate.IQuery query = session.CreateQuery("delete from LinkedInFeed where UserId = :userid and ProfileId = :profileId"); query.SetParameter("userid", userid); query.SetParameter("profileId", Profileid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //End Transaction } //End Session }
/// <GetUserInfo> /// Get the all information of existing admin by UserName and Password. /// </summary> /// <param name="UserName">Admin UserName </param> /// <param name="Password">Admin Password</param> /// <returns>Return Latest Information of Admin</returns> public Domain.Socioboard.Domain.Admin GetUserInfo(string UserName, string Password) { //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 Data from Query //Set the parameters to find the specific Data. NHibernate.IQuery query = session.CreateQuery("from Admin u where u.UserName = : email and u.Password= :password"); query.SetParameter("email", UserName); query.SetParameter("password", Password); // Get the UniqueResult and return. Domain.Socioboard.Domain.Admin result = (Domain.Socioboard.Domain.Admin)query.UniqueResult(); return result; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return null; } }// End using transaction }//End Using 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 DeleteUserPackageRelation(UserPackageRelation userPackageRelation) { int isUpdated = 0; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery query = session.CreateQuery("delete from userPackageRelation where Id = :adsid") .SetParameter("adsid", userPackageRelation.Id); isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } } } catch (Exception ex) { logger.Error("Error : " + ex.StackTrace); Console.WriteLine("Error : " + ex.StackTrace); } return(isUpdated); }
/// <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.Socioboard.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.Socioboard.Domain.Groups grou = query.UniqueResult <Domain.Socioboard.Domain.Groups>(); return(grou); } 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 }
/// <DeleteGroup> /// Delete group by group id. /// </summary> /// <param name="groupid">Id of group(Guid)</param> /// <returns>Return 1 when Data is deleted Otherwise retun 0. (int)</returns> public int DeleteGroup(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 { //Proceed action, to delete a group detail by group guid. NHibernate.IQuery query = session.CreateQuery("delete from Groups where Id = :userid") .SetParameter("userid", groupid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //End Transaction } //End Session }
/// <deleteInstagramUser> /// Delete InstagrameUser from Databse by Inuserid(string) and userid(Guid). /// </summary> /// <param name="Insuserid">Inuserid InstagramAccount(string)</param> /// <param name="userid">userid InstagramAccount(Guid)</param> /// <returns>Return integer 1 for true and 0 for false</returns> public int deleteInstagramUser(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 delete InstagrameUser from Databse. NHibernate.IQuery query = session.CreateQuery("delete from InstagramAccount where InstagramId = :InstagramId and UserId = :UserId") .SetParameter("InstagramId", Insuserid) .SetParameter("UserId", userid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //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 }
/// <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 }
/// <deleteGoogelAnalyticsUser> /// Delete googel analytics user account /// </summary> /// <param name="gauserid">Id of the google account.(String)</param> /// <param name="userid">Id of the user.(Guid)</param> /// <returns>Return int value when successfullt deleted it's return 1 , otherwise return 0</returns> public int deleteGoogelAnalyticsUser(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 delete user account. NHibernate.IQuery query = session.CreateQuery("delete from GoogleAnalyticsAccount where GaAccountId = :gauserid and UserId = :userid") .SetParameter("gauserid", gauserid) .SetParameter("userid", userid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //End Transaction } //End Session }
public bool checkTubmlrUserExists(Domain.Socioboard.Domain.TumblrAccount objTumblrAccount) { //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 TumblrAccount where UserId = :uidd and tblrUserName = :tbuname"); query.SetParameter("uidd", objTumblrAccount.UserId); query.SetParameter("tbuname", objTumblrAccount.tblrUserName); 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 }