private SQLiteCommand CommandBuilder(string aTitle, CatType aCategory)
{
var selectCommand = new SQLiteCommand();
if (aCategory.GetType() == typeof(Category))
{
selectCommand.CommandText = searchCatQuery;
selectCommand.Parameters.AddWithValue("@cat", (int)((Category)aCategory).CatType);
}
else if (aCategory.GetType() == typeof(SubCategory))
{
selectCommand.CommandText = searchSubCatQuery;
selectCommand.Parameters.AddWithValue("@subcat", (int)((SubCategory)aCategory).SubCatType);
}
else
{
selectCommand.CommandText = searchQuery;
}
selectCommand.Parameters.AddWithValue("@animeTitle", aTitle);
return(selectCommand);
}
