public void Close(TicketStatus NewStatus, bool UpdateInDb)
        {
            String dbType = null;
            Status = NewStatus;
            if (UpdateInDb)
            {
                switch (NewStatus)
                {
                    case TicketStatus.RESOLVED:
                        dbType = "resolved";
                        break;

                    case TicketStatus.ABUSIVE:
                        dbType = "abusive";
                        break;

                    case TicketStatus.INVALID:
                        dbType = "invalid";
                        break;
                }

                using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
                {
                    adapter.ExecuteQuery("UPDATE moderation_tickets SET status = '" + dbType + "' WHERE Id = '" + Id + "' LIMIT 1");
                }
            }
        }

 /// <summary>
 /// create a new assembla ticket
 /// </summary>
 /// <param name="summary"></param>
 /// <param name="desc"></param>
 /// <param name="pri"></param>
 /// <param name="stat"></param>
 public AssemblaTicket(string summary, string desc, Priority pri, TicketStatus stat)
 {
     _stat = stat;
     _pri = pri;
     _sum = summary;
     _desc = desc;
 }

        public SupportTicket(uint Id, int Score, int Type, int CatagoryId, uint SenderId, uint ReportedId, string Message, uint RoomId, string RoomName, double Timestamp, object senderName, object reportedName, object modName)
        {
            this.Id = Id;
            this.Score = Score;
            this.Type = Type;
            CategoryId = CatagoryId;
            Status = TicketStatus.OPEN;
            this.SenderId = SenderId;
            this.ReportedId = ReportedId;
            ModeratorId = 0;
            this.Message = Message;
            this.RoomId = RoomId;
            this.RoomName = RoomName;
            this.Timestamp = Timestamp;

            if (senderName == DBNull.Value)
                SenderName = string.Empty;
            else
                SenderName = (string)senderName;

            if (reportedName == DBNull.Value)
                ReportedName = string.Empty;
            else
                ReportedName = (string)reportedName;

            if (modName == DBNull.Value)
                ModName = string.Empty;
            else
                ModName = (string)modName;
        }

        internal SupportTicket(UInt32 Id, int Score, int Type, UInt32 SenderId, UInt32 ReportedId, String Message, UInt32 RoomId, String RoomName, Double Timestamp, object senderName, object reportedName, object modName)
        {
            this.Id = Id;
            this.Score = Score;
            this.Type = Type;
            this.Status = TicketStatus.OPEN;
            this.SenderId = SenderId;
            this.ReportedId = ReportedId;
            this.ModeratorId = 0;
            this.Message = Message;
            this.RoomId = RoomId;
            this.RoomName = RoomName;
            this.Timestamp = Timestamp;

            if (senderName == DBNull.Value)
                this.SenderName = string.Empty;
            else
                this.SenderName = (string)senderName;

            if (reportedName == DBNull.Value)
                this.ReportedName = string.Empty;
            else
                this.ReportedName = (string)reportedName;

            if (modName == DBNull.Value)
                this.ModName = string.Empty;
            else
                this.ModName = (string)modName;
        }

 protected Ticket(IPerformance performance, TicketType type)
 {
     this.Performance = performance;
     this.Price = this.CalculatePrice();
     this.status = TicketStatus.Unsold;
     this.Type = type;
 }

        public TicketItemViewModel(string description, TicketStatus status = TicketStatus.Open, Action<object> removeAction = null)
        {
            removeAction = removeAction ?? (x => Console.WriteLine("NoOp."));
            Description = description;
            Status = status;

            RemoveItem = new ReactiveCommand();
            RemoveItem.Subscribe(removeAction);
        }

 public Ticket(long ticketnr, long klantnr, int verwachteReparatieTijd, double verwachteKosten, TicketStatus status, string afdelingsAfkorting, string probleem, string categorieNaam)
 {
     this.ticketnr = ticketnr;
     this.klantnr = klantnr;
     this.verwachteReparatieTijd = verwachteReparatieTijd;
     this.verwachteKosten = verwachteKosten;
     this.status = status;
     this.afdelingsAfkorting = afdelingsAfkorting;
     this.probleem = probleem;
     this.categorieNaam = categorieNaam;
 }

		public void Pick(uint ModeratorId, bool UpdateInDb)
		{
			Status = TicketStatus.PICKED;
			//ModeratorId = ModeratorId;
			ModName = PhoenixEnvironment.GetGame().GetClientManager().GetNameById(ModeratorId);
			if (UpdateInDb)
			{
				using (DatabaseClient adapter = PhoenixEnvironment.GetDatabase().GetClient())
				{
					adapter.ExecuteQuery("UPDATE moderation_tickets SET status = 'picked', moderator_id = '" + ModeratorId + "' WHERE Id = '" + Id + "' LIMIT 1");
				}
			}
		}

 public SupportTicket(uint Id, int Score, int Type, uint SenderId, uint ReportedId, string Message, uint RoomId, string RoomName, Double Timestamp)
 {
     this.Id = Id;
     this.Score = Score;
     this.Type = Type;
     this.Status = TicketStatus.OPEN;
     this.SenderId = SenderId;
     this.ReportedId = ReportedId;
     this.ModeratorId = 0;
     this.Message = Message;
     this.RoomId = RoomId;
     this.RoomName = RoomName;
     this.Timestamp = Timestamp;
 }

 public override bool CanChangeTo(TicketStatus toStatus)
 {
     switch (toStatus) {
         case TicketStatus.New:
             return false;
         case TicketStatus.Accepted:
             return true;
         case TicketStatus.Rejected:
             return false;
         case TicketStatus.Closed:
             return false;
         default:
             return false;
     }
 }

 internal SupportTicket(UInt32 Id, int Score, int Type, UInt32 SenderId, UInt32 ReportedId, String Message, UInt32 RoomId, String RoomName, Double Timestamp)
 {
     this.Id = Id;
     this.Score = Score;
     this.Type = Type;
     this.Status = TicketStatus.OPEN;
     this.SenderId = SenderId;
     this.ReportedId = ReportedId;
     this.ModeratorId = 0;
     this.Message = Message;
     this.RoomId = RoomId;
     this.RoomName = RoomName;
     this.Timestamp = Timestamp;
     this.SenderName = SilverwaveEnvironment.GetGame().GetClientManager().GetNameById(SenderId);
     this.ReportedName = SilverwaveEnvironment.GetGame().GetClientManager().GetNameById(ReportedId);
     this.ModName = SilverwaveEnvironment.GetGame().GetClientManager().GetNameById(ModeratorId);
 }

		public SupportTicket(uint mId, int mScore, int mType, uint mSenderId, uint mReportedId, string mMessage, uint mRoomId, string mRoomName, double mTimestamp, uint mModeratorId)
		{
			Id = mId;
			Score = mScore;
			Type = mType;
			Status = TicketStatus.OPEN;
			SenderId = mSenderId;
			ReportedId = mReportedId;
			ModeratorId = mModeratorId;
			Message = mMessage;
			RoomId = mRoomId;
			RoomName = mRoomName;
			Timestamp = mTimestamp;
			SenderName = PhoenixEnvironment.GetGame().GetClientManager().GetNameById(mSenderId);
			ReportedName = PhoenixEnvironment.GetGame().GetClientManager().GetNameById(mReportedId);
			ModName = PhoenixEnvironment.GetGame().GetClientManager().GetNameById(mModeratorId);
		}

 public SupportTicket(uint mId, int mScore, int mType, uint mSenderId, uint mReportedId, string mMessage, uint mRoomId, string mRoomName, double mTimestamp, uint mModeratorId)
 {
     this.Id = mId;
     this.Score = mScore;
     this.Type = mType;
     this.Status = TicketStatus.OPEN;
     this.SenderId = mSenderId;
     this.ReportedId = mReportedId;
     this.ModeratorId = mModeratorId;
     this.Message = mMessage;
     this.RoomId = mRoomId;
     this.RoomName = mRoomName;
     this.Timestamp = mTimestamp;
     this.string_2 = GoldTree.GetGame().GetClientManager().GetNameById(mSenderId);
     this.string_3 = GoldTree.GetGame().GetClientManager().GetNameById(mReportedId);
     this.string_4 = GoldTree.GetGame().GetClientManager().GetNameById(mModeratorId);
 }

		internal SupportTicket(uint Id, int Score, int Type, uint SenderId, uint ReportedId, string Message, uint RoomId, string RoomName, double Timestamp, List<string> ReportedChats)
		{
			this.Id = Id;
			this.Score = Score;
			this.Type = Type;
			this.Status = TicketStatus.OPEN;
			this.SenderId = SenderId;
			this.ReportedId = ReportedId;
			this.ModeratorId = 0u;
			this.Message = Message;
			this.RoomId = RoomId;
			this.RoomName = RoomName;
			this.Timestamp = Timestamp;
			this.SenderName = CyberEnvironment.GetGame().GetClientManager().GetNameById(SenderId);
			this.ReportedName = CyberEnvironment.GetGame().GetClientManager().GetNameById(ReportedId);
			this.ModName = CyberEnvironment.GetGame().GetClientManager().GetNameById(this.ModeratorId);
            this.ReportedChats = ReportedChats;
		}

        public static int Create(string space, string user, string password, string summary, string description, TicketStatus status, Priority priority)
        {
            int stat = (int)status;
            int pri = (int)priority;
            string url = GetTicketUrl(space);
                        StringBuilder data = new StringBuilder();
            data.AppendLine("<ticket>");
            data.AppendLine("<status>" + stat.ToString() + "</status>");
            data.AppendLine("<priority>" + pri.ToString() + "</priority>");
            data.AppendLine("<summary>");
            data.AppendLine(System.Web.HttpUtility.HtmlEncode(summary));
            data.AppendLine("</summary>");
            data.AppendLine("<description>");
            data.AppendLine(System.Web.HttpUtility.HtmlEncode(description));
            data.AppendLine("</description>");
            data.AppendLine("</ticket>");

            // prepare id
            int id = 0;
            string rs = string.Empty;
            try 
            {
                qc.gopost(url,user,password, data.ToString(),SendDebug, out rs);
                

                XmlDocument xd = new XmlDocument();
                xd.LoadXml(rs);
                XmlNodeList xnl = xd.GetElementsByTagName("id");
                string val = xnl[0].InnerText;
                if ((val != null) && (val != string.Empty))
                    id = Convert.ToInt32(val);
                // display it
                if (SendDebug != null)
                    SendDebug(rs);
            }
            catch (Exception ex)
            {
                if (SendDebug != null)
                    SendDebug("error on data: "+rs+" err: " + ex.Message + ex.StackTrace);
                return 0;
            }
            return id;
        }

        public SupportTicket(int Id, int Score, int Type, int Category, int SenderId, int ReportedId, String Message, int RoomId, String RoomName, Double Timestamp, List<string> ReportedChats)
        {
            this.Id = Id;
            this.Score = Score;
            this.Type = Type;
            this.Category = Category;
            this.Status = TicketStatus.OPEN;
            this.SenderId = SenderId;
            this.ReportedId = ReportedId;
            ModeratorId = 0;
            this.Message = Message;
            this.RoomId = RoomId;
            this.RoomName = RoomName;
            this.Timestamp = Timestamp;
            this.ReportedChats = ReportedChats;

            SenderName = PlusEnvironment.GetGame().GetClientManager().GetNameById(SenderId);
            ReportedName = PlusEnvironment.GetGame().GetClientManager().GetNameById(ReportedId);
            ModName = PlusEnvironment.GetGame().GetClientManager().GetNameById(ModeratorId);
        }

		internal void Pick(uint pModeratorId, bool UpdateInDb)
		{
			this.Status = TicketStatus.PICKED;
			this.ModeratorId = pModeratorId;
			this.ModName = CyberEnvironment.getHabboForId(pModeratorId).Username;
			if (UpdateInDb)
			{
				using (IQueryAdapter queryreactor = CyberEnvironment.GetDatabaseManager().getQueryReactor())
				{
					queryreactor.runFastQuery(string.Concat(new object[]
					{
						"UPDATE moderation_tickets SET status = 'picked', moderator_id = ",
						pModeratorId,
						", timestamp = '",
						CyberEnvironment.GetUnixTimestamp(),
						"' WHERE id = ",
						this.Id
					}));
				}
			}
		}

        /// <summary>
        /// Creates shiny new modules that are not referenced / altered by other methods.
        /// </summary>
        /// <returns></returns>
        private TicketStatus NewStatus()
        {
            //Initialize a basic module object.
            TicketStatus Status = new TicketStatus();
            Status.Description = "This is my status descrition";
            Status.IsActive = true;
            Status.Name = "Ticket Status Name";
            Status.StatusOrder = 1;

            return Status;
        }

 /// <summary>
 /// Helper method to insert values into the database.  If successful, it will set teh appropriate row id.
 /// </summary>
 /// <param name="Module"></param>
 private void InsertStatusIntoDatabase(TicketStatus Status)
 {
     HelpdeskService.CreateStatus(Status);
 }

 void Response_SendTicketEvent(string space, string user, string password, string summary, string description, Priority pri, TicketStatus stat)
 {
     if (_sendticketwarn) return;
     debug("Sendticket not supported in gauntlet.");
     _sendticketwarn = true;
 }