/// <summary>
/// Gets the neighborhood.
/// </summary>
/// <param name="municipalityID">The municipality identifier.</param>
/// <returns></returns>
public OutDepartments GetNeighborhood(int municipalityID)
{
OutDepartments data = new OutDepartments();
try
{
ParametersDAO dao = new ParametersDAO();
data = dao.GetNeighborhood(municipalityID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerParameters", "GetNeighborhood", ex, "");
}
return(data);
}
/// <summary>
/// Gets the cities.
/// </summary>
/// <param name="departmentID">The department identifier.</param>
/// <returns></returns>
public OutDepartments GetCities(int departmentID)
{
OutDepartments data = new OutDepartments();
try
{
ParametersDAO dao = new ParametersDAO();
data = dao.GetCities(departmentID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerParameters", "GetCities", ex, "");
}
return(data);
}
/// <summary>
/// Gets the neighborhood.
/// </summary>
/// <param name="municipalityID">The municipality identifier.</param>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetNeighborhood</exception>
public OutDepartments GetNeighborhood(int municipalityID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutDepartments response = new OutDepartments();
var ora = new OracleServer(connectionString);
Departments department;
List <Departments> list = new List <Departments>();
string command = string.Empty;
try
{
command = " select cod_ctro_pobla, nom_ctro_pobla, cod_munic from dfpctropoblado ";
command = command + string.Format(" where cod_munic = {0} ", municipalityID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
department = new Departments();
department.populationID = DBNull.Value.Equals(rdr["cod_ctro_pobla"]) ? 0 : int.Parse(rdr["cod_ctro_pobla"].ToString());
department.populationName = DBNull.Value.Equals(rdr["nom_ctro_pobla"]) ? string.Empty : rdr["nom_ctro_pobla"].ToString();
department.municipalityID = DBNull.Value.Equals(rdr["cod_munic"]) ? 0 : int.Parse(rdr["cod_munic"].ToString());
list.Add(department);
}
rdr.Close();
response.lstDepartments = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetNeighborhood", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
/// <summary>
/// Gets the cities.
/// </summary>
/// <param name="departmentID">The department identifier.</param>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetCities</exception>
public OutDepartments GetCities(int departmentID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutDepartments response = new OutDepartments();
var ora = new OracleServer(connectionString);
Departments department;
List <Departments> list = new List <Departments>();
string command = string.Empty;
try
{
command = "select distinct A.cod_munic, A.nom_munic, A.cod_depto from dfpctropoblado A where CONSECUTIVO > 0 ";
command = command + string.Format(" and A.cod_depto = {0} ", departmentID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
department = new Departments();
department.municipalityID = DBNull.Value.Equals(rdr["cod_munic"]) ? 0 : int.Parse(rdr["cod_munic"].ToString());
department.municipalityName = DBNull.Value.Equals(rdr["nom_munic"]) ? string.Empty : rdr["nom_munic"].ToString();
department.departmentID = DBNull.Value.Equals(rdr["cod_depto"]) ? 0 : int.Parse(rdr["cod_depto"].ToString());
list.Add(department);
}
rdr.Close();
response.lstDepartments = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetCities", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
/// <summary>
/// Gets the departments.
/// </summary>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetDepartments</exception>
public OutDepartments GetDepartments()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutDepartments response = new OutDepartments();
var ora = new OracleServer(connectionString);
Departments department;
List <Departments> list = new List <Departments>();
string command = string.Empty;
try
{
command = "SELECT distinct nom_depto as nombre_producto, cod_depto as codigo_producto FROM dfpctropoblado ORDER BY 1 ASC ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
department = new Departments();
department.departmentID = DBNull.Value.Equals(rdr["codigo_producto"]) ? 0 : int.Parse(rdr["codigo_producto"].ToString());
department.departmentName = DBNull.Value.Equals(rdr["nombre_producto"]) ? string.Empty : rdr["nombre_producto"].ToString();
list.Add(department);
}
rdr.Close();
response.lstDepartments = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetDepartments", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
