private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { try { DBDingus.UserTableTableEntry deEntry = alleDeEntrys.Where(entr => entr.ID == Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value.ToString())).FirstOrDefault(); textBoxUpdateID.Text = deEntry.ID.ToString(); textBoxUpdateVoornaam.Text = deEntry.VoorNaam; textBoxUpdateAchternaam.Text = deEntry.AchterNaam; textBoxUpdateNFCID.Text = deEntry.NFCID; dateTimePickerUpdateDateJoined.Value = deEntry.DateJoined; checkBoxUpdateZitNogOpSchool.Checked = deEntry.IsActiveUser; if (!deEntry.IsActiveUser) { dateTimePickerUpdateDateLeft.Value = deEntry.DateLeft; } } catch (Exception ex) { MessageBox.Show(ex.Message, "dit had niet moeten gebeuren"); } } }
public static List <DBDingus.UserTableTableEntry> GetListUTFromReader(SqlCommand _command) { List <DBDingus.UserTableTableEntry> toReturn = new List <DBDingus.UserTableTableEntry>(); try { using (SqlConnection connection = new SqlConnection(_ConnectionString)) { _command.Connection = connection; connection.Open(); SqlDataReader _reader = _command.ExecuteReader(); List <string> fields = new List <string>(); for (int i = 0; i < _reader.FieldCount; i++) { fields.Add(_reader.GetName(i)); } while (_reader.Read()) { DBDingus.UserTableTableEntry entry = new DBDingus.UserTableTableEntry(); if (fields.Contains(DBDingus.UserTableNames.ID)) { entry.ID = ReadFromReader <int>((IDataRecord)_reader, DBDingus.UserTableNames.ID); } if (fields.Contains(DBDingus.UserTableNames.VoorNaam)) { entry.VoorNaam = ReadFromReader <string>((IDataRecord)_reader, DBDingus.UserTableNames.VoorNaam); } if (fields.Contains(DBDingus.UserTableNames.AchterNaam)) { entry.AchterNaam = ReadFromReader <string>((IDataRecord)_reader, DBDingus.UserTableNames.AchterNaam); } if (fields.Contains(DBDingus.UserTableNames.NFCID)) { entry.NFCID = ReadFromReader <string>((IDataRecord)_reader, DBDingus.UserTableNames.NFCID); } if (fields.Contains(DBDingus.UserTableNames.DateJoined)) { entry.DateJoined = ReadDateTimeFromReader((IDataRecord)_reader, DBDingus.UserTableNames.DateJoined); } if (fields.Contains(DBDingus.UserTableNames.DateLeft)) { entry.DateLeft = ReadDateTimeFromReader((IDataRecord)_reader, DBDingus.UserTableNames.DateLeft); } if (fields.Contains(DBDingus.UserTableNames.IsActiveUser)) { entry.IsActiveUser = ReadFromReader <bool>((IDataRecord)_reader, DBDingus.UserTableNames.IsActiveUser); } toReturn.Add(entry); } } } catch (Exception ex) { throw new Exception($"(UTFromReader)ERROR @ SQL Command: {_command.CommandText} | Message: {ex.Message}"); } return(toReturn); }
private void push(bool isNew, bool delete) { try { NetCom.ServerRequestChangeUserTable request = new NetCom.ServerRequestChangeUserTable(); DBDingus.UserTableTableEntry deEntry = new DBDingus.UserTableTableEntry(); if (delete) { request.DeleteEntry = true; deEntry.ID = Convert.ToInt32(textBoxUpdateID.Text); } else { request.DeleteEntry = false; request.IsNewUser = isNew; if (isNew) { deEntry.VoorNaam = textBoxNewvoornaam.Text; deEntry.AchterNaam = textBoxNewAchternaam.Text; deEntry.NFCID = textBoxNewNfcid.Text; deEntry.DateJoined = dateTimePickerNewDateJoined.Value; deEntry.IsActiveUser = checkBoxNewZitNogOpSchool.Checked; if (!deEntry.IsActiveUser) // deze if statement is overbodig { deEntry.DateLeft = dateTimePickerNewDateLeft.Value; } } else { deEntry.ID = Convert.ToInt32(textBoxUpdateID.Text); deEntry.VoorNaam = textBoxUpdateVoornaam.Text; deEntry.AchterNaam = textBoxUpdateAchternaam.Text; deEntry.NFCID = textBoxUpdateNFCID.Text; deEntry.DateJoined = dateTimePickerUpdateDateJoined.Value; deEntry.IsActiveUser = checkBoxUpdateZitNogOpSchool.Checked; if (!deEntry.IsActiveUser) { deEntry.DateLeft = dateTimePickerUpdateDateLeft.Value; } } } request.deEntry = deEntry; NetCom.ServerResponseChangeUserTable response = webr <NetCom.ServerResponseChangeUserTable>(request); if (response.OK == false) { if (isNew) { throw new Exception("buttonNew~~ response !OK"); } else { throw new Exception("buttonUpdate~~ response !OK"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } refreshList(); }