public PartialViewResult SubmitNewMixingStationsAnswers(MixingStationAnswersVM vm) { int stationCount = default(int); try { var stationsOfFactory = db.MixingStationsAnswersOfFactories.Where(p => p.FactoryId == vm.FactoryId).GroupBy(g => g.StationNumber); if (stationsOfFactory != null) { stationCount = stationsOfFactory.Count() + 1; } else { stationCount = 1; } } catch { stationCount = 1; } foreach (var item in vm.mixstation) { if (item.QuestionId != null && item.Answer != null) { db.MixingStationsAnswersOfFactories.Add(new MixingStationsAnswersOfFactory { FactoryId = vm.FactoryId, MixingStationsQuestionsId = int.Parse(item.QuestionId), InputValue = item.Answer, StationNumber = stationCount }); } } db.SaveChanges(); ViewBag.ListMixStationTitls = db.MixingStationsTypes.ToList(); ViewBag.ListMixStationOptions = db.MixingStationsQuestions.ToList(); ViewBag.MixingStationsAnswersOfFactories = db.MixingStationsAnswersOfFactories.Where(p => p.FactoryId == vm.FactoryId).GroupBy(p => p.StationNumber).OrderByDescending(g => g.Key).FirstOrDefault().ToList(); return(PartialView("_SubmitNewMixingStationsAnswers")); }
public PartialViewResult AddMixiningStation(int FactoryId) { ViewBag.ListMixStationTitls = db.MixingStationsTypes.ToList(); ViewBag.ListMixStationOptions = db.MixingStationsQuestions.ToList(); MixingStationAnswersVM vm = new MixingStationAnswersVM() { FactoryId = FactoryId }; return(PartialView("_NewMixiningStation", vm)); }
public PartialViewResult ShowMixiningStation(int FactoryId, int StationNumber) { ViewBag.ListMixStationTitls = db.MixingStationsTypes.ToList(); ViewBag.ListMixStationOptions = db.MixingStationsQuestions.ToList(); ViewBag.MixingStationsAnswersOfFactories = db.MixingStationsAnswersOfFactories.Where(p => p.FactoryId == FactoryId).GroupBy(p => p.StationNumber).OrderBy(g => g.Key).Skip(StationNumber).FirstOrDefault().ToList(); MixingStationAnswersVM vm = new MixingStationAnswersVM() { FactoryId = FactoryId }; return(PartialView("_SubmitNewMixingStationsAnswers", vm)); }