In My API Controller Shows an Error

Sivakumar

Hi,

In my API Controller shows an error like teamID Does not exist.

this is my code :

[HttpGet]
[Route("{teamId}/members")]
[OverrideAuthorization]
public List GetTeamMember()
{
return _team.GetTeamMember(teamID);
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sivakumar11y ago
thank you manas for giving suggestions,

i resolved the problem
0
Manas Mohapatra11y ago
1. Make sure that you are passing correct temID not any string to your SP.

2. Collect temID from your controller and execute your sp by following command in your DB. Make sure that it s working fine:

execute uspGetAllTeamMembers 123

If you are getting exception here please provide your sp code here.
0
Sivakumar11y ago
if am executes this project shows an error like

An exception of type 'System.InvalidCastException' occurred in System.Data.dll but was not handled in user code

Additional information: Specified cast is not valid.

in my api controller code is :

[HttpGet]
[Route("{teamId}/members")]
[OverrideAuthorization]
public List GetTeamMembers(int teamId)
{
//TODO member doesn't have team - member type. This has to be handled
return _team.GetTeamMember(teamId);
}

and in my data access layer code is :

public List GetTeamMember(int teamID)
{
var getteammember = (from tm in _DataContext.uspGetAllTeamMembers(teamID) select new TeamMemberData {TeamID=tm.TeamID}).ToList();
return getteammember;
}

here shows an error
0
Shuvojit Halder11y ago
This will be
[HttpGet]
[Route("methodname/{teamId}")]
[OverrideAuthorization]
public List GetTeamMember(int teamId)
{
return _team.GetTeamMember(teamID);
}
0
Manas Mohapatra11y ago
Try below one:

1. Change code to return _team.GetTeamMember(teamId);
2. Make sure that you are typing correct URL(12/members)
0