/// <summary>
/// Gets the applied studies.
/// </summary>
/// <returns></returns>
public OutAppliedStudies GetAppliedStudies()
{
OutAppliedStudies data = new OutAppliedStudies();
try
{
ParametersDAO dao = new ParametersDAO();
data = dao.GetAppliedStudies();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerParameters", "GetAppliedStudies", ex, "");
}
return(data);
}
/// <summary>
/// Gets the applied studies.
/// </summary>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetAppliedStudies</exception>
public OutAppliedStudies GetAppliedStudies()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutAppliedStudies response = new OutAppliedStudies();
var ora = new OracleServer(connectionString);
AppliedStudies studies;
List <AppliedStudies> list = new List <AppliedStudies>();
string command = string.Empty;
try
{
command = " SELECT DFPNES08.codigo_estudio, DFPNES08.nombre_estudio FROM DFPNES08 WHERE DFPNES08.CODIGO_ESTUDIO > 0 ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
studies = new AppliedStudies();
studies.studiesID = DBNull.Value.Equals(rdr["codigo_estudio"]) ? 0 : int.Parse(rdr["codigo_estudio"].ToString());
studies.studiesName = DBNull.Value.Equals(rdr["nombre_estudio"]) ? string.Empty : rdr["nombre_estudio"].ToString();
list.Add(studies);
}
rdr.Close();
response.lstAppliedStudies = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetAppliedStudies", ex);
}
finally
{
ora.Dispose();
}
return(response);
}