public void Get_domicilio_by_Localdiad_success()
{
_domicilioByFilterQuery = new DomicilioByFilterQuery()
{
StateDomicilio = DomicilioStateEnum.Localidad
};
_domicilioQueryResult = _QueryDispatcher.Dispatch <DomicilioByFilterQuery, DomicilioQueryResult>(_domicilioByFilterQuery);
}
public DomicilioQueryResult ExecuteState(DomicilioByFilterQuery query)
{
DomicilioQueryResult result = new DomicilioQueryResult();
var query1 = _repositryLocalScheme.Session.CallFunction <IdNombreDto>("PR_OBTENER_DEPT_X_PROV(?)");
query1.SetParameter(0, query.ProvinciaId);
result.Departamentos = (List <IdNombreDto>)query1.List <IdNombreDto>();
return(result);
}
public DomicilioQueryResult ExecuteState(DomicilioByFilterQuery query)
{
DomicilioQueryResult result = new DomicilioQueryResult();
var query1 = _repositryLocalScheme.Session.CallFunction <IdNombreDto>("PR_OBTENER_DEPARTAMENTOS_STR(?)");
query1.SetParameter(0, StringHelper.devolverStringUpperCase(query.Nombre));
result.Departamentos = (List <IdNombreDto>)query1.List <IdNombreDto>();
return(result);
}
public DomicilioQueryResult ExecuteState(DomicilioByFilterQuery query)
{
DomicilioQueryResult result = new DomicilioQueryResult();
var querySession = _repositryLocalScheme.Session.CallFunction <IdNombreDto>("PR_OBTENER_PROVINCIAS(?)");
querySession.SetParameter(0, query.PaisId);
result.Provincias = (List <IdNombreDto>)querySession.List <IdNombreDto>();
return(result);
}
public DomicilioQueryResult ExecuteState(DomicilioByFilterQuery query)
{
DomicilioQueryResult result = new DomicilioQueryResult();
var querySession = _repositryLocalScheme.Session.CallFunction <IdNombreDto>("PR_OBTENER_LOCALIDADES_STR(?,?,?)");
querySession.SetParameter(0, query.DepartamentoId.Value);
querySession.SetParameter(1, StringHelper.devolverStringUpperCase(query.Nombre));
querySession.SetParameter(2, query.ProvinciaId);
result.Localidades = (List <IdNombreDto>)querySession.List <IdNombreDto>();
return(result);
}
public DomicilioQueryResult ExecuteState(DomicilioByFilterQuery query)
{
DomicilioQueryResult result = new DomicilioQueryResult();
var querySession = _repositryLocalScheme.Session.CallFunction <IdNombreDto>("PR_OBTENER_BARRIOS(?)");
querySession.SetParameter(0, query.LocalidadId.Value);
result.Barrios = (List <IdNombreDto>)querySession.List <IdNombreDto>();
querySession = _repositryLocalScheme.Session.CallFunction <IdNombreDto>("PR_OBTENER_TIPOS_CALLE()");
result.TipoCalles = (List <IdNombreDto>)querySession.List <IdNombreDto>();
return(result);
}