public List <Organization> Handle(string accessTokenID, ListOrganizations_Q query)
{
using (var connection = _connFactory.GetConnection())
{
connection.Open();
var sql = @"
select
o.ID
,o.OrganizationName
,o.OrganizationSpectrumID
,o.OrganizationWebsiteURL
,o.IsActive
,o.CreatedOn
,o.CreatedBy
,o.ModifiedOn
,o.ModifiedBy
from [Organizations].[Organizations] o
";
var res = connection.Query <Organization>(sql).ToList();
return(res);
}
}
public List <Organization> ListOrganizations(string accessToken)
{
var query = new ListOrganizations_Q();
var result = _queryDispatcher.Dispatch <ListOrganizations_Q, List <Organization> >(accessToken, query);
return(result);
}