public IQueryable <Atm> GetFilteredATM(SWSearchModel searchModel)
{
//TODO: CREATE STORED PROCEDURE TO FETCH FILTERED DATA
var result = _context.Atm.AsQueryable();
if (searchModel != null)
{
//TODO: CREATE FOREACH STATEMENT
if (!string.IsNullOrEmpty(searchModel.Barrio))
{
result = result.Where(x => x.Barrio.Contains(searchModel.Barrio));
}
if (!string.IsNullOrEmpty(searchModel.CodigoPostalArgentino))
{
result = result.Where(x => x.CodigoPostalArgentino.Contains(searchModel.CodigoPostalArgentino));
}
if (!string.IsNullOrEmpty(searchModel.Banco))
{
result = result.Where(x => x.Banco.Contains(searchModel.Banco));
}
if (!string.IsNullOrEmpty(searchModel.Red))
{
result = result.Where(x => x.Red.Contains(searchModel.Red));
}
if (!string.IsNullOrEmpty(searchModel.Ubicacion))
{
result = result.Where(x => x.Ubicacion.Contains(searchModel.Ubicacion));
}
if (!string.IsNullOrEmpty(searchModel.Localidad))
{
result = result.Where(x => x.Localidad.Contains(searchModel.Localidad));
}
if (searchModel.Terminales.HasValue)
{
result = result.Where(x => x.Terminales == searchModel.Terminales);
}
if (searchModel.NoVidente.HasValue)
{
result = result.Where(x => x.NoVidente == searchModel.NoVidente);
}
if (searchModel.Dolares.HasValue)
{
result = result.Where(x => x.Dolares == searchModel.Dolares);
}
}
return(result);
}
public IQueryable <Biblioteca> GetFilteredLibraries(SWSearchModel searchModel)
{
var result = _context.Biblioteca.AsQueryable();
if (searchModel != null)
{
//TODO: CREATE FOREACH STATEMENT
if (!string.IsNullOrEmpty(searchModel.Barrio))
{
result = result.Where(x => x.Barrio.Contains(searchModel.Barrio));
}
if (!string.IsNullOrEmpty(searchModel.CodigoPostalArgentino))
{
result = result.Where(x => x.CodigoPostalArgentino.Contains(searchModel.CodigoPostalArgentino));
}
if (!string.IsNullOrEmpty(searchModel.Nombre))
{
result = result.Where(x => x.Nombre.Contains(searchModel.Nombre));
}
if (!string.IsNullOrEmpty(searchModel.Telefono))
{
result = result.Where(x => x.Telefono.Contains(searchModel.Telefono));
}
if (!string.IsNullOrEmpty(searchModel.Observaciones))
{
result = result.Where(x => x.Observaciones.Contains(searchModel.Observaciones));
}
if (!string.IsNullOrEmpty(searchModel.DireccionNormalizada))
{
result = result.Where(x => x.DireccionNormalizada.Contains(searchModel.DireccionNormalizada));
}
if (!string.IsNullOrEmpty(searchModel.Piso))
{
result = result.Where(x => x.Piso.Contains(searchModel.Piso));
}
if (!string.IsNullOrEmpty(searchModel.Piso))
{
result = result.Where(x => x.Piso.Contains(searchModel.Piso));
}
if (!string.IsNullOrEmpty(searchModel.Piso))
{
result = result.Where(x => x.Piso.Contains(searchModel.Piso));
}
}
return(result);
}
public IQueryable <Farmacia> GetFilteredFarmacies(SWSearchModel searchModel)
{
var result = _context.Farmacia.AsQueryable();
if (searchModel != null)
{
//TODO: CREATE FOREACH STATEMENT
if (!string.IsNullOrEmpty(searchModel.Barrio))
{
result = result.Where(x => x.Barrio.Contains(searchModel.Barrio));
}
if (!string.IsNullOrEmpty(searchModel.CodigoPostalArgentino))
{
result = result.Where(x => x.CodigoPostalArgentino.Contains(searchModel.CodigoPostalArgentino));
}
if (!string.IsNullOrEmpty(searchModel.Telefono))
{
result = result.Where(x => x.Telefono.Contains(searchModel.Telefono));
}
if (!string.IsNullOrEmpty(searchModel.CalleNombre))
{
result = result.Where(x => x.CalleNombre.Contains(searchModel.CalleNombre));
}
if (searchModel.CalleAltura.HasValue)
{
result = result.Where(x => x.CalleAltura == searchModel.CalleAltura);
}
if (!string.IsNullOrEmpty(searchModel.CalleCruce))
{
result = result.Where(x => x.CalleCruce.Contains(searchModel.CalleCruce));
}
if (!string.IsNullOrEmpty(searchModel.Barrio))
{
result = result.Where(x => x.Barrio.Contains(searchModel.Barrio));
}
}
return(result);
}
