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>()); }