public List <string> findDataContentValueByDataValuesId(CooperativeDataValues dataValue)
{
return(Dbase.getCurrentInstance().cooperativeDataContent
.Where(d => d.cooperativeDataValuesId == dataValue.cooperativeDataValuesId)
.Select(d => d.value)
.ToList());
}
public DataValues findDataValuesByPlantId(Plant plant, DataType dataType)
{
return((DataValues)Dbase.getCurrentInstance().dataValues
.Where(dv => dv.plantId == plant.plantId)
.Where(dv => dv.dataTypeId == dataType.dataTypeId)
.SingleOrDefault <DataValues>());
}
public IList <Plant> getAllPlantByCoop(Int32 coopId)
{
return(Dbase.getCurrentInstance().plants
.Where(p => p.cooperativeId == coopId)
.Include(p => p.dataValues)
.ToList <Plant>());
}
public CooperativeDataValues findDataValuesByCoopertiveId(Cooperative coop, DataType dataType)
{
return((CooperativeDataValues)Dbase.getCurrentInstance().cooperativeDataValues
.Where(cdv => cdv.cooperative.cooperativeId == coop.cooperativeId)
.Where(cdv => cdv.dataTypeId == dataType.dataTypeId)
.SingleOrDefault <CooperativeDataValues>());
}
public Plant getPlantByPlantNCoop(String plantName, String coopName)
{
return(Dbase.getCurrentInstance().plants
.Where(p => p.name == plantName)
.Where(p => p.cooperative.name == coopName)
.FirstOrDefault <Plant>());
}
public Cooperative getCooperativeByNameAndRegionId(Cooperative coop, Int32 regionId)
{
return(Dbase.getCurrentInstance().cooperatives
.Where(c => c.name == coop.name)
.Where(c => c.regionId == regionId)
.FirstOrDefault <Cooperative>());
}
public List <Cooperative> getCooperativeByRegion(Int32 regionId)
{
return(Dbase.getCurrentInstance().cooperatives
.Include(c => c.plants)
.Include(c => c.cooperativeDataValues)
.Where(c => c.regionId == regionId)
.ToList <Cooperative>());
}
public IList <Plant> getAllPlantData()
{
return(Dbase.getCurrentInstance().plants
.Include(p => p.dataValues)
.Include(p => p.cooperative)
.Include(p => p.cooperative.region)
.Include(p => p.cooperative.region.area)
.ToList <Plant>());
}
public List <Cooperative> getAllCooperative()
{
return(Dbase.getCurrentInstance().cooperatives
.ToList <Cooperative>());
}
public Plant getPlantByNameAndCooperative(Plant plant)
{
return(Dbase.getCurrentInstance().plants
.Where(p => p.name == plant.name && p.cooperativeId == plant.cooperativeId)
.FirstOrDefault <Plant>());
}
public List <CooperativeDataContent> findAllDataContentByDataValue(CooperativeDataValues dataValue)
{
return((List <CooperativeDataContent>)Dbase.getCurrentInstance().cooperativeDataContent
.Where(dc => dc.cooperativeDataValuesId == dataValue.cooperativeDataValuesId)
.ToList <CooperativeDataContent>());
}
public Regions getRegionByArea(Int32 areaId)
{
return(Dbase.getCurrentInstance().regions
.Where(r => r.area.areaId == areaId)
.FirstOrDefault <Regions>());
}
public IList <Regions> getAllRegions()
{
return(Dbase.getCurrentInstance().regions.ToList <Regions>());
}
public IList <Plant> getAllPlantsByCoopName(String cooperativeName)
{
return((IList <Plant>)Dbase.getCurrentInstance().cooperatives
.Where(c => c.name == cooperativeName)
.ToList <Cooperative>()[0].plants);
}
public List <CooperativeDataValues> findDataValuesByCooperativeId(Cooperative coop)
{
return((List <CooperativeDataValues>)Dbase.getCurrentInstance().cooperativeDataValues
.Where(cdv => cdv.cooperative.cooperativeId == coop.cooperativeId)
.ToList <CooperativeDataValues>());
}
public IList <DataValues> getAllDataValuesByPlant(Plant plant)
{
return(Dbase.getCurrentInstance().dataValues
.Where(dv => dv.plant == plant)
.ToList <DataValues>());
}
public IList <Plant> getAllPlant()
{
return(Dbase.getCurrentInstance()
.plants.ToList <Plant>());
}
public Plant getPlantByName(Plant plant)
{
return(Dbase.getCurrentInstance()
.plants.Where(p => p.name == plant.name)
.FirstOrDefault <Plant>());
}
public Cooperative getCooperativeByName(Cooperative coop)
{
return(Dbase.getCurrentInstance().cooperatives
.Where(c => c.name == coop.name)
.FirstOrDefault <Cooperative>());
}
public Area getAreaById(Int32 areaId)
{
return(Dbase.getCurrentInstance().areas
.Where(a => a.areaId == areaId)
.SingleOrDefault <Area>());
}
public List <Regions> getAllRegionsByArea(Area area)
{
return((List <Regions>)Dbase.getCurrentInstance().regions
.Where(r => r.areaId == area.areaId)
.ToList <Regions>());
}
public IList <Area> getAllAreas()
{
return(Dbase.getCurrentInstance().areas
.Include(a => a.regions)
.ToList <Area>());
}
private IList <Regions> getAllCoopsByRegion(String region)
{
return(Dbase.getCurrentInstance().regions.Where(r => r.name == region).ToList <Regions>());
}
public Area getAreaByName(Area area)
{
return(Dbase.getCurrentInstance().areas
.Where(a => a.name == area.name)
.FirstOrDefault <Area>());
}
public Regions getRegionByName(Regions region)
{
return(Dbase.getCurrentInstance().regions
.Where(r => r.name == region.name)
.FirstOrDefault <Regions>());
}
public void deleteByDataValueId(Int32 dataValueId)
{
Dbase.getCurrentInstance()
.Database
.ExecuteSqlCommand("DELETE FROM " + CooperativeDataContent.ENTITY_NAME + " WHERE cooperativeDataValuesId=" + dataValueId);
}
public List <DataValues> findDataValuesByPlant(Plant plant)
{
return((List <DataValues>)Dbase.getCurrentInstance().dataValues
.Where(dv => dv.plantId == plant.plantId)
.ToList <DataValues>());
}
public IList <DataValues> getAllDataValues()
{
return(Dbase.getCurrentInstance().dataValues.ToList <DataValues>());
}
public DataCategory getDataCategoryByName(String dataCategoryName)
{
return(Dbase.getCurrentInstance().dataCategories
.Where(dc => dc.name == dataCategoryName)
.FirstOrDefault <DataCategory>());
}
public List <DataContent> findDataContentByDataValuesId(DataValues dataValue)
{
return((List <DataContent>)Dbase.getCurrentInstance().dataContents
.Where(dc => dc.dataValuesId == dataValue.dataValuesId)
.ToList <DataContent>());
}
