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