public TemplatesResponse GetTemplates()
{
TemplatesResponse oTemplatesResponse = new TemplatesResponse();
{
TemplatesBL oTemplatesBL = new TemplatesBL();
List <Templates> liTemplates = new List <Templates>();
ServerResponse.ResponseCodes eResponse = ServerResponse.ResponseCodes.Internal_Error;
eResponse = oTemplatesBL.GetAllTemplates(out liTemplates);
oTemplatesResponse.data = new multipleTemplateresponse {
Templates = liTemplates
};
oTemplatesResponse.meta.error_message = ServerResponse.GetResponse(eResponse);
oTemplatesResponse.meta.code = Convert.ToInt32(eResponse);
}
return(oTemplatesResponse);
}
/// <summary>
/// Recupera de forma paginada os templates
/// </summary>
/// <param name="advancedFilter"></param>
/// <returns></returns>
public TemplatesResponse GetAllPaged(FilterTemplateRequest advancedFilter)
{
var result = new TemplatesResponse();
var sql = string.Empty;
var sqlCount = string.Empty;
try
{
using (var conn = CreateConnection())
{
result.TotalGeral = (int)conn.ExecuteScalar("SELECT COUNT(*) FROM Template_Resposta");
sql = RecuperarQuery(advancedFilter);
result.Templates = conn.Query <TemplateResposta>(sql).Distinct().ToList();
}
return(result);
}
catch (Exception)
{
throw;
}
}
