/// <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
}
/// <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
}
/// <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
}
/// <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();
}
}
}
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 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 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 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);
}
}
}
}
/// <summary>
/// 提交事务
/// </summary>
public void Commit()
{
if (isOriginator && !transaction.WasCommitted && !transaction.WasRolledBack)
{
transaction.Commit();
}
}
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 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);
}
/// <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 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);
}
/// <summary>
/// Commit this instance.
/// </summary>
public void Commit()
{
AssertNotFinalised();
if (mayCommitAndDispose)
{
transaction.Commit();
}
IsFinal = true;
}
/// <summary>
/// Commits transaction and closes database connection.
/// </summary>
public void Commit()
{
try
{
_transaction.Commit();
}
finally
{
Session.Close();
}
}
/// <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();
}
}
/// <addNewSearchResult>
/// Add a new search result in a database.
/// </summary>
/// <param name="dis">Set Values in a DiscoverySearch Class Property and Pass the same Object of DiscoverySearch Class.(Domain.DiscoverySearch)</param>
public void addNewSearchResult(Domain.Socioboard.Domain.DiscoverySearch dis)
{
//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 data.
session.Save(dis);
transaction.Commit();
} //End Transaction
} //End session
}
/// <AddDrafts>
/// Add new draft
/// </summary>
/// <param name="d">Set Values in a Draft Class Property and Pass the Object of Draft Class (SocioBoard.Domain.Draft).</param>
public void LeadKeyword(Domain.Socioboard.Domain.DiscoveryLeads lead)
{
//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())
{
//Proceed action , to save data.
session.Save(lead);
transaction.Commit();
} //End transaction
} //End session
}
/// <summary>
/// Commit this instance.
/// </summary>
public void Commit()
{
if (IsFinal || disposedValue)
{
throw new InvalidTransactionOperationException(Resources.ExceptionMessages.CannotCommitAlreadyFinalised);
}
if (mayCommitAndDispose)
{
transaction.Commit();
}
IsFinal = true;
}
public bool SaveWorkFlowLog(D_Report_Model model, D_WorkFlowLog_Model logModel)
{
NHibernate.ITransaction tran = NhSession.BeginTransaction();
try
{
logModel.ReportGuid = model;
NhSession.SaveOrUpdate(model.ReportD2);
NhSession.SaveOrUpdate(model);
if (model.ReportD8DataModels.Count > 0)
{
foreach (var item in model.ReportD8DataModels)
{
NhSession.SaveOrUpdate(item);
}
}
if (model.WorkFlow_Models.Count > 0)
{
foreach (var item in model.WorkFlow_Models)
{
NhSession.SaveOrUpdate(item);
}
}
if (model.WorkFlowLog_Models.Count > 0)
{
foreach (var item in model.WorkFlowLog_Models)
{
NhSession.SaveOrUpdate(item);
}
}
NhSession.SaveOrUpdate(model);
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!tran.WasCommitted && !tran.WasRolledBack)
{
tran.Rollback();
}
}
}
/// <summary>Commits the transaction.</summary>
public void Commit()
{
if (isOriginator && !transaction.WasCommitted && !transaction.WasRolledBack)
{
logger.InfoFormat("Committing {0}", transaction.GetHashCode());
transaction.Commit();
IsCommitted = true;
RemoveFromContext();
OnCommit();
}
else
{
logger.WarnFormat("Not commiting {0}, isOriginator:{1}, wasCommitted:{2}, wasRolledBack:{3}", transaction.GetHashCode(), isOriginator, transaction.WasCommitted, transaction.WasRolledBack);
}
}
public int DeleteTaskOfGroup(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 delete task of user by groupId.
NHibernate.IQuery query = session.CreateQuery("delete from Tasks where GroupId = :GroupId")
.SetParameter("GroupId", groupId);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
}
}
public void Update(GroupCampaign groupCamp)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Update(groupCamp.GroupCampaignName, groupCamp);
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public void UpdateAccountType(Guid Userid, string AccountType)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update User set AccountType=:acctype where Id = :userid")
.SetParameter("userid", Userid)
.SetParameter("acctype", AccountType)
.ExecuteUpdate();
transaction.Commit();
}
catch { }
}
}
}
public void DeleteSelectRows(GroupCampaign ObjGrpCamp)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateSQLQuery("delete from GroupCampaign WHERE GroupCampaignName = :CampaignName and Module =:module").SetParameter("CampaignName", ObjGrpCamp.GroupCampaignName).SetParameter("module", ObjGrpCamp.Module);
int res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public void DeleteAll()
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("delete from GroupCampaign");
int res = query.ExecuteUpdate();
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
/// <addTask>
/// Add New Task
/// </summary>
/// <param name="task">Set Values in a Tasks Class Property and Pass the Object of Tasks Class.(Domein.Tasks)</param>
public void addTask(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 save new data.
session.Save(task);
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End Session
}
/// <summary>
/// 删除数据字典
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(D_Dictionary_Model model)
{
NHibernate.ITransaction tran = NhSession.BeginTransaction();
try
{
NhSession.Delete(model);
tran.Commit();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (!tran.WasCommitted && !tran.WasRolledBack)
{
tran.Rollback();
}
}
}
