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