public ActionResult Index([FromBody] LoginQueryModel param)
{
SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"));
string query = "select * from Logins where Email='" + param.Email + "' ";
var adapter = new SqlDataAdapter(query, connection);
var datatable = new DataTable();
adapter.Fill(datatable);
List <object> output = new List <object>();
if (datatable.Rows.Count == 0)
{
return(NotFound());
}
for (int i = 0; i < datatable.Rows.Count; i++)
{
output.Add(new
{
Email = datatable.Rows[i]["Email"],
Name = datatable.Rows[i]["Name"]
});
}
return(Ok(output));
}
public async Task When_Handling_Query_Then_Gets_User_From_Repository(LoginQueryModel model)
{
// Act
var response = await sut.Handle(model, default);
// Assert
response.Should().BeOfType <TokenModel>();
}
public async Task When_Handling_Query_Then_Returns_Token_Model(LoginQueryModel model)
{
// Act
var response = await sut.Handle(model, default);
// Assert
response.Should().BeOfType <TokenModel>();
}
public async Task When_Login_Then_Response_Accepted(LoginQueryModel model)
{
// Act
var response = await sut.Login(model);
// Assert
response.Should().BeOfType <OkObjectResult>();
}
public async Task When_Login_Then_Send_Login_Query_Model_With_Bus(LoginQueryModel model)
{
// Act
await sut.Login(model);
// Assert
busMock.Verify(x => x.SendAsync(It.IsAny <LoginQueryModel>(), default), Times.Once);
}
public ActionResult Index([FromBody] LoginQueryModel param)
{
SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"));
string query = "select * from Logins where Email=@email";
SqlCommand command = new SqlCommand(query, connection);
// prevent injection
var emailParam = new SqlParameter("email", SqlDbType.VarChar);
emailParam.Value = param.Email;
command.Parameters.Add(emailParam);
var adapter = new SqlDataAdapter(command);
var datatable = new DataTable();
adapter.Fill(datatable);
List <object> output = new List <object>();
if (datatable.Rows.Count == 0)
{
return(NotFound());
}
for (int i = 0; i < datatable.Rows.Count; i++)
{
output.Add(new
{
Email = datatable.Rows[i]["Email"],
Name = datatable.Rows[i]["Name"]
});
}
return(Ok(output));
}
public async Task <IActionResult> Login(LoginQueryModel model)
{
var response = await bus.SendAsync(model);
return(Ok(response));
}
