public static bool AlreadyRegistered(int counter)
{
using (var q = new QueeuingEntities())
{
return(q.Counters.Any(x => x.CounterNumber == counter));
}
}
private void ShowNumbersForm_Load(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
fillTable(q.Ques.Where(x => x.Status == 0));
}
}
/// <summary>
/// processes the messages relayed by clients
/// </summary>
/// <param name="n"></param>
void processNotification(string n)
{
int nc;
if (int.TryParse(n, out nc))
{
using (var q = new QueeuingEntities())
{
var counter = q.Counters.FirstOrDefault(x => x.CounterNumber == nc);
var token = numbersTable.Controls.Cast <CounterToken>().FirstOrDefault(x => x.Counter == counter.CounterNumber);
if (counter.Ques.Any(x => x.Status == 0))
{
token.Number = "--";
return;
}
var currentNumber = counter.Ques.FirstOrDefault(x => x.Status == 1);
token.Number = currentNumber?.TicketCode ?? "--";
if (currentNumber != null)
{
SpeechManager.AddMessages("Now serving, " + currentNumber.TicketCode + " at counter " + counter.CounterNumber);
}
}
}
}
private void Main_Load(object sender, EventArgs e)
{
WindowState = Properties.Settings.Default.WindowsState ? FormWindowState.Maximized : FormWindowState.Normal;
checkBox2.Checked = Properties.Settings.Default.AutoHide;
counterNum = AppStartup.CounterNumber;
this.Text = "COUNTER: " + counterNum;
using (var q = new QueeuingEntities())
{
transactionType.Items.AddRange(q.Transactions.Select(x => x.Name).ToArray());
var c = q.Counters.FirstOrDefault(x => x.CounterNumber == counterNum);
targetCounter = c;
targetItem = c.Transaction;
counterNumber.Text = c.CounterNumber.ToString();
counterNum = c.CounterNumber;
transactionType.Text = c.Transaction.Name;
var num = c.Ques.FirstOrDefault(x => x.Status == 1);
currentNumberTxt.Text = num?.TicketCode ?? "--";
currentNumber = num;
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
if (!q.Counters.Any(x => x.CounterNumber == (int)numericUpDown1.Value))
{
var c = new Counter();
// c.IpAddress = label1.Text;
c.Transaction = q.Transactions.FirstOrDefault(x => x.Name == transactions.Text);
c.CounterNumber = (int)numericUpDown1.Value;
q.Counters.Add(c);
q.SaveChanges();
}
else
{
var c = q.Counters.FirstOrDefault(x => x.CounterNumber == (int)numericUpDown1.Value);
c.Transaction = q.Transactions.FirstOrDefault(x => x.Name == transactions.Text);
q.SaveChanges();
}
AppStartup.CounterNumber = (int)numericUpDown1.Value;
DialogResult = DialogResult.Yes;
this.Close();
}
}
void RefreshControls()
{
var controls = tableLayoutPanel1.Controls.Cast <TicketToken>().ToArray();
tableLayoutPanel1.Controls.Clear();
using (var q = new QueeuingEntities())
{
foreach (var i in q.Transactions)
{
var token = new TicketToken();
token.Dock = DockStyle.Fill;
token.Transaction = i.Name.ToUpper();
foreach (var j in i.Counters)
{
token.Counters += "COUNTER " + j.CounterNumber + " ";
}
token.OnSelected += (X, Y) =>
{
ShowConfirmation(i.Id);
};
tableLayoutPanel1.Controls.Add(token);
}
}
foreach (var i in controls)
{
i.Dispose();
}
}
private void transactionsTable_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 4)
{
if (MessageBox.Show("Are you sure want to remove this type of transaction?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
///get the transaction id in transaction table
var tId = (int)transactionsTable.SelectedCells[0].Value;
using (var q = new QueeuingEntities())
{
///get the reference of transaction in the model
var t = q.Transactions.FirstOrDefault(x => x.Id == tId);
///if found in model, then remove
if (t != null)
{
q.Transactions.Remove(t);
q.SaveChanges();
}
}
///remove the entry in the table
transactionsTable.Rows.RemoveAt(e.RowIndex);
changesMade = true;
}
}
private void Main_Load(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
transactions.Items.AddRange(q.Transactions.Select(x => x.Name).ToArray());
transactions.SelectedIndex = 0;
}
}
private void nextNumber_Click(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
var counter = q.Counters.FirstOrDefault(x => x.CounterNumber == counterNum);
if (currentNumber != null)
{
Console.WriteLine("remove");
var cnum = q.Ques?.FirstOrDefault(x => x.Id == currentNumber.Id);
if (cnum != null)
{
cnum.Status = 2;
}
}
IQueryable <Que> numbers = null;
if (checkBox1.Checked)
{
numbers = q.Ques.Where(x => x.Transaction.Id == targetItem.Id && x.Status == 0 && x.Priority);
if (numbers.Count() == 0)
{
numbers = q.Ques.Where(x => x.Transaction.Id == targetItem.Id && x.Status == 0);
}
}
else
{
numbers = q.Ques.Where(x => x.Transaction.Id == targetItem.Id && x.Status == 0);
}
if (numbers.Count() == 0)
{
q.SaveChanges();
currentNumberTxt.Text = "--";
sendMessage();
MessageBox.Show("Numbers for this particular transaction is depleted. Choose other transactions.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Que next = numbers.First();
currentNumber = next;
next.Counter = counter;
next.Status = 1;
q.SaveChanges();
currentNumberTxt.Text = next.TicketCode;
sendMessage();
}
if (checkBox2.Checked)
{
WindowState = FormWindowState.Minimized;
}
}
private void button2_Click(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
var counter = q.Counters.FirstOrDefault(x => x.CounterNumber == counterNum);
q.Counters.Remove(counter);
q.SaveChanges();
}
this.Close();
}
private void transactionType_SelectedIndexChanged(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
targetItem = q.Transactions.FirstOrDefault(x => x.Name == transactionType.Text);
var c = q.Counters.FirstOrDefault(x => x.CounterNumber == counterNum);
c.Transaction = targetItem;
q.SaveChanges();
}
}
private void SkippedNumbers_Load(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
var qs = q.Ques.Where(x => x.CounterId == counterId && x.Status == 3);
foreach (var i in qs)
{
dataGridView1.Rows.Add(i.Id, i.TicketCode, i.Transaction.Name);
}
}
}
void ShowConfirmation(int id)
{
using (var ticketCon = new TicketConfirmationForm())
{
using (var q = new QueeuingEntities())
{
ticketCon.targetTransaction = q.Transactions.FirstOrDefault(x => x.Id == id);
ticketCon.Number = ticketCon.targetTransaction.CurrentNumber + 1;
}
ticketCon.ShowDialog();
}
}
void LoadValues()
{
transactionsTable.Rows.Clear();
using (var q = new QueeuingEntities())
{
foreach (var i in q.Transactions)
{
transactionsTable.Rows.Add(i.Id,
i.Name,
i.Prefix,
i.Details,
"Delete");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
var t = new Transaction();
t.Name = nameTxt.Text.Trim();
t.Prefix = prefTxt.Text.Trim();
t.Details = detTxt.Text.Trim();
t.CurrentNumber = 0;
q.Transactions.Add(t);
q.SaveChanges();
}
ClearTextBoxes();
changesMade = true;
}
private void skip_Click(object sender, EventArgs e)
{
if (currentNumber == null)
{
return;
}
using (var q = new QueeuingEntities())
{
var n = q.Ques.FirstOrDefault(x => x.Id == currentNumber.Id);
n.Status = (int)NumberStatus.skipped;
q.SaveChanges();
}
currentNumberTxt.Text = "--";
currentNumber = null;
sendMessage();
}
private void Skipped_SkipSelect(object sender, int e)
{
//throw new NotImplementedException();
using (var q = new QueeuingEntities())
{
if (currentNumber != null)
{
var c = q.Ques.FirstOrDefault(x => x.Id == currentNumber.Id);
c.Status = (int)NumberStatus.done;
}
var skipped = q.Ques.FirstOrDefault(x => x.Id == e);
currentNumber = skipped;
currentNumberTxt.Text = skipped.TicketCode;
skipped.Status = (int)NumberStatus.active;
sendMessage();
q.SaveChanges();
}
}
/// <summary>
/// instantiates tokens for display
/// </summary>
void populateTokens()
{
using (var q = new QueeuingEntities())
{
foreach (var i in q.Counters.OrderBy(x => x.CounterNumber))
{
///creates the token
var token = new CounterToken();
token.Dock = DockStyle.Fill;
token.Counter = i.CounterNumber;
///finds the active number corresponding the current counter on the loop
var currentNumber = i.Ques.FirstOrDefault(x => x.Status == 1);
///if nothing found put __ for empty number
token.Number = currentNumber?.TicketCode ?? "--";
///then add to the table
numbersTable.Controls.Add(token);
}
}
}
private void Main_Load(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
foreach (var i in q.Transactions)
{
var token = new TicketToken();
token.Dock = DockStyle.Fill;
token.Transaction = i.Name.ToUpper();
foreach (var j in i.Counters)
{
token.Counters += "COUNTER " + j.CounterNumber + " ";
}
token.OnSelected += (X, Y) =>
{
ShowConfirmation(i.Id);
};
//flowLayoutPanel1.Controls.Add(token);
tableLayoutPanel1.Controls.Add(token);
}
}
}
private void confirmBtn_Click(object sender, EventArgs e)
{
using (var q = new QueeuingEntities())
{
var newQue = new Que();
newQue.TransactionId = targetTransaction.Id;
newQue.Priority = isPrio.Checked;
newQue.Status = 0;
newQue.TicketCode = number.Text;
var t = q.Transactions.FirstOrDefault(x => x.Id == targetTransaction.Id);
t.CurrentNumber = Number;
q.Ques.Add(newQue);
q.SaveChanges();
RNumber = newQue.TicketCode;
RCategory = newQue.Transaction.Name;
}
///Print number
document.Print();
this.Close();
}
private void clearBtn_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want clear the number in Queue and reset all numbers to 1?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
using (var q = new QueeuingEntities())
{
foreach (var i in q.Transactions)
{
i.CurrentNumber = 0;
}
q.Ques.RemoveRange(q.Ques);
q.SaveChanges();
}
var token = numbersTable.Controls.Cast <CounterToken>();
foreach (var i in token)
{
i.Number = "--";
}
}
