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