public async Task SetPasswordHashAsync(UserModel user, string passwordHash) { user.PasswordHash = passwordHash; using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { var foundUser = db.Get <UserModel>(user.Id); if (foundUser != null) { foundUser.PasswordHash = passwordHash; db.Update(foundUser); tx.Commit(); db.Flush(); } //user.PasswordHash = passwordHash; } } /*using (var db = HibernateSession.GetCurrentSession()) * { * using (var tx = db.BeginTransaction()) * { * user = db.Get<UserModel>(user.Id); * user.PasswordHash = passwordHash; * db.SaveOrUpdate(user); * tx.Commit(); * db.Flush(); * } * }*/ }
//[Untested("OnDisposedActions", "Rollback", "Exception", "NotCommitted", "OnlyOnCommit = false")] public void Dispose() { var currentContext = _ContextStack.Pop(); WasDisposed = true; if (_shouldDispose) { _backingSession.Dispose(); } var actions = currentContext.DisposeActions.ToList(); currentContext.DisposeActions.Clear(); foreach (var a in actions) { if (!a.OnlyOnCommit || (!currentContext.TransactionRolledBack && currentContext.TransactionCommitted)) { using (var s = HibernateSession.GetCurrentSession()) { using (var tx = s.BeginTransaction()) { AsyncHelper.RunSync(() => { return(a.Action(s, tx)); }); } } } } }
public async Task <POHeaderModel> FindPOAByIdAsync(long Id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <POHeaderModel>(Id)); } } }
public async Task <NonCatalogItemHeadModel> GetNonCatalogAsync(long id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <NonCatalogItemHeadModel>(id)); } } }
public async Task <IList <POAprovalModel> > FindPOAprovalAsync(POHeaderModel pr) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <POAprovalModel>().Where(x => x.POHeader == pr).List()); } } }
public async Task <UserModel> FindByIdAsync(string userId) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <UserModel>(userId)); } } }
public async Task <UserModel> FindByNameAsync(string userName) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <UserModel>().Where(x => x.UserName == userName).SingleOrDefault()); } } }
public async Task <IList <NonCatalogItemHeadModel> > FindIdNonCatalogHeadListAsync(long id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <NonCatalogItemHeadModel>().Where(x => x.DeleteTime == null && x.Id == id).OrderBy(x => x.CreateTime).Desc.List()); } } }
public async Task <IList <DriverModel> > GetAllForValidationAsync() { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <DriverModel>().Where(x => x.Status == RegistrationStatus.ForValidation && x.DeleteTime == null).List()); } } }
public async Task <bool> HasPasswordAsync(UserModel user) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <UserModel>(user.Id).PasswordHash != null); } } }
public async Task <EmployeeModel> GetEmployeeAsync(string id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <EmployeeModel>(id)); } } }
public async Task <TokenModel> FindByTokenAsync(string token) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <TokenModel>().Where(x => x.Status == StatusType.Active && x.Token == token).SingleOrDefault()); } } }
public async Task <IList <UserModel> > GetAllAdminEmailAsync() { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <UserModel>().Where(x => x.IsAdmin == true && x.DeleteTime == null).List()); } } }
//protected static TaskAccessor _TaskAccessor = new TaskAccessor(); //protected static TeamAccessor _TeamAccessor = new TeamAccessor(); //protected static NexusAccessor _NexusAccessor = new NexusAccessor(); //protected static ImageAccessor _ImageAccessor = new ImageAccessor(); //protected static GroupAccessor _GroupAccessor = new GroupAccessor(); //protected static OriginAccessor _OriginAccessor = new OriginAccessor(); //protected static ReviewAccessor _ReviewAccessor = new ReviewAccessor(); //protected static AskableAccessor _AskableAccessor = new AskableAccessor(); //protected static PaymentAccessor _PaymentAccessor = new PaymentAccessor(); //protected static KeyValueAccessor _KeyValueAccessor = new KeyValueAccessor(); //protected static PositionAccessor _PositionAccessor = new PositionAccessor(); //protected static QuestionAccessor _QuestionAccessor = new QuestionAccessor(); //protected static CategoryAccessor _CategoryAccessor = new CategoryAccessor(); //protected static PrereviewAccessor _PrereviewAccessor = new PrereviewAccessor(); //protected static ScorecardAccessor _ScorecardAccessor = new ScorecardAccessor(); //protected static PermissionsAccessor _PermissionsAccessor = new PermissionsAccessor(); //protected static OrganizationAccessor _OrganizationAccessor = new OrganizationAccessor(); //protected static DeepSubordianteAccessor _DeepSubordianteAccessor = new DeepSubordianteAccessor(); // protected static ResponsibilitiesAccessor _ResponsibilitiesAccessor = new ResponsibilitiesAccessor(); #endregion #region GetUserModel protected UserModel GetUserModel(bool styles = false) { using (var s = HibernateSession.GetCurrentSession()) { using (var tx = s.BeginTransaction()) { return(GetUserModel(s, styles)); } } }
public async Task <PRLinesModel> GetPRLineAsync(long Id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <PRLinesModel>(Id)); } } }
public async Task UpdateAsync(UserModel user) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { db.SaveOrUpdate(user); } } }
public async Task <CostAproverModel> FindCostApprover(double amount) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <CostAproverModel>().Where(x => amount >= x.Min && amount <= x.Max).SingleOrDefault()); } } }
public async Task <IList <TeamModel> > GetAllTeamAsync() { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <TeamModel>().Where(x => x.DeleteTime == null).List()); } } }
public async Task <IList <EmployeeModel> > TeamEmployeeAsync(TeamModel team) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <EmployeeModel>().Where(x => x.Team == team && x.DeleteTime == null).List()); } } }
public async Task <IList <NonCatalogItemHeadModel> > FindLatestNonCatalogHeadAsync(int count) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <NonCatalogItemHeadModel>().Where(x => x.DeleteTime == null).OrderBy(x => x.CreateTime).Desc.Take(count).List()); } } }
public async Task <DepartmentModel> GetDepartmentByIdAsync(long id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <DepartmentModel>(id)); } } }
public async Task <UserModel> FindAsync(UserLoginInfo login) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <UserModel>().Where(x => x.Logins.Any(y => y.ProviderKey == login.ProviderKey && login.LoginProvider == y.LoginProvider)).SingleOrDefault()); } } }
public async Task <IList <UserLoginInfo> > GetLoginsAsync(UserModel user) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <UserModel>(user.Id).Logins.Select(x => new UserLoginInfo(x.LoginProvider, x.ProviderKey)).ToList()); } } }
public async Task <UserModel> FindByStampAsync(string stamp) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.QueryOver <UserModel>().Where(x => x.SecurityStamp == stamp).SingleOrDefault()); } } }
public async Task <IList <SubCategoryModel> > GeatSubCategoryAsync(long id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <CategoryModel>(id).SubCategory.ToList()); } } }
public UserModel FindUserById(string userId) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <UserModel>(userId)); } } }
public async Task <SubCategoryModel> FindSubCategoryByIdAsync(long Id) { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { return(db.Get <SubCategoryModel>(Id)); } } }
public async Task <IList <CategoryModel> > GeatAllCategoryAsync() { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { var categories = db.QueryOver <CategoryModel>().Where(x => x.DeleteTime == null); return(categories.List()); } } }
public async Task <IList <BrandModel> > GeatAllBrandAsync() { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { var brands = db.QueryOver <BrandModel>().Where(x => x.DeleteTime == null); return(brands.List()); } } }
public async Task <IList <SupplierModel> > GeatAllSupplierAsync() { using (var db = HibernateSession.GetCurrentSession()) { using (var tx = db.BeginTransaction()) { var supplier = db.QueryOver <SupplierModel>().Where(x => x.DeleteTime == null); return(supplier.List()); } } }