private void btnSaveDrive_Click(object sender, EventArgs e)
{
dbconn.connect();
MySqlCommand labourerValidation = new MySqlCommand("SELECT labourerName = @user FROM drivingTask WHERE (startDate >= @startDate AND endDate <= @endDate)", dbconn.getConn());
labourerValidation.Parameters.AddWithValue("@user", comboBoxDriver.Text);
labourerValidation.Parameters.AddWithValue("@startDate", dateTimePickerDvStartDate.Value.Date);
labourerValidation.Parameters.AddWithValue("@endDate", dateTimePickerDvEndDate.Value.Date);
MySqlDataReader reader = labourerValidation.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("Labourer is already assigned to a task!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
reader.Close();
}
else
{
dbconn.connect();
Driving drv = new Driving();
drv.LabourerName = comboBoxDriver.Text;
drv.FarmSector = int.Parse(comboBoxFarmD.Text);
drv.TaskStatus = comBoxSowTaskStatus.Text;
drv.StartDate = dateTimePickerDvStartDate.Value.Date;
drv.EndDate = dateTimePickerDvEndDate.Value.Date;
drv.VehicleUsed = comboBoxVehicles.Text;
ScheduleHandler scHand = new ScheduleHandler();
scHand.addDrivingSchedule(dbconn.getConn(), drv);
MessageBox.Show("Task Assigned!");
}
}
private void btnHarvUpd_Click(object sender, EventArgs e)
{
dbcon.connect();
Harvest harv = new Harvest();
harv.LabourerName = txtBoxHarvLabr.Text;
harv.TaskStatus = comBoxUpdHarvTask.Text;
ScheduleHandler scHand = new ScheduleHandler();
scHand.updateHarvTask(dbcon.getConn(), harv);
MessageBox.Show("Task Updated!");
}
private void btnUpdTreat_Click(object sender, EventArgs e)
{
dbcon.connect();
Treating trt = new Treating();
trt.LabourerName = txtBoxTrtLabr.Text;
trt.TaskStatus = comBoxUpdTrtTask.Text;
ScheduleHandler scHand = new ScheduleHandler();
scHand.updateTrtTask(dbcon.getConn(), trt);
MessageBox.Show("Task Updated!");
}
private void btnUpdDrv_Click(object sender, EventArgs e)
{
dbcon.connect();
Driving drv = new Driving();
drv.LabourerName = txtBoxDrv.Text;
drv.TaskStatus = comBoxUpdDrvTask.Text;
ScheduleHandler scHand = new ScheduleHandler();
scHand.updateDrvTask(dbcon.getConn(), drv);
MessageBox.Show("Task Updated!");
}
private void btnSowUpd_Click(object sender, EventArgs e)
{
dbcon.connect();
Sowing sow = new Sowing();
sow.LabourerName = txtBoxSowLabr.Text;
sow.TaskStatus = comBoxUpdSowTask.Text;
ScheduleHandler scHand = new ScheduleHandler();
scHand.updateSowTask(dbcon.getConn(), sow);
MessageBox.Show("Task Updated!");
}
//Buttons to save data into the database
private void btnSaveSow_Click(object sender, EventArgs e)
{
try
{
dbconn.connect();
string checkQuery = "SELECT labourerName = @user FROM sowingTask WHERE (startDate >= @startDate AND endDate <= @endDate)";
using (MySqlCommand labourerValidation = new MySqlCommand(checkQuery, dbconn.getConn()))
{
labourerValidation.Parameters.AddWithValue("@user", comboBoxWorkers.Text);
labourerValidation.Parameters.AddWithValue("@startDate", dateTimePickerSowStartDate.Value.Date);
labourerValidation.Parameters.AddWithValue("@endDate", dateTimePickerSowEndDate.Value.Date);
using (MySqlDataReader reader = labourerValidation.ExecuteReader())
{
if (reader.HasRows)
{
MessageBox.Show("Labourer is already assigned to a task!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
reader.Close();
}
else
{
dbconn.connect();
Sowing sow = new Sowing();
sow.LabourerName = comboBoxWorkers.Text;
sow.FarmSector = int.Parse(comboBoxFarmSectorSow.Text);
sow.TaskStatus = comBoxSowTaskStatus.Text;
sow.StartDate = dateTimePickerDvStartDate.Value.Date;
sow.EndDate = dateTimePickerDvEndDate.Value.Date;
sow.Method = comboBoxMethods.Text;
sow.Seed = comboBoxSeeds.Text;
sow.Quantity = numericUpDownQauntity.Value;
sow.StartTime = dateTimePickerStartSow.Value;
sow.EndTime = dateTimePickerEndSow.Value;
ScheduleHandler scHand = new ScheduleHandler();
scHand.addSowingSchedule(dbconn.getConn(), sow);
MessageBox.Show("Task Assigned!");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSaveT_Click(object sender, EventArgs e)
{
dbconn.connect();
MySqlCommand labourerValidation = new MySqlCommand("SELECT labourerName = @user FROM treatmentTask WHERE (startDate >= @startDate AND endDate <= @endDate)", dbconn.getConn());
labourerValidation.Parameters.AddWithValue("@user", comboBoxWorkerT.Text);
labourerValidation.Parameters.AddWithValue("@startDate", dateTimePickerStartT.Value.Date);
labourerValidation.Parameters.AddWithValue("@endDate", dateTimePickerEndT.Value.Date);
MySqlDataReader reader = labourerValidation.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("Labourer is already assigned to a task!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
reader.Close();
}
else
{
dbconn.connect();
Treating trt = new Treating();
trt.LabourerName = comboBoxWorkerT.Text;
trt.FarmSector = int.Parse(comboBoxFarmT.Text);
trt.TaskStatus = comBoxTrTaskStatus.Text;
trt.StartDate = dateTimePickerStartT.Value.Date;
trt.EndDate = dateTimePickerEndT.Value.Date;
trt.FertiliserUsed = comboBoxFertilisers.Text;
trt.Quantity = numericUpDownFertilisers.Value;
trt.StartTime = dateTimePickerStartTr.Value;
trt.EndTime = dateTimePickerEndTr.Value;
ScheduleHandler scHand = new ScheduleHandler();
scHand.addTreatingSchedule(dbconn.getConn(), trt);
MessageBox.Show("Task Assigned!");
}
}
private void btnSaveHarv_Click(object sender, EventArgs e)
{
dbconn.connect();
MySqlCommand labourerValidation = new MySqlCommand("SELECT labourerName = @user FROM harvestTask WHERE (startDate >= @startDate AND endDate <= @endDate)", dbconn.getConn());
labourerValidation.Parameters.AddWithValue("@user", comboBoxWorkerHarv.Text);
labourerValidation.Parameters.AddWithValue("@startDate", dateTimePickerHrStartDate.Value.Date);
labourerValidation.Parameters.AddWithValue("@endDate", dateTimePickerHrvEndDate.Value.Date);
MySqlDataReader reader = labourerValidation.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("Labourer is already assigned to a task!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
reader.Close();
}
else
{
dbconn.connect();
Harvest harv = new Harvest();
harv.LabourerName = comboBoxWorkerHarv.Text;
harv.FarmSector = int.Parse(comboBoxFarmSectorHarv.Text);
harv.TaskStatus = comBoxHvTaskStatus.Text;
harv.StartDate = dateTimePickerHrStartDate.Value.Date;
harv.EndDate = dateTimePickerHrvEndDate.Value.Date;
harv.Method = comboBoxHarvestMehtod.Text;
harv.Machine = comboBoxPlantType.Text;
harv.StorageUnit = comboBoxStorageUnit.Text;
harv.StartTime = dateTimePickerStartHarv.Value;
harv.EndTime = dateTimePickerEndHarv.Value;
ScheduleHandler scHand = new ScheduleHandler();
scHand.addHarvestSchedule(dbconn.getConn(), harv);
MessageBox.Show("Task Assigned!");
}
}
