public List<MasterRecipe> AddMasterRecipeToPlant(int plantID, int masterRecipeID)
{
BrewDBContext cont = new BrewDBContext();
MasterRecipe rec = cont.MasterRecipes.SingleOrDefault(g => g.MasterRecipeID == masterRecipeID);
cont.Plants.SingleOrDefault(g => g.PlantID == plantID).ThisPlantsBrands.Add(rec);
cont.SaveChanges();
List<MasterRecipe> recList = cont.Plants.SelectMany(g => g.ThisPlantsBrands).ToList();
return recList;
}
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
// Equipment
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
public Plant EQAddPlant(Plant newplant)
{
BrewDBContext cont = new BrewDBContext();
Plant plant = new Plant();
plant.PlantLoops = new List<EQControlLoop>();
plant.PlantAux = new List<EQAuxilary>();
plant.PlantVessels = new List<EQVessel>();
plant.BrewPubMenu = newplant.BrewPubMenu;
plant.PlantAddress = newplant.PlantAddress;
plant.PlantLocation = newplant.PlantLocation;
plant.PlantName = newplant.PlantName;
plant.Units = new List<Unit>();
cont.Plants.Add(plant);
cont.SaveChanges();
Plant plantreturn = cont.Plants.FirstOrDefault(e => e.PlantID == plant.PlantID);
return plantreturn;
}
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
// Plant
//----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------
public List<EQControlLoop> AddEQControlLoopToPlant(int plantID, EQControlLoop loop)
{
BrewDBContext cont = new BrewDBContext();
Plant plant = cont.Plants.FirstOrDefault(g => g.PlantID == plantID);
plant.PlantLoops.Add(loop);
cont.Plants.FirstOrDefault(g => g.PlantID == plantID).PlantLoops.Add(loop);
cont.SaveChanges();
return cont.EQControlLoops.SelectMany(g => EQControlLoops).Where(g => g.Plant.PlantID == plantID).ToList();
}
