private string TraceTransactionQueue(TransactionQueueSr tq) { if (tq == null) { return("TransactionQueue (null)"); } return(string.Format("TransactionQueue (ORMID: {0}; Type: {1}; Description: '{2}'; TransactionId: {3}; Uid: {4}; Object1: '{5}'; Object2: '{6}'; Tag1: '{7}'; Tag2: '{8}';)", tq.ORMID, tq.Type, Limit(tq.Description), tq.TransactionId, Limit(tq.UidState), Limit(tq.Object1), Limit(tq.Object2), Limit(tq.Tag1), Limit(tq.Tag2))); }
public List <TransactionQueueSr> GetAllFromQueue() { try { return(TransactionQueueSr.GetTransactionQueueList()); } catch (Exception excp) { Logger.ErrorFormat("GetAllFromQueue ERROR:\r\n{0}\r\n{1}", excp, excp.Message, excp.StackTrace); } return(null); }
public int GetCountTransactionQueue() { try { return(TransactionQueueSr.GetCountTransactionQueue()); } catch (Exception excp) { Logger.ErrorFormat("GetCountTransactionQueue ERROR:\r\n{0}\r\n{1}", excp, excp.Message, excp.StackTrace); } return(0); }
public void Initialize(string sStationNumber, BusinessProps bp) { lock (locker) { Log.InfoFormat("Initializing '{0}' {1}", sStationNumber, BusinessPropsToString(bp)); m_sStationNumber = sStationNumber; ExcpHelper.ThrowIf(string.IsNullOrEmpty(m_sStationNumber), "Station Number is invalid"); List <TransactionQueueSr> lObjects = TransactionQueueSr.GetByQuery("SELECT * FROM TransactionQueue WHERE Type = {0} OR Type = {1} OR Type = {2} ORDER BY TransactionQueueID DESC", (int)eTransactionQueueType.Ticket, (int)eTransactionQueueType.DepositByCreditNote, (int)eTransactionQueueType.Deposit); foreach (TransactionQueueSr tq in lObjects) { eTransactionQueueType eType = (eTransactionQueueType)tq.Type; if (eType == eTransactionQueueType.Ticket && m_lLastTicketNumber == 0) { m_lastTicket = SerializeHelper.StringToDataContractObject <TicketWS>(tq.Object1); m_lLastTicketNumber = ParseNumberId(m_lastTicket.ticketNbr); } else if (eType == eTransactionQueueType.DepositByCreditNote && m_lLastCreditNoteNumber == 0) { string sNoteNumber = tq.Object2; m_lLastCreditNoteNumber = ParseNumberId(sNoteNumber); } if (m_lLastTicketNumber > 0 && m_lLastCreditNoteNumber > 0) { break; } } m_lLastTransactionID = bp.LastTransactionId; m_lLastTicketNumber = Math.Max(m_lLastTicketNumber, bp.LastTicketNumber); m_lLastCreditNoteNumber = Math.Max(m_lLastCreditNoteNumber, bp.LastCreditNoteNumber); } }
private void CreateAndSaveTransactionQueue(eTransactionQueueType eType, string sDescription, string sTransactionId, uid User, string sObject1, string sObject2, string sObject3, string sTag1, string sTag2) { Debug.Assert(sDescription != null); TransactionQueueSr tq = null; tq = new TransactionQueueSr(); tq.Type = (short)eType; tq.Description = sDescription; tq.TransactionId = sTransactionId; tq.UidState = SerializeHelper.SerializableObjectToString <uid>(User); tq.Object1 = sObject1; tq.Object2 = sObject2; tq.Object3 = sObject3; tq.Tag1 = sTag1; tq.Tag2 = sTag2; tq.Created = DateTime.Now; tq.Save(); }