public static NetCom.ServerResponseChangeUserTable ChangeUserTable(DBDingus.AcountTableEntry _MasterRightsEnty, NetCom.ServerRequestChangeUserTable _request)
{
NetCom.ServerResponseChangeUserTable toReturn = new NetCom.ServerResponseChangeUserTable();
SqlCommand command = new SqlCommand();
if (!_request.IsNewUser || _request.DeleteEntry)
{
command.Parameters.AddWithValue("@ID", _request.deEntry.ID);
}
if (_request.DeleteEntry)
{
command.CommandText = $"delete from {DBDingus.UserTableNames.UserTableName} where {DBDingus.UserTableNames.ID} = @ID";
}
else
{
command.Parameters.AddWithValue("@Voornaam", _request.deEntry.VoorNaam);
command.Parameters.AddWithValue("@Achternaam", _request.deEntry.AchterNaam);
command.Parameters.AddWithValue("@NFCID", _request.deEntry.NFCID);
command.Parameters.AddWithValue("@DateJoined", _request.deEntry.DateJoined);
command.Parameters.AddWithValue("@IsActive", _request.deEntry.IsActiveUser);
if (!_request.IsNewUser)
{
command.Parameters.AddWithValue("@DateLeft", _request.deEntry.DateLeft);
}
if (_request.IsNewUser)
{
if (!_request.IsNewUser)
{
command.CommandText = $"insert into {DBDingus.UserTableNames.UserTableName} ({DBDingus.UserTableNames.VoorNaam}, {DBDingus.UserTableNames.AchterNaam}, {DBDingus.UserTableNames.NFCID}, {DBDingus.UserTableNames.DateJoined}, {DBDingus.UserTableNames.IsActiveUser}, {DBDingus.UserTableNames.DateLeft} ) values (@Voornaam, @Achternaam, @NFCID, cast(@DateJoined as date), cast(@IsActive as bit), cast(@DateLeft as date))";
}
else
{
command.CommandText = $"insert into {DBDingus.UserTableNames.UserTableName} ({DBDingus.UserTableNames.VoorNaam}, {DBDingus.UserTableNames.AchterNaam}, {DBDingus.UserTableNames.NFCID}, {DBDingus.UserTableNames.DateJoined}, {DBDingus.UserTableNames.IsActiveUser}) values (@Voornaam, @Achternaam, @NFCID, cast(@DateJoined as date), cast(@IsActive as bit))";
}
}
else
{
if (!_request.IsNewUser)
{
command.CommandText = $"update {DBDingus.UserTableNames.UserTableName} set {DBDingus.UserTableNames.VoorNaam} = @Voornaam, {DBDingus.UserTableNames.AchterNaam} = @Achternaam, {DBDingus.UserTableNames.NFCID} = @NFCID, {DBDingus.UserTableNames.DateJoined} = cast(@DateJoined as date), {DBDingus.UserTableNames.IsActiveUser} = cast(@IsActive as bit), {DBDingus.UserTableNames.DateLeft} = cast(@DateLeft as date) where {DBDingus.UserTableNames.ID} = @ID";
}
else
{
command.CommandText = $"update {DBDingus.UserTableNames.UserTableName} set {DBDingus.UserTableNames.VoorNaam} = @Voornaam, {DBDingus.UserTableNames.AchterNaam} = @Achternaam, {DBDingus.UserTableNames.NFCID} = @NFCID, {DBDingus.UserTableNames.DateJoined} = cast(@DateJoined as date), {DBDingus.UserTableNames.IsActiveUser} = cast(@IsActive as bit) where {DBDingus.UserTableNames.ID} = @ID";
}
}
}
if (FuncsVSQL.SQLNonQuery(command) != 1)
{
toReturn.OK = false;
}
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();
}
