Exemple #1
0
        private static IQueryPart GetNotebooksByCPUNameQuery(string name)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByCpuName);

            getNotebook.AddParameter("$name", "%" + name + "%");
            return(getNotebook);
        }
Exemple #2
0
        private static IQueryPart GetNotebooksByOsQuery(OS os)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByOS);

            getNotebook.AddParameter("$os", "%" + os.ToString() + "%");
            return(getNotebook);
        }
Exemple #3
0
        private static IQueryPart GetNotebooksByGraphicCardName(string name)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByGraphicCardName);

            getNotebook.AddParameter("$graphicCardName", "%" + name + "%");

            return(getNotebook);
        }
Exemple #4
0
        private static IQueryPart GetNotebooksByVRAMMemory(Range memory)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByVRAMMemory);

            getNotebook.AddParameter("$minVRAM", memory.Min);
            getNotebook.AddParameter("$maxVRAM", memory.Max);
            return(getNotebook);
        }
Exemple #5
0
        private static IQueryPart GetNotebooksByhardDriveType(string type)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByHardDriveType);

            getNotebook.AddParameter("$type", "%" + type + "%");

            return(getNotebook);
        }
Exemple #6
0
        private static IQueryPart GetNotebooksByhardDriveMemory(Range size)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByHardDriveSize);

            getNotebook.AddParameter("$minSize", size.Min);
            getNotebook.AddParameter("$maxSize", size.Max);
            return(getNotebook);
        }
Exemple #7
0
        private static IQueryPart GetNotebooksByCPUClockRateQuery(Range clockRate)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksCpuClockRate);

            getNotebook.AddParameter("$minClockRate", clockRate.Min);
            getNotebook.AddParameter("$maxClockRate", clockRate.Max);
            return(getNotebook);
        }
Exemple #8
0
        private static IQueryPart GetNotebooksByCpuCountQuery(Range cpuCount)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByCpuCount);

            getNotebook.AddParameter("$minCount", cpuCount.Min);
            getNotebook.AddParameter("$maxCount", cpuCount.Max);
            return(getNotebook);
        }
Exemple #9
0
        private static IQueryPart GetNotebooksByRAMQuery(Range ram)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByRAM);

            getNotebook.AddParameter("$minRam", ram.Min);
            getNotebook.AddParameter("$maxRam", ram.Max);
            return(getNotebook);
        }
Exemple #10
0
        private static IQueryPart GetNotebooksByBatteryTimeQuery(Range time)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByBatteryTime);

            getNotebook.AddParameter("$minTime", time.Min);
            getNotebook.AddParameter("$maxTime", time.Max);
            return(getNotebook);
        }
Exemple #11
0
        private static IQueryPart GetNotebooksByPriceQuery(PriceRange range)
        {
            MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByPriceSubQuery);

            getNotebook.AddParameter("$minPrice", range.Min.Amount);
            getNotebook.AddParameter("$maxPrice", range.Max.Amount);
            return(getNotebook);
        }
        private static IQueryPart GetProductsByPriceQuery(PriceRange range)
        {
            MySqliteQueryPart getProduct = new MySqliteQueryPart(CommandGetProductsByPriceQuery);

            getProduct.AddParameter("$minProductPrice", range.Min.Amount);
            getProduct.AddParameter("$maxProductPrice", range.Max.Amount);
            return(getProduct);
        }
        private static IQueryPart GetProductsByName(string name)
        {
            MySqliteQueryPart getProduct = new MySqliteQueryPart(CommandGetProductsByName);

            getProduct.AddParameter("$productName", "%" + name + "%");

            return(getProduct);
        }