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();
}
