public async Task <IActionResult> Create([Bind("Id_FamSampling,Id_Farm,DateSampling,Details,Description_CFV,Value_CFV,Description_DAS," + "Value_DAS,Description_DFS,Value_DFS,Description_MPE,Value_MPE,Description_NCS,Value_NCS,Description_NES,Value_NES,Description_NRS," + "Value_NRS,Description_PES,Value_PES,Description_RCES,Value_RCES,Description_RCS,Value_RCS,Description_RES,Value_RES,Description_VBS," + "Value_VBS,Description_AF,Value_AF,AnimalsAmount,IVEA")] FarmSampling farmSampling) { if (ModelState.IsValid) { farmSampling.IVEA = (float)farmSampling.IndexValue; _context.Add(farmSampling); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(farmSampling)); }
public async Task <IActionResult> Edit(int id, [Bind("Id_FamSampling,Id_Farm,DateSampling,Details,Description_CFV,Value_CFV,Description_DAS," + "Value_DAS,Description_DFS,Value_DFS,Description_MPE,Value_MPE,Description_NCS,Value_NCS,Description_NES,Value_NES,Description_NRS," + "Value_NRS,Description_PES,Value_PES,Description_RCES,Value_RCES,Description_RCS,Value_RCS,Description_RES,Value_RES,Description_VBS," + "Value_VBS,Description_AF,Value_AF,AnimalsAmount,IVEA")] FarmSampling farmSampling) { if (id != farmSampling.Id_FamSampling) { return(NotFound()); } if (ModelState.IsValid) { try { //DropDownList value validations SetFarmSamplingsViewBag(id, farmSampling); //Calculated Field farmSampling.IVEA = (float)farmSampling.IndexValue; _context.Update(farmSampling); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FarmSamplingExists(farmSampling.Id_FamSampling)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(farmSampling)); }
//Defining values to use in the dropdownlists private void SetFarmSamplingsViewBag(int?id, FarmSampling farmSampling) { if (id == null) { //ViewBag.Id_Farm = new SelectList(_context.Farm, "Id_Farm", "NameFarm"); //ViewBag.Description_CFV = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 8).ToList(), "Specificity", "Specificity"); //ViewBag.Description_DAS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 4).ToList(), "Specificity", "Specificity"); //ViewBag.Description_DFS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 5).ToList(), "Specificity", "Specificity"); //ViewBag.Description_MPE = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 10).ToList(), "Specificity", "Specificity"); //ViewBag.Description_NCS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 3).ToList(), "Specificity", "Specificity"); //ViewBag.Description_NES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 2).ToList(), "Specificity", "Specificity"); //ViewBag.Description_NRS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 7).ToList(), "Specificity", "Specificity"); //ViewBag.Description_PES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 1).ToList(), "Specificity", "Specificity"); //ViewBag.Description_RCES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 9).ToList(), "Specificity", "Specificity"); //ViewBag.Description_RCS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 12).ToList(), "Specificity", "Specificity"); //ViewBag.Description_RES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 11).ToList(), "Specificity", "Specificity"); //ViewBag.Description_VBS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 6).ToList(), "Specificity", "Specificity"); //ViewBag.Description_AF = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 13).ToList(), "Specificity", "Specificity"); } else { GetDropDownListValues getDropDownListValues = new GetDropDownListValues(); List <int> ValueList = new List <int>() { }; ViewBag.Id_Farm = new SelectList(_context.Farm.ToArray(), "Id_Farm", "NameFarm", id); //ViewBag.Description_CFV = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 8).ToList(), "Specificity", "Specificity", id); var Val_CFV = (int)farmSampling.Value_CFV; ValueList = getDropDownListValues.GetLevel(Val_CFV); ViewBag.Value_CFV = new SelectList(ValueList); ViewBag.Description_DAS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 4).ToList(), "Specificity", "Specificity", id); var Val_DAS = (int)farmSampling.Value_DAS; ValueList = getDropDownListValues.GetLevel(Val_DAS); ViewBag.Value_DAS = new SelectList(ValueList); ViewBag.Description_DFS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 5).ToList(), "Specificity", "Specificity", id); var Val_DFS = (int)farmSampling.Value_DFS; ValueList = getDropDownListValues.GetLevel(Val_DFS); ViewBag.Value_DFS = new SelectList(ValueList); ViewBag.Description_MPE = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 10).ToList(), "Specificity", "Specificity", id); var Val_MPE = (int)farmSampling.Value_MPE; ValueList = getDropDownListValues.GetLevel(Val_MPE); ViewBag.Value_MPE = new SelectList(ValueList); ViewBag.Description_NCS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 3).ToList(), "Specificity", "Specificity", id); var Val_NCS = (int)farmSampling.Value_NCS; ValueList = getDropDownListValues.GetLevel(Val_NCS); ViewBag.Value_NCS = new SelectList(ValueList); ViewBag.Description_NES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 2).ToList(), "Specificity", "Specificity", id); var Val_NES = (int)farmSampling.Value_NES; ValueList = getDropDownListValues.GetLevel(Val_NES); ViewBag.Value_NES = new SelectList(ValueList); ViewBag.Description_NRS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 7).ToList(), "Specificity", "Specificity", id); var Val_NRS = (int)farmSampling.Value_NRS; ValueList = getDropDownListValues.GetLevel(Val_NRS); ViewBag.Value_NRS = new SelectList(ValueList); ViewBag.Description_PES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 1).ToList(), "Specificity", "Specificity", id); var Val_PES = (int)farmSampling.Value_PES; ValueList = getDropDownListValues.GetLevel(Val_PES); ViewBag.Value_PES = new SelectList(ValueList); ViewBag.Description_RCES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 9).ToList(), "Specificity", "Specificity", id); var Val_RCES = (int)farmSampling.Value_RCES; ValueList = getDropDownListValues.GetLevel(Val_RCES); ViewBag.Value_RCES = new SelectList(ValueList); ViewBag.Description_RCS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 12).ToList(), "Specificity", "Specificity", id); var Val_RCS = (int)farmSampling.Value_RCS; ValueList = getDropDownListValues.GetLevel(Val_RCS); ViewBag.Value_RCS = new SelectList(ValueList); ViewBag.Description_RES = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 11).ToList(), "Specificity", "Specificity", id); var Val_RES = (int)farmSampling.Value_RES; ValueList = getDropDownListValues.GetLevel(Val_RES); ViewBag.Value_RES = new SelectList(ValueList); ViewBag.Description_VBS = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 6).ToList(), "Specificity", "Specificity", id); var Val_VBS = (int)farmSampling.Value_VBS; ValueList = getDropDownListValues.GetLevel(Val_VBS); ViewBag.Value_VBS = new SelectList(ValueList); ViewBag.Description_AF = new SelectList(_context.IndicatorSpecificity.Where(e => e.Id_Indicator == 13).ToList(), "Specificity", "Specificity", id); var Val_AF = (int)farmSampling.Value_AF; ValueList = getDropDownListValues.GetLevel(Val_AF); ViewBag.Value_AF = new SelectList(ValueList); } }