public ResposeLoginModel CheckValidateLogin(LoginModle login)
{
ResposeLoginModel response = new ResposeLoginModel();
int result = _usersRepository.SelectUserIdFromDB(login);
if (result == -1)
{
response.state = false;
response.message = "Login failed";
response.userId = -1;
}
else
{
response.state = true;
response.message = "Login successful";
response.userId = result;
}
return(response);
}
public int SelectUserIdFromDB(LoginModle log)
{
var cs = "Server=localhost\\SQLEXPRESS;Database=LibraryDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs);
con.Open();
string sql = string.Format("SELECT UserId FROM UserTable WHERE Username = '******' AND Password = '******';", log.username, log.password);
using var cmd = new SqlCommand(sql, con);
using SqlDataReader rdr = cmd.ExecuteReader();
var output = -1;
while (rdr.Read())
{
output = rdr.GetInt32(0);
}
return(output);
}
public ResposeLoginModel Login([FromBody] LoginModle login)
{
ResposeLoginModel res = _usersService.CheckValidateLogin(login);
return(res);
}
