public static BOL.Task.objTask GetDisplayCurrentTask()
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "SELECT " +
"* " +
"FROM " +
"task " +
"WHERE " +
"type != @refresh_frontdesk AND type != @refresh_clientterminal " +
"ORDER BY " +
"id ASC " +
"LIMIT 1";
BOL.Task.objTask Task = conn.Query <BOL.Task.objTask>(statement,
new {
refresh_frontdesk = BOL.Task.objTask.MessageType.RefreshFrontDesk,
refresh_clientterminal = BOL.Task.objTask.MessageType.RefreshClientTerminal
}).SingleOrDefault();
if (Task != null)
{
statement = "DELETE FROM " +
"task " +
"WHERE " +
"id = @id";
conn.Execute(statement, new { id = Task.id });
}
conn.Close();
conn.Dispose();
return(Task);
}
}
public static void Delete_Task(BOL.Task.objTask task)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "DELETE FROM " +
"task " +
"WHERE " +
"id = @id";
conn.Execute(statement,
new
{
id = task.id
});
conn.Close();
conn.Dispose();
}
}
public static bool AddNew_Task(BOL.Task.objTask task)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "INSERT INTO " +
"task " +
"(type, terminal_id) " +
"VALUES " +
"(@type, @terminal_id)";
conn.Execute(statement,
new
{
type = task.type,
terminal_id = task.terminal_id
});
conn.Close();
conn.Dispose();
return(true);
}
}
public static BOL.Task.objTask GetTerminalClientTask(BOL.Terminal.objTerminal terminal)
{
using (var conn = DAL.Base.ConnectionManager.Connection)
{
var statement = "SELECT " +
"* " +
"FROM " +
"task " +
"WHERE " +
"type = @type AND terminal_id = @terminal_id " +
"ORDER BY " +
"id ASC " +
"LIMIT 1";
BOL.Task.objTask Task = conn.Query <BOL.Task.objTask>(statement,
new
{
terminal_id = terminal.id,
type = BOL.Task.objTask.MessageType.RefreshClientTerminal
}).SingleOrDefault();
if (Task != null)
{
statement = "DELETE FROM " +
"task " +
"WHERE " +
"id = @id";
conn.Execute(statement, new { id = Task.id });
}
conn.Close();
conn.Dispose();
return(Task);
}
}
