public static bool Update(BOL.Transaction.objTransaction transaction)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "UPDATE " +
"transaction " +
"SET " +
"name = @name, " +
"prefix = @prefix, " +
"description = @description, " +
"active = @active " +
"WHERE " +
"id = @id";
conn.Execute(statement,
new
{
id = transaction.id,
name = transaction.name.Trim(),
prefix = transaction.prefix.Trim(),
description = transaction.description.Trim(),
active = transaction.active
});
conn.Close();
conn.Dispose();
return(true);
}
}
public objTerminalTransaction()
{
id = 0;
terminal_id = 0;
objTransaction = new Transaction.objTransaction();
priority_level = 0;
}
public static bool Add(BOL.Transaction.objTransaction transaction)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "INSERT INTO " +
"transaction " +
"(name, prefix, description, active) " +
"VALUES " +
"(@name, @prefix, @description, @active)";
conn.Execute(statement,
new
{
name = transaction.name.Trim(),
prefix = transaction.prefix.Trim(),
description = transaction.description.Trim(),
active = transaction.active
});
conn.Close();
conn.Dispose();
return(true);
}
}
public ucButton(BOL.Transaction.objTransaction transaction)
{
this.Transaction = transaction;
this.Click_Command = new COMMON.RelayCommand(this.Execute_ClickCommand, this.CanClick);
CanPress = true;
}
public vmTransactionEntry(COMMON.SaveMode.Mode mode, BOL.Transaction.objTransaction transaction)
{
this.Mode = mode;
this.Transaction = transaction;
this.Cancel_Command = new COMMON.RelayCommand(this.Execute_Cancel, this.CanCancel);
this.Save_Command = new COMMON.RelayCommand(this.Execute_Save, this.CanSave);
}
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 static bool Delete(BOL.Transaction.objTransaction transaction)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "DELETE FROM " +
"transaction " +
"WHERE " +
"id = @id";
conn.Execute(statement,
new
{
id = transaction.id
});
conn.Close();
conn.Dispose();
return(true);
}
}
public static bool AddNew_Transaction(BOL.Terminal.objTerminal terminal, BOL.Transaction.objTransaction transaction)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "SELECT " +
"IFNULL(MAX(priority_level), 0) + 1 " +
"FROM " +
"terminal_transaction " +
"WHERE " +
"terminal_id = @terminal_id";
int next_level = conn.Query <int>(statement,
new
{
terminal_id = terminal.id
}).SingleOrDefault();
statement = "INSERT INTO " +
"terminal_transaction " +
"(terminal_id, transaction_id, priority_level) " +
"VALUES " +
"(@terminal_id, @transaction_id, @priority_level)";
conn.Execute(statement,
new
{
terminal_id = terminal.id,
transaction_id = transaction.id,
priority_level = next_level
});
conn.Close();
conn.Dispose();
return(true);
}
}
