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 = "Ошибка связи с БД",
}));
}
