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)); }