private void button_Click(object sender, RoutedEventArgs e) { Soil selectedSoil = soilComboBox.SelectedItem as Soil; Fertilizer selectedFertilizer = fertilizerComboBox.SelectedItem as Fertilizer; try { selectedFertilizer.Count = int.Parse(FertilizerCountText.Text); Models.Model.Condition condition = new Models.Model.Condition(); condition.MinTmp = double.Parse(plantMinTempText.Text); condition.MaxTmp = double.Parse(plantMaxTempText.Text); condition.MinHumidity = double.Parse(plantHumidityMinText.Text); condition.MaxHumidity = double.Parse(plantHumidityMaxText.Text); condition.phMin = double.Parse(plantPhminText.Text); condition.phMax = double.Parse(plantPhmaxText.Text); Plant plant = new Plant(); plant.Name = plantNameText.Text; plant.Price = double.Parse(plantPriceText.Text); if (selectedFertilizer != null || selectedSoil != null || condition.MinTmp < condition.MaxTmp || condition.MinHumidity < condition.MaxHumidity || condition.phMin < condition.phMax || plant.Price != 0 || !string.IsNullOrEmpty(plant.Name)) { MainWindow.channel.AddPlant(plant, condition, selectedSoil, selectedFertilizer); } MessageBox.Show(plantNameText.Text + " added!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task <IActionResult> Edit(string id, [Bind("FertilizerName,Oecproduct,Liquid")] Fertilizer fertilizer) { if (id != fertilizer.FertilizerName) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(fertilizer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FertilizerExists(fertilizer.FertilizerName)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(fertilizer)); }
public async Task <int> Add(Fertilizer fertilizer) { var cmd = QueriesCreatingHelper.CreateQueryInsert(fertilizer); cmd += ";SELECT LAST_INSERT_ID();"; return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First()); }
private void PopulateBox() { for (int i = 0; i < 4; i++) { Fertilizer fert = new Fertilizer(); Box[i] = fert; } }
private void mapItem(Fertilizer fertilizer, FertilizerViewModel input) { fertilizer.Description = input.Fertilizer.Description; fertilizer.K = input.Fertilizer.K; fertilizer.N = input.Fertilizer.N; fertilizer.Name = input.Fertilizer.Name; fertilizer.Notes = input.Fertilizer.Notes; fertilizer.P = input.Fertilizer.P; }
public void CanPlaceToStock() { var f = new Fertilizer(); var stock = new Stock(); stock.Items.Add(f); Assert.IsTrue(stock.Items.Contains(f)); }
public ActionResult AddOrEditFertilizer(AddOrEditFertilizer model, HttpPostedFileBase file) { SmartFarmingEntities db = new SmartFarmingEntities(); if (file != null) { var filename = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Images/"), filename); file.SaveAs(path); model.FertilizerImage = filename; } if (model.id != 0) { var fertilizerDetails = db.Fertilizers.Where(x => x.id == model.id).FirstOrDefault(); fertilizerDetails.crop_id = model.crop_id; fertilizerDetails.dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]); fertilizerDetails.FertilizerName = model.FertilizerName; fertilizerDetails.Material = model.Material; fertilizerDetails.FertilizerImage = model.FertilizerImage; fertilizerDetails.PackType = model.PackType; fertilizerDetails.PackSize = model.PackSize; fertilizerDetails.Features = model.Features; fertilizerDetails.Solubility = model.Solubility; fertilizerDetails.Doses = model.Doses; fertilizerDetails.PHvalue = model.PHvalue; fertilizerDetails.HowToUse = model.HowToUse; fertilizerDetails.Price = model.Price; db.SaveChanges(); } else { Fertilizer fertilizerDetails = new Fertilizer() { crop_id = model.crop_id, dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]), FertilizerName = model.FertilizerName, Material = model.Material, FertilizerImage = model.FertilizerImage, PackType = model.PackType, PackSize = model.PackSize, Features = model.Features, Solubility = model.Solubility, Doses = model.Doses, PHvalue = model.PHvalue, HowToUse = model.HowToUse, Price = model.Price }; db.Fertilizers.Add(fertilizerDetails); db.SaveChanges(); } return(RedirectToAction("ManageFertilizers")); }
public ActionResult Save(FertilizerViewModel input) { Fertilizer fertilizer = input.Fertilizer.EntityId > 0 ? _repository.Find <Fertilizer>(input.Fertilizer.EntityId) : new Fertilizer(); mapItem(fertilizer, input); var crudManager = _saveEntityService.ProcessSave(fertilizer); var notification = crudManager.Finish(); return(Json(notification, JsonRequestBehavior.AllowGet)); }
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 void UpdateFertilizer(Fertilizer fertilizer) { _context.Attach(fertilizer); _context.Entry(fertilizer).Property("Producer").IsModified = true; _context.Entry(fertilizer).Property("FertilizerComposition").IsModified = true; _context.Entry(fertilizer).Property("Concentration").IsModified = true; _context.Entry(fertilizer).Property("Capacity").IsModified = true; _context.Entry(fertilizer).Property("CurrentAmount").IsModified = true; _context.Entry(fertilizer).Property("Price").IsModified = true; _context.Entry(fertilizer).Property("AdditionalInformation").IsModified = true; }
private void PopulateBox() { for (int i = 0; i < 4; i++) { Fertilizer fert = new Fertilizer(); fert.Name = "Unknown"; fert.ID = 0; fert.Amount = 0; Box[i] = fert; } }
private void PopulateBox() { for (int i = 0; i < 4; i++) { Fertilizer fert = new Fertilizer { Name = "Unknown", ID = 0, Amount = 0 }; Box[i] = fert; } }
public async Task <IActionResult> Get(string fertilizerId) { try { var fertilizer = await _fertilizerService.GetAsync(fertilizerId); var dto = new Fertilizer(fertilizer); return(Ok(dto)); } catch (FertilizerNotFoundException) { return(NotFound()); } }
public ActionResult AddFertilizer(TankViewModel model) { if (ModelState.IsValid) { var fertilizer = new Fertilizer { Name = model.Fertilizer.Name, Amount = model.Fertilizer.Amount }; var operatorId = User.Identity.GetUserId(); var db = new WarehouseDbContext(); var operatorData = db.Users.Where(o => o.Id == operatorId).FirstOrDefault(); var tank = db.Tanks.Find(model.Id); try { tank.AddFertilizer(fertilizer, operatorData.FullName); db.SaveChanges(); return(RedirectToAction("All", "Tanks")); } catch (Exception ex) { ModelState.AddModelError("", $"{ex.Message}"); var tankOther = db.Tanks .Where(t => t.Id == model.Id) .Select(t => new TankViewModel { Number = t.Number, Name = t.Name, CurrentLoad = t.CurrentLoad, MaxCapacity = t.MaxCapacity, CapacityLeft = t.MaxCapacity - t.CurrentLoad, Fertilizer = new Fertilizer(), CurrentFertilizer = t.CurrentFertilizer }) .FirstOrDefault(); return(View(tankOther)); } } return(View(model)); }
public AppleTree CreateAppleTree(double appleYield, double waterConsumption, Fertilizer fertilizingAgent) { var f = new AppleTree(); f.AppleYield = appleYield; f.WaterConsumption = waterConsumption; f.FertilizingAgent = fertilizingAgent; //Add to Database db.AppleTrees.Add(f); //Save db.SaveChanges(); return(f); }
public List <Fertilizer> GetAllFertilizer() { List <Fertilizer> fertilizers = new List <Fertilizer>(); NpgsqlCommand cmd = new NpgsqlCommand("SELECT fertilizer_id, name from FERTILIZER", DBManager.con); using (NpgsqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Fertilizer fertilizer = new Fertilizer(); fertilizer.FertilizerId = reader.GetInt16(0); fertilizer.Name = reader.GetString(1); fertilizers.Add(fertilizer); } } return(fertilizers); }
private void button1_Click(object sender, RoutedEventArgs e) { //add fertilizer Fertilizer fertilizer = new Fertilizer(); try { fertilizer.Name = fetilizerNameText.Text; fertilizer.Count = int.Parse(fetilizerPriceText.Text); MainWindow.channel.AddFertilizer(fertilizer); MessageBox.Show(fetilizerNameText.Text + " added!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// POST api/<controller> public HttpResponseMessage Post([FromBody] Fertilizer fertilizer) { try { Context.Fertilizers.Add(new Fertilizer() { Name = fertilizer.Name, Description = fertilizer.Description }); Context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, true)); } catch (Exception ex) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ExceptionMessageHelper.GetErrorMessage(ex))); } }
// PUT api/<controller>/5 public HttpResponseMessage Put(int id, [FromBody] Fertilizer fertilizer) { try { var existingRecord = Context.Fertilizers.FirstOrDefault(f => f.Id == id); if (existingRecord != null) { existingRecord.Name = fertilizer.Name; existingRecord.Description = fertilizer.Description; Context.Fertilizers.AddOrUpdate(existingRecord); Context.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, true)); } catch (Exception ex) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, ExceptionMessageHelper.GetErrorMessage(ex))); } }
private void InitialiteConsumables() { AnimalFood animalFood = new AnimalFood(); AnimalWater animalWater = new AnimalWater(); Fertilizer fertilizer = new Fertilizer(); Fungicide fungicide = new Fungicide(50); Herbicide herbicide = new Herbicide(50); Irrigation irrigation = new Irrigation(); Pesticide pesticide = new Pesticide(50); Vaccine vaccine = new Vaccine(50); market.AddConsumable(animalFood); market.AddConsumable(animalWater); market.AddConsumable(fertilizer); market.AddConsumable(fungicide); market.AddConsumable(herbicide); market.AddConsumable(irrigation); market.AddConsumable(pesticide); market.AddConsumable(vaccine); }
public List <Fertilizer> GetFertilizersByPlantId(int plantId) { List <Fertilizer> fertilizers = new List <Fertilizer>(); NpgsqlCommand cmd = new NpgsqlCommand(@"SELECT f.fertilizer_id, f.name, cf.count from FERTILIZER f inner join condition_fertilizer cf on f.fertilizer_id=cf.fertilizer_id inner join condition c on cf.condition_id=c.condition_id inner join plant p on p.condition_id=c.condition_id where p.plant_id=" + plantId + ";", DBManager.con); using (NpgsqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Fertilizer fertilizer = new Fertilizer(); fertilizer.FertilizerId = reader.GetInt16(0); fertilizer.Name = reader.GetString(1); fertilizer.Count = reader.GetInt16(2); fertilizers.Add(fertilizer); } } return(fertilizers); }
private void CreateFertilizer() { _fertilizer1 = new Fertilizer { Name = "cow poop", N = 10, P = 10, K = 10 }; _fertilizer2 = new Fertilizer { Name = "Chicken poop", N = 10, P = 10, K = 10 }; _repository.Save(_fertilizer1); _repository.Save(_fertilizer2); }
public int AddFertilizer(Fertilizer fertilizer) { NpgsqlCommand cmd = new NpgsqlCommand( string.Format("INSERT INTO FERTILIZER(name)" + " VALUES('" + fertilizer.Name + "') RETURNING fertilizer_id;"), DBManager.con); int fertilizerId = 0; using (NpgsqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { fertilizerId = reader.GetInt32(0); } } cmd.ExecuteNonQuery(); cmd.Dispose(); return(fertilizerId); }
private Task <CalcFertilizerViewModel> GetFertilizerAsync(string fldName) { string fertilizerName = string.Empty; CalcFertilizerViewModel fvm = new CalcFertilizerViewModel(); fvm.fldFertilizers = new List <DisplayNutrientFertilizer>(); List <NutrientFertilizer> fldFertilizers = _ud.GetFieldNutrientsFertilizers(fldName); foreach (var f in fldFertilizers) { DisplayNutrientFertilizer dm = new DisplayNutrientFertilizer(); FertilizerType ft = _sd.GetFertilizerType(f.fertilizerTypeId.ToString()); if (ft.Custom) { fertilizerName = ft.DryLiquid == "dry" ? "Custom (Dry) " : "Custom (Liquid) "; fertilizerName = fertilizerName + f.customN.ToString() + "-" + f.customP2o5.ToString() + "-" + f.customK2o.ToString(); } else { Fertilizer ff = _sd.GetFertilizer(f.fertilizerId.ToString()); fertilizerName = ff.Name; } dm.fldName = fldName; dm.fertilizerId = f.id; dm.fertilizerName = fertilizerName; dm.valN = f.fertN.ToString("G29"); dm.valP = f.fertP2o5.ToString("G29"); dm.valK = f.fertK2o.ToString("G29"); fvm.fldFertilizers.Add(dm); } return(Task.FromResult(fvm)); }
public async Task <IActionResult> Create(FertilizerViewModel model) { if (!ModelState.IsValid) { return(View(model)); } var fertilizer = new Fertilizer { Id = model.Id, Name = model.Name, N = model.N, P = model.P, K = model.K, Ca = model.Ca, Mg = model.Mg, S = model.S, Na = model.Na, }; await _fertilizerRepository.Add(fertilizer); TempData["message"] = "Dodano nowy nawóz!"; ModelState.Clear(); return(View()); }
// This processing detemines the N P K values in lb per acre for the fertilizer select and appricatio rate/density etc. public FertilizerNutrients GetFertilizerNutrients(int FertilizerId, string fertilizerType, decimal applicationRate, int applicationRateUnits, decimal density, int densityUnits, decimal userN, decimal userP2o5, decimal userK2o, bool customFertilizer) { var fn = new FertilizerNutrients(); // get the fertilizer N P K % values from fertlizer look up // for dry fertilizers // N (lb/ac) = Application rate converted to lb/ac * N % // P and K same as above // for wet fertilizers // N (lb/ac) = Application rate converted to lb/ac * N% * Density converted to lb / imp gallons // decimal applicationRateConversion = 0; decimal densityInSelectedUnit = 0; decimal densityUnitConversion = 0; Fertilizer _fertilizer = _sd.GetFertilizer(FertilizerId.ToString()); if (customFertilizer && fertilizerType == "dry" || !customFertilizer && _fertilizer.DryLiquid == "dry") { densityUnitConversion = 1; switch (applicationRateUnits) { case 1: // application rate in lb/ac no conversion required applicationRateConversion = 1; break; case 2: // application rate in kg/ha, convert to lb/ac ConversionFactor _cf = _sd.GetConversionFactor(); applicationRateConversion = _cf.KilogramPerHectareToPoundPerAcreConversion; break; case 7: // application rate in lb/100 ft squared, convert to lb/ac ConversionFactor _cf1 = _sd.GetConversionFactor(); applicationRateConversion = _cf1.PoundPer1000FtSquaredToPoundPerAcreConversion; break; } } else //use liquid fertilizer { FertilizerUnit _fU = _sd.GetFertilizerUnit(applicationRateUnits); applicationRateConversion = _fU.ConversionToImperialGallonsPerAcre; if (customFertilizer) { densityInSelectedUnit = density; } else { LiquidFertilizerDensity _lfd = _sd.GetLiquidFertilizerDensity(FertilizerId, densityUnits); densityInSelectedUnit = _lfd.Value; } DensityUnit _du = _sd.GetDensityUnit(densityUnits); densityUnitConversion = _du.ConvFactor * densityInSelectedUnit; } fn.fertilizer_N = applicationRate * decimal.Divide(userN, 100) * applicationRateConversion * densityUnitConversion; fn.fertilizer_P2O5 = applicationRate * decimal.Divide(userP2o5, 100) * applicationRateConversion * densityUnitConversion; fn.fertilizer_K2O = applicationRate * decimal.Divide(userK2o, 100) * applicationRateConversion * densityUnitConversion; return(fn); }
private void AddWaterOrFood() { int selectedTerrainIndex = map.getTerrainIndex(player.Terrains, true); if (selectedTerrainIndex == -1) { Console.WriteLine("Opción no valida..."); } else { Terrain selectedTerrain = map.Terrains[selectedTerrainIndex]; int playerTerrainIndex = player.Terrains.IndexOf(selectedTerrain); Terrain terrain = player.Terrains[playerTerrainIndex]; if (!terrain.HasBuilding()) { Console.WriteLine("No tienes un edificio en este terreno..."); } else { Building terrainBuilding = terrain.Building; if (terrainBuilding.GetType() == typeof(Plantation)) { Plantation plantationBuilding = terrainBuilding as Plantation; List <Consumable> availableConsumables = new List <Consumable>(); bool hasAvailableConsumables = false; while (!hasAvailableConsumables) { availableConsumables = player.GetAvailableConsumables(new List <string> { "Irrigation", "Fertilizer" }); string option = CheckIfCanAddConsumableToTerrain(availableConsumables); if (option == "out") { return; } else if (option == "continue") { hasAvailableConsumables = true; } } Console.WriteLine("Elige uno de los productos disponibles:"); for (int i = 0; i < availableConsumables.Count; i++) { Console.WriteLine($"({i + 1}) - {availableConsumables[i].Name}"); } int userOption = Int32.Parse(Console.ReadLine()); if (userOption < 1 || userOption > availableConsumables.Count) { Console.WriteLine("Opción no valida..."); return; } Consumable selectedConsumable = availableConsumables[userOption - 1]; if (selectedConsumable.GetType() == typeof(Irrigation)) { Irrigation irrigationConsumable = selectedConsumable as Irrigation; plantationBuilding.Water += irrigationConsumable.QuantityAdded; Console.WriteLine($"Se agrego riego correctamente. Nuevo nivel de agua: {plantationBuilding.Water}"); } else if (selectedConsumable.GetType() == typeof(Fertilizer)) { Fertilizer fertilizerConsumable = selectedConsumable as Fertilizer; plantationBuilding.Nutrients += fertilizerConsumable.QuantityAdded; Console.WriteLine($"Se agrego fertilizante correctamente. Nuevo nivel de nutrientes: {plantationBuilding.Nutrients}"); } else { return; } int indexOfConsumable = player.consumables.IndexOf(selectedConsumable); player.consumables.RemoveAt(indexOfConsumable); } else if (terrainBuilding.GetType() == typeof(Livestock)) { Livestock liveStockBuilding = terrainBuilding as Livestock; List <Consumable> availableConsumables = new List <Consumable>(); bool hasAvailableConsumables = false; while (!hasAvailableConsumables) { availableConsumables = player.GetAvailableConsumables(new List <string> { "AnimalFood", "AnimalWater" }); string option = CheckIfCanAddConsumableToTerrain(availableConsumables); if (option == "out") { return; } else if (option == "continue") { hasAvailableConsumables = true; } } Console.WriteLine("Elige uno de los productos disponibles:"); for (int i = 0; i < availableConsumables.Count; i++) { Console.WriteLine($"({i + 1}) - {availableConsumables[i].Name}"); } int userOption = Int32.Parse(Console.ReadLine()); if (userOption < 1 || userOption > availableConsumables.Count) { Console.WriteLine("Opción no valida..."); return; } Consumable selectedConsumable = availableConsumables[userOption - 1]; if (selectedConsumable.GetType() == typeof(AnimalWater)) { AnimalWater animalWaterConsumable = selectedConsumable as AnimalWater; liveStockBuilding.Water += animalWaterConsumable.QuantityAdded; Console.WriteLine($"Se agrego agua correctamente. Nuevo nivel de agua: {liveStockBuilding.Water}"); } else if (selectedConsumable.GetType() == typeof(AnimalFood)) { AnimalFood animalFoodConsumable = selectedConsumable as AnimalFood; liveStockBuilding.Food += animalFoodConsumable.QuantityAdded; Console.WriteLine($"Se agrego comida correctamente. Nuevo nivel de nutrientes: {liveStockBuilding.Food}"); } else { return; } int indexOfConsumable = player.consumables.IndexOf(selectedConsumable); player.consumables.RemoveAt(indexOfConsumable); } else { return; } } } }
public int AddFertilizer(Fertilizer fertilizer) { _context.Fertilizers.Add(fertilizer); _context.SaveChanges(); return(fertilizer.Id); }
public FertilizerViewModel() { var DB = new Fertilizer(); Fdetail = DB.GetFart(); }
// This processing detemines the N P K values in lb per acre for the fertilizer select and appricatio rate/density etc. public FertilizerNutrients GetFertilizerNutrients() { FertilizerNutrients fn = new FertilizerNutrients(); // get the fertilizer N P K % values from fertlizer look up // for dry fertilizers // N (lb/ac) = Application rate converted to lb/ac * N % // P and K same as above // for wet fertilizers // N (lb/ac) = Application rate converted to lb/ac * N% * Density converted to lb / imp gallons // decimal applicationRateConversion = 0; decimal densityInSelectedUnit = 0; decimal densityUnitConversion = 0; Fertilizer _fertilizer = _sd.GetFertilizer(FertilizerId.ToString()); if ((CustomFertilizer && FertilizerType == "dry") || (!CustomFertilizer && _fertilizer.dry_liquid == "dry")) { densityUnitConversion = 1; switch (ApplicationRateUnits) { case 1: // application rate in lb/ac no conversion required applicationRateConversion = 1; break; case 2: // application rate in kg/ha, convert to lb/ac ConversionFactor _cf = _sd.GetConversionFactor(); applicationRateConversion = _cf.kgperha_lbperac_conversion; break; case 7: // application rate in lb/100 ft squared, convert to lb/ac ConversionFactor _cf1 = _sd.GetConversionFactor(); applicationRateConversion = _cf1.lbper1000ftsquared_lbperac_conversion; break; } } else //use liquid fertilizer { FertilizerUnit _fU = _sd.GetFertilizerUnit(ApplicationRateUnits); applicationRateConversion = _fU.conv_to_impgalperac; if (CustomFertilizer) { densityInSelectedUnit = Density; } else { LiquidFertilizerDensity _lfd = _sd.GetLiquidFertilizerDensity(FertilizerId, DensityUnits); densityInSelectedUnit = _lfd.value; } DensityUnit _du = _sd.GetDensityUnit(DensityUnits); densityUnitConversion = _du.convfactor * densityInSelectedUnit; } fn.fertilizer_N = ApplicationRate * decimal.Divide(userN, 100) * applicationRateConversion * densityUnitConversion; fn.fertilizer_P2O5 = ApplicationRate * decimal.Divide(userP2o5, 100) * applicationRateConversion * densityUnitConversion; fn.fertilizer_K2O = ApplicationRate * decimal.Divide(userK2o, 100) * applicationRateConversion * densityUnitConversion; return(fn); }