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!"); } }