/// <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(); } } }