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