public List <Composition> GetList()
{
using (var context = new CookBookContext())
{
return(context.Compositions.ToList());
}
}
public List <Ingredient> GetList()
{
using (var context = new CookBookContext())
{
return(context.Ingredients.ToList());
}
}
public Recipe GetItem(Guid id)
{
using (var context = new CookBookContext())
{
return(context.Recipes.FirstOrDefault(x => x.Id == id));
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseIdentity();
app.UseDefaultFiles();
app.UseStaticFiles();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
var context = new CookBookContext();
context.Database.Migrate();
}
public List <Review> GetList()
{
using (var context = new CookBookContext())
{
return(context.Reviews.ToList());
}
}
private void UseContext(Action <ICookBookContext> action)
{
using (var context = new CookBookContext(_options))
{
action(context);
}
}
public List <User> GetList()
{
using (var context = new CookBookContext())
{
return(context.Users.ToList());
}
}
public void AddRange(List <Review> items)
{
using (var context = new CookBookContext())
{
context.Reviews.AddRange(items);
context.SaveChanges();
}
}
public void AddRange(List <Composition> items)
{
using (var context = new CookBookContext())
{
context.Compositions.AddRange(items);
context.SaveChanges();
}
}
public void Add(Composition item)
{
using (var context = new CookBookContext())
{
context.Compositions.Add(item);
context.SaveChanges();
}
}
public void AddRange(List <Ingredient> items)
{
using (var context = new CookBookContext())
{
context.Ingredients.AddRange(items);
context.SaveChanges();
}
}
public void Add(Review item)
{
using (var context = new CookBookContext())
{
context.Reviews.Add(item);
context.SaveChanges();
}
}
public void AddRange(List <User> items)
{
using (var context = new CookBookContext())
{
context.Users.AddRange(items);
context.SaveChanges();
}
}
public void Add(User item)
{
using (var context = new CookBookContext())
{
context.Users.Add(item);
context.SaveChanges();
}
}
public List <T> GetList()
{
using (var context = new CookBookContext())
{
var dbSet = context.Set <T>();
return(dbSet.AsNoTracking().ToList());
}
}
public object[] BrowseRecipeSteps(int selectedRecipeId)
{
Console.WriteLine("Cliecked");
using (var context = new CookBookContext())
{
try
{
object result = context.RecipeSteps.Where(rs => rs.recipeId == selectedRecipeId).ToArray();
return(context.RecipeSteps.Where(rs => rs.recipeId == selectedRecipeId).ToArray());
}
catch (Exception e)
{
Console.WriteLine("Error connecting to database: " + e.Message);
return(new object[] { });
}
}
//using (MySqlConnection connection = GetMySqlConnection())
//{
// try
// {
// connection.Open();
// string querySteps = "SELECT rs.stepNumber, rs.stepInstructions FROM recipes r JOIN recipe_steps rs on r.id = rs.recipeId WHERE r.id = @Id";
// MySqlCommand getSteps = new MySqlCommand(querySteps, connection);
// getSteps.Parameters.Add(new MySqlParameter("Id", selectedRecipeId));
// MySqlDataReader stepsReader;
// stepsReader = getSteps.ExecuteReader();
// while (stepsReader.Read())
// {
// int stepNumber = stepsReader.GetInt32(0);
// String stepInstruction = stepsReader.GetString(1);
// // create instance of RecipeStepsUIModel and add it to a list or array
// var recipeStep = new RecipeStepItem { stepNumber=stepNumber, stepInstruction=stepInstruction};
// // recipeStepList.push(recipeStep)
// //Console.WriteLine("Step #: {0} | Step Instruction: {1}", stepNumber, stepInstruction);
// }
// stepsReader.Close();
// connection.Close();
// return new object[] { };
// }
// catch (Exception e)
// {
// Console.WriteLine("Error connecting to database: " + e.Message);
// return new object[] { };
// }
//}
}
public Guid Add(Ingredient item)
{
using (var context = new CookBookContext())
{
context.Ingredients.Add(item);
context.SaveChanges();
return(item.Id);
}
}
public void Delete(Guid id)
{
using (var context = new CookBookContext())
{
if (id != null)
{
context.Reviews.Remove(context.Reviews.FirstOrDefault(x => x.Id == id));
context.SaveChanges();
}
}
}
public void Update(Review item)
{
using (var context = new CookBookContext())
{
if (item != null)
{
context.Entry(item).State = EntityState.Modified;
context.SaveChanges();
}
}
}
public void AddRange(List <T> items)
{
using (var context = new CookBookContext())
{
if (items != null)
{
var dbSet = context.Set <T>();
dbSet.AddRange(items);
context.SaveChanges();
}
}
}
public void Delete(T item)
{
using (var context = new CookBookContext())
{
if (item != null)
{
var dbSet = context.Set <T>();
dbSet.Remove(item);
context.SaveChanges();
}
}
}
public static IHost MigrateDatabase(this IHost host)
{
using (IServiceScope scope = host.Services.CreateScope())
{
using CookBookContext appContext = scope.ServiceProvider.GetRequiredService <CookBookContext>();
try
{
appContext.Database.Migrate();
}
catch
{
}
}
return(host);
}
public void TestRemoveBatchSqlProvider()
{
var builder = new DbContextOptionsBuilder <CookBookContext>();
builder.UseSqlServer("Data Source=.")
.MaxBatchSize(10)
.CommandTimeout(10);
using (var context = new CookBookContext(builder.Options))
{
var books = context.Book.ToList();
context.RemoveRange(books.Where(e => e.Name == "Sql Batch").ToArray());
context.SaveChanges();
}
}
public object[] BrowseRecipeSteps()
{
using (var context = new CookBookContext())
{
try
{
object result = context.RecipeSteps.ToArray();
return(context.RecipeSteps.ToArray());
}
catch (Exception e)
{
Console.WriteLine("Error connecting to database: " + e.Message);
return(new object[] { });
}
}
}
public object[] BrowseIngredients()
{
using (var context = new CookBookContext())
{
try
{
return(context.Ingredients.ToArray());
}
catch (Exception ex)
{
Console.WriteLine("Could not retrieve ingredients");
Console.WriteLine(ex.Message);
return(new object[] { });
}
}
}
// get the RecipeIngredient from both, recipeId and ingredientId
public object ReadRecipeIngredient(Recipe selectedRecipe, Ingredient selectedRecipeIngredient)
{
if (selectedRecipe == null || selectedRecipeIngredient == null)
{
return(false);
}
using (var context = new CookBookContext())
{
try
{
return(context.RecipeIngredients.FirstOrDefault(e => (e.Id == selectedRecipe.Id && e.ingredientId == selectedRecipeIngredient.Id)));
}
catch (Exception ex)
{
Console.WriteLine("Could not read Recipe Ingredient");
Console.WriteLine(ex.Message);
return(null);
}
}
}
public void TestBatchSqlProvider()
{
var builder = new DbContextOptionsBuilder <CookBookContext>();
builder.UseSqlServer("Data Source=.")
.MaxBatchSize(10)
.CommandTimeout(10);
using (var context = new CookBookContext(builder.Options))
{
var bookAzureSql = new Book()
{
Name = "Azure Sql", Recipes = new List <Recipe>()
};
var bookAzureRedis = new Book()
{
Name = "Azure Redis", Recipes = new List <Recipe>()
};
var bookSqlBatch1 = new Book()
{
Name = "Sql Batch 1", Recipes = new List <Recipe>()
};
var bookSqlBatch2 = new Book()
{
Name = "Sql Batch 2", Recipes = new List <Recipe>()
};
var bookSqlBatch3 = new Book()
{
Name = "Sql Batch 3", Recipes = new List <Recipe>()
};
var bookSqlBatch4 = new Book()
{
Name = "Sql Batch 4", Recipes = new List <Recipe>()
};
context.Book.AddRange(bookAzureSql, bookAzureRedis, bookSqlBatch1, bookSqlBatch2, bookSqlBatch3, bookSqlBatch4);
context.SaveChanges();
}
}
public object ReadRecipeStep(RecipeStep recipeStep)
{
if (recipeStep == null)
{
return(false);
}
using (var context = new CookBookContext())
{
try
{
return(context.RecipeSteps.FirstOrDefault(e => e.Id == recipeStep.Id || e.stepInstructions == recipeStep.stepInstructions));
}
catch (Exception ex)
{
Console.WriteLine("Could not read Recipe step");
Console.WriteLine(ex.Message);
return(null);
}
}
}
public object ReadIngredient(Ingredient ingredient)
{
if (ingredient == null)
{
return(false);
}
using (var context = new CookBookContext())
{
try
{
return(context.Ingredients.FirstOrDefault(e => e.Id == ingredient.Id || e.name == ingredient.name));
}
catch (Exception ex)
{
Console.WriteLine("Could not read ingredient");
Console.WriteLine(ex.Message);
return(null);
}
}
}
public object ReadRecipe(Recipe recipe)
{
if (recipe == null)
{
return(false);
}
using (var context = new CookBookContext())
{
try
{
return(context.Recipes.FirstOrDefault(e => e.Id == recipe.Id || e.name == recipe.name));
}
catch (Exception ex)
{
Console.WriteLine("Could not read recipe");
Console.WriteLine(ex.Message);
return(null);
}
}
}
