public objTerminalQueue()
{
id = 0;
objTransactionQueue = new Transaction_Queue.objTransactionQueue();
terminal_id = 0;
is_done = true;
}
public rptQueueTicket(BOL.Transaction_Queue.objTransactionQueue trans_queue)
{
InitializeComponent();
txtTransacrion.Value = trans_queue.objTransaction.name;
txtNumber.Value = trans_queue.ToString();
}
public static bool Set_Waiting_As_Current(BOL.Transaction_Queue.objTransactionQueue transaction_queue, BOL.Terminal.objTerminal terminal)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "UPDATE " +
"terminal_queue " +
"SET " +
"is_done = @previous_done " +
"WHERE " +
"terminal_id = @terminal_id";
statement += ";INSERT INTO " +
"terminal_queue " +
"(terminal_id, transaction_queue_id, is_done) " +
"VALUES " +
"(@terminal_id, @transaction_queue_id, @is_done)";
conn.Execute(statement,
new
{
previous_done = true,
transaction_id = transaction_queue.objTransaction.id,
terminal_id = terminal.id,
transaction_queue_id = transaction_queue.id,
is_done = false
});
conn.Close();
conn.Dispose();
return(true);
}
}
public static void Print_Queue(BOL.Transaction_Queue.objTransactionQueue trans_queue)
{
BackgroundWorker bw = new BackgroundWorker();
bw.DoWork += (s, arg) =>
{
try
{
rptQueueTicket report = new rptQueueTicket(trans_queue)
{
Name = "Queue Ticket"
};
ReportSource report_source = new InstanceReportSource()
{
ReportDocument = report
};
// Obtain the settings of the default printer
System.Drawing.Printing.PrinterSettings printerSettings
= new System.Drawing.Printing.PrinterSettings();
// The standard print controller comes with no UI
System.Drawing.Printing.PrintController standardPrintController =
new System.Drawing.Printing.StandardPrintController();
// Print the report using the custom print controller
Telerik.Reporting.Processing.ReportProcessor reportProcessor
= new Telerik.Reporting.Processing.ReportProcessor();
reportProcessor.PrintController = standardPrintController;
//reportProcessor.PrintReport(typeReportSource, printerSettings);
reportProcessor.PrintReport(report_source, printerSettings);
}
catch (Exception ex)
{
EventLog.WriteEntry("Report", ex.Message, EventLogEntryType.Error);
}
};
//bw.RunWorkerCompleted += (s, arg) =>
//{
// if (arg.Error == null)
// {
// }
// else
// throw new Exception(arg.Error.Message);
//};
bw.RunWorkerAsync();
}
public static BOL.Transaction_Queue.objTransactionQueue AddNew(BOL.Transaction.objTransaction trans)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "SELECT IFNULL(MAX(queue_number), 0) + 1 FROM transaction_queue WHERE transaction_id = @transaction_id AND DATE(date_time) = CURRENT_DATE() ";
int next_queue = conn.Query <int>(statement,
new
{
transaction_id = trans.id
}).SingleOrDefault();
statement = "INSERT INTO " +
"transaction_queue " +
"(transaction_id, queue_number, date_time) " +
"VALUES " +
"(@transaction_id, @queue_number, CURRENT_TIMESTAMP())";
statement += ";SELECT " +
"TQ.*, T.* " +
"FROM " +
"transaction_queue TQ " +
"INNER JOIN transaction T ON TQ.transaction_id = T.id " +
"ORDER BY " +
"TQ.id DESC " +
"LIMIT 1";
BOL.Transaction_Queue.objTransactionQueue TransQueue = conn.Query <BOL.Transaction_Queue.objTransactionQueue, BOL.Transaction.objTransaction, BOL.Transaction_Queue.objTransactionQueue>
(statement,
(TQ, T) => { TQ.objTransaction = T; return(TQ); },
new
{
transaction_id = trans.id,
queue_number = next_queue
}).SingleOrDefault();
conn.Close();
return(TransQueue);
}
}
public override string ToString()
{
if (objTransactionQueue == null)
{
objTransactionQueue = new Transaction_Queue.objTransactionQueue();
}
if (objTransactionQueue.objTransaction == null)
{
objTransactionQueue.objTransaction = new Transaction.objTransaction();
}
if (id > 0)
{
return(String.Format("{0}{1:0000}", objTransactionQueue.objTransaction.prefix.Trim(), objTransactionQueue.queue_number));
}
else
{
return("");
}
}
public static bool Next(BOL.Terminal.objTerminal terminal, BOL.Terminal_Queue.objTerminalQueue terminal_queue)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "UPDATE " +
"terminal_queue " +
"SET " +
"is_done = @is_done " +
"WHERE " +
"id = @id";
conn.Execute(statement,
new
{
id = terminal_queue.id,
is_done = true
});
statement = "SELECT " +
"TQ.*, T.* " +
"FROM " +
"transaction_queue TQ " +
"INNER JOIN transaction T ON TQ.transaction_id = T.id " +
"WHERE " +
"TQ.terminal_id = @terminal_id AND TQ.id NOT IN (SELECT transaction_queue_id FROM terminal_queue) AND DATE(TQ.date_time) = CURRENT_DATE() " +
"ORDER BY " +
"TQ.id ASC " +
"LIMIT 1";
BOL.Transaction_Queue.objTransactionQueue ForwardedQueue = conn.Query <BOL.Transaction_Queue.objTransactionQueue, BOL.Transaction.objTransaction, BOL.Transaction_Queue.objTransactionQueue>(statement,
(TQ, T) => { TQ.objTransaction = T; return(TQ); },
new
{
terminal_id = terminal.id
}).SingleOrDefault();
if (ForwardedQueue == null)
{
statement = "SELECT " +
"TQ.*, T.* " +
"FROM " +
"transaction_queue TQ " +
"INNER JOIN transaction T ON TQ.transaction_id = T.id " +
"INNER JOIN terminal_transaction TT ON T.id = TT.transaction_id " +
"WHERE " +
"TQ.id NOT IN (SELECT transaction_queue_id FROM terminal_queue) AND TT.terminal_id = @terminal_id AND TQ.terminal_id IS NULL AND DATE(TQ.date_time) = CURRENT_DATE() " +
"ORDER BY " +
"TT.priority_level ASC, TQ.queue_number ASC, TQ.id ASC " +
"LIMIT 1";
BOL.Transaction_Queue.objTransactionQueue TransQueue = conn.Query <BOL.Transaction_Queue.objTransactionQueue, BOL.Transaction.objTransaction, BOL.Transaction_Queue.objTransactionQueue>(statement,
(TQ, T) => { TQ.objTransaction = T; return(TQ); },
new
{
terminal_id = terminal.id
}).SingleOrDefault();
if (TransQueue == null)
{
return(false);
}
statement = "INSERT INTO " +
"terminal_queue " +
"(terminal_id, transaction_queue_id, is_done) " +
"VALUES " +
"(@terminal_id, @transaction_queue_id, @is_done)";
conn.Execute(statement,
new
{
transaction_id = TransQueue.objTransaction.id,
terminal_id = terminal.id,
transaction_queue_id = TransQueue.id,
is_done = false
});
conn.Close();
conn.Dispose();
return(true);
}
statement = "INSERT INTO " +
"terminal_queue " +
"(terminal_id, transaction_queue_id, is_done) " +
"VALUES " +
"(@terminal_id, @transaction_queue_id, @is_done)";
conn.Execute(statement,
new
{
transaction_id = ForwardedQueue.objTransaction.id,
terminal_id = terminal.id,
transaction_queue_id = ForwardedQueue.id,
is_done = false
});
conn.Close();
conn.Dispose();
return(true);
}
}
public vmPromptTicket(BOL.Transaction_Queue.objTransactionQueue transacton_queue)
{
TransactionQueue = transacton_queue;
Delay_Prompt();
}
