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