public OutStates GetStates() { var response = new OutStates(); try { PqrDAO dao = new PqrDAO(); response = dao.GetStates(); } catch (Exception ex) { //escribir en el log LogHelper.WriteLog("Models", "ManagerPQR", "GetStates", ex, ""); } return(response); }
public OutStates GetStates() { string connectionString = DataBaseHelper.GetConnectionString("DLG"); OutStates response = new OutStates(); var ora = new OracleServer(connectionString); State state; List <State> list = new List <State>(); string command = string.Empty; try { command = "SELECT TIPO_FLUJO, NOMBRE_FLUJO, CODIGO_ESTADO, NOMBRE_ESTADO FROM BBS_LIQCOM_V_EDO_PQR "; var rdr = ora.ExecuteCommand(command); while (rdr.Read()) { state = new State(); state.flowType = DBNull.Value.Equals(rdr["TIPO_FLUJO"]) ? 0 : int.Parse(rdr["TIPO_FLUJO"].ToString()); state.flowName = DBNull.Value.Equals(rdr["NOMBRE_FLUJO"]) ? string.Empty : rdr["NOMBRE_FLUJO"].ToString(); state.codeState = DBNull.Value.Equals(rdr["CODIGO_ESTADO"]) ? 0 : int.Parse(rdr["CODIGO_ESTADO"].ToString()); state.stateName = DBNull.Value.Equals(rdr["NOMBRE_ESTADO"]) ? string.Empty : rdr["NOMBRE_ESTADO"].ToString(); list.Add(state); } rdr.Close(); response.lstStates = list; response.msg = new Response(); response.msg.errorCode = "200"; response.msg.errorMessage = "OK"; } catch (Exception ex) { throw new Exception("PqrDAO.GetStates", ex); } finally { ora.Dispose(); } return(response); }