C# (CSharp) PrototypeBeta.SQLite Recent_Search_Table Examples

Example #1

 public static void addRecentSearch(Recent_Search_Table recentSeachRecord)
 {
     if (!checkExistRecentSearch(recentSeachRecord))
     {
         handleExceedMaxLimit();
         dbConn.Insert(recentSeachRecord);
     }
 }

Example #2

        static bool checkExistRecentSearch(Recent_Search_Table recentSeachRecord)
        {
            List <Recent_Search_Table> resultsList = dbConn.Query <Recent_Search_Table>(SQL.querycheckExistRecentSearch, recentSeachRecord.startStationId, recentSeachRecord.endStationId, recentSeachRecord.startTime, recentSeachRecord.endTime);

            if (resultsList.Count > 0)
            {
                return(true);
            }

            return(false);
        }

Example #3

 public static void removeRecentSearch(Recent_Search_Table recentSeachRecord)
 {
     dbConn.Delete(recentSeachRecord);
 }