Exemplo n.º 1
0
        private void InsertUser(SQLiteConnection conn)
        {
            UserDO user1 = new UserDO()
            {
            };

            conn.Insert(user1);
        }
Exemplo n.º 2
0
        public static UserDO GetLastUser(SQLiteConnection conn)
        {
            DateTime      today    = DateTime.Today;
            UserDO        Lastuser = new UserDO();
            string        Query    = "select * from user where ExpiryDate>'" + today + "'";
            List <UserDO> user     = conn.Query <UserDO>(Query);

            if (user != null && user.Count > 0)
            {
                Lastuser = user [0];
            }
            else
            {
                Lastuser = null;
            }
            return(Lastuser);
        }