public async Task <IActionResult> Create([Bind("FarmId,VarietyId,DatePlanted,Cec,PlantingRateByPounds")] Plot plot)
{
// create if plot is valid
if (ModelState.IsValid)
{
_context.Add(plot);
await _context.SaveChangesAsync();
TempData["Message"] = "Yeeehaw, Plot Number " + plot.PlotId.ToString() + " " + plot.Farm + " has been added to records.";
return(RedirectToAction(nameof(Index)));
}
// otherwise return to view
int cropId;
int varietyId;
var variety = _context.Variety.AsQueryable();
if (HttpContext.Session.GetString(nameof(cropId)) != null)
{
cropId = Convert.ToInt32(HttpContext.Session.GetString(nameof(cropId)));
variety = variety.Where(a => a.CropId == cropId);
}
if (HttpContext.Session.GetString(nameof(varietyId)) != null)
{
varietyId = Convert.ToInt32(HttpContext.Session.GetString(nameof(varietyId)));
variety = variety.Where(a => a.VarietyId == varietyId);
}
ViewData["FarmId"] = new SelectList(_context.Farm.OrderBy(a => a.Name), "FarmId", "Name", plot.FarmId);
ViewData["VarietyId"] = new SelectList(variety.OrderBy(a => a.Name), "VarietyId", "Name", plot.VarietyId);
TempData["Message"] = "Awe Shoot, Plot Number " + plot.PlotId.ToString() + " didn't get added";
return(View(plot));
}
public async Task <IActionResult> Create([Bind("FarmId,Name,Address,Town,County,ProvinceCode,PostalCode,HomePhone,CellPhone,Email,Directions,DateJoined,LastContactDate")] Farm farm)
{
try
{
if (ModelState.IsValid)
{
//3d. if the insert works, place a msg in your temp data
_context.Add(farm);
await _context.SaveChangesAsync();
TempData["message"] = "Farm insert was successful";
return(RedirectToAction(nameof(Index)));
}
else
{
//3c.add modelstate error
ModelState.AddModelError("Name", "Name Error");
}
}
//3c
catch (Exception ex)
{
ModelState.AddModelError("", $"Error creating new item: {ex.GetBaseException().Message}");
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", farm.ProvinceCode);
return(View(farm));
}
public async Task <IActionResult> Create([Bind("FarmId,Name,Address,Town,County,ProvinceCode,PostalCode,HomePhone,CellPhone,Email,Directions,DateJoined,LastContactDate")] Farm farm)
{
try
{
if (ModelState.IsValid)
{
if (await TryUpdateModelAsync(farm))
{
_context.Add(farm);
await _context.SaveChangesAsync();
TempData["message"] = "Farm creation sucessfull";
return(RedirectToAction(nameof(Index)));
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("", $"error creating farm {ex.GetBaseException().Message}");
}
Create();
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", farm.ProvinceCode);
return(View(farm));
}
public async Task <IActionResult> Create([Bind("TreatmentId,Name,PlotId,Moisture,Yield,Weight")] Treatment treatment)
{
Treatment thisTreatment = treatment;
int PlotId = thisTreatment.PlotId;
//var FarmId = _context.Treatment
// .Include(t => t.Plot)
// .Where(t => t.Plot.PlotId == thisTreatment.PlotId)
// .Select(t => t.Plot.FarmId)
// .FirstOrDefault();
//var FarmName = _context.Treatment
// .Include(p => p.Plot.Farm)
// .Where(p => p.Plot.FarmId == FarmId)
// .Select(p => p.Plot.Farm.Name)
// .FirstOrDefault();
HttpContext.Session.SetInt32(nameof(PlotId), PlotId);
// HttpContext.Session.SetString(nameof(FarmName), FarmName);
ViewBag.FarmName = HttpContext.Session.GetString("FarmName");
if (ModelState.IsValid)
{
_context.Add(treatment);
TempData["Message"] = "Treatment for " + HttpContext.Session.GetString("FarmName") + " is created successfully";
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PlotId"] = new SelectList(_context.Plot, "PlotId", "PlotId", treatment.PlotId);
return(View(treatment));
}
public async Task <IActionResult> Create([Bind("TreatmentId,Name,PlotId,Moisture,Yield,Weight")] Treatment treatment)
{
try
{
if (ModelState.IsValid)
{
if (treatment.Name == "")
{
treatment.Name = "no fertilizer";
}
_context.Add(treatment);
await _context.SaveChangesAsync();
TempData["message"] = $"Treatment created: {treatment.Name}";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", $"Exception thrown on Create: {ex.GetBaseException().Message}");
}
Create();
return(View(treatment));
}
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)
{
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("FarmId,Name,Address,Town,County,ProvinceCode,PostalCode,HomePhone,CellPhone,Email,Directions,DateJoined,LastContactDate")] Farm farm)
{
try
{
if (ModelState.IsValid)
{
_context.Add(farm);
await _context.SaveChangesAsync();
TempData["message"] = $"Farm created: {farm.Name}";
return(RedirectToAction(nameof(Index)));
}
}
catch (Exception ex)
{
while (ex.InnerException != null)
{
ex = ex.InnerException;
}
ModelState.AddModelError("", $"Exception thrown on Create: {ex.Message}");
}
Create();
return(View(farm));
}
public async Task<IActionResult> Create([Bind("CountryCode,Name,PostalPattern,PhonePattern")] Country country)
{
if (ModelState.IsValid)
{
_context.Add(country);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(country);
}
public async Task<IActionResult> Create([Bind("CropId,Name,Image")] Crop crop)
{
if (ModelState.IsValid)
{
_context.Add(crop);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(crop);
}
public async Task <IActionResult> Create([Bind("ProvinceCode,Name,CountryCode,RetailTaxName,RetailTaxRate,FederalTaxIncluded")] Province province)
{
if (ModelState.IsValid)
{
_context.Add(province);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(province));
}
public async Task <IActionResult> Create([Bind("FertilizerName,Oecproduct,Liquid")] Fertilizer fertilizer)
{
if (ModelState.IsValid)
{
_context.Add(fertilizer);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(fertilizer));
}
public async Task <IActionResult> Create([Bind("CropId,Name")] Variety variety)
{
if (ModelState.IsValid)
{
_context.Add(variety);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
//ViewData["CropId"] = new SelectList(_context.Crop, "CropId", "CropId", variety.CropId);
return(View(variety));
}
public async Task <IActionResult> Create([Bind("TreatmentId,Name,PlotId,Moisture,Yield,Weight")] Treatment treatment)
{
if (ModelState.IsValid)
{
_context.Add(treatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PlotId"] = new SelectList(_context.Plot, "PlotId", "PlotId", treatment.PlotId);
return(View(treatment));
}
public async Task <IActionResult> Create([Bind("VarietyId,CropId,Name")] Variety variety)
{
if (ModelState.IsValid)
{
_context.Add(variety);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CropId"] = HttpContext.Session.GetString("cropidSession");
return(View(variety));
}
public async Task <IActionResult> Create([Bind("FarmId,Name,Address,Town,County,ProvinceCode,PostalCode,HomePhone,CellPhone,Email,Directions,DateJoined,LastContactDate")] Farm farm)
{
if (ModelState.IsValid)
{
_context.Add(farm);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ProvinceCode"] = new SelectList(_context.Province, "ProvinceCode", "ProvinceCode", farm.ProvinceCode);
return(View(farm));
}
public async Task <IActionResult> Create([Bind("ProvinceCode,Name,CountryCode")] Province province)
{
if (ModelState.IsValid)
{
_context.Add(province);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CountryCode"] = new SelectList(_context.Country, "CountryCode", "CountryCode", province.CountryCode);
return(View(province));
}
public async Task <IActionResult> Create([Bind("TreatmentId,Name,PlotId,Moisture,Yield,Weight")] Treatment treatment)
{
if (ModelState.IsValid)
{
_context.Add(treatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PlotId"] = HttpContext.Session.GetString("plotidSession");
return(View(treatment));
}
public async Task <IActionResult> Create([Bind("ProvinceCode,Name,CountryCode,RetailTaxName,RetailTaxRate,FederalTaxIncluded")] Province province)
{
if (ModelState.IsValid)
{
_context.Add(province);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["country"] = new SelectList(_context.Country.OrderBy(c => c.Name), "CountryCode", "Name", province.CountryCode);
return(View(province));
}
// make sure its not over posting
public async Task <IActionResult> Create([Bind("CropId,Name,Image")] Crop crop)
{
if (ModelState.IsValid)
{
_context.Add(crop);
await _context.SaveChangesAsync();
//this will take you back to the index if successful
return(RedirectToAction(nameof(Index)));
}
// if anything goes wrong just return the view with data you just entered
return(View(crop));
}
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> Create([Bind("PlotId,FarmId,VarietyId,DatePlanted,DateHarvested,PlantingRate,PlantingRateByPounds,RowWidth,PatternRepeats,OrganicMatter,BicarbP,Potassium,Magnesium,Calcium,PHsoil,PHbuffer,Cec,PercentBaseSaturationK,PercentBaseSaturationMg,PercentBaseSaturationCa,PercentBaseSaturationH,Comments")] Plot plot)
{
if (ModelState.IsValid)
{
_context.Add(plot);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["FarmId"] = new SelectList(_context.Farm, "FarmId", "ProvinceCode", plot.FarmId);
ViewData["VarietyId"] = new SelectList(_context.Variety, "VarietyId", "VarietyId", plot.VarietyId);
return(View(plot));
}
public async Task <IActionResult> Create([Bind("VarietyId,CropId,Name")] Variety variety)
{
if (ModelState.IsValid)
{
variety.CropId = Convert.ToInt32(Request.Cookies["cropId_Variety"]);
_context.Add(variety);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CropId"] = new SelectList(_context.Crop, "CropId", "CropId", variety.CropId);
return(View(variety));
}
public async Task <IActionResult> Create([Bind("PlotId,FarmId,VarietyId,DatePlanted,DateHarvested,PlantingRate,PlantingRateByPounds,RowWidth,PatternRepeats,OrganicMatter,BicarbP,Potassium,Magnesium,Calcium,PHsoil,PHbuffer,Cec,PercentBaseSaturationK,PercentBaseSaturationMg,PercentBaseSaturationCa,PercentBaseSaturationH,Comments")] Plot plot)
{
if (ModelState.IsValid)
{
if (HttpContext.Session.GetString(SessionKeySearchCriteria) != null)
{
var Id = Convert.ToInt32(HttpContext.Session.GetInt32(SessionKeyId));
var SearchCriteria = HttpContext.Session.GetString(SessionKeySearchCriteria);
switch (SearchCriteria)
{
case "farm":
break;
case "variety":
plot.Variety = _context.Variety
.FirstOrDefault(x => x.VarietyId == plot.VarietyId);
//_context.Variety.SingleOrDefault(x => x.VarietyId == plot.VarietyId);
break;
case "crop":
plot.Variety.Crop = _context.Crop
.Include(x => x.Variety)
.FirstOrDefault(x => x.CropId == plot.Variety.Crop.CropId);
break;
default:
break;
}
}
_context.Add(plot);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["FarmId"] = new SelectList(_context.Farm.OrderBy(x => x.Name), "FarmId", "Name");
ViewData["VarietyId"] = new SelectList(_context.Variety.OrderBy(x => x.Name), "VarietyId", "Name");
//ViewData["FarmId"] = new SelectList(_context.Farm, "FarmId", "ProvinceCode", plot.FarmId);
//ViewData["VarietyId"] = new SelectList(_context.Variety, "VarietyId", "VarietyId", plot.VarietyId);
return(View(plot));
}
public async Task <IActionResult> Create([Bind("VarietyId,CropId,Name")] Variety variety)
{
if (ModelState.IsValid)
{
_context.Add(variety);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CropId"] = new SelectList(_context.Crop, "CropId", "CropId", variety.CropId);
//add Name from session to ViewBag objects
ViewBag.Name = HttpContext.Session.GetString("SCropName");
return(View(variety));
}
public async Task <IActionResult> Create([Bind("VarietyId,CropId,Name")] Variety variety)
{
if (ModelState.IsValid)
{
_context.Add(variety);
await _context.SaveChangesAsync();
TempData["message"] = "New variety has been created";
return(RedirectToAction(nameof(Index)));
}
ViewData["CropId"] = new SelectList(_context.Crop, "CropId", "CropId", Convert.ToInt32(HttpContext.Session.GetString("cropId")));
return(View(variety));
}
public async Task <IActionResult> Create([Bind("TreatmentId,Name,PlotId,Moisture,Yield,Weight")] Treatment treatment)
{
if (ModelState.IsValid)
{
_context.Add(treatment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
int plotId = Convert.ToInt32(HttpContext.Session.GetString(nameof(plotId)));
string plotName = HttpContext.Session.GetString(nameof(plotName));
ViewData["FarmName"] = plotName;
ViewData["PlotId"] = plotId;
return(View(treatment));
}
public async Task <IActionResult> Create([Bind("ProvinceCode,Name,CountryCode")] Province province)
{
if (ModelState.IsValid)
{
province.CountryCode = _context.Country.SingleOrDefault(x => x.Name == province.CountryCode).CountryCode;
_context.Add(province);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
// ViewData["CountryCode"] = new SelectList(_context.Country, "CountryCode", "CountryCode", province.CountryCode);
string name = province.CountryCode = _context.Country.SingleOrDefault(p => p.CountryCode == province.CountryCode.ToString()).Name;
ViewData["CountryName"] = new SelectList(_context.Country.OrderBy(x => x.Name), "Name", "Name", name);
return(View(province));
}
public async Task <IActionResult> Create([Bind("VarietyId,CropId,Name")] Variety variety)
{
if (ModelState.IsValid)
{
dynamic cropid = HttpContext.Session.GetString("CropId");
variety.CropId = Convert.ToInt32(cropid);
_context.Add(variety);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
// ViewData["CropId"] = new SelectList(_context.Crop, "CropId", "CropId", variety.CropId);
ViewData["CropId"] = new SelectList(_context.Crop, "CropId", "CropId", variety.CropId);
// ViewBag.CropId = HttpContext.Session.GetString("CropId");
ViewBag.message = "Create " + HttpContext.Session.GetString("CropName");
return(View(variety));
}
public async Task <IActionResult> Create([Bind("FarmId,Name,Address,Town,County,ProvinceCode,PostalCode,HomePhone,CellPhone,Email,Directions,DateJoined,LastContactDate")] Farm farm)
{
if (ModelState.IsValid)
{
try
{
_context.Add(farm);
@TempData["SUCCESS"] = "Insert the data successfully !";
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
ModelState.AddModelError("", $"error inserting new order: {ex.GetBaseException().Message}");
}
}
return(View(farm));
}
