public static NetCom.ServerResponseOverzightFromOneDate overzight(DBDingus.AcountTableEntry _userAcount, NetCom.ServerRequestOverzightFromOneDate _request) { NetCom.ServerResponseOverzightFromOneDate toReturn = new NetCom.ServerResponseOverzightFromOneDate(); SqlCommand command = new SqlCommand(); command.CommandText = $"select * from {DBDingus.UserTableNames.UserTableName}"; if (!_request.alsoReturnExUsers) { command.CommandText += $" where {DBDingus.UserTableNames.IsActiveUser} = 1"; } List <DBDingus.UserTableTableEntry> userEntrys = FuncsVSQL.GetListUTFromReader(command); //_DBDingus.GetListUTFromReader(FuncsVSQL.SQLQuery(command)); List <DBDingus.RegistratieTableTableEntry> regEntrys = new List <DBDingus.RegistratieTableTableEntry>(); command = new SqlCommand(); command.CommandText = $"select * from {DBDingus.RegistratieTableNames.RegistratieTableName} where {DBDingus.RegistratieTableNames.Date}"; if (_request.useToday) { command.CommandText += " = cast(getdate() as date)"; } else { command.CommandText += $" = cast('{_request.dateToGetOverzightFrom.Date.ToString("yyyy-MM-dd")}' as date)"; } regEntrys = FuncsVSQL.GetListRTFromReader(command); //_DBDingus.GetListRTFromReader(FuncsVSQL.SQLQuery(command)); foreach (var User in userEntrys) { if (_request.alsoReturnExUsers || User.IsActiveUser) { DBDingus.CombUserAfwEntry toPutInList = new DBDingus.CombUserAfwEntry(); toPutInList.UsE = User; foreach (var Entry in regEntrys) { if (Entry.IDOfUserRelated == User.ID) { toPutInList.HasTodayRegEntry = true; toPutInList.RegE = Entry; break; } } toReturn.EtList.Add(toPutInList); } } toReturn.SQlDateTime = GetDateTimeFromSqlDatabase(); return(toReturn); }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { try { if (dataGridView1.SelectedRows.Count == 0) { return; } DBDingus.CombUserAfwEntry selectedUserData = new DBDingus.CombUserAfwEntry(); string _voorNaam = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); string _achterNaam = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); bool found = false; foreach (DBDingus.CombUserAfwEntry entry in _LastRecivedOverzight) { if (entry.UsE.VoorNaam == _voorNaam && entry.UsE.AchterNaam == _achterNaam) { selectedUserData = entry; found = true; break; } } if (!found) { MessageBox.Show("Cant Find Selected User"); return; } //bleh _CurrentlySelectedUser = selectedUserData; //quick fix```````````````````````````````````````````````````````````````` buttonTekenIn.Enabled = false; buttonTekenUit.Enabled = false; if (selectedUserData.HasTodayRegEntry) { if (selectedUserData.RegE.HeeftIngetekend) { buttonClearInEnUitTeken.Enabled = true; if (selectedUserData.RegE.IsAanwezig) { buttonTekenUit.Enabled = true; } else { buttonTekenIn.Enabled = true; // anulleer uitteken } } else { buttonTekenIn.Enabled = true; } } else { buttonTekenIn.Enabled = true; } ///\quick fix ```````````````````````````````````````````````````````` if (_ALLOWCLEARINPUTSONRELOAD) { disableEditControls(); labelVoorNaam.Text = selectedUserData.UsE.VoorNaam; labelAchterNaam.Text = selectedUserData.UsE.AchterNaam; buttonSave.Enabled = true; textBoxOpmerking.Enabled = true; //enable buttons / set values if (selectedUserData.HasTodayRegEntry) { buttonSave.Enabled = true; textBoxOpmerking.Text = selectedUserData.RegE.Opmerking; textBoxOpmerking.Enabled = true; //select item in dropdown bool erIsEenAfwezigNotatie = true; if (selectedUserData.RegE.IsZiek) { comboBoxRedenAfwezig.SelectedItem = comboBoxRedenAfwezig.Items[1]; } else if (selectedUserData.RegE.IsFlexiebelverlof) { comboBoxRedenAfwezig.SelectedItem = comboBoxRedenAfwezig.Items[3]; } else if (selectedUserData.RegE.IsStudieverlof) { comboBoxRedenAfwezig.SelectedItem = comboBoxRedenAfwezig.Items[2]; } else if (selectedUserData.RegE.IsExcurtie) { comboBoxRedenAfwezig.SelectedItem = comboBoxRedenAfwezig.Items[4]; } else if (selectedUserData.RegE.IsLaat) { comboBoxRedenAfwezig.SelectedItem = comboBoxRedenAfwezig.Items[0]; dateTimePickerVerwachteTijdVanAankomst.Value = Convert.ToDateTime(selectedUserData.RegE.Verwachtetijdvanaanwezighijd.ToString("hh\\:mm\\:ss")); } else if (selectedUserData.RegE.IsToegestaalAfwezig) { comboBoxRedenAfwezig.SelectedItem = comboBoxRedenAfwezig.Items[5]; } else { erIsEenAfwezigNotatie = false; } if (erIsEenAfwezigNotatie) { checkBoxHeefAfwezigReden.Checked = true; } if (selectedUserData.RegE.HeeftIngetekend) { buttonClearInEnUitTeken.Enabled = true; dateTimePickerTijdIn.Enabled = true; dateTimePickerTijdIn.Value = Convert.ToDateTime(selectedUserData.RegE.TimeInteken.ToString("hh\\:mm\\:ss")); if (selectedUserData.RegE.IsAanwezig) { buttonTekenUit.Enabled = true; } else { dateTimePickerTimeUit.Enabled = true; dateTimePickerTimeUit.Value = Convert.ToDateTime(selectedUserData.RegE.TimeUitteken.ToString("hh\\:mm\\:ss")); buttonTekenIn.Enabled = true; // anulleer uitteken } } else { buttonTekenIn.Enabled = true; } } else { buttonTekenIn.Enabled = true; } } _ALLOWCLEARINPUTSONRELOAD = true; } catch (Exception ex) { var x = ex.Message; } }
private void ReloadOverzight(bool reloadFromServer) { if (!_NoConnectionMode) { _TimerReloadOverzicht.Stop(); NetCom.ServerRequestOverzightFromOneDate request = new NetCom.ServerRequestOverzightFromOneDate(); if (checkBoxSeUserTodayAsDate.Checked) { request.useToday = true; } else { request.useToday = false; request.dateToGetOverzightFrom = dateTimePickerSeDateToListTo.Value.Date; _LastRecivedOverzightDate = dateTimePickerSeDateToListTo.Value.Date; } _LastRecivedOverzightDateIsToday = checkBoxSeUserTodayAsDate.Checked; if (checkBoxSeShowExUsers.Checked) { request.alsoReturnExUsers = true; } NetCom.ServerResponse response; try { Stopwatch sw = new Stopwatch(); sw.Start(); response = webbbbrrrrrry(request); label2.Text = sw.ElapsedMilliseconds.ToString(); } catch { // als server down is (als school in brand staat...) // if (MessageBox.Show("Kan Niet Verbinden Met Server", "Ga Naar Alarm Modus?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { enableNoConnectionMode(); // } else { // this.BackColor = Color.Yellow;//times are outdated // panel2.BackColor = Color.Yellow; // } _TimerReloadOverzicht.Start(); return; } NetCom.ServerResponseOverzightFromOneDate returnedValue; if (response.IsErrorOccurred) { throw new Exception(response.ErrorInfo.ErrorMessage); } else { //-- int _SelectedRowNummber = 0; if (dataGridView1.CurrentCell != null) { _SelectedRowNummber = dataGridView1.CurrentCell.RowIndex; } ListSortDirection _oldSortOrder; DataGridViewColumn _oldSortCol; _oldSortOrder = dataGridView1.SortOrder == SortOrder.Ascending ? ListSortDirection.Ascending : ListSortDirection.Descending; _oldSortCol = dataGridView1.SortedColumn; ///-- if (reloadFromServer) { returnedValue = JsonConvert.DeserializeObject <NetCom.ServerResponseOverzightFromOneDate>(JsonConvert.SerializeObject(response.Response)); _ALLOWCLEARINPUTSONRELOAD = false; if (_LastRecivedOverzight != null && _CurrentlySelectedUser.UsE != null && _CurrentlySelectedUser.RegE != null && ((_LastRecivedOverzightDateIsToday == checkBoxSeUserTodayAsDate.Checked && _LastRecivedOverzightDateIsToday == true) || _LastRecivedOverzightDate == dateTimePickerSeDateToListTo.Value.Date)) { #region try 2015/2016? /* * try * { * foreach (var entry in returnedValue.EtList) * { * if (entry.UsE.ID == _CurrentlySelectedUser.UsE.ID) * { * if (entry.hasTodayRegEntry == _CurrentlySelectedUser.hasTodayRegEntry) * { * if (entry.RegE.ID == _CurrentlySelectedUser.RegE.ID && * entry.RegE.HeeftIngetekend == _CurrentlySelectedUser.RegE.HeeftIngetekend && * entry.RegE.IsAanwezig == _CurrentlySelectedUser.RegE.IsAanwezig && * entry.RegE.IsExcurtie == _CurrentlySelectedUser.RegE.IsExcurtie && * entry.RegE.IsFlexiebelverlof == _CurrentlySelectedUser.RegE.IsStudieverlof && * entry.RegE.IsStudieverlof == _CurrentlySelectedUser.RegE.IsStudieverlof && * entry.RegE.IsLaat == _CurrentlySelectedUser.RegE.IsLaat && * entry.RegE.IsZiek == _CurrentlySelectedUser.RegE.IsZiek && * entry.RegE.Opmerking == _CurrentlySelectedUser.RegE.Opmerking) * { * if (entry.RegE.HeeftIngetekend) * { * if (entry.RegE.TimeInteken == _CurrentlySelectedUser.RegE.TimeInteken) * { * if (entry.RegE.IsAanwezig == false) * { * if (entry.RegE.TimeUitteken == _CurrentlySelectedUser.RegE.TimeUitteken) * { * if (entry.RegE.IsLaat) * { * if (entry.RegE.Verwachtetijdvanaanwezighijd == _CurrentlySelectedUser.RegE.Verwachtetijdvanaanwezighijd) * { * _ALLOWCLEARINPUTSONRELOAD = false; * } * break; * } * _ALLOWCLEARINPUTSONRELOAD = false; * } * break; * } * _ALLOWCLEARINPUTSONRELOAD = false; * } * break; * } * _ALLOWCLEARINPUTSONRELOAD = false; * } * break; * } * break; * } * } * } * catch (Exception ex) { string kanker = ex.Message; _ALLOWCLEARINPUTSONRELOAD = true; } */ #endregion #region try 2017 try { DBDingus.CombUserAfwEntry entry = returnedValue.EtList.First(x => x.UsE.ID == _CurrentlySelectedUser.UsE.ID); if (entry.RegE != null) { if (entry.RegE.ID == _CurrentlySelectedUser.RegE.ID && entry.RegE.HeeftIngetekend == _CurrentlySelectedUser.RegE.HeeftIngetekend && entry.RegE.IsAanwezig == _CurrentlySelectedUser.RegE.IsAanwezig && entry.RegE.IsExcurtie == _CurrentlySelectedUser.RegE.IsExcurtie && entry.RegE.IsFlexiebelverlof == _CurrentlySelectedUser.RegE.IsStudieverlof && entry.RegE.IsStudieverlof == _CurrentlySelectedUser.RegE.IsStudieverlof && entry.RegE.IsLaat == _CurrentlySelectedUser.RegE.IsLaat && entry.RegE.IsZiek == _CurrentlySelectedUser.RegE.IsZiek && entry.RegE.Opmerking == _CurrentlySelectedUser.RegE.Opmerking) { _ALLOWCLEARINPUTSONRELOAD = false; } else { _ALLOWCLEARINPUTSONRELOAD = true; } } } catch (Exception ex) { _ALLOWCLEARINPUTSONRELOAD = true; } #endregion } _LastRecivedOverzight = returnedValue.EtList; } else { returnedValue = new NetCom.ServerResponseOverzightFromOneDate(); returnedValue.EtList = _LastRecivedOverzight; } if (textBoxZoekOp.Text.Trim() == "") { dataGridView1.SelectionChanged -= dataGridView1_SelectionChanged; dataGridView1.DataSource = FormHelp.UserInfoListToDataTableForDataGridDisplay(returnedValue.EtList, returnedValue.SQlDateTime); dataGridView1.SelectionChanged += new EventHandler(dataGridView1_SelectionChanged); dataGridView1.Refresh(); } else { //zoek op List <DBDingus.CombUserAfwEntry> sortedList = new List <DBDingus.CombUserAfwEntry>(); foreach (DBDingus.CombUserAfwEntry perso in returnedValue.EtList) { if (perso.UsE.VoorNaam.Contains(textBoxZoekOp.Text.Trim()) || perso.UsE.AchterNaam.Contains(textBoxZoekOp.Text.Trim())) { sortedList.Add(perso); } } dataGridView1.SelectionChanged -= dataGridView1_SelectionChanged; dataGridView1.DataSource = FormHelp.UserInfoListToDataTableForDataGridDisplay(sortedList, returnedValue.SQlDateTime); dataGridView1.SelectionChanged += new EventHandler(dataGridView1_SelectionChanged); dataGridView1.Refresh(); } this.BackColor = SystemColors.Control; // times are uptodate panel2.BackColor = SystemColors.Control; //-- if (_oldSortCol != null) { DataGridViewColumn newCol = dataGridView1.Columns[_oldSortCol.Name]; dataGridView1.Sort(newCol, _oldSortOrder); } try {// voor als row[x] er niet (meer) is if (dataGridView1.CurrentCell != null) { dataGridView1.CurrentCell = dataGridView1[1, _SelectedRowNummber]; } } catch { dataGridView1.ClearSelection(); } ///-- dataGridView1.Columns[0].Width = 130; dataGridView1.Columns[1].Width = 140; dataGridView1.Columns[2].Width = 130; dataGridView1.Columns[3].Width = 130; dataGridView1.Columns[4].Width = dataGridView1.Width - dataGridView1.Columns[0].Width - dataGridView1.Columns[1].Width - dataGridView1.Columns[2].Width - dataGridView1.Columns[3].Width - 3 - 20; _TimerReloadOverzicht.Start(); } } else { if (FormHelp.CanConnectToServer(_ApiAddres)) { disableNoConnectionMode(); this.BackColor = Color.Yellow; //still outdated panel2.BackColor = Color.Yellow; //why? } } }