public RecipeToCategory GetCategory(Recipe recipe)
{
using (var sqlConnection = new SqlConnection(_dbPath))
{
sqlConnection.Open();
var sqlCommand = new SqlCommand("SELECT RecipeCategoryID FROM RC WHERE " +
$"RecipeID={recipe.Id}", sqlConnection);
var sqlDataReader = sqlCommand.ExecuteReader();
try
{
var recipeCategoryModel = new RecipeCategoryModel(_dbPath);
var recipeToCategories = new List <RecipeToCategory>();
if (sqlDataReader.Read())
{
var recipeToCategory = new RecipeToCategory
{
Recipe = recipe,
RecipeCategory = recipeCategoryModel.GetRecipeCategory((int)sqlDataReader[0])
};
return(recipeToCategory);
}
}
finally
{
sqlDataReader.Close();
}
}
return(null);
}
public List <RecipeToCategory> GetRecipes(RecipeCategory recipeCategory)
{
using (var sqlConnection = new SqlConnection(_dbPath))
{
sqlConnection.Open();
var sqlCommand = new SqlCommand("SELECT RecipeID FROM RC WHERE " +
$"RecipeCategoryID={recipeCategory.Id}", sqlConnection);
var sqlDataReader = sqlCommand.ExecuteReader();
try
{
var recipeModel = new RecipeModel(_dbPath);
var recipeToCategories = new List <RecipeToCategory>();
while (sqlDataReader.Read())
{
var recipeToCategory = new RecipeToCategory
{
Recipe = recipeModel.GetRecipe((int)sqlDataReader[0]),
RecipeCategory = recipeCategory
};
recipeToCategories.Add(recipeToCategory);
}
return(recipeToCategories);
}
finally
{
sqlDataReader.Close();
}
}
}