public RoleCredentialsController(MyApiContext context)
{
_context = context;
}
public UserController(MyApiContext context)
{
Context = context;
}
public RoleUsersController(MyApiContext context)
{
_context = context;
}
public MoviesController(MyApiContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public SongsController(MyApiContext context)
{
_context = context;
}
public UserAccountsController(MyApiContext context)
{
_context = context;
}
public KindMusicsController(MyApiContext context)
{
_context = context;
}
/// <summary>
/// Use an apicontext (the authtoken and secret) to find the UserID in the db.
/// </summary>
/// <param name="apiContext"></param>
/// <returns></returns>
public int GetShopsterUserId(MyApiContext apiContext)
{
OdbcCommand sqlUserId = new OdbcCommand("SELECT id FROM shopsteruser WHERE AuthToken = '"
+ apiContext.AccessToken + "' and AuthSecret = '" + apiContext.AccessTokenSecret + "' LIMIT 1;", dbConn);
int returnValue =Convert.ToInt32(sqlUserId.ExecuteScalar());
Console.WriteLine("GetShopsterUserId::Info: Query= SELECT id FROM shopster user WHERE AuthToken = '"
+ apiContext.AccessToken + "' and AuthSecret = '" + apiContext.AccessTokenSecret + "' LIMIT 1;");
Console.WriteLine("GetShopsterUserId::Info: Query returned " + returnValue);
return returnValue;
}
public MyCustumerController(MyApiContext context)
{
_context = context;
}
public UserInformationsController(MyApiContext context)
{
_context = context;
}
public PersonasController(MyApiContext db)
{
_db = db;
}
