public async Task <UserInfoDto> ValidateUser(string username, string password) { try { using (AguilaContext _context = new AguilaContext()) { var users = await(from user in _context.AspNetUsers join roles in _context.AspNetUserRoles on user.Id equals roles.UserId join roleType in _context.AspNetRoles on roles.RoleId equals roleType.Id where user.UserName == username && user.PasswordHash == password select new UserInfoDto { UserId = user.Id, UserName = user.UserName, Name = user.Name, Role = roleType.Name }).FirstOrDefaultAsync(); return(users); } } catch (Exception) { return(null); } }
public UserService(IMapper mapper , ILoggerFactory loggerFactory , AguilaContext aguilaContext , RoleManager <ApplicationRoleDto> roleManager , UserManager <ApplicationUserDto> userManager , SignInManager <ApplicationUserDto> signInManager , IOptions <IdentityCookieOptions> identityCookieOptions , ISendEmailService sendEmailService ) { _mapper = mapper; _userManager = userManager; _roleManager = roleManager; _signInManager = signInManager; _aguilaContext = aguilaContext; _externalCookieScheme = identityCookieOptions.Value.ExternalCookieAuthenticationScheme; _sendEmailService = sendEmailService; }
//code by sohan Service public async Task <IEnumerable <SituationsDto> > GetSituationsByNextHoleId(int Id) { using (AguilaContext _context = new AguilaContext()) { _context.Database.OpenConnection(); DbCommand cmd = _context.Database.GetDbConnection().CreateCommand(); cmd.CommandText = "USP_getSituationsNextHole"; DbParameter param1 = cmd.CreateParameter(); param1.ParameterName = "@ID"; param1.Value = Id; cmd.Parameters.Add(param1); cmd.CommandType = CommandType.StoredProcedure; List <SituationsDto> IistSituation; using (var reader = cmd.ExecuteReader()) { IistSituation = reader.MapToList <SituationsDto>(); } if (IistSituation != null) { IQueryable <Situations> situations = _context.Situations .Include(x => x.SituationHandicaps) .Include(x => x.SituationAttributes) .Include(x => x.SituationQuestions).ThenInclude(situation => situation.Answers) .Include(x => x.SituationCategory) .Where(x => x.Deleted == false); var result1 = situations.Where(x => IistSituation.Any(y => y.Id == x.Id)); var data = await result1.ToListAsync(); IEnumerable <SituationsDto> result = _mapper.Map <IEnumerable <Situations>, IEnumerable <SituationsDto> >(data); return(result); } else { return(null); } } }
public AccountService(IMapper mapper , AguilaContext aguilaContext , ILoggerFactory loggerFactory , IConfiguration configuration , IHostingEnvironment hostingEnv , RoleManager <ApplicationRoleDto> roleManager , UserManager <ApplicationUserDto> userManager , IHttpContextAccessor httpContextAccessor , SignInManager <ApplicationUserDto> signInManager , IOptions <IdentityCookieOptions> identityCookieOptions , IPasswordHasher <ApplicationUserDto> passwordHasher ) { _mapper = mapper; _hostingEnv = hostingEnv; _userManager = userManager; _roleManager = roleManager; _signInManager = signInManager; _aguilaContext = aguilaContext; _configuration = configuration; this._httpContextAccessor = httpContextAccessor; _externalCookieScheme = identityCookieOptions.Value.ExternalCookieAuthenticationScheme; _passwordHasher = passwordHasher; }
public RoundService(AguilaContext entities) { this._entities = entities; }
public SituationService(AguilaContext context, IMapper mapper) { _context = context; _mapper = mapper; }
public LRDService(AguilaContext entities, IUnitOfWork repo, IMapper mapper) { this._entities = entities; this._mapper = mapper; this._repo = repo; }
public AttributeService(IUnitOfWork repo, IMapper mapper, AguilaContext context) { this._repo = repo; this._mapper = mapper; this._context = context; }
public PictureBookService(IUnitOfWork repo, IMapper mapper, AguilaContext context) { this._context = context; this._repo = repo; this._mapper = mapper; }
public UnitOfWork(AguilaContext dbContext) { entities = dbContext; }
public ValuesController(AguilaContext _answerServices) { answerServices = _answerServices; }
public Repository(AguilaContext _entities) { entities = _entities; }