public OutBornCities GetBornCity()
{
OutBornCities data = new OutBornCities();
try
{
ParametersDAO dao = new ParametersDAO();
data = dao.GetBornCity();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerParameters", "GetBornCity", ex, "");
}
return(data);
}
/// <summary>
/// Gets the born city.
/// </summary>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetBornCity</exception>
public OutBornCities GetBornCity()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutBornCities response = new OutBornCities();
var ora = new OracleServer(connectionString);
BornCities city;
List <BornCities> list = new List <BornCities>();
string command = string.Empty;
try
{
command = " SELECT to_char(A.nombre_ciudad || ' / ' || B.nombre_depto) as nombre_ciudad, A.codigo_ciudad as codigo_ciudad ";
command = command + " FROM dfpcdd07 A, dfpdpt06 B WHERE B.codigo_estado = A.codigo_estado and B.codigo_depto = A.codigo_depto ";
command = command + " and A.Codigo_Ciudad > 0 order by 1 ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
city = new BornCities();
city.cityName = DBNull.Value.Equals(rdr["nombre_ciudad"]) ? string.Empty : rdr["nombre_ciudad"].ToString();
city.cityCode = DBNull.Value.Equals(rdr["codigo_ciudad"]) ? 0 : int.Parse(rdr["codigo_ciudad"].ToString());
list.Add(city);
}
rdr.Close();
response.lstBornCities = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetBornCity", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
