/// <summary> /// This method is use for login user /// </summary> /// <param name="loginDTO">Login DTOs pass</param> /// <returns></returns> public async Task <BaseResponse> ValidateUserAsync(LoginDTO loginDTO) { try { string ConnectionString = _config[_iStringConstants.MyConnectionString]; BaseResponse baseResponse = new BaseResponse(); UserTokenDTO userTokenAC = new UserTokenDTO(); using (DeepakdbContext deepakDBContext = new DeepakdbContext()) { /*var parameterOut=new SqlParameter * { * ParameterName= * }*/ var data = await deepakDBContext.UserDetail.FromSqlRaw("spGetUserDetailByEmail @Email=@p0", parameters : new[] { loginDTO.Email }).ToListAsync(); if (data != null) { data.ForEach(x => new UserTokenDTO() { Id = x.Id, FirstName = x.FirstName, LastName = x.LastName, ZipCode = x.ZipCode, Email = x.Email, MobileNumber = x.MobileNumber, Password = x.Password }); if (PasswordHashUtill.VerifyHashedPassword(userTokenAC.Password, loginDTO.Password)) { baseResponse.StatusCode = (int)EnumList.ResponseType.Success; baseResponse.Data = userTokenAC; } else { baseResponse.Message = _iStringConstants.InvalidPassword; baseResponse.StatusCode = (int)EnumList.ResponseType.Error; baseResponse.Data = null; } } else { baseResponse.Message = _iStringConstants.LoginCredentailWrong; baseResponse.StatusCode = (int)EnumList.ResponseType.Error; baseResponse.Data = null; } return(baseResponse); } } catch (Exception ex) { throw ex; } }
public async Task <BaseResponseModel> ValidateUserAsync(LoginAC loginAC) { BaseResponseModel baseResponseModel = new BaseResponseModel(); UserTokenAC userTokenAC = new UserTokenAC(); using (IDbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { try { var existingUserQuery = "select * from AspNetUsers where Email='" + loginAC.Email + "'"; var userData = connection.Query(existingUserQuery).FirstOrDefault(); if (userData != null) { if (PasswordHashUtill.VerifyHashedPassword(userData.PasswordHash, loginAC.Password)) { userTokenAC.Id = userData.Id; userTokenAC.FullName = userData.UserName; userTokenAC.Email = userData.Email; baseResponseModel.StatusCode = (int)EnumList.ResponseType.Success; baseResponseModel.Data = userTokenAC; } else { baseResponseModel.Message = StringConstant.InvalidPassword; baseResponseModel.StatusCode = (int)EnumList.ResponseType.Error; baseResponseModel.Data = null; } } else { baseResponseModel.Message = StringConstant.LoginCredentailWrong; baseResponseModel.StatusCode = (int)EnumList.ResponseType.Error; baseResponseModel.Data = null; } return(baseResponseModel); } catch (Exception ex) { throw; } } }