public TOTransaction <List <toRnRadic> > getInfoAfilNovedad(int emp_codi, int afi_cont, DateTime rad_feci, DateTime rad_fecf)
{
DAOSuConsu daosuconsu = new DAOSuConsu();
try
{
var result = daosuconsu.getInfoAfilNovedad(emp_codi, afi_cont, rad_feci, rad_fecf);
if (result == null)
{
throw new Exception("No se encontraron datos con los parámetros especificados");
}
else
{
foreach (toRnRadic radic in result)
{
radic.rad_fech = string.IsNullOrEmpty(radic.rad_fech) ? "" : Convert.ToDateTime(radic.rad_fech).ToString("dd/MM/yyyy");
radic.rad_fecc = string.IsNullOrEmpty(radic.rad_fecc) ? "" : Convert.ToDateTime(radic.rad_fecc).ToString("dd/MM/yyyy");
}
}
return(new TOTransaction <List <toRnRadic> >()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <toRnRadic> >()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction <List <ToSuHgicm> > getInfoSubsidios(int emp_codi, int hgi_peri, int hgi_perf, string afi_docu)
{
DAOSuConsu daosuconsu = new DAOSuConsu();
try
{
var result = daosuconsu.getInfoSubsidios(emp_codi, hgi_peri, hgi_perf, afi_docu);
if (result == null)
{
throw new Exception("No se encontraron datos con los parámetros especificados");
}
else
{
foreach (ToSuHgicm hgi in result)
{
hgi.hgi_fech = string.IsNullOrEmpty(hgi.hgi_fech) ? "" : Convert.ToDateTime(hgi.hgi_fech).ToString("dd/MM/yyyy");
hgi.afi_noco = hgi.afi_nom1 + ' ' + hgi.afi_nom2 + ' ' + hgi.afi_ape1 + ' ' + hgi.afi_ape2;
}
}
return(new TOTransaction <List <ToSuHgicm> >()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <ToSuHgicm> >()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction <List <toArDpil> > getInfoAportes(int emp_codi, int afi_cont, int rpi_peri, int rpi_perf, string apo_coda, string apo_razr)
{
DAOSuConsu daosuconsu = new DAOSuConsu();
try
{
var result = daosuconsu.getInfoAportes(emp_codi, afi_cont, rpi_peri, rpi_perf, apo_coda, apo_razr);
if (result == null)
{
throw new Exception("No se encontraron datos con los parámetros especificados");
}
else
{
foreach (toArDpil dpil in result)
{
dpil.rpi_fchp = string.IsNullOrEmpty(dpil.rpi_fchp) ? "" : Convert.ToDateTime(dpil.rpi_fchp).ToString("dd/MM/yyyy");
}
}
return(new TOTransaction <List <toArDpil> >()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <toArDpil> >()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction <tofiliatrab> getInfoAfilitrab(int emp_codi, string afi_docu)
{
DAOSuConsu daosuconsu = new DAOSuConsu();
try
{
tofiliatrab result = new tofiliatrab();
result = daosuconsu.getInfoAfilitrab(emp_codi, afi_docu);
if (result == null)
{
throw new Exception("No se encontraron datos con los parámetros especificados");
}
else
{
result.afi_noco = string.Format("{0}{1}{2}{3}{4}{5}{6}", result.afi_nom1, " ", result.afi_nom2, " ", result.afi_ape1, " ", result.afi_ape2);
result.afi_fecn = string.IsNullOrEmpty(result.afi_fecn) ? "" : Convert.ToDateTime(result.afi_fecn).ToString("dd/MM/yyyy");
result.sutraye = daosuconsu.getInfoSutrayeTrab(emp_codi, result.afi_cont);
if (result.sutraye != null)
{
foreach (toSutraye traye in result.sutraye)
{
traye.tra_fchi = string.IsNullOrEmpty(traye.tra_fchi) ? "" : Convert.ToDateTime(traye.tra_fchi).ToString("dd/MM/yyyy");
traye.tra_fcha = string.IsNullOrEmpty(traye.tra_fcha) ? "" : Convert.ToDateTime(traye.tra_fcha).ToString("dd/MM/yyyy");
}
}
result.superca = daosuconsu.getInfoSupercaTrab(emp_codi, result.afi_cont);
if (result.superca != null)
{
foreach (toSuperca perca in result.superca)
{
perca.afi_noco = string.Format("{0}{1}{2}{3}{4}{5}{6}", perca.afi_nom1, " ", perca.afi_nom2, " ", perca.afi_ape1, " ", perca.afi_ape2);
perca.afi_fecn = string.IsNullOrEmpty(perca.afi_fecn) ? "" : Convert.ToDateTime(perca.afi_fecn).ToString("dd/MM/yyyy");
perca.rad_fech = string.IsNullOrEmpty(perca.rad_fech) ? "" : Convert.ToDateTime(perca.rad_fech).ToString("dd/MM/yyyy");
}
}
}
return(new TOTransaction <tofiliatrab>()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <tofiliatrab>()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
