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