private void InsertUser(SQLiteConnection conn) { UserDO user1 = new UserDO() { }; conn.Insert(user1); }
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); }