public OutParamSectorTablas GetddSectorTablas()
{
OutParamSectorTablas data = new OutParamSectorTablas();
try
{
DocumentsDAO dao = new DocumentsDAO();
data = dao.GetddSectorTablas();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageDocuments", "GetddSectorTablas", ex, "");
}
return(data);
}
public OutParamSectorTablas GetddSectorTablas()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutParamSectorTablas response = new OutParamSectorTablas();
var ora = new OracleServer(connectionString);
ParamSectorTablas Secguias;
response.ListSectorTablas = new List <ParamSectorTablas>();
string command = string.Empty;
try
{
command = " select * from dlg_param_sectorTablas where ind_estado = 1 order by sector ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
Secguias = new ParamSectorTablas();
Secguias.secuencia = DBNull.Value.Equals(rdr["SECUENCIA"]) ? 0 : double.Parse(rdr["SECUENCIA"].ToString());
Secguias.sector = DBNull.Value.Equals(rdr["SECTOR"]) ? "" : (rdr["SECTOR"].ToString());
response.ListSectorTablas.Add(Secguias);
}
rdr.Close();
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("DocumentsDAO.GetddSectorTablas", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
