private void addHarvestingJob()
        {
            HarvestingJob hj = new HarvestingJob();

            hj.Description  = textBox1.Text;
            hj.SowingJob_id = Convert.ToInt32(cbSoj.Text);
            string idStr = cbFarm.Text.Split('.')[0];

            hj.Farm_id = int.Parse(idStr);
            string idStr1 = cbCrop.Text.Split('.')[0];

            hj.Crop_id = int.Parse(idStr1);
            string idStr2 = cbVehicle.Text.Split('.')[0];

            hj.Vehicle_id         = int.Parse(idStr2);
            hj.Est_quantity       = int.Parse(numericUpDown1.Text);
            hj.Harvested_quantity = int.Parse(numericUpDown2.Text);
            string idStr3 = cbEmployee.Text.Split('.')[0];

            hj.Employee_id = int.Parse(idStr3);
            hj.Date_start  = Convert.ToDateTime(dtpStart1.Value);
            hj.Date_end    = Convert.ToDateTime(dtpEnd.Value);

            InsertSQL hdl = new InsertSQL();

            hdl.addNewHarvestingJob(hj);
            MessageBox.Show("Success!!");
            this.Close();
        }