public async Task <RequestModel[]> GetRejectedRequests(int year, CancellationToken cancellationToken) { var getRequestsModel = new GetRequestsModel { Year = year, RequestStates = new[] { RequestState.Rejected } }; return(await _getRequestsQuery.Value.ExecuteAsync(getRequestsModel, HttpContext.User, cancellationToken)); }
public IActionResult Index() { var getRequestModel = new GetRequestsModel() { RequestList = new RequestRepository(_connection) .GetRequestByEmail(User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Email)?.Value), Email = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Email)?.Value }; var model = new RequestModel() { GetRequestsModel = getRequestModel, }; return(View(model)); }
public async Task <IActionResult> GetRequests([FromQuery] GetRequestsModel model) { if (string.IsNullOrEmpty(model.UserEmail) || string.IsNullOrEmpty(model.HashedPassword)) { return(Json(new { IsError = true, Error = "Вы неавторизированы", RedirectToLogin = true })); } var identityUser = await _signInManager.UserManager.FindByNameAsync(model.UserEmail); if (identityUser == null) { return(Json(new { IsError = true, Error = "Пользователь не найден", RedirectToLogin = true })); } var decryptedPassword = StringEncryptor.DecryptString(model.HashedPassword, "TOMSK2018"); var signInResult = await _signInManager.PasswordSignInAsync(identityUser, decryptedPassword, false, true); try { if (signInResult.Succeeded) { using (var connection = new SqlConnection("Server=localhost,1433;Database=aspnet-BlogPost-3BDC69D5-9F9E-443F-96EC-0E1B2326A0AE;user id=SA;password=qwerty123!")) { var commandText = "SELECT * FROM Companies WHERE userName = '******'"; SqlCommand command = new SqlCommand(commandText, connection); command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); IList <RequestsEntryModel> results = new List <RequestsEntryModel>(); while (reader.Read()) { var request = new RequestsEntryModel() { Id = reader["id"].ToString(), Inn = reader["inn"].ToString(), Name = reader["name"].ToString(), Address = reader["address"].ToString(), }; if (!string.IsNullOrEmpty(reader["isFound"].ToString())) { request.IsFound = reader["isFound"].ToString() == "1"; } if (!string.IsNullOrEmpty(reader["positiveProbability"].ToString())) { decimal parseResultsDecimal = 0; decimal.TryParse(reader["positiveProbability"].ToString(), out parseResultsDecimal); request.PositiveProbability = parseResultsDecimal; } results.Add(request); } return(Json(new { IsError = false, Results = results })); } } } catch (Exception ex) { var a = 2; } return(Json(new { IsError = true, Error = "Ошибка связи с БД", })); }