public Boolean isExist(Object obj) { bool exist = false; if (obj.GetType() == typeof(Area)) { areaSessionData = new AreaSessionData(); Area area = areaSessionData.getAreaByName((Area)obj); exist = (area != null) ? true : false; } else if (obj.GetType() == typeof(Cooperative)) { cooperativeSessionData = new CooperativeSessionData(); Cooperative coop = cooperativeSessionData.getCooperativeByName((Cooperative)obj); exist = (coop != null) ? true : false; } else if (obj.GetType() == typeof(Plant)) { plantSessionData = new PlantDataSession(); Plant plant = plantSessionData.getPlantByNameAndCooperative((Plant)obj); exist = (plant != null) ? true : false; } else if (obj.GetType() == typeof(Regions)) { regionSessionData = new RegionSessionData(); Regions region = regionSessionData.getRegionByName((Regions)obj); exist = (region != null) ? true : false; } else if (obj.GetType() == typeof(DataType)) { exist = ((DataType)search(obj) != null) ? true : false; } return(exist); }
public Cooperative getCooperativeByName(String cooperativeName) { Cooperative coop = new Cooperative(); coop.name = cooperativeName; return(getCooperativeByName(coop)); }
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 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 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 Object search(Object obj) { object resultObj = null; if (obj.GetType() == typeof(Area)) { areaSessionData = new AreaSessionData(); Area area = areaSessionData.getAreaByName((Area)obj); resultObj = area; } else if (obj.GetType() == typeof(Cooperative)) { Cooperative cooperative = (Cooperative)obj; cooperativeSessionData = new CooperativeSessionData(); Cooperative coop = cooperativeSessionData.getCooperativeByNameAndRegionId(cooperative, cooperative.regionId); resultObj = coop; } else if (obj.GetType() == typeof(Plant)) { Plant planta = (Plant)obj; plantSessionData = new PlantDataSession(); Plant plant = plantSessionData.getPlantByNameAndCooperative(planta); // plantSessionData.getPlantByName((Plant)obj); resultObj = plant; } else if (obj.GetType() == typeof(Regions)) { regionSessionData = new RegionSessionData(); Regions region = regionSessionData.getRegionByName((Regions)obj); resultObj = region; } else if (obj.GetType() == typeof(DataType)) { dataTypeSessionData = new DataTypeSessionData(); DataType dataType = dataTypeSessionData.getDataTypeByName((DataType)obj); resultObj = dataType; } return(resultObj); }
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 Plant(String plantName, Cooperative cooperative) : this() { name = plantName; this.cooperative = cooperative; }
public Cooperative getCooperativeByName(Cooperative coop) { return(Dbase.getCurrentInstance().cooperatives .Where(c => c.name == coop.name) .FirstOrDefault <Cooperative>()); }
public List <CooperativeDataValues> findDataValuesByCooperativeId(Cooperative coop) { return((List <CooperativeDataValues>)Dbase.getCurrentInstance().cooperativeDataValues .Where(cdv => cdv.cooperative.cooperativeId == coop.cooperativeId) .ToList <CooperativeDataValues>()); }
public CooperativeDataValues(Cooperative cooperative, DataType dataType) : base() { this.cooperativeId = cooperative.cooperativeId; this.dataTypeId = dataType.dataTypeId; }
public Plant getPlantByCoop(Cooperative coop) { return(getPlantByCoop(coop.name)); }