public static LocationModel GetLocation(DSModel db, uint locationID)
{
if (db == null)
{
throw new ArgumentNullException("db");
}
return(LocationRepository.GetLocations(db, locationID).FirstOrDefault());
}
public static LocationModel GetLocation(DSModel db, string locationCode)
{
if (db == null)
{
throw new ArgumentNullException("db");
}
uint locID = db.Locations.Where(l => l.LocationCode == locationCode).Select(l => l.LocationID).FirstOrDefault();
if (locID == 0)
{
return(null);
}
return(LocationRepository.GetLocations(db, locID).FirstOrDefault());
}
public static List <LocationModel> GetLocationsByCompanies(DSModel db, uint[] companies = null)
{
if (db == null)
{
throw new ArgumentNullException("db");
}
var query = PredicateBuilder.True <Location>();
if (companies != null && companies.Length > 0)
{
query = query.And(q => companies.Contains(q.CompanyID));
}
uint[] ids = db.Locations
.Where(query)
.Select(i => i.LocationID)
.ToArray();
return(LocationRepository.GetLocations(db, ids));
}
