/// <summary> /// Gets the civil status. /// </summary> /// <returns></returns> public OutCivilStatus GetCivilStatus() { OutCivilStatus data = new OutCivilStatus(); try { ParametersDAO dao = new ParametersDAO(); data = dao.GetCivilStatus(); } catch (Exception ex) { //escribir en el log LogHelper.WriteLog("Models", "ManagerParameters", "GetCivilStatus", ex, ""); } return(data); }
/// <summary> /// Gets the civil status. /// </summary> /// <returns></returns> /// <exception cref="Exception">ParametersDAO.GetCivilStatus</exception> public OutCivilStatus GetCivilStatus() { string connectionString = DataBaseHelper.GetConnectionString("DLG"); OutCivilStatus response = new OutCivilStatus(); var ora = new OracleServer(connectionString); CivilStatus status; List <CivilStatus> list = new List <CivilStatus>(); string command = string.Empty; try { command = "SELECT dfpecv09.codigo_civil, dfpecv09.nombre_civil FROM dfpecv09 WHERE CODIGO_CIVIL<> 0 ORDER BY dfpecv09.codigo_civil ASC "; var rdr = ora.ExecuteCommand(command); while (rdr.Read()) { status = new CivilStatus(); status.statusID = DBNull.Value.Equals(rdr["codigo_civil"]) ? 0 : int.Parse(rdr["codigo_civil"].ToString()); status.statusName = DBNull.Value.Equals(rdr["nombre_civil"]) ? string.Empty : rdr["nombre_civil"].ToString(); list.Add(status); } rdr.Close(); response.lstCivilStatus = list; response.msg = new Response(); response.msg.errorCode = "200"; response.msg.errorMessage = "OK"; } catch (Exception ex) { throw new Exception("ParametersDAO.GetCivilStatus", ex); } finally { ora.Dispose(); } return(response); }