public static void Initialize(VegiContext db, IHostingEnvironment env)
{
db.Database.EnsureCreated();
if (db.Categories.Any() || db.Dishes.Any())
{
return;
}
var path = Path.Combine(env.ContentRootPath, "data");
var dishesJson = File.ReadAllText(Path.Combine(path, "dishes.json"));
var categoriesJson = File.ReadAllText(Path.Combine(path, "categories.json"));
var dishes = JsonConvert.DeserializeObject <List <Dish> >(dishesJson);
var categories = JsonConvert.DeserializeObject <List <Category> >(categoriesJson);
foreach (var category in categories)
{
foreach (var dish in dishes.Where(x => x.CategoryId == category.Id))
{
dish.Id = 0;
category.Dishes.Add(dish);
}
category.Id = 0;
db.Categories.Add(category);
}
db.SaveChanges();
}
protected override void OnAppearing()
{
base.OnAppearing();
using (var db = new VegiContext())
{
CategoriesListView.ItemsSource = db.Categories.ToList();
}
}
protected override void OnAppearing()
{
base.OnAppearing();
using (var db = new VegiContext())
{
DishesListView.ItemsSource = db.Dishes.Where(x => x.CategoryId == _category.Id).ToList();
}
}
protected override void OnStart()
{
SQLitePCL.Batteries_V2.Init();
// Handle when your app starts
using (var db = new VegiContext())
{
DbInitializer.Initialize(db);
}
}
public List <GrowableItem> GetAllGrowableItems()
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.GrowableItems
orderby g.GrowableItemID
select g).ToList();
return(query);
}
}
public List <Humidity> GetAllHumidity()
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Humidity
orderby g.HumidityID
select g).ToList();
return(query);
}
}
public List <Light> GetAllLight()
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Light
orderby g.LightID
select g).ToList();
return(query);
}
}
public List <Temperature> GetAllTemperature()
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Temperature
orderby g.TemperatureID
select g).ToList();
return(query);
}
}
public List <User> GetAllUsers()
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Users
orderby g.UserId
select g).ToList();
return(query);
}
}
public Humidity GetHumidityById(int id)
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Humidity
where g.HumidityID == id
orderby g.HumidityID
select g).FirstOrDefault();
return(query);
}
}
public Temperature GetTemperatureById(int id)
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Temperature
where g.TemperatureID == id
orderby g.TemperatureID
select g).FirstOrDefault();
return(query);
}
}
public GrowableItem GetGrowableItemById(int id)
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.GrowableItems
where g.GrowableItemID == id
orderby g.GrowableItemID
select g).FirstOrDefault();
return(query);
}
}
public Light GetLightById(int id)
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Light
where g.LightID == id
orderby g.LightID
select g).FirstOrDefault();
return(query);
}
}
public User GetUserById(int id)
{
using (VegiContext db = new VegiContext())
{
var query = (from g in db.Users
where g.UserId == id
orderby g.UserId
select g).FirstOrDefault();
return(query);
}
}
public static void Initialize(VegiContext db)
{
db.Database.EnsureCreated();
if (db.Categories.Any() || db.Dishes.Any())
{
return;
}
var dishesJson = GetResourceString("dishes.json");
var categoriesJson = GetResourceString("categories.json");
var dishes = JsonConvert.DeserializeObject <List <Dish> >(dishesJson);
var categories = JsonConvert.DeserializeObject <List <Category> >(categoriesJson);
foreach (var category in categories)
{
foreach (var dish in dishes.Where(x => x.CategoryId == category.Id))
{
category.Dishes.Add(dish);
}
db.Categories.Add(category);
}
db.SaveChanges();
}
public EfDishRepository(VegiContext db)
{
_db = db;
}
public EfDishRepository(VegiContext vegiContext)
{
_vegiContext = vegiContext;
}
public EfDishRespository(VegiContext context)
{
_context = context;
}
public EfCategoryRespository(VegiContext context)
{
_context = context;
}
public EfCategoryRepository(VegiContext db)
{
_db = db;
}
// 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, VegiContext db)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
DbInitializer.Initialize(db, env);
app.UseDefaultFiles();
app.UseStaticFiles();
app.UseMvc();
}
public EfCategoryRepository(VegiContext vegiContext)
{
_vegiContext = vegiContext;
}
