public OutCategoryRange GetCategoryRange()
{
OutCategoryRange data = new OutCategoryRange();
try
{
ComplianceGoalDAO dao = new ComplianceGoalDAO();
data = dao.GetCategoryRange();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageComplianceGoal", "GetCategoryRange", ex, "");
}
return(data);
}
public OutCategoryRange GetCategoryRange()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutCategoryRange response = new OutCategoryRange();
var ora = new OracleServer(connectionString);
CategoryRange categoryRange;
List <CategoryRange> list = new List <CategoryRange>();
string command = string.Empty;
try
{
command = "SELECT bbs_liqcom_v_par_categoria.codigo_esquema, bbs_liqcom_v_par_categoria.nombre_esquema, bbs_liqcom_v_par_categoria.rango_inicial, bbs_liqcom_v_par_categoria.rango_final, " +
" bbs_liqcom_v_par_categoria.codigo_categoria, bbs_liqcom_v_par_categoria.nombre_categoria FROM bbs_liqcom_v_par_categoria ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
categoryRange = new CategoryRange();
categoryRange.SchemeCode = DBNull.Value.Equals(rdr["codigo_esquema"]) ? 0 : double.Parse(rdr["codigo_esquema"].ToString());
categoryRange.SchemeName = DBNull.Value.Equals(rdr["nombre_esquema"]) ? string.Empty : rdr["nombre_esquema"].ToString();
categoryRange.InitialRange = DBNull.Value.Equals(rdr["rango_inicial"]) ? 0 : double.Parse(rdr["rango_inicial"].ToString());
categoryRange.FinalRange = DBNull.Value.Equals(rdr["rango_final"]) ? 0 : double.Parse(rdr["rango_final"].ToString());
categoryRange.CategoryCode = DBNull.Value.Equals(rdr["codigo_categoria"]) ? 0 : double.Parse(rdr["codigo_categoria"].ToString());
categoryRange.CategoryName = DBNull.Value.Equals(rdr["nombre_categoria"]) ? string.Empty : rdr["nombre_categoria"].ToString();
list.Add(categoryRange);
}
rdr.Close();
response.lstCategoryRange = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ComplianceGoalDAO.GetCategoryRange", ex);
}
finally
{
ora.Dispose();
}
return(response);
}