/// <summary>
///
/// </summary>
public void Begin(ISession sess)
{
if (InTransaction)
{
throw new Exceptions.IncorrectTransactionStatusException("Transaction has already begun");
}
nhtransaction = sess.BeginTransaction();
}
public NHibernateTransaction(NHibernate.ITransaction transaction, Action<NHibernateTransaction> committed, Action<NHibernateTransaction> rolledBack)
{
if (transaction == null)
throw new ArgumentNullException("transaction", "The transaction must not be null");
_committed = committed;
_rolledBack = rolledBack;
_transaction = transaction;
}
/// <summary>
/// Attaches to an existing transaction bute doesn't create one otherwise
/// </summary>
/// <param name="attachToExistingOnly"></param>
public Transaction(bool attachToExistingOnly)
{
NHibernate.ISession session = SessionProvider.Instance.GetOpenSession();
this.tx = session.Transaction;
//Check if the transaction is already active, if so, the method that opened it
//needs to close it.
if (this.tx.IsActive)
this.isOriginator = false;
}
public void Dispose(bool disposing)
{
if (_disposed) return;
if (disposing)
{
if (_transaction != null)
{
_transaction.Dispose();
_transaction = null;
}
}
_disposed = true;
}
/// <summary>
/// Try commit the nhtransaction, if failed the nhtransaction will be rollback and the session will be close
/// </summary>
public void Commit()
{
CheckInTransaction();
try
{
if ( !nhtransaction.WasCommitted && !nhtransaction.WasRolledBack)
{
nhtransaction.Commit();
}
}
catch (Exception)
{
try
{
Rollback();
}
catch (Exception e)
{
//Catch the exception thrown from RollBackTransaction() to prevent the original exception from being swallowed.
ILog log = LogFactory.Log;
if (log.IsErrorEnabled)
{
log.Error("NHibernate.Burrow Rollback failed", e);
}
else
{
Console.WriteLine(e);
}
}
throw;
}
finally
{
nhtransaction = null;
}
}
public int UpdateGooglePlusAccount(Domain.Socioboard.Domain.GooglePlusAccount _GooglePlusAccount)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update GooglePlusAccount set InYourCircles =: InYourCircles, HaveYouInCircles =: HaveYouInCircles where UserId =: UserId and GpUserId =: GpUserId")
.SetParameter("InYourCircles", _GooglePlusAccount.InYourCircles)
.SetParameter("HaveYouInCircles", _GooglePlusAccount.HaveYouInCircles)
.SetParameter("UserId", _GooglePlusAccount.UserId)
.SetParameter("GpUserId", _GooglePlusAccount.GpUserId)
.ExecuteUpdate();
transaction.Commit();
return(i);
}
catch (Exception ex) {
return(0);
}
}
}
}
public List <Domain.Socioboard.Domain.Team> GetAllTeamExcludeUser(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
{
List <Domain.Socioboard.Domain.Team> alstFBAccounts = session.CreateQuery("from Team where GroupId=:groupId")
.SetParameter("groupId", groupId)
.List <Domain.Socioboard.Domain.Team>()
.ToList <Domain.Socioboard.Domain.Team>();
return(alstFBAccounts);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public int UpdateTumblrAccount(Domain.Socioboard.Domain.TumblrAccount _TumblrAccount, string tumblrUserName)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update tumblraccount set tblrProfilePicUrl=:TumblrProfilePicUrl, tblrUserName =:TumblrUserName where tblrUserName =:TumblrUserNameold")
.SetParameter("TumblrUserName", _TumblrAccount.tblrUserName)
.SetParameter("TumblrProfilePicUrl", _TumblrAccount.tblrProfilePicUrl)
.SetParameter("TumblrUserNameold", tumblrUserName)
.ExecuteUpdate();
transaction.Commit();
return(i);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
/// <getAllFacebookUserFeeds>
/// Get All Facebook User Feeds
/// </summary>
/// <param name="profileid">Profile id</param>
/// <returns>List of Facebbok feeds (List<FacebookFeed>)</returns>
public List <Domain.Socioboard.Domain.TwitterFeed> getAllFeedsOfSBUserWithRangeByProfileId(string profileid, string noOfDataToSkip, string noOfResultsFromTop)
{
//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 get all facebook feeds of profile by facebook profile id
List <Domain.Socioboard.Domain.TwitterFeed> alst = session.Query <Domain.Socioboard.Domain.TwitterFeed>().Where(x => x.ProfileId.Equals(profileid)).OrderByDescending(x => x.FeedDate).Skip(Convert.ToInt32(noOfDataToSkip)).Take(Convert.ToInt32(noOfResultsFromTop))//.CreateQuery("from FacebookFeed where UserId = :UserId and FeedDescription like %' =:keyword '% ORDER BY FeedDate DESC")
.ToList <Domain.Socioboard.Domain.TwitterFeed>();
return(alst);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} // End se
}
public void Delete <T>(T item) where T : class, new()
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession(_env))
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Delete(item);
transaction.Commit();
}
}
}
catch (Exception ex)
{
_logger.LogCritical(ex.Message);
_logger.LogError(ex.StackTrace);
if (ex.InnerException != null)
{
_logger.LogError(ex.InnerException.Message);
_logger.LogError(ex.InnerException.StackTrace);
}
}
}
/// <getAllDirectMessagesByScreenName>
/// Get All Direct Messages By ScreenName
/// </summary>
/// <param name="screenName">Twitter account screen name.(String)</param>
/// <returns>Return object of TwitterDirectMessages Class with value of each member in the form of list.(List<TwitterDirectMessages>)</returns>
public List <Domain.Socioboard.Domain.TwitterDirectMessages> getAllDirectMessagesByScreenName(string screenName)
{
//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 Messages by screen name.
List <Domain.Socioboard.Domain.TwitterDirectMessages> alstFBAccounts = session.CreateQuery("from TwitterDirectMessages where SenderScreenName = :teamid")
.SetParameter("teamid", screenName)
.List <Domain.Socioboard.Domain.TwitterDirectMessages>()
.ToList <Domain.Socioboard.Domain.TwitterDirectMessages>();
//List<TwitterDirectMessages> alstFBAccounts = new List<TwitterDirectMessages>();
//foreach (TwitterDirectMessages item in query.Enumerable())
//{
// alstFBAccounts.Add(item);
//}
return(alstFBAccounts);
} //End Transaction
} //End Session
}
/// <IsDraftsMessageExist>
/// Check the draft message is exist or not.
/// </summary>
/// <param name="UserId">Guid of user</param>
/// <param name="message">Draft message</param>
/// <returns>It is return bool value. If draft is exist it returns true otherwise false </returns>
public bool IsDraftsMessageExist(Guid UserId, string message)
{
//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 check draft by user id and message.
NHibernate.IQuery query = session.CreateQuery("From Drafts where UserId = :userid and Message =:mess");
query.SetParameter("userid", UserId);
query.SetParameter("mess", message);
List <Domain.Socioboard.Domain.Drafts> lst = new List <Domain.Socioboard.Domain.Drafts>();
foreach (Domain.Socioboard.Domain.Drafts item in query.Enumerable <Domain.Socioboard.Domain.Drafts>())
{
lst.Add(item);
}
if (lst.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End trasaction
} //End session
}
/// <deleteAllFeedsOfUser>
/// Delete all feeds of user from database by facebook user id(String) and User id(Guid).
/// </summary>
/// <param name="fbuserid">facebook userid (String)</param>
/// <param name="userid">userid(Guid)</param>
public void deleteAllFeedsOfUser(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 Delete instagram feed.
NHibernate.IQuery query = session.CreateQuery("delete from InstagramFeed where UserId = :userid and InstagramId = :profileId");
query.SetParameter("userid", userid);
query.SetParameter("profileId", fbuserid);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End Session
}
/// <UpdateGroupProfile>
/// Update the details of group profile
/// </summary>
/// <param name="group">Set Values in a GroupProfile Class Property and Pass the same Object of GroupProfile Class.(Domain.GroupProfile)</param>
public void UpdateGroupProfile(Domain.Socioboard.Domain.GroupProfile 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 update specific data by user id.
session.CreateQuery("Update GroupProfiles set EntryDate =:entrydate where Id = :userid")
.SetParameter("userid", group.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
public Domain.Myfashion.Domain.WordpressSites GetSiteBySiteId(Guid UserId, string SiteId)
{
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 alst = session.CreateQuery("from WordpressSites where UserId = :userid and SiteId =: SiteId");
alst.SetParameter("userid", UserId);
alst.SetParameter("SiteId", SiteId);
return((Domain.Myfashion.Domain.WordpressSites)alst.UniqueResult());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(new Domain.Myfashion.Domain.WordpressSites());
}
} //End Transaction
} //End session
}
public void updateTeambyteamid(Guid teamid)
{
//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 team details.
session.CreateQuery("Update Team set InviteStatus=1 where Id = :teamid")
.SetParameter("teamid", teamid)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
/// <getAdsForHome>
/// Get Latest two Ads for Home Page.
/// </summary>
/// <returns>Return Latest two Ads in the Form of Array List.</returns>
public ArrayList getAdsForHome()
{
//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())
{
ArrayList lstAd = new ArrayList();
try
{
// Proceed action to get ads
// And return list of ad's
var query = session.CreateSQLQuery("Select Id,Advertisment,ImageUrl,Script,Status from Ads Where ExpiryDate>CURDATE() and Status=1 order by EntryDate Desc limit 2");
// Get list from query
foreach (var item in query.List())
{
// Add the all return value in list from query.
//Array temp = (Array)item;
lstAd.Add(item);
//ads.Id = Guid.Parse(temp.GetValue(0).ToString());
//ads.Advertisment = temp.GetValue(1).ToString();
//ads.ImageUrl = temp.GetValue(2).ToString();
//ads.Script = temp.GetValue(3).ToString();
//ads.Status = bool.Parse(temp.GetValue(2).ToString());
}// End ForEach
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
return(lstAd);
} // End using Transaction
} // End using session
}
public int UpdateUsingSchName(SchFanPageLiker schFanPageLiker)
{
lock (lockerUpdateUsingCmpName)
{
int res = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("Update SchFanPageLiker set SchedulerProcess = :SchedulerProcess, AccountsFile= :AccountsFile, FanPageURLsFile= :FanPageURLsFile, FanPageMessageFile= :FanPageMessageFile, FanPageCommentsFile = :FanPageCommentsFile, StartDate = :StartDate, EndDate = :EndDate, StartTime = :StartTime, EndTime = :EndTime where SchedulerName= :SchedulerName");
query.SetParameter("SchedulerProcess", schFanPageLiker.SchedulerProcess);
query.SetParameter("AccountsFile", schFanPageLiker.AccountsFile);
query.SetParameter("FanPageURLsFile", schFanPageLiker.FanPageURLsFile);
query.SetParameter("FanPageMessageFile", schFanPageLiker.FanPageMessageFile);
query.SetParameter("FanPageCommentsFile", schFanPageLiker.FanPageCommentsFile);
query.SetParameter("StartDate", schFanPageLiker.StartDate);
query.SetParameter("EndDate", schFanPageLiker.EndDate);
query.SetParameter("StartTime", schFanPageLiker.StartTime);
query.SetParameter("EndTime", schFanPageLiker.EndTime);
query.SetParameter("SchedulerName", schFanPageLiker.SchedulerName);
res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(res);
}
}
public Domain.Myfashion.Domain.TicketAssigneeStatus getAssignedMembersByUserId(Guid AssigneeUserId)
{
//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 team id.
NHibernate.IQuery query = session.CreateQuery("from TicketAssigneeStatus where AssigneeUserId =: AssigneeUserId");
query.SetParameter("AssigneeUserId", AssigneeUserId);
var result = query.UniqueResult();
return((Domain.Myfashion.Domain.TicketAssigneeStatus)result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public ArrayList UnPaidUserCountByMonth()
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
ArrayList alstUser = new ArrayList();
try
{
NHibernate.IQuery query = session.CreateSQLQuery("Select month(CreateDate),Count(*) from User where PaymentStatus='unpaid' group by month(CreateDate)");
foreach (var item in query.List())
{
alstUser.Add(item);
}
return(alstUser);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
return(alstUser);
}
}
}
}
/// <SavePayPalTransaction>
/// Save PayPal Transaction Details
/// </summary>
/// <param name="paymentTransaction">Set the payment details in a payment Transaction Class Property and Pass the Object of PaymentTransaction Class.(Domain.paymentTransaction)</param>
public string SavePayPalTransaction(PaymentTransaction paymentTransaction)
{
try
{
//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 save details of paypal transaction.
session.Save(paymentTransaction);
transaction.Commit();
return("Success");
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return("Failure");
}
}
/// <getPackageDetails>
/// Get Package Details by package name.
/// </summary>
/// <param name="packagename">package name.(String)</param>
/// <returns>Return the object of package class with value.(Domain.package)</returns>
public Package getPackageDetails(string packagename)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//proceed action, to get package details by name.
NHibernate.IQuery query = session.CreateQuery("from Package where PackageName=:packagename");
query.SetParameter("packagename", packagename);
Package grou = query.UniqueResult <Package>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <getAllFacebookFeedsOfUser>
/// get All Facebook Feeds Of User
/// </summary>
/// <param name="UserId">Userid of FacebookFeed</param>
/// <param name="profileid">Profileid of FacebookFeed</param>
/// <returns>List of Facebook feeds.(List<FacebookFeed>)</returns>
public List <Domain.Socioboard.Domain.FacebookFeed> getAllFacebookFeedsOfUser(Guid UserId, string profileid)
{
//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 get all data of facebook feed by user id and profileid.
List <Domain.Socioboard.Domain.FacebookFeed> alst = session.CreateQuery("from FacebookFeed where UserId = :userid and ProfileId = :profileId")
.SetParameter("userid", UserId)
.SetParameter("profileId", profileid)
.List <Domain.Socioboard.Domain.FacebookFeed>()
.ToList <Domain.Socioboard.Domain.FacebookFeed>();
#region oldcode
//List<FacebookFeed> alst = new List<FacebookFeed>();
//foreach (FacebookFeed item in query.Enumerable<FacebookFeed>().OrderByDescending(x => x.FeedDate))
//{
// alst.Add(item);
//}
#endregion
return(alst);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
} //End session
public BusinessSetting IsAssignTaskEnable(Guid groupId)
{
// bool flag = 0;
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
List <BusinessSetting> lstdetails = session.CreateQuery("from BusinessSetting where groupId=:groupId")
.SetParameter("groupId", groupId).List <BusinessSetting>().ToList <BusinessSetting>();
BusinessSetting objBsnsStng = lstdetails[0];
//flag = objBsnsStng.AssigningTasks;
//if (objBsnsStng.AssigningTasks == true)
//{
// return true;
//}
//else
//{
// return false;
//}
return(objBsnsStng);
}
}
}
/// <getFacebookUserWallPost>
/// Get all wall post of Facebook User by UserId(Guid) and ProfileId(String).
/// </summary>
/// <param name="userid">userid FacebookMessage(Guid)</param>
/// <param name="profileid">profileid FacebookMessage(string)</param>
/// <returns>Return a object of FacebookMessage Class with value of each member in form List type.</returns>
public List <FacebookMessage> getFacebookUserWallPost(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 wall post of Facebook User.
List <FacebookMessage> alst = session.CreateQuery("from FacebookMessage where UserId = :userid and ProfileId = :profileId and Type='fb_home'")
.SetParameter("userid", userid)
.SetParameter("profileId", profileid)
.List <FacebookMessage>()
.ToList <FacebookMessage>();
#region oldcode
//List<FacebookMessage> alst = new List<FacebookMessage>();
//foreach (FacebookMessage item in query.Enumerable<FacebookMessage>().OrderByDescending(x => x.MessageDate))
//{
// alst.Add(item);
//}
#endregion
return(alst);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
public Domain.Socioboard.Domain.ShareathonGroup getShareathon(Guid Id)
{
Domain.Socioboard.Domain.ShareathonGroup shareathon = null;
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from ShareathonGroup where Id = :ID");
query.SetParameter("ID", Id);
Domain.Socioboard.Domain.ShareathonGroup result = (Domain.Socioboard.Domain.ShareathonGroup)query.UniqueResult();
shareathon = result;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End session
return(shareathon);
}
/// <getNewsDetails>
/// Get the all info of news by news details.
/// </summary>
/// <param name="newsdetail">New details.</param>
/// <returns>Return object of News Class with all news info.(List<News>)</returns>
public News getNewsDetails(string newsdetail)
{
//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 the all info of news by news details.
NHibernate.IQuery query = session.CreateQuery("from Package where NewsDetail=:newsdetail");
query.SetParameter("newsdetail", newsdetail);
News grou = query.UniqueResult <News>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public List <Domain.Myfashion.Domain.TeamMemberProfile> getLinkedInTeamMemberProfileData(Guid TeamId)
{
//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 details of team by team id.
List <Domain.Myfashion.Domain.TeamMemberProfile> alstFBAccounts = session.CreateQuery("from TeamMemberProfile where TeamId = :teamid and ProfileType='linkedIn'")
.SetParameter("teamid", TeamId)
.List <Domain.Myfashion.Domain.TeamMemberProfile>()
.ToList <Domain.Myfashion.Domain.TeamMemberProfile>();
//List<TeamMemberProfile> alstFBAccounts = new List<TeamMemberProfile>();
//foreach (TeamMemberProfile item in query.Enumerable())
//{
// alstFBAccounts.Add(item);
//}
return(alstFBAccounts);
} //End Transaction
} //End Session
}
public Domain.Socioboard.Domain.InboxMessages getInboxMessageByMessageId(Guid UserId, Guid MessageId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery results = session.CreateQuery("from InboxMessages Where UserId =: UserId and Id =: MessageId")
.SetParameter("UserId", UserId)
.SetParameter("MessageId", MessageId);
Domain.Socioboard.Domain.InboxMessages result = (Domain.Socioboard.Domain.InboxMessages)results.UniqueResult();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(new Domain.Socioboard.Domain.InboxMessages());
}
} //End using transaction
} //End using session
}
public int UpdateCode(Guid userid, string code)
{
int i = 0;
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update User set UserCode=:code where Id = :Id")
.SetParameter("code", code)
.SetParameter("Id", userid)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
i = 0;
}
}
}
return(i);
}
/// <getTeamByEmailId>
/// Get Team By Email Id.
/// </summary>
/// <param name="EmailId">memver Email id.(String)</param>
/// <returns>Return the object of Team class with value.(Domain.Team)</returns>
public Domain.Socioboard.Domain.Team getTeamByEmailId(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 team details.
NHibernate.IQuery query = session.CreateQuery("from Team where EmailId =:memberId");
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
}
public void UpdatePassword(string emailid, string password, Guid id, string username, string accounttype)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update User set EmailId=:email, UserName =: username, Password =:pass, AccountType= :acctype where Id = :twtuserid")
.SetParameter("twtuserid", id)
.SetParameter("email", emailid)
.SetParameter("pass", password)
.SetParameter("acctype", accounttype)
.SetParameter("username", username)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public int UpdateUserRefRelation(UserRefRelation userRefRelation)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update UserRefRelation set ReferenceUserId =:referenceUserId, RefereeUserId =: refereeUserId , ReferenceUserEmail=:referenceUserEmail,RefereeUserEmail =:refereeUserEmail,EntryDate =:entryDate where Id = :id")
.SetParameter("referenceUserId", userRefRelation.ReferenceUserId)
.SetParameter("refereeUserId", userRefRelation.RefereeUserId)
.SetParameter("referenceUserEmail", userRefRelation.ReferenceUserEmail)
.SetParameter("refereeUserEmail", userRefRelation.RefereeUserEmail)
.SetParameter("entryDate", userRefRelation.EntryDate)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(i);
}
/// <updateFriendsCount>
/// update afriends in FacebookAccount by FbUserId(string).
/// </summary>
/// <param name="fbUserId">fbUserId of FacebookAccount(string)</param>
/// <param name="UserID">UserId of User(Guid)</param>
/// <param name="friends">friends of FacebookAccount (Frinds)</param>
public void updateFriendsCount(string fbUserId, Guid UserID, int friends)
{
//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 friends in FacebookAccount by FbUserId(string).
session.CreateQuery("update FacebookAccount set Friends =:friends where FbUserId =:fbuserid")
.SetParameter("fbuserid", fbUserId)
.SetParameter("friends", friends)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End session
}
public void DeleteUsingMainPageUrl(FanPageStatus fpStatus)
{
try
{
lock (lockerDeleteUsingMainPageUrl)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("Delete from FanPageStatus where MainPageUrl= :mainPageUrl");
query.SetParameter("mainPageUrl", fpStatus.MainPageUrl);
int res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public NHibernateTransactionWrapper(NHTransaction transaction)
{
_transaction = transaction;
}
public ResourceAdapter(ITransaction transaction)
{
this.transaction = transaction;
}
public void Dispose()
{
if (_dispose)
{
//Usually the Transaction implementation automatically rollback the transaction when Dispose is called
// but seems that MySql doesn't follow this rule so I manually call a RollBack to be sure.
if (NHibernateTransaction != null)
{
if (NHibernateTransaction.IsActive)
NHibernateTransaction.Rollback();
NHibernateTransaction.Dispose();
}
NHibernateSession.Dispose();
}
NHibernateTransaction = null;
NHibernateSession = null;
}
/// <summary>
/// Rollback the Transaction and Close Session
/// </summary>
/// <remarks>
/// if the tranasaction has already been rollback or the session closed this will do nothing.
/// You can perform this method multiple times, only the first time will take effect.
/// </remarks>
public void Rollback()
{
try
{
if (nhtransaction != null && !nhtransaction.WasCommitted && !nhtransaction.WasRolledBack)
{
nhtransaction.Rollback();
}
} catch (Exception e)
{
//Catch the exception thrown from to prevent the original exception from being swallowed.
try
{
ILog log = LogManager.GetLogger(typeof (SessionAndTransactionManager));
if (log.IsErrorEnabled)
{
log.Error("NHibernate.Burrow Rollback failed", e);
}
else
{
Console.WriteLine(e);
}
}
catch (Exception) {}
}
finally
{
nhtransaction = null;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="ResourceAdapter"/> class.
/// </summary>
/// <param name="transaction">The transaction.</param>
/// <param name="isAmbient"></param>
public ResourceAdapter(ITransaction transaction, bool isAmbient)
{
this.transaction = transaction;
this.isAmbient = isAmbient;
}
/// <summary>
/// Default Constructor.
/// Creates a new instance of the <see cref="NhTransaction"/> instance.
/// </summary>
/// <param name="transaction">The underlying NHibernate.ITransaction instance.</param>
public NhTransaction(NHibernate.ITransaction transaction)
{
Throw.IfArgumentNull(transaction == null, "Expected a non null NHibernate.ITransaction instance.");
_transaction = transaction;
}
