WhatForensics.WAMessage.WAMessage C# (CSharp) Method

        public WAMessage(int messagePrimaryKey, string connectionString)
        {
            SQLiteConnection connection = new SQLiteConnection(connectionString);
            SQLiteCommand command = new SQLiteCommand("select *, datetime(zmessagedate, 'unixepoch', 'localtime') from zwamessage where z_pk = " + messagePrimaryKey.ToString() + " limit 1 offset 0", connection);

            connection.Open();
            SQLiteDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                Z_PK = Convert.ToInt32(reader[0]);
                Z_ENT = Convert.ToInt32(reader[1]);
                Z_OPT = Convert.ToInt32(reader[2]);
                Z_GROUPEVENTTYPE = Convert.ToInt32(reader[3]);
                ZISFROMME = Convert.ToInt32(reader[4]);
                ZMESSAGESTATUS = Convert.ToInt32(reader[5]);
                ZMESSAGETYPE = Convert.ToInt32(reader[6]);
                ZSORT = Convert.ToInt32(reader[7]);
                ZCHATSESSION = Convert.ToInt32(reader[8]);

                if (!(reader[9] is DBNull))
                {
                    ZGROUPMEMBER = Convert.ToInt32(reader[9]);
                }

                //ZGROUPMEMBER = Convert.ToInt32(reader[9]);

                if (!(reader[10] is DBNull))
                {
                    ZLASTSESSION = Convert.ToInt32(reader[10]);
                }

                if (!(reader[11] is DBNull))
                {
                    ZMEDIAITEM = reader[11].ToString();
                }

                //ZMESSAGEDATE = reader[12].ToString(); // Fix date later

                //ZMESSAGEDATE = reader.GetDataTypeName(12);

                ZMESSAGEDATE = (reader[18].ToString());
                //System.Windows.Forms.MessageBox.Show(MiscHelper.HandleWeirdEpochAddTimezoneInformation(ZMESSAGEDATE));
                //System.Windows.Forms.MessageBox.Show(test.ToLongTimeString());

                //System.Windows.Forms.MessageBox.Show(reader[12].ToString());
                //ZMESSAGEDATE = new DateTime(Convert.ToInt64(reader[12]) );
                ZFROMJID = reader[13].ToString();

                if (!(reader[14] is DBNull))
                {
                    ZPUSHNAME = reader[14].ToString();
                }

                ZPUSHNAME = reader[14].ToString();
                ZSTANZAID = reader[15].ToString();
                ZTEXT = reader[16].ToString();
                ZTOJID = reader[17].ToString();

            }
            reader.Close();
            MessageLoaded = true;
        }