public static void Dequeue(LoginUser loginUser, int ticketID, int userID) { TicketQueueItem item = TicketQueue.GetTicketQueueItem(loginUser, ticketID, userID); if (item != null) { item.Delete(); item.Collection.Save(); } }
public static int GetLastPosition(LoginUser loginUser, int userID) { TicketQueue queue = new TicketQueue(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = "SELECT MAX(Position) FROM TicketQueue WHERE (UserID = @UserID)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@UserID", userID); object result = queue.ExecuteScalar(command); return(result == DBNull.Value ? -1 : (int)result); } }
public static TicketQueueItem GetTicketQueueItem(LoginUser loginUser, int ticketQueueID) { TicketQueue ticketQueue = new TicketQueue(loginUser); ticketQueue.LoadByTicketQueueID(ticketQueueID); if (ticketQueue.IsEmpty) { return(null); } else { return(ticketQueue[0]); } }
public static TicketQueueItem GetTicketQueueItem(LoginUser loginUser, int ticketID, int userID) { TicketQueue queue = new TicketQueue(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = @"SELECT * FROM TicketQueue WHERE (UserID = @UserID) AND (TicketID = @TicketID)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@TicketID", ticketID); command.Parameters.AddWithValue("@UserID", userID); queue.Fill(command); } if (queue.IsEmpty) { return(null); } return(queue[0]); }
public static void RepositionTickets(LoginUser loginUser, int userID, int[] ticketIDs) { TicketQueue queue = new TicketQueue(loginUser); queue.LoadByUser(userID); List <int> list = new List <int>(ticketIDs); foreach (TicketQueueItem item in queue) { item.Position = item.Position + 10000; } foreach (TicketQueueItem item in queue) { item.Position = list.IndexOf(item.TicketQueueID); } queue.Save(); }
public TicketQueueItem(DataRow row, TicketQueue ticketQueue) : base(row, ticketQueue) { _ticketQueue = ticketQueue; }