private void addStoringJob()
{
StoringJob sj = new StoringJob();
sj.Description = textBox1.Text;
string idStr = cbHarvest.Text.Split('.')[0];
sj.Harvest_id = int.Parse(idStr);
string idStr1 = cbCrop.Text.Split('.')[0];
sj.Crop_id = int.Parse(idStr1);
string idStr2 = cbBox.Text.Split('.')[0];
sj.Box_id = int.Parse(idStr2);
sj.Quantity = int.Parse(textBox5.Text);
string idStr3 = cbVehicle.Text.Split('.')[0];
sj.Vehicle_id = int.Parse(idStr3);
string idStr4 = cbEmployee.Text.Split('.')[0];
sj.Employee_id = int.Parse(idStr4);
sj.Date_start = Convert.ToDateTime(dtpStart.Text);
sj.Date_end = Convert.ToDateTime(dtpEnd.Text);
InsertSQL addHnd = new InsertSQL();
int addrecord = addHnd.addNewStoringJob(sj);
MessageBox.Show(addrecord + " Your record is added");
this.Close();
}
