private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (RaiseValueChanged) { DataGridViewCheckBoxCell cc; ItemResult ItemChanged; if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("CheckedIn")) { cc = dataGridView1[e.ColumnIndex, e.RowIndex] as DataGridViewCheckBoxCell; ItemChanged = GenerateItemResult(e.RowIndex); if ((bool)cc.Value) { ItemChanged.LastCheckInValue = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); (dataGridView1["LastCheckIn", e.RowIndex] as DataGridViewTextBoxCell).Value = ItemChanged.LastCheckInValue; ItemChanged.UpsertCheckInOut(Form1.MasterConnection, true); dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = System.Drawing.Color.LightGreen; //Cursor.Current = Cursors.WaitCursor; } else { ItemChanged.LastCheckOutValue = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); (dataGridView1["LastCheckOut", e.RowIndex] as DataGridViewTextBoxCell).Value = ItemChanged.LastCheckOutValue; ItemChanged.UpsertCheckInOut(Form1.MasterConnection, false); dataGridView1.Rows[e.RowIndex].DefaultCellStyle.BackColor = System.Drawing.Color.LightPink; //Cursor.Current = Cursors.WaitCursor; } } } }
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { DataGridViewCheckBoxCell cc; ItemResult ItemChanged; if (dataGridView1.Columns[e.ColumnIndex].Name.Equals("CheckInCol")) { cc = dataGridView1[e.ColumnIndex, e.RowIndex] as DataGridViewCheckBoxCell; ItemChanged = itemResultBindingSource[e.RowIndex] as ItemResult; if ((bool)cc.Value) { ItemChanged.LastCheckInValue = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ItemChanged.UpsertCheckInOut(SearchItems.SearchItemsConnection, true); } else { ItemChanged.LastCheckOutValue = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ItemChanged.UpsertCheckInOut(SearchItems.SearchItemsConnection, false); } } }