private void push(bool isNew, bool delete)
{ // push to server
NetCom.ServerRequestChangeModTable request = new NetCom.ServerRequestChangeModTable();
DBDingus.ModifierTableEntry d = new DBDingus.ModifierTableEntry();
if (delete)
{
request.DeleteEntry = true;
d.ID = curModEntryID;
}
else
{
request.DeleteEntry = false;
if (isNew)
{
request.IsNewEntry = true;
}
else
{
d.ID = curModEntryID;
request.IsNewEntry = false;
}
//fill D
if (checkBoxIsStudiVerlof.Checked || checkBoxIsFlexiebelverlof.Checked || checkBoxIsExcurtie.Checked)
{
d.HoursToAdd = new TimeSpan();
}
else
{
d.HoursToAdd = dateTimePickerHoursToAdd.Value.TimeOfDay;
}
d.DateTotEnMet = dateTimePickerDatumTotEnMet.Value;
d.DateVanafEnMet = dateTimePickerVanafEnMet.Value;
d.omschrijveing = textBoxOpmerking.Text;
d.isExurtie = checkBoxIsExcurtie.Checked;
d.isStudieVerlof = checkBoxIsStudiVerlof.Checked;
d.isFlexibelverlofoeorfsjklcghiur = checkBoxIsFlexiebelverlof.Checked;
d.DaysOfEffect[0] = checkBoxMo.Checked;
d.DaysOfEffect[1] = checkBoxDi.Checked;
d.DaysOfEffect[2] = checkBoxWo.Checked;
d.DaysOfEffect[3] = checkBoxDo.Checked;
d.DaysOfEffect[4] = checkBoxVr.Checked;
d.DaysOfEffect[5] = checkBoxZa.Checked;
d.DaysOfEffect[6] = checkBoxZo.Checked;
d.UserIDs = selectedUsers.Select(i => i.ID).ToList();
}
request.deEntry = d; // request.deEntry in the firstplcae
NetCom.ServerResponseChangeModTable response = webr <NetCom.ServerResponseChangeModTable>(request);
if (response.OK)
{
//niuets
}
else
{
MessageBox.Show("niet ok");
}
ClearInterface();
LoadAlleDeEntrys();
LoadDataTablesFromAlleDeEntrys();
}
public static NetCom.ServerResponseChangeModTable ChangeModtable(DBDingus.AcountTableEntry _MasterRightsEnty, NetCom.ServerRequestChangeModTable _request)
{
NetCom.ServerResponseChangeModTable toReturn = new NetCom.ServerResponseChangeModTable();
SqlCommand command = new SqlCommand();
if (!_request.IsNewEntry || _request.DeleteEntry)
{
command.Parameters.AddWithValue("@ID", _request.deEntry.ID);
}
if (_request.DeleteEntry)
{
command.CommandText = $"delete from {DBDingus.ModifierTableNames.ModifierTableName} where {DBDingus.ModifierTableNames.ID} = @ID";
}
else
{
command.Parameters.AddWithValue("@dateVan", _request.deEntry.DateVanafEnMet);
command.Parameters.AddWithValue("@dateTot", _request.deEntry.DateTotEnMet);
command.Parameters.AddWithValue("@daysOfEffect", JsonConvert.SerializeObject(_request.deEntry.DaysOfEffect));
command.Parameters.AddWithValue("@users", JsonConvert.SerializeObject(_request.deEntry.UserIDs));
command.Parameters.AddWithValue("@hoursToAdd", _request.deEntry.HoursToAdd);
command.Parameters.AddWithValue("@omschrij", _request.deEntry.omschrijveing);
command.Parameters.AddWithValue("@isStudiev", _request.deEntry.isStudieVerlof);
command.Parameters.AddWithValue("@isExcur", _request.deEntry.isExurtie);
command.Parameters.AddWithValue("@isFlexy", _request.deEntry.isFlexibelverlofoeorfsjklcghiur);
if (_request.IsNewEntry)
{
command.CommandText = $"insert into {DBDingus.ModifierTableNames.ModifierTableName} ({DBDingus.ModifierTableNames.DateVanafEnMet}, {DBDingus.ModifierTableNames.DateTotEnMet}, {DBDingus.ModifierTableNames.DaysOfEffect}, {DBDingus.ModifierTableNames.UserIDs}, {DBDingus.ModifierTableNames.HoursToAdd}, {DBDingus.ModifierTableNames.Omschrijving}, {DBDingus.ModifierTableNames.isStudiever}, {DBDingus.ModifierTableNames.isExur}, {DBDingus.ModifierTableNames.isflexy}) values (cast(@dateVan as date), cast(@dateTot as date), @daysOfEffect, @users, @hoursToAdd, @omschrij, @isStudiev, @isExcur, @isFlexy)";
}
else
{
command.CommandText = $"update {DBDingus.ModifierTableNames.ModifierTableName} set {DBDingus.ModifierTableNames.DateVanafEnMet} = cast(@dateVan as date), {DBDingus.ModifierTableNames.DateTotEnMet} = @dateTot, {DBDingus.ModifierTableNames.DaysOfEffect} = @daysOfEffect, {DBDingus.ModifierTableNames.UserIDs} = @users, {DBDingus.ModifierTableNames.HoursToAdd} = @hoursToAdd, {DBDingus.ModifierTableNames.Omschrijving} = @omschrij, {DBDingus.ModifierTableNames.isStudiever} = @isStudiev, {DBDingus.ModifierTableNames.isExur} = @isExcur, {DBDingus.ModifierTableNames.isflexy} = @isFlexy where {DBDingus.ModifierTableNames.ID} = @ID";
}
}
if (FuncsVSQL.SQLNonQuery(command) != 1)
{
toReturn.OK = false;
}
return(toReturn);
}
