public async Task <IActionResult> Edit(int id, [Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { if (id != treatmentFertilizer.TreatmentFertilizerId) { ModelState.AddModelError("", "The fertilizer for the treatment is for a different treatmentFertilizerID than your asked for."); } if (ModelState.IsValid) { try { _context.Update(treatmentFertilizer); await _context.SaveChangesAsync(); treatmentFertilizer.FertilizerName = Request.Form["FertilizerName"]; TempData["message"] = $"Fertilizer for treatment updated: {treatmentFertilizer.FertilizerName}"; return(RedirectToAction(nameof(Index))); } catch (Exception ex) { while (ex.InnerException != null) { ex = ex.InnerException; } ModelState.AddModelError("", $"Exception occurred while updating fertilizer for treatment: {ex.Message}."); } } Create(); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Edit(int id, [Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { if (id != treatmentFertilizer.TreatmentFertilizerId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(treatmentFertilizer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TreatmentFertilizerExists(treatmentFertilizer.TreatmentFertilizerId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer.OrderBy(f => f.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "TreatmentId", treatmentFertilizer.TreatmentId); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { TempData["treatmentId"] = HttpContext.Session.GetInt32("treatmentId"); if (ModelState.IsValid) { _context.Add(treatmentFertilizer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer.OrderBy(t => t.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "TreatmentId", treatmentFertilizer.TreatmentId); ViewData["ratePerAcre"] = _context.TreatmentFertilizer .Where(t => t.TreatmentId == HttpContext.Session.GetInt32("treatmentId")) .Select(t => t.RatePerAcre) .FirstOrDefault(); ViewData["rateMetric"] = _context.TreatmentFertilizer .Where(t => t.TreatmentId == HttpContext.Session.GetInt32("treatmentId")) .Select(t => t.RateMetric) .FirstOrDefault(); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { var checkLiquid = _context.Fertilizer.FirstOrDefault(a => a.FertilizerName == treatmentFertilizer.FertilizerName && a.Liquid == true); if (checkLiquid != null) { treatmentFertilizer.RateMetric = "Gal"; } else if (checkLiquid == null) { treatmentFertilizer.RateMetric = "LB"; } if (ModelState.IsValid) { _context.Add(treatmentFertilizer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer, "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "TreatmentId", treatmentFertilizer.TreatmentId); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { if (ModelState.IsValid) { _context.Add(treatmentFertilizer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer, "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "TreatmentId", treatmentFertilizer.TreatmentId); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Edit(int id, [Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { var checkLiquid = _context.Fertilizer.FirstOrDefault(a => a.FertilizerName == treatmentFertilizer.FertilizerName && a.Liquid == true); if (checkLiquid != null) { treatmentFertilizer.RateMetric = "Gal"; } else if (checkLiquid == null) { treatmentFertilizer.RateMetric = "LB"; } if (id != treatmentFertilizer.TreatmentFertilizerId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(treatmentFertilizer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TreatmentFertilizerExists(treatmentFertilizer.TreatmentFertilizerId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer, "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = new SelectList(_context.Treatment, "TreatmentId", "TreatmentId", treatmentFertilizer.TreatmentId); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Edit(int id, [Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { if (id != treatmentFertilizer.TreatmentFertilizerId) { return(NotFound()); } if (ModelState.IsValid) { try { bool liquid = _context.Fertilizer.SingleOrDefault(f => f.FertilizerName.ToString() == treatmentFertilizer.FertilizerName).Liquid; if (liquid == true) { treatmentFertilizer.RateMetric = "Gal"; } else { treatmentFertilizer.RateMetric = "LB"; } _context.Update(treatmentFertilizer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TreatmentFertilizerExists(treatmentFertilizer.TreatmentFertilizerId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer.OrderBy(f => f.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = HttpContext.Session.GetString("treatementIdSession"); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { List <string> rateMetric = new List <string> { "Gal", "LB" }; if (ModelState.IsValid) { treatmentFertilizer.TreatmentId = Convert.ToInt32(Request.Cookies["treatmentId"]); _context.Add(treatmentFertilizer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["RateMetric"] = new SelectList(rateMetric); ViewData["FertilizerName"] = new SelectList(_context.Fertilizer.OrderBy(p => p.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { try { if (ModelState.IsValid) { _context.Add(treatmentFertilizer); await _context.SaveChangesAsync(); TempData["message"] = $"Fertilizer for treatment created: {treatmentFertilizer.FertilizerName}"; return(RedirectToAction(nameof(Index))); } } catch (Exception ex) { ModelState.AddModelError("", $"Exception thrown on Create: {ex.GetBaseException().Message}"); } Create(); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Edit(int id, [Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { var oECContext = _context.Fertilizer.AsQueryable(); if (id != treatmentFertilizer.TreatmentFertilizerId) { return(NotFound()); } if (ModelState.IsValid) { try { var myTreatmentFertilizer = treatmentFertilizer; myTreatmentFertilizer.RateMetric = (oECContext .FirstOrDefault(t => t.FertilizerName == myTreatmentFertilizer.FertilizerName) .Liquid) ? "Gal" : "Lb"; _context.Update(treatmentFertilizer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TreatmentFertilizerExists(treatmentFertilizer.TreatmentFertilizerId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } int treatmentId = Convert.ToInt32(HttpContext.Session.GetString(nameof(treatmentId))); ViewData["FertilizerName"] = new SelectList(oECContext.OrderBy(a => a.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = treatmentId; return(View(treatmentFertilizer)); }
public async Task <IActionResult> Edit(int id, [Bind("TreatmentFertilizerId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { if (id != treatmentFertilizer.TreatmentFertilizerId) { return(NotFound()); } if (ModelState.IsValid) { try { treatmentFertilizer.TreatmentId = Convert.ToInt32(Request.Cookies["treatmentId"]); _context.Update(treatmentFertilizer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TreatmentFertilizerExists(treatmentFertilizer.TreatmentFertilizerId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } List <string> rateMetric = new List <string> { "Gal", "LB" }; ViewData["RateMetric"] = new SelectList(rateMetric); ViewData["FertilizerName"] = new SelectList(_context.Fertilizer.OrderBy(p => p.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { var oECContext = _context.Fertilizer.AsQueryable(); if (ModelState.IsValid) { var myTreatmentFertilizer = treatmentFertilizer; myTreatmentFertilizer.RateMetric = (oECContext .FirstOrDefault(t => t.FertilizerName == myTreatmentFertilizer.FertilizerName) .Liquid) ? "Gal" : "Lb"; _context.Add(myTreatmentFertilizer); await _context.SaveChangesAsync(); TempData["Message"] = "Record added for " + myTreatmentFertilizer.FertilizerName; return(RedirectToAction(nameof(Index))); } int treatmentId = Convert.ToInt32(HttpContext.Session.GetString(nameof(treatmentId))); ViewData["FertilizerName"] = new SelectList(oECContext.OrderBy(a => a.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = treatmentId; return(View(treatmentFertilizer)); }
public async Task <IActionResult> Create([Bind("TreatmentFertilizerId,TreatmentId,FertilizerName,RatePerAcre,RateMetric")] TreatmentFertilizer treatmentFertilizer) { if (ModelState.IsValid) { bool liquid = _context.Fertilizer.SingleOrDefault(f => f.FertilizerName.ToString() == treatmentFertilizer.FertilizerName).Liquid; if (liquid == true) { treatmentFertilizer.RateMetric = "Gal"; } else { treatmentFertilizer.RateMetric = "LB"; } _context.Add(treatmentFertilizer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["FertilizerName"] = new SelectList(_context.Fertilizer.OrderBy(f => f.FertilizerName), "FertilizerName", "FertilizerName", treatmentFertilizer.FertilizerName); ViewData["TreatmentId"] = HttpContext.Session.GetString("treatementIdSession"); return(View(treatmentFertilizer)); }