/// <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
}
