private void populateDgvQueue() { DataTable datatable; try { datatable = Queues.get(true, null, null, MAXDISPLAYEDQUEUE, null, null, Settings.QueueNoCutoffTimestamp); if (pnlHeader.BackColor == _HeaderColor_ERROR) { pnlHeader.BackColor = _HeaderColor_DEFAULT; } } catch { //save default header color if (pnlHeader.BackColor != _HeaderColor_ERROR) { _HeaderColor_DEFAULT = pnlHeader.BackColor; } //set header color to error pnlHeader.BackColor = _HeaderColor_ERROR; return; } Util.populateDataGridView(dgv, datatable); Guid newCalledId; if (datatable.Rows.Count > 0) { //highlight first row only //dgv.Rows[0].DefaultCellStyle.ForeColor = LASTCALLEDHIGHLIGHTCOLOR; //if (dgv.Rows.Count > 1) // dgv.Rows[1].DefaultCellStyle.ForeColor = dgv.DefaultCellStyle.ForeColor; DataRow row = datatable.Rows[0]; newCalledId = (Guid)row[Queues.COL_DB_Id]; if (_lastCalledId != newCalledId) { showLargeCallDisplay(datatable.Rows[0]); _lastCalledId = newCalledId; _CALL_QueueNumber.Add(row[Queues.COL_CallNo].ToString()); _CALL_CounterName.Add(row[Queues.COL_DB_CounterAddresses_Name].ToString()); if (!_isSoundPlaying) { bgwCaller.RunWorkerAsync(); } } } }
private void QueueNoReset_Changed(object sender, EventArgs e) { Settings.ManualQueueNoReset = rbManualQueueNoReset.Checked; Settings.AutomaticQueueNoResetHour = in_AutomaticQueueNoResetHour.ValueInt; if (rbAutomaticQueueNoReset.Checked) { DateTime newCutoffTimestamp = Settings.getAutomaticQueueNoResetTimestamp(DateTime.Now); Settings.QueueNoCutoffTimestamp = newCutoffTimestamp; Queues.update_VoidTimestamp(newCutoffTimestamp); lblQueueNoCutoffTimestamp.Text = string.Format("Current Cut Off Time: {0:dd/MM/yy HH:mm}", newCutoffTimestamp); } }
public static void clearQueueIfStartOfDay() { DataTable datatable = Queues.get(true, null, null, 1); if (datatable.Rows.Count > 0) { DateTime lastdate = Util.wrapNullable <DateTime>(datatable.Rows[0], Queues.COL_DB_Timestamp); if (lastdate.Date < DateTime.Now.Date) { Queues.deleteAll(); } } }
private void btnCallPrevious_Click(object sender, EventArgs e) { if (!ddlCalled.isValidSelectedValue()) { Util.inputError <LIBUtil.Desktop.UserControls.Dropdownlist>(ddlCalled, "Pilih nomor antrian"); } else { Queues.call((Guid)ddlCalled.SelectedValue, Helper.counter.Id); } showLastCalled(((DataRowView)ddlCalled.SelectedItem)[Queues.COL_CallNo].ToString()); }
private void populateData() { for (int i = 0; i < _counterAddresses.Rows.Count; i++) { CounterCallStatus counter = ((CounterCallStatus)tlpCounters.Controls[i]); foreach (DataRow row in Queues.getLastCalledForEachCounter().Rows) { if (LIBUtil.Util.wrapNullable <Guid>(row, Queues.COL_DB_CounterAddresses_Id) == counter.CounterAddressId) { counter.QueueNo = LIBUtil.Util.wrapNullable <string>(row, Queues.COL_CallNo); break; } } } }
private void btnResetQueueNumber_Click(object sender, EventArgs e) { Queues.resetQueueNumber(); }
private void btnResetQueues_Click(object sender, EventArgs e) { Queues.deleteAll(); }