public Pesticide Put <V>(Pesticide obj) where V : AbstractValidator <Pesticide>
{
Validate(obj, Activator.CreateInstance <V>());
repository.Update(obj);
return(obj);
}
public async Task <int> Add(Pesticide pesticide)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(pesticide);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public static List <string> getPesticideList()
{
Pesticide pesticide = new Pesticide();
List <string> flist = new List <string>();
MySqlDataReader rdr = null;
try
{
string tableName = "pesticide";
string query = "SELECT * FROM " + tableName;
MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn());
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
pesticide.Name = rdr.GetString("name");
flist.Add(pesticide.Name);
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(flist);
}
private void Validate(Pesticide obj, AbstractValidator <Pesticide> validator)
{
if (obj == null)
{
throw new Exception("Registros não detectados!");
}
validator.ValidateAndThrow(obj);
}
public ActionResult AddOrEditPesticide(AddOrEditPesticide 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.PesticideImage = filename;
}
if (model.id != 0)
{
var pesticideDetails = db.Pesticides.Where(x => x.id == model.id).FirstOrDefault();
pesticideDetails.crop_id = model.crop_id;
pesticideDetails.dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]);
pesticideDetails.PesticideName = model.PesticideName;
pesticideDetails.Category = model.Category;
pesticideDetails.PesticideImage = model.PesticideImage;
pesticideDetails.State = model.State;
pesticideDetails.PackingType = model.PackingType;
pesticideDetails.Dosage = model.Dosage;
pesticideDetails.Formulation = model.Formulation;
pesticideDetails.PesticideDescription = model.PesticideDescription;
pesticideDetails.Price = model.Price;
db.SaveChanges();
}
else
{
Pesticide pesticideDetails = new Pesticide()
{
crop_id = model.crop_id,
dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]),
PesticideName = model.PesticideName,
Category = model.Category,
PesticideImage = model.PesticideImage,
State = model.State,
PackingType = model.PackingType,
Dosage = model.Dosage,
Formulation = model.Formulation,
PesticideDescription = model.PesticideDescription,
Price = model.Price
};
db.Pesticides.Add(pesticideDetails);
db.SaveChanges();
}
return(RedirectToAction("ManagePesticides"));
}
private void addPesticide()
{
Pesticide p1 = new Pesticide();
p1.Name = textBox1.Text;
p1.Quantity_kg = Int32.Parse(textBox2.Text);
p1.Remark = textBox3.Text;
InsertSQL add = new InsertSQL();
int changerecord = add.addNewPesticide(p1);
MessageBox.Show(changerecord + " Your record is added");
}
public void UpdatePesticide()
{
Pesticide p1 = new Pesticide();
p1.Id = p11.Id;
p1.Name = textBox1.Text;
p1.Quantity_kg = Int32.Parse(textBox2.Text);
p1.Remark = textBox3.Text;
UpdateSQL ord = new UpdateSQL();
int changerecord = ord.updatePesticide(p1);
MessageBox.Show("Successful!");
}
public void UpdatePesticide(Pesticide pesticide)
{
_context.Attach(pesticide);
_context.Entry(pesticide).Property("Producer").IsModified = true;
_context.Entry(pesticide).Property("Name").IsModified = true;
_context.Entry(pesticide).Property("PesticideComposition").IsModified = true;
_context.Entry(pesticide).Property("Capacity").IsModified = true;
_context.Entry(pesticide).Property("CurrentAmount").IsModified = true;
_context.Entry(pesticide).Property("Price").IsModified = true;
_context.Entry(pesticide).Property("AdditionalInformation").IsModified = true;
_context.Entry(pesticide).Property("TypePesticideId").IsModified = true;
_context.Entry(pesticide).Property("WarehouseId").IsModified = true;
_context.SaveChanges();
}
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 Pesticide Post <V>(PesticidePostCommand obj) where V : AbstractValidator <Pesticide>
{
Pesticide o = new Pesticide()
{
Id = Guid.NewGuid(),
ActivePrinciple = obj.ActivePrinciple,
CommercialName = obj.CommercialName,
Date = obj.Date,
DoseL = obj.DoseL,
Hour = obj.Hour,
Lack = obj.Lack,
Lot = obj.Lot,
Sytem = obj.System,
PesticideType = obj.PesticideType
};
Validate(o, Activator.CreateInstance <V>());
repository.Insert(o);
return(o);
}
public Pesticide GetPesticideFromID(int itemId)
{
Pesticide p1 = new Pesticide();
MySqlDataReader rdr = null;
try
{
string tableName = "pesticide";
string query = "SELECT * FROM " + tableName + " WHERE id = " + itemId;
MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn());
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
p1.Id = itemId;
p1.Name = rdr.GetString("name");
p1.Quantity_kg = rdr.GetInt32("quantity_kg");
p1.Remark = rdr.GetString("remark");
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(p1);
}
public void Put(int id, [FromBody] Pesticide value)
{
var pesticide = service.Put <PesticideValidator>(value);
}
public int AddPesticide(Pesticide pesticide)
{
_context.Pesticides.Add(pesticide);
_context.SaveChanges();
return(pesticide.Id);
}
public UpdateCommand(Pesticide pesticide)
{
Pesticide = pesticide;
}
public async Task CreateAsync(Pesticide pesticide)
{
await _repository.AddAsync(pesticide);
}
public async Task <int> Update(Pesticide pesticide)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(pesticide);
return(await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection));
}
public void ApplyCure()
{
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> {
"Herbicide", "Pesticide", "Fungicide"
});
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(Herbicide))
{
Herbicide herbicideConsumable = selectedConsumable as Herbicide;
if (herbicideConsumable.CheckSuccess())
{
plantationBuilding.HasUndergrowth = false;
Console.WriteLine($"Herbicida funciono.");
}
else
{
Console.WriteLine($"Herbicida no funciono.");
}
}
else if (selectedConsumable.GetType() == typeof(Pesticide))
{
Pesticide pesticideConsumable = selectedConsumable as Pesticide;
if (pesticideConsumable.CheckSuccess())
{
plantationBuilding.HasWorms = false;
Console.WriteLine($"Pesticida funciono.");
}
else
{
Console.WriteLine($"Pesticida no funciono.");
}
}
else if (selectedConsumable.GetType() == typeof(Fungicide))
{
Fungicide fungicideConsumable = selectedConsumable as Fungicide;
if (fungicideConsumable.CheckSuccess())
{
plantationBuilding.Sick = false;
Console.WriteLine($"Fungicida funciono.");
}
else
{
Console.WriteLine($"Fungicida no funciono.");
}
}
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> {
"Vaccine"
});
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(Vaccine))
{
Vaccine vaccineConsumable = selectedConsumable as Vaccine;
if (vaccineConsumable.CheckSuccess())
{
liveStockBuilding.Sick = false;
Console.WriteLine($"Vacuna funciono.");
}
else
{
Console.WriteLine($"Vacuna no funciono.");
}
}
else
{
return;
}
int indexOfConsumable = player.consumables.IndexOf(selectedConsumable);
player.consumables.RemoveAt(indexOfConsumable);
}
else
{
return;
}
}
}
}
public async Task UpdateAsync(Pesticide pesticide)
{
await _repository.UpdateAsync(pesticide);
}
public AddCommand(Pesticide pesticide)
{
Pesticide = pesticide;
}
