public CustomActionResult <getServico> get_servicos()
{
getServico get = new getServico();
get.lstServicos = new ServicoDAO().Buscaservico(null);
List <object> Filtro = new List <object>();
foreach (var servico in get.lstServicos)
{
Filtro = new List <object>();
Filtro.Add(" AND agendaservico.idservico = " + servico.id);
servico.lstAgendaServico = new AgendaServicoDAO().BuscaAgendaServico(Filtro);
foreach (var item in servico.lstAgendaServico)
{
try
{
Filtro = new List <object>();
Filtro.Add(" AND ConfirmacaoAgendaServico.idagendaservico = " + item.id);
item.confirmacao = new ConfirmacaoAgendaServicoDAO().BuscaConfirmacaoAgendaServico(Filtro).First();
}
catch
{
item.confirmacao = null;
}
}
}
return(GetResultOK(get));
}
public CustomActionResult <getServico> get_servicos_disp()
{
getServico get = new getServico();
get.lstServicos = new ServicoDAO().Buscaservico(null);
List <object> Filtro = new List <object>();
foreach (var servico in get.lstServicos)
{
Filtro = new List <object>();
Filtro.Add(" AND agendaservico.idservico = " + servico.id);
Filtro.Add(@" AND not exists ( select 0 from
ConfirmacaoAgendaServico conf
where conf.idagendaservico = agendaservico.id) ");
servico.lstAgendaServico = new AgendaServicoDAO().BuscaAgendaServico(Filtro);
}
return(GetResultOK(get));
}
