private static IQueryPart GetNotebooksByCPUNameQuery(string name)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByCpuName);
getNotebook.AddParameter("$name", "%" + name + "%");
return(getNotebook);
}
private static IQueryPart GetNotebooksByOsQuery(OS os)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByOS);
getNotebook.AddParameter("$os", "%" + os.ToString() + "%");
return(getNotebook);
}
private static IQueryPart GetNotebooksByGraphicCardName(string name)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByGraphicCardName);
getNotebook.AddParameter("$graphicCardName", "%" + name + "%");
return(getNotebook);
}
private static IQueryPart GetNotebooksByVRAMMemory(Range memory)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByVRAMMemory);
getNotebook.AddParameter("$minVRAM", memory.Min);
getNotebook.AddParameter("$maxVRAM", memory.Max);
return(getNotebook);
}
private static IQueryPart GetNotebooksByhardDriveType(string type)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByHardDriveType);
getNotebook.AddParameter("$type", "%" + type + "%");
return(getNotebook);
}
private static IQueryPart GetNotebooksByhardDriveMemory(Range size)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByHardDriveSize);
getNotebook.AddParameter("$minSize", size.Min);
getNotebook.AddParameter("$maxSize", size.Max);
return(getNotebook);
}
private static IQueryPart GetNotebooksByCPUClockRateQuery(Range clockRate)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksCpuClockRate);
getNotebook.AddParameter("$minClockRate", clockRate.Min);
getNotebook.AddParameter("$maxClockRate", clockRate.Max);
return(getNotebook);
}
private static IQueryPart GetNotebooksByCpuCountQuery(Range cpuCount)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByCpuCount);
getNotebook.AddParameter("$minCount", cpuCount.Min);
getNotebook.AddParameter("$maxCount", cpuCount.Max);
return(getNotebook);
}
private static IQueryPart GetNotebooksByRAMQuery(Range ram)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByRAM);
getNotebook.AddParameter("$minRam", ram.Min);
getNotebook.AddParameter("$maxRam", ram.Max);
return(getNotebook);
}
private static IQueryPart GetNotebooksByBatteryTimeQuery(Range time)
{
MySqliteQueryPart getNotebook = new MySqliteQueryPart(CommandGetNotebooksByBatteryTime);
getNotebook.AddParameter("$minTime", time.Min);
getNotebook.AddParameter("$maxTime", time.Max);
return(getNotebook);
}
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);
}