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 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 List <string> findDataContentValueByDataValuesId(CooperativeDataValues dataValue)
{
return(Dbase.getCurrentInstance().cooperativeDataContent
.Where(d => d.cooperativeDataValuesId == dataValue.cooperativeDataValuesId)
.Select(d => d.value)
.ToList());
}
public IList <Plant> getAllPlantByCoop(Int32 coopId)
{
return(Dbase.getCurrentInstance().plants
.Where(p => p.cooperativeId == coopId)
.Include(p => p.dataValues)
.ToList <Plant>());
}
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 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 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 Plant getPlantByCoopId(Int32 coopId)
{
var db = new Dbase();
db.Configuration.LazyLoadingEnabled = false;
return(db.plants
.Where(p => p.cooperative.cooperativeId == coopId)
.FirstOrDefault <Plant>());
}
public void delete(Object obj)
{
using (var db = new Dbase())
{
if (obj.GetType() == typeof(Area))
{
Area area = (Area)obj;
Area areaDelete = db.areas.Where(a => a.name == area.name).FirstOrDefault <Area>();
db.areas.Remove(areaDelete);
}
else if (obj.GetType() == typeof(Cooperative))
{
Cooperative cooperative = (Cooperative)obj;
Cooperative cooperativeDelete = db.cooperatives.Where(c => c.name == cooperative.name).FirstOrDefault <Cooperative>();
db.cooperatives.Remove(cooperativeDelete);
}
else if (obj.GetType() == typeof(Plant))
{
Plant plant = (Plant)obj;
Plant plantDelete = db.plants.Where(p => p.name == plant.name).FirstOrDefault <Plant>();
db.plants.Remove(plantDelete);
}
else if (obj.GetType() == typeof(Regions))
{
Regions region = (Regions)obj;
Regions regionDelete = db.regions.Where(r => r.name == region.name).FirstOrDefault <Regions>();
db.regions.Remove(regionDelete);
}
else if (obj.GetType() == typeof(CooperativeDataValues))
{
CooperativeDataValues cooperativeDataValues = (CooperativeDataValues)obj;
db.cooperativeDataValues.Remove(cooperativeDataValues);
}
else if (obj.GetType() == typeof(CooperativeDataContent))
{
CooperativeDataContent cooperativeDataContent = (CooperativeDataContent)obj;
db.cooperativeDataContent.Remove(cooperativeDataContent);
}
db.SaveChanges();
}
}
public IList <Area> getAllRegionsByArea(String area)
{
try
{
using (var data = new Dbase())
{
data.Configuration.LazyLoadingEnabled = true;
IList <Area> areas = data.areas.Include(s => s.regions)
.Where(a => a.name == area)
.ToList <Area>();
return(areas);
}
}
catch (Exception ex)
{
Console.WriteLine("ERROR: " + ex.Message.ToString());
}
return(null);
}
public Regions getRegionByName(Regions region)
{
return(Dbase.getCurrentInstance().regions
.Where(r => r.name == region.name)
.FirstOrDefault <Regions>());
}
public Regions getRegionByArea(Int32 areaId)
{
return(Dbase.getCurrentInstance().regions
.Where(r => r.area.areaId == areaId)
.FirstOrDefault <Regions>());
}
private IList <Regions> getAllCoopsByRegion(String region)
{
return(Dbase.getCurrentInstance().regions.Where(r => r.name == region).ToList <Regions>());
}
public IList <Regions> getAllRegions()
{
return(Dbase.getCurrentInstance().regions.ToList <Regions>());
}
public List <Regions> getAllRegionsByArea(Area area)
{
return((List <Regions>)Dbase.getCurrentInstance().regions
.Where(r => r.areaId == area.areaId)
.ToList <Regions>());
}
public void deleteByDataValueId(Int32 dataValueId)
{
Dbase.getCurrentInstance()
.Database
.ExecuteSqlCommand("DELETE FROM " + CooperativeDataContent.ENTITY_NAME + " WHERE cooperativeDataValuesId=" + dataValueId);
}
public IList <DataValues> getAllDataValuesByPlant(Plant plant)
{
return(Dbase.getCurrentInstance().dataValues
.Where(dv => dv.plant == plant)
.ToList <DataValues>());
}
public List <CooperativeDataValues> findDataValuesByCooperativeId(Cooperative coop)
{
return((List <CooperativeDataValues>)Dbase.getCurrentInstance().cooperativeDataValues
.Where(cdv => cdv.cooperative.cooperativeId == coop.cooperativeId)
.ToList <CooperativeDataValues>());
}
public List <DataValues> findDataValuesByPlant(Plant plant)
{
return((List <DataValues>)Dbase.getCurrentInstance().dataValues
.Where(dv => dv.plantId == plant.plantId)
.ToList <DataValues>());
}
public Area getAreaByName(Area area)
{
return(Dbase.getCurrentInstance().areas
.Where(a => a.name == area.name)
.FirstOrDefault <Area>());
}
public IList <Area> getAllAreas()
{
return(Dbase.getCurrentInstance().areas
.Include(a => a.regions)
.ToList <Area>());
}
public List <CooperativeDataContent> findAllDataContentByDataValue(CooperativeDataValues dataValue)
{
return((List <CooperativeDataContent>)Dbase.getCurrentInstance().cooperativeDataContent
.Where(dc => dc.cooperativeDataValuesId == dataValue.cooperativeDataValuesId)
.ToList <CooperativeDataContent>());
}
public Cooperative getCooperativeByName(Cooperative coop)
{
return(Dbase.getCurrentInstance().cooperatives
.Where(c => c.name == coop.name)
.FirstOrDefault <Cooperative>());
}
public IList <Plant> getAllPlant()
{
return(Dbase.getCurrentInstance()
.plants.ToList <Plant>());
}
public IList <Plant> getAllPlantsByCoopName(String cooperativeName)
{
return((IList <Plant>)Dbase.getCurrentInstance().cooperatives
.Where(c => c.name == cooperativeName)
.ToList <Cooperative>()[0].plants);
}
public Object add(Object obj)
{
object resultObj = null;
using (var db = new Dbase())
{
if (obj.GetType() == typeof(Area))
{
Area area = (Area)obj;
db.areas.Add(area);
db.SaveChanges();
resultObj = area;
}
else if (obj.GetType() == typeof(Cooperative))
{
Cooperative cooperative = (Cooperative)obj;
db.cooperatives.Add(cooperative);
db.SaveChanges();
resultObj = cooperative;
}
else if (obj.GetType() == typeof(Plant))
{
Plant plant = (Plant)obj;
db.plants.Add(plant);
db.SaveChanges();
resultObj = plant;
}
else if (obj.GetType() == typeof(Regions))
{
Regions region = (Regions)obj;
db.regions.Add(region);
db.SaveChanges();
resultObj = region;
}
else if (obj.GetType() == typeof(DataValues))
{
DataValues dataValue = (DataValues)obj;
db.dataValues.Add(dataValue);
db.SaveChanges();
resultObj = dataValue;
}
else if (obj.GetType() == typeof(DataContent))
{
DataContent dataContent = (DataContent)obj;
db.dataContents.Add(dataContent);
db.SaveChanges();
resultObj = dataContent;
}
else if (obj.GetType() == typeof(CooperativeDataValues))
{
CooperativeDataValues cooperativeDataValues = (CooperativeDataValues)obj;
db.cooperativeDataValues.Add(cooperativeDataValues);
db.SaveChanges();
resultObj = cooperativeDataValues;
}
else if (obj.GetType() == typeof(CooperativeDataContent))
{
CooperativeDataContent cooperativeDataContent = (CooperativeDataContent)obj;
db.cooperativeDataContent.Add(cooperativeDataContent);
db.SaveChanges();
resultObj = cooperativeDataContent;
}
else if (obj.GetType() == typeof(DataType))
{
DataType dataType = (DataType)obj;
db.dataTypes.Add(dataType);
db.SaveChanges();
resultObj = dataType;
}
return(resultObj);
}
}
public Area getAreaById(Int32 areaId)
{
return(Dbase.getCurrentInstance().areas
.Where(a => a.areaId == areaId)
.SingleOrDefault <Area>());
}
public DataCategory getDataCategoryByName(String dataCategoryName)
{
return(Dbase.getCurrentInstance().dataCategories
.Where(dc => dc.name == dataCategoryName)
.FirstOrDefault <DataCategory>());
}
public List <Cooperative> getAllCooperative()
{
return(Dbase.getCurrentInstance().cooperatives
.ToList <Cooperative>());
}
