public int updateTrtTask(MySqlConnection conn, Treating treating)
{
string taskTrtQuery = "UPDATE treatmentTask SET taskStatus = '" + treating.TaskStatus + "' WHERE labourerName = '" + treating.LabourerName + "'";
MySqlCommand sqlCmd = new MySqlCommand(taskTrtQuery, conn);
return(sqlCmd.ExecuteNonQuery());
}
//Treatment Task
public int addTreatingSchedule(MySqlConnection cn, Treating treating)
{
string treatmentQuery = "INSERT INTO treatmentTask (labourerName, farmSector, taskStatus, startDate, endDate, fertiliserUsed, quantity, startTime, endTime)"
+ "VALUES ('" + treating.LabourerName + "', " + treating.FarmSector + ", '" + treating.TaskStatus + "', '" + treating.StartDate.ToString("yyyy-MM-dd") + "', '" + treating.EndDate.ToString("yyyy-MM-dd") + "', '" +
treating.FertiliserUsed + "', '" + treating.Quantity + "', '" + treating.StartTime.ToString("HH:mm:ss") + "', '" +
treating.EndTime.ToString("HH:mm:ss") + "' )";
MySqlCommand sqlCmd = new MySqlCommand(treatmentQuery, cn);
return(sqlCmd.ExecuteNonQuery());
}
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 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!");
}
}
