/// <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); }