public ItemResult ResourceSearchForSearchButton([FromBody] InResourceAuthorSearchFilter inResourceAuthorSearchFilter)
{
Console.WriteLine("-------------ResourceSearchForSearchButton----------------");
Console.WriteLine(JsonConvert.SerializeObject(inResourceAuthorSearchFilter));
Console.WriteLine("-----------------------------");
return(pgResource.ResourceSearchForSearchButton(inResourceAuthorSearchFilter));
}
public ItemResult ResourceSearchForSearchButton(InResourceAuthorSearchFilter inResourceAuthorSearchFilter)
{
ItemResult itemResult = new ItemResult();
using (NpgsqlConnection connection = this.CreateConnection())
{
try
{
connection.Open();
this.CreateFunctionCallQuery(LibraryFunctions.fn_resources_search_for_search_button, connection);
this.Cmd.Parameters.AddWithValue("p_resource_filter", JsonConvert.SerializeObject(inResourceAuthorSearchFilter));
NpgsqlDataReader dataReader = null;
dataReader = this.Cmd.ExecuteReader();
using (dataReader)
{
while (dataReader.Read())
{
itemResult.Item = JsonConvert.DeserializeObject <SearchButtonResult>((dataReader[0]).ToString());
}
}
connection.Close();
}
catch (PostgresException e)
{
itemResult.Code = e.MessageText;
itemResult.Message = LibraryErrorMessages.GetErrorMessage(itemResult.Code);
}
catch (NpgsqlException e)
{
itemResult.Code = (e.ErrorCode).ToString();
itemResult.Message = LibraryErrorMessages.GetErrorMessage(itemResult.Code);
}
}
return(itemResult);
}
public ItemResult SearchResourceAuthor([FromBody] InResourceAuthorSearchFilter inResourceAuthorSearchFilter)
{
return(pgResource.ResourceAuthorSearch(inResourceAuthorSearchFilter));
}
