/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <returns>true or false</returns>
public bool SaveList(List <D_Board_User_Role_Model> models)
{
NHibernate.ITransaction tran = NhSession.BeginTransaction();
try
{
foreach (var item in models)
{
NhSession.SaveOrUpdate(item);
}
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!tran.WasCommitted && !tran.WasRolledBack)
{
tran.Rollback();
}
}
}
/// <updateTask>
/// Update Task
/// </summary>
/// <param name="task">Set Values in a Tasks Class Property and Pass the Object of Tasks Class.(Domein.Tasks)</param>
public void updateTask(Domain.Socioboard.Domain.Tasks task)
{
//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 task
session.CreateQuery("Update Tasks set TaskMessage =:TaskMessage,UserId =:UserId,AssignTaskTo =:AssignTaskTo,TaskStatus=:TaskStatus,AssignDate=:AssignDate where Id = :taskid and UserId = :userid")
.SetParameter("TaskMessage", task.TaskMessage)
.SetParameter("UserId", task.UserId)
.SetParameter("AssignTaskTo", task.AssignTaskTo)
.SetParameter("TaskStatus", task.TaskStatus)
.SetParameter("AssignDate", task.AssignDate)
.SetParameter("taskid", task.Id)
.SetParameter("userid", task.UserId)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
public NHTransaction(IsolationLevel?isolation, ISessionProvider sessionProvider)
{
var context = sessionProvider.OpenSession;
ISession session = context.Session;
transaction = session.Transaction;
if (transaction.IsActive)
{
isOriginator = false; // The method that first opened the transaction should also close it
}
else if (isolation.HasValue)
{
transaction.Begin(isolation.Value);
}
else
{
transaction.Begin();
}
if (context.Transaction != null)
{
context.Transaction.Committed += (o, s) => OnCommit();
context.Transaction.Disposed += (o, s) => OnDispose();
context.Transaction.Rollbacked += (o, s) => OnRollback();
}
}
public int UpdateReferenceUserByUserId(User user)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update User set ReferenceStatus =:referenceStatus where Id = :id")
.SetParameter("referenceStatus", user.ReferenceStatus)
.SetParameter("id", user.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(i);
}
public List <User> GetUserByCouponCode(User user)
{
List <User> alstUser = new List <User>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
alstUser = session.CreateQuery("from User where CouponCode=:couponCode")
.SetParameter("couponCode", user.CouponCode)
.List <User>().ToList <User>();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(alstUser);
}
public NHTransaction(ISessionProvider sessionProvider)
{
context = sessionProvider.OpenSession;
ISession session = context.Session;
transaction = session.Transaction;
if (transaction.IsActive)
{
isOriginator = false; // The method that first opened the transaction should also close it
}
else if (sessionProvider.Isolation.HasValue)
{
transaction.Begin(sessionProvider.Isolation.Value);
}
else
{
transaction.Begin();
}
logger.InfoFormat("Begin {0}, transaction:{1}, isOriginator:{2}, isolation:{3} [", GetHashCode(), transaction.GetHashCode(), isOriginator, sessionProvider.Isolation);
logger.Indent();
if (context.Transaction != null)
{
context.Transaction.Committed += (o, s) => OnCommit();
context.Transaction.Disposed += (o, s) => OnDispose();
context.Transaction.Rollbacked += (o, s) => OnRollback();
}
}
/// <DeleteDiscoverySearchByUserid>
/// Delete DiscoverySearch from database by userId(Guid)
/// </summary>
/// <param name="userid">UserId of DiscoverySearch(Guid)</param>
/// <returns>Return integer 1 for true 0 for false</returns>
public int DeleteDiscoverySearchByUserid(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 discoverysearch by userid.
NHibernate.IQuery query = session.CreateQuery("delete from DiscoverySearch 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
}
/// <getResultsFromKeyword>
/// Get result from database by keyword
/// </summary>
/// <param name="keyword">Keyword of DiscoverySearch(string)</param>
/// <returns>List of all results by Keyword</returns>
public List <Domain.Socioboard.Domain.DiscoverySearch> getResultsFromKeyword(string keyword)
{
//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 results by Keyword.
List <Domain.Socioboard.Domain.DiscoverySearch> lst = session.CreateQuery("from DiscoverySearch where SearchKeyword = :keyword")
.SetParameter("keyword", keyword)
.List <Domain.Socioboard.Domain.DiscoverySearch>()
.ToList <Domain.Socioboard.Domain.DiscoverySearch>();
#region Oldcode
//foreach (DiscoverySearch item in query.Enumerable())
//{
// lst.Add(item);
//}
#endregion
return(lst);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End session
}
//public int ResetPassword(Guid id, string password)
//{
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// int i = session.CreateQuery("Update User set Password =:pass where Id = :userid")
// .SetParameter("userid", id)
// .SetParameter("pass", password)
// .ExecuteUpdate();
// transaction.Commit();
// return i;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// return 0;
// }
// }
// }
//}
public List <User> GetAllUsersByCreateDate(string date)
{
List <User> alstUser = new List <User>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
alstUser = session.CreateQuery("from User where CreateDate < '2014-02-10' order by CreateDate desc").List <User>().ToList <User>();
//.SetParameter("date", date).List<User>().ToList<User>();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(alstUser);
}
/// <updateTaskStatus>
/// update Task Status
/// </summary>
/// <param name="TaskId">Task id.(guid)</param>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="status">Status.(Bool)</param>
public void updateTaskStatus(Guid TaskId, Guid UserId, bool status)
{
//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 Task status and completion date by user id and task id.
session.CreateQuery("Update Tasks set TaskStatus=:TaskStatus, CompletionDate=:completedate where Id = :taskid and UserId = :userid")
.SetParameter("userid", UserId)
.SetParameter("taskid", TaskId)
.SetParameter("TaskStatus", status)
.SetParameter("completedate", DateTime.Now)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
public void SetUserByUserId(string emailid, string password, Guid id, string username, string accounttype, string couponcode)
{
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,CouponCode=:couponCode where Id = :twtuserid")
.SetParameter("twtuserid", id)
.SetParameter("email", emailid)
.SetParameter("pass", password)
.SetParameter("acctype", accounttype)
.SetParameter("username", username)
.SetParameter("couponCode", couponcode)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public int UpdatePaymentStatusByUserId(User user)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update User set PaymentStatus=:paymentStatus where Id = :userid")
.SetParameter("userid", user.Id)
.SetParameter("paymentStatus", user.PaymentStatus)
.ExecuteUpdate();
transaction.Commit();
}
catch { }
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(i);
}
public int UpdateCreatDateByUserId(User user)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update User set CreateDate =:createDate, AccountType =: accountType , PaymentStatus=:paymentStatus where Id = :id")
.SetParameter("createDate", user.CreateDate)
.SetParameter("accountType", user.AccountType)
.SetParameter("paymentStatus", user.PaymentStatus)
.SetParameter("id", user.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(i);
}
public static void UpdateAccountType(User user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update User set ProfileUrl =:profileurl, UserName =: username , EmailId=:emailid,AccountType=:accounttype,UserStatus=:userstatus,ExpiryDate=:expirydate,TimeZone=:timezone where Id = :twtuserid")
.SetParameter("twtuserid", user.Id)
.SetParameter("profileurl", user.ProfileUrl)
.SetParameter("username", user.UserName)
.SetParameter("emailid", user.EmailId)
.SetParameter("accounttype", user.AccountType)
.SetParameter("userstatus", user.UserStatus)
.SetParameter("expirydate", user.ExpiryDate)
.SetParameter("timezone", user.TimeZone)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public int UpdateUserExpiryDateById(User user)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update User set ExpiryDate=:expirydate, AccountType=:accounttype where Id = :id")
.SetParameter("id", user.Id)
.SetParameter("accounttype", user.AccountType)
.SetParameter("expirydate", user.ExpiryDate)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(i);
}
public int ChangePassword(string newpassword, string oldpassword, string Emailid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//NHibernate.IQuery query = session.CreateQuery("Update User set Password=:password where EmailId = :email and Password = :oldpass");
//query.SetParameter("email", Emailid);
//query.SetParameter("oldpass",oldpassword);
//query.SetParameter("password",newpassword);
//query.ExecuteUpdate();
int i = session.CreateQuery("Update User set Password=:password where EmailId = :email and Password = :oldpass")
.SetParameter("email", Emailid)
.SetParameter("oldpass", oldpassword)
.SetParameter("password", newpassword)
.ExecuteUpdate();
transaction.Commit();
return(i);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
public User getUserInfoByEmail(string emailId)
{
List <User> lstUser = new List <User>();
User user = new User();
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
lstUser = session.CreateQuery("from User u where u.EmailId = : email")
.SetParameter("email", emailId).List <User>().ToList <User>();
user = lstUser[0];
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
user = null;
}
}
}
return(user);
}
/********************/
public List <User> testing()
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
List <User> s = session.CreateQuery("from User").List <User>().ToList <User>();
return(s);
//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 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);
}
}
}
}
/// <getTasksByUserwithDetail>
/// Get Tasks By User with Detail
/// </summary>
/// <param name="USerId">User id.(Guid)</param>
/// <param name="days">Number of Days.(int)</param>
/// <returns>Return values in the form of array list.(ArrayList)</returns>
public ArrayList getTasksByUserwithDetail(Guid USerId, int days, 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())
{
//Proceed action, to get details of task. //ts.UserId=:userid and //.SetParameter("userid", USerId)
//var queryString = @"SELECT * FROM Tasks ts LEFT JOIN User u on ts.AssignTaskTo=u.Id where ts.UserId=:userid and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)";
//var queryString = @"SELECT * FROM Tasks ts LEFT JOIN User u on ts.AssignTaskTo=u.Id where ts.GroupId=:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)";
try
{
var queryString = @"select * from tasks where (AssignTaskTo =:userid or UserId =:userid) and GroupId =:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)";
var query = session.CreateSQLQuery(queryString)
.SetParameter("userid", USerId)
.SetParameter("GroupId", GroupId);
//.SetParameter("GroupId", GroupId);
ArrayList alstTask = new ArrayList();
foreach (var item in query.List())
{
alstTask.Add(item);
}
return(alstTask);
}
catch (Exception)
{
throw;
}
} //End Transaction
} //End Session
}
public List <Domain.Socioboard.Domain.Tasks> getAllTasksOfUserBYDays(Guid Userid, Guid GroupId, int days)
{
List <Domain.Socioboard.Domain.Tasks> alstTask = new List <Domain.Socioboard.Domain.Tasks>();
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())
{
DateTime AssignDate = DateTime.Now;
string AssinDate = AssignDate.AddDays(-days).ToString("yyyy-MM-dd HH:mm:ss");
//Proceed action, to get all task of user.
//NHibernate.IQuery query = session.CreateQuery("from Tasks where (UserId = :Userid or AssignTaskTo =:Userid) and GroupId =:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)");
NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :Userid and GroupId =:GroupId and AssignDate>=:AssinDate");
query.SetParameter("Userid", Userid);
query.SetParameter("GroupId", GroupId);
query.SetParameter("AssinDate", AssinDate);
foreach (var item in query.Enumerable())
{
alstTask.Add((Domain.Socioboard.Domain.Tasks)item);
}
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(alstTask);
}
/// <deleteTask>
/// Delete Task
/// </summary>
/// <param name="taskid">Task id.(String)</param>
/// <param name="userid">User id.(Guid)</param>
/// <returns>Return 1 for true and 0 for false.(int)</returns>
public int deleteTask(string taskid, 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 task by task id and user id.
NHibernate.IQuery query = session.CreateQuery("delete from Task where Id = :taskid and UserId = :userid")
.SetParameter("taskid", taskid)
.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 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);
}
}
}
}
/// <checkTaskExists>
/// checkTaskExists
/// </summary>
/// <param name="TaskId">Task id.(String)</param>
/// <param name="Userid">User id.(Guid)</param>
/// <returns>True and False.(bool)</returns>
public bool checkTaskExists(string TaskId, 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 task details by userid and task id.
NHibernate.IQuery query = session.CreateQuery("from Task where UserId = :userid and Id = :taskid");
query.SetParameter("userid", Userid);
query.SetParameter("taskid", TaskId);
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
}
//public ArrayList getAllTasksOfUser(Guid UserId)
//{
// ArrayList alstTask = new ArrayList();
// 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 get all task of user.
// NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :UserId and AssignTaskTo !=:UserId");
// query.SetParameter("UserId", UserId);
// query.SetParameter("UserId", UserId);
// //query.SetParameter("GroupId", GroupId);
// foreach (var item in query.Enumerable())
// {
// alstTask.Add(item);
// }
// }//End Transaction
// }//End Session
// }
// catch (Exception ex)
// {
// Console.WriteLine("Error : " + ex.StackTrace);
// }
// return alstTask;
//}
public ArrayList getAllTasksOfUser(Guid UserId)
{
ArrayList alstTask = new ArrayList();
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 get all task of user.
NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :UserId ");
query.SetParameter("UserId", UserId);
query.SetParameter("UserId", UserId);
//query.SetParameter("GroupId", GroupId);
foreach (var item in query.Enumerable())
{
alstTask.Add(item);
}
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(alstTask);
}
public NHibernateTransaction(ISession session, IsolationLevel? isolation = null)
{
Assertion.NotNull(session);
this.session = session;
this.transaction = isolation != null ? session.BeginTransaction(isolation.Value) : session.BeginTransaction();
this.isolation = isolation ?? IsolationLevel.Unspecified;
}
private NH.ITransaction BuildTransaction()
{
NH.ITransaction returnValue = null;
if (this.IsTransactional)
{
returnValue = this.Session.BeginTransaction(this.ContextAttribute.SessionFactoryBuilder.TransactionIsolationLevel);
}
return(returnValue);
}
/// <summary>
/// Implementors should start the
/// transaction on the underlying resource
/// </summary>
public void Start()
{
transaction = session.BeginTransaction(level);
if (isReadOnly)
{
previousFlushMode = session.FlushMode;
session.FlushMode = FlushMode.Never;
}
}
public NHTransaction(ISessionProvider sessionProvider)
{
ISession session = sessionProvider.OpenSession.Session;
transaction = session.Transaction;
if (transaction.IsActive)
isOriginator = false; // The method that first opened the transaction should also close it
else
transaction.Begin();
}
public Transaction(NH.ISession session)
{
transaction = session.Transaction;
if (transaction.IsActive)
isOriginator = false; // The method that first opened the transaction should also close it
else
transaction.Begin();
}
public NHibernateTransaction(ISession session, IsolationLevel?isolation = null)
{
Assertion.NotNull(session);
this.session = session;
this.transaction = isolation != null?session.BeginTransaction(isolation.Value) : session.BeginTransaction();
this.isolation = isolation ?? IsolationLevel.Unspecified;
}
public NHTransaction(IsolationLevel? isolation, ISessionProvider sessionProvider)
{
ISession session = sessionProvider.OpenSession.Session;
transaction = session.Transaction;
if (transaction.IsActive)
isOriginator = false; // The method that first opened the transaction should also close it
else if (isolation.HasValue)
transaction.Begin(isolation.Value);
else
transaction.Begin();
}
/// <summary>
/// Add a new student in the database.
/// </summary>
/// <param name="student">Student object</param>
public static void Add(User user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(user);
transaction.Commit();
}
}
}
public static void Update <T>(T obj)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.SaveOrUpdate(obj);
transaction.Commit();
}
}
}
/// <summary>
/// Creates the specified parameters.
/// </summary>
/// <param name="parameters">The parameters.</param>
public void Create(CreateUserParameters parameters)
{
parameters.Password = _crypto.Hash(parameters.Password);
using (ITransaction trans = _session.BeginTransaction())
{
_session.CreateCommandProcedure("User_Create", parameters)
.ExecuteUpdate();
trans.Commit();
}
}
public NHTransaction(IsolationLevel? isolation, ISessionProvider sessionProvider)
{
var context = sessionProvider.OpenSession;
ISession session = context.Session;
transaction = session.Transaction;
if (transaction.IsActive)
isOriginator = false; // The method that first opened the transaction should also close it
else if (isolation.HasValue)
transaction.Begin(isolation.Value);
else
transaction.Begin();
if (context.Transaction != null)
{
context.Transaction.Committed += (o, s) => OnCommit();
context.Transaction.Disposed += (o, s) => OnDispose();
context.Transaction.Rollbacked += (o, s) => OnRollback();
}
}
public NHTransaction(ISessionProvider sessionProvider)
{
context = sessionProvider.OpenSession;
ISession session = context.Session;
transaction = session.Transaction;
if (transaction.IsActive)
isOriginator = false; // The method that first opened the transaction should also close it
else if (sessionProvider.Isolation.HasValue)
transaction.Begin(sessionProvider.Isolation.Value);
else
transaction.Begin();
logger.InfoFormat("Begin {0}, transaction:{1}, isOriginator:{2}, isolation:{3} [", GetHashCode(), transaction.GetHashCode(), isOriginator, sessionProvider.Isolation);
logger.Indent();
if (context.Transaction != null)
{
context.Transaction.Committed += (o, s) => OnCommit();
context.Transaction.Disposed += (o, s) => OnDispose();
context.Transaction.Rollbacked += (o, s) => OnRollback();
}
}
public TransactionWrapper(NHibernate.ITransaction transaction)
{
this.transaction = transaction;
}
public void AfterTransactionBegin(ITransaction tx)
{
}
public void BeforeTransactionCompletion(ITransaction tx)
{
}
public void AfterTransactionCompletion(ITransaction tx)
{
}
