/// <summary>
/// Gets the afp.
/// </summary>
/// <returns></returns>
public OutAFP GetAFP()
{
OutAFP data = new OutAFP();
try
{
ParametersDAO dao = new ParametersDAO();
data = dao.GetAFP();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerParameters", "GetAFP", ex, "");
}
return(data);
}
/// <summary>
/// Gets the afp.
/// </summary>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetAFP</exception>
public OutAFP GetAFP()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutAFP response = new OutAFP();
var ora = new OracleServer(connectionString);
AFP afp;
List <AFP> list = new List <AFP>();
string command = string.Empty;
try
{
command = " SELECT NIT, NOMBRE, CODIGO_MINISTERIO FROM BBS_WFC_PAR_AFP where nit> 0 ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
afp = new AFP();
afp.afpNIT = DBNull.Value.Equals(rdr["NIT"]) ? string.Empty : rdr["NIT"].ToString();
afp.afpName = DBNull.Value.Equals(rdr["NOMBRE"]) ? string.Empty : rdr["NOMBRE"].ToString();
afp.afpCodeMinistry = DBNull.Value.Equals(rdr["CODIGO_MINISTERIO"]) ? string.Empty : rdr["CODIGO_MINISTERIO"].ToString();
list.Add(afp);
}
rdr.Close();
response.lstAFP = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetAFP", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
