private void addPesticideJob()
{
PesticideJob pj = new PesticideJob();
pj.Description = textBox1.Text;
string idStr = cbPesticide.Text.Split('.')[0];
pj.Pesticide_id = int.Parse(idStr);
pj.Quantity_kg = int.Parse(textBox3.Text);
string idStr1 = cbSoj.Text.Split('.')[0];
pj.SowingJob_id = int.Parse(idStr1);
string idStr2 = cbFarm.Text.Split('.')[0];
pj.Farm_id = int.Parse(idStr2);
string idStr3 = cbVehicle.Text.Split('.')[0];
pj.Vehicle_id = int.Parse(idStr3);
string idStr4 = cbCrop.Text.Split('.')[0];
pj.Crop_id = int.Parse(idStr4);
string idStr5 = cbEmployee.Text.Split('.')[0];
pj.Employee_id = int.Parse(idStr5);
pj.Date_start = Convert.ToDateTime(dtpStart.Text);
pj.Date_end = Convert.ToDateTime(dtpEnd.Text);
InsertSQL add = new InsertSQL();
int addrecord = add.addNewPesticideJob(pj);
MessageBox.Show("Success!!");
this.Close();
}
