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