public StatePower GetStatePowerById(SIGEeLDBContext e, string id)
{
var query = (from c in e.StatePowers
where c.StatePowerId == new Guid(id)
select c).FirstOrDefault();
return(query);
}
public IEnumerable <Locality> GetLocalitiesByRegionId(SIGEeLDBContext e, string id)
{
var query = (from c in e.Localities
where c.Region.RegionId == new Guid(id)
select c);
return(query);
}
public SubSector GetSubSectorByName(SIGEeLDBContext e, string name)
{
var query = (from c in e.SubSectors
where c.SubSectorName == name
select c).FirstOrDefault();
return(query);
}
public Country GetCountryById(SIGEeLDBContext e, string id)
{
var query = (from c in e.Countries
where c.CountryId == new Guid(id)
select c).FirstOrDefault();
return(query);
}
public Locality GetLocalityById(SIGEeLDBContext e, string id)
{
var query = (from c in e.Localities
where c.LocalityId == new Guid(id)
select c).FirstOrDefault();
return(query);
}
public Country GetCountryByName(SIGEeLDBContext e, string name)
{
var query = (from c in e.Countries
where c.CountryName == name
select c).FirstOrDefault();
return(query);
}
public InstitutionType GetInstitutionTypeById(SIGEeLDBContext e, string id)
{
var query = (from c in e.InstitutionTypes
where c.InstitutionTypeId == new Guid(id)
select c).FirstOrDefault();
return(query);
}
public InstitutionType GetInstitutionTypeByName(SIGEeLDBContext e, string name)
{
var query = (from c in e.InstitutionTypes
where c.InstitutionTypeName == name
select c).FirstOrDefault();
return(query);
}
public Region GetRegionByName(SIGEeLDBContext e, string name)
{
var query = (from c in e.Regions
where c.RegionName == name
select c).FirstOrDefault();
return(query);
}
public Region GetRegionById(SIGEeLDBContext e, string id)
{
var query = (from c in e.Regions
where c.RegionId == new Guid(id)
select c).FirstOrDefault();
return(query);
}
public IEnumerable <StatePower> GetAll(SIGEeLDBContext e)
{
return(from c in e.StatePowers
orderby c.StatePowerName ascending
select c);
}
public IEnumerable <SubSector> GetAll(SIGEeLDBContext e)
{
return(from c in e.SubSectors
orderby c.SubSectorName ascending
select c);
}
public IEnumerable <Locality> GetAll(SIGEeLDBContext e)
{
return(from c in e.Localities
orderby c.LocalityName ascending
select c);
}
public IEnumerable <Country> GetAll(SIGEeLDBContext e)
{
return(from c in e.Countries
orderby c.CountryName ascending
select c);
}
public IEnumerable <InstitutionType> GetAll(SIGEeLDBContext e)
{
return(from c in e.InstitutionTypes
orderby c.InstitutionTypeName ascending
select c);
}
public IEnumerable <Region> GetAll(SIGEeLDBContext e)
{
return(from c in e.Regions
orderby c.RegionName ascending
select c);
}
