public TOTransaction <SfFovis> GetInfoForpo(int emp_codi, int for_cont, int afi_cont) { DAOSfForpo daoSfForpo = new DAOSfForpo(); SfFovis sffovis = new SfFovis(); try { sffovis = daoSfForpo.getInfoForpo(emp_codi, for_cont); if (sffovis.for_esta == "U" || sffovis.for_esta == "N" || sffovis.for_esta == "R" || sffovis.for_esta == "V") { sffovis.for_insf = "P"; } else { sffovis.for_insf = "A"; } sffovis.postulante = daoSfForpo.getInfoPostulanteForpo(emp_codi, for_cont); sffovis.conyuge = daoSfForpo.getInfoConyugeForpo(emp_codi, for_cont); sffovis.InfoSfDfomhP = daoSfForpo.getInfoForpoSuPerca(emp_codi, for_cont, "P"); sffovis.InfoSfDfomhO = daoSfForpo.getInfoForpoSuPerca(emp_codi, for_cont, "O"); sffovis.InfoGnmasal = daoSfForpo.GetInfoMasal(DateTime.Now.Year); sffovis.infoHogar = daoSfForpo.GetInfoHogar(emp_codi, for_cont); sffovis.InfoEmpresa = daoSfForpo.getInfoEmpre(emp_codi, afi_cont); sffovis.InfodforeA = daoSfForpo.getInfoDforeForpo(emp_codi, for_cont, "A"); if (sffovis.InfodforeA == null) { sffovis.InfodforeA = new List <SfDfore>(); } foreach (SfDfore dfore in sffovis.InfodforeA) { List <SfDdfor> ddfor = new List <SfDdfor>(); ddfor = daoSfForpo.getInfoDdforForpo(emp_codi, for_cont, dfore.dfo_cont); if (ddfor != null) { dfore.Infoddfor = ddfor; } } sffovis.InfodforeR = daoSfForpo.getInfoDforeForpo(emp_codi, for_cont, "R"); if (sffovis.InfodforeR == null) { sffovis.InfodforeR = new List <SfDfore>(); } foreach (SfDfore dfore in sffovis.InfodforeR) { List <SfDdfor> ddfor = new List <SfDdfor>(); ddfor = daoSfForpo.getInfoDdforForpo(emp_codi, for_cont, dfore.dfo_cont); if (ddfor != null) { dfore.Infoddfor = ddfor; } } if (sffovis.infoHogar == null) { sffovis.infoHogar = new InfoDfoih(); } if (sffovis.conyuge == null) { sffovis.conyuge = daoSfForpo.getInfoConyu(emp_codi, afi_cont); } if (sffovis.conyuge == null) { sffovis.conyuge = new InfoAportante(); } if (sffovis.InfoSfDfomhP == null) { sffovis.InfoSfDfomhP = new List <InfoAportante>(); } if (sffovis.InfoSfDfomhO == null) { sffovis.InfoSfDfomhO = new List <InfoAportante>(); } return(new TOTransaction <SfFovis>() { objTransaction = sffovis, txtRetorno = "", retorno = 0 }); } catch (Exception ex) { return(new TOTransaction <SfFovis>() { objTransaction = null, retorno = 1, txtRetorno = ex.Message }); } }