private void updateFertiliser()
{
FertilisingJob fj = new FertilisingJob();
fj.Id = fb11.Id;
fj.Description = textBox1.Text;
string idStr = cbFertiliser.Text.Split('.')[0];
fj.Fertiliser_id = int.Parse(idStr);
fj.Quantity_kg = int.Parse(textBox3.Text);
string idStr1 = cbSoj.Text.Split('.')[0];
fj.SowingJob_id = int.Parse(idStr1);
string idStr2 = cbFarm.Text.Split('.')[0];
fj.Farm_id = int.Parse(idStr2);
string idStr3 = cbVehicle.Text.Split('.')[0];
fj.Vehicle_id = int.Parse(idStr3);
string idStr4 = cbCrop.Text.Split('.')[0];
fj.Crop_id = int.Parse(idStr4);
string idStr5 = cbEmployee.Text.Split('.')[0];
fj.Employee_id = int.Parse(idStr5);
fj.Date_start = this.dtpStart.Value;
fj.Date_end = this.dtpEnd.Value;
UpdateSQL edit = new UpdateSQL();
int editrecord = edit.updateFertilisingJob(fj);
MessageBox.Show("Success!!");
this.Close();
}
public static List <string> getFertilisingList()
{
FertilisingJob fertilising = new FertilisingJob();
List <string> flist = new List <string>();
MySqlDataReader rdr = null;
try
{
string tableName = "fertilisingjob";
string query = "SELECT * FROM " + tableName;
MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn());
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
fertilising.Description = rdr.GetString("description");
flist.Add(fertilising.Description);
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(flist);
}
public FertilisingJob GetFertilisingJobFromID(int itemId)
{
FertilisingJob fer = new FertilisingJob();
MySqlDataReader rdr = null;
try
{
string tableName = "fertilisingjob";
string query = "SELECT * FROM " + tableName + " WHERE id = " + itemId;
MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn());
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
fer.Id = itemId;
fer.Description = rdr.GetString("description");
fer.Fertiliser_id = rdr.GetInt32("fertiliser_id");
fer.Quantity_kg = rdr.GetInt32("quantity_kg");
fer.SowingJob_id = rdr.GetInt32("sowingJob_id");
fer.Crop_id = rdr.GetInt32("farm_id");
fer.Vehicle_id = rdr.GetInt32("vehicle_id");
fer.Employee_id = rdr.GetInt32("employee_id");
fer.Date_start = rdr.GetDateTime("date_start");
fer.Date_end = rdr.GetDateTime("date_end");
}
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(fer);
}
