예제 #1
0
        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));
        }
예제 #2
0
        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));
        }
예제 #3
0
        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));
        }
예제 #7
0
        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));
        }
예제 #8
0
        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));
        }
예제 #9
0
        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));
        }
예제 #11
0
        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));
        }
예제 #13
0
        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));
        }