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