private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { //get standard hours for that day getStandardHours(_staff_id, Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells[5].Value)); if (e.ColumnIndex == dataGridView1.Columns["Full"].Index) { //6.40 hours - full Day dataGridView1.Rows[e.RowIndex].Cells[7].Value = _standardHours; dataGridView1.Rows[e.RowIndex].Cells[6].Value = "Full Day"; dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.LightSeaGreen; } if (e.ColumnIndex == dataGridView1.Columns["Half"].Index) {//3.2 dataGridView1.Rows[e.RowIndex].Cells[7].Value = _standardHours / 2; dataGridView1.Rows[e.RowIndex].Cells[6].Value = "Half Day"; dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.MediumPurple; } if (e.ColumnIndex == dataGridView1.Columns["Shift"].Index) {//6.4 dataGridView1.Rows[e.RowIndex].Cells[7].Value = _standardHours; dataGridView1.Rows[e.RowIndex].Cells[6].Value = "Shift"; dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red; } if (e.ColumnIndex == dataGridView1.Columns["Manual"].Index) { //grab time from user input //open form frmManualHours mh = new frmManualHours(); mh.ShowDialog(); dataGridView1.Rows[e.RowIndex].Cells[7].Value = mh._manualHours; dataGridView1.Rows[e.RowIndex].Cells[6].Value = "Manual"; dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.LightSeaGreen; } }
private void dataGridViewSoftware_CellClick(object sender, DataGridViewCellEventArgs e) { int selectedrowindex = dgSelected.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dgSelected.Rows[selectedrowindex]; int placementID = Convert.ToInt32(selectedRow.Cells["PlacementID"].Value); int staffID = Convert.ToInt32(selectedRow.Cells["Staff Id"].Value); //for my department swap - ryucxd 27/11/19 string PT = Convert.ToString(selectedRow.Cells["placement type"].Value); double hour = Convert.ToDouble(selectedRow.Cells["Hours"].Value); //MessageBox.Show(_selectedDate.ToString()); getStandardHours(staffID); //REMOVE BUTTON if (e.ColumnIndex == dgSelected.Columns["Remove"].Index) { SqlConnection conn = new SqlConnection(connectionStrings.ConnectionString); // the below code is only commented out because it would remove the user and we cant have that ^-^ using (SqlCommand cmd = new SqlCommand("DELETE FROM DBO.power_plan_staff where ID = @placementID", conn)) { cmd.Parameters.AddWithValue("@placementID", placementID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); checkExistingSelections(); } //ask if the user wants to move this person to another location --- DialogResult result = MessageBox.Show("Would you like to move this user to another department?", "Move user?", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (result == DialogResult.Yes) { //find out where they are heading //form with combobox maybe? frmMoveDept md = new frmMoveDept(staffID, _selectedDate, PT, hour); md.ShowDialog(); } } //MANUAL BUTTON if (e.ColumnIndex == dgSelected.Columns["Manual"].Index) { frmManualHours mh = new frmManualHours(); mh.ShowDialog(); SqlConnection conn = new SqlConnection(connectionStrings.ConnectionString); using (SqlCommand cmd = new SqlCommand("UPDATE dbo.power_plan_staff set placement_type = 'Manual' , hours = @hours where ID = @placementID", conn)) { cmd.Parameters.AddWithValue("placementID", placementID); cmd.Parameters.AddWithValue("@hours", mh._manualHours); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); checkExistingSelections(); } } //FULL BUTTON if (e.ColumnIndex == dgSelected.Columns["Full"].Index) { SqlConnection conn = new SqlConnection(connectionStrings.ConnectionString); using (SqlCommand cmd = new SqlCommand("UPDATE dbo.power_plan_staff set placement_type = 'Full Day' , hours = @hours where ID = @placementID", conn)) { cmd.Parameters.AddWithValue("placementID", placementID); cmd.Parameters.AddWithValue("@hours", _standardHours); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); checkExistingSelections(); } } //FULL BUTTON if (e.ColumnIndex == dgSelected.Columns["Shift"].Index) { SqlConnection conn = new SqlConnection(connectionStrings.ConnectionString); using (SqlCommand cmd = new SqlCommand("UPDATE dbo.power_plan_staff set placement_type = 'Shift' , hours = @hours where ID = @placementID", conn)) { cmd.Parameters.AddWithValue("placementID", placementID); cmd.Parameters.AddWithValue("@hours", _standardHours); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); checkExistingSelections(); } } //Half BUTTON if (e.ColumnIndex == dgSelected.Columns["Half"].Index) { SqlConnection conn = new SqlConnection(connectionStrings.ConnectionString); using (SqlCommand cmd = new SqlCommand("UPDATE dbo.power_plan_staff set placement_type = 'Half Day' , hours = @hours where ID = @placementID", conn)) { cmd.Parameters.AddWithValue("placementID", placementID); cmd.Parameters.AddWithValue("@hours", _standardHours / 2); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); checkExistingSelections(); } } //Note BUTTON if (e.ColumnIndex == dgSelected.Columns["Note"].Index) { PlacementNote pn = new PlacementNote(placementID); pn.ShowDialog(); checkExistingSelections(); } }