private void newFoodButton_Click(object sender, EventArgs e)
{
string foodName = foodComboBox.Text;
int foodId = (from f in ctx.Food1 where (f.Food_Name == foodName) select f.Food_Id).First();
SpeciesFood speciesFood = new SpeciesFood();
speciesFood.Food_Id = foodId;
speciesFood.Species_Id = species_Id;
speciesFoodBindingSource.DataSource = ctx.SpeciesFood.Local.ToBindingList();
speciesFoodBindingSource.Add(speciesFood);
ctx.SaveChanges();
LoadData();
}
private void foodDeletebutton_Click(object sender, EventArgs e)
{
try
{
SpeciesFood speciesFood = (SpeciesFood)foodDataGridView.CurrentRow.DataBoundItem;
speciesFoodBindingSource.DataSource = ctx.SpeciesFood.Local.ToBindingList();
speciesFoodBindingSource.Remove(speciesFood);
ctx.SaveChanges();
LoadData();
}
catch (Exception)
{
MessageBox.Show("Помилка видалення");
}
}
public async Task <IActionResult> Create([Bind("Name,LifeTime,Temperature")] Species species, string[] selectedFood)
{
species.ID = Guid.NewGuid().GetHashCode();
if (selectedFood != null)
{
species.SpeciesFood = new List <SpeciesFood>();
foreach (var food in selectedFood)
{
var foodToAdd = new SpeciesFood {
SpeciesID = species.ID, FoodID = int.Parse(food), ID = Guid.NewGuid().GetHashCode()
};
species.SpeciesFood.Add(foodToAdd);
}
}
if (ModelState.IsValid)
{
_context.Add(species);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(species));
}
private void UpdateSpeciesFood(string[] selectedFood, Species speciesToUpdate)
{
if (selectedFood == null)
{
speciesToUpdate.SpeciesFood = new List <SpeciesFood>();
return;
}
var selectedFoodHS = new HashSet <string>(selectedFood);
var speciesFood = new HashSet <int>
(speciesToUpdate.SpeciesFood.Select(sf => sf.Food.ID));
foreach (var food in _context.Food)
{
if (selectedFoodHS.Contains(food.ID.ToString()))
{
if (!speciesFood.Contains(food.ID))
{
SpeciesFood newElement = new SpeciesFood {
SpeciesID = speciesToUpdate.ID, FoodID = food.ID, ID = Guid.NewGuid().GetHashCode()
};
speciesToUpdate.SpeciesFood.Add(newElement);
_context.SpeciesFood.Add(newElement);
}
}
else
{
if (speciesFood.Contains(food.ID))
{
SpeciesFood foodToRemove = speciesToUpdate.SpeciesFood.FirstOrDefault(i => i.FoodID == food.ID);
_context.Remove(foodToRemove);
}
}
}
_context.SaveChanges();
}
public static void Initialize(AnimalsContext context)
{
context.Database.EnsureCreated();
if (context.Animals.Any())
{
return;
}
var shops = new Shop[]
{
new Shop {
ID = 1, Name = "Ваші тварини", Adress = "вул.Сеченова,буд 6"
},
new Shop {
ID = 2, Name = "Дикі друзі", Adress = "вул.Володимирська,буд.60"
}
};
foreach (Shop s in shops)
{
context.Shops.Add(s);
}
context.SaveChanges();
var cages = new Cage[]
{
new Cage {
ID = 1, ShopID = 1, Number = 1, Square = 20
},
new Cage {
ID = 2, ShopID = 1, Number = 2, Square = 30
},
new Cage {
ID = 3, ShopID = 2, Number = 3, Square = 20
},
new Cage {
ID = 4, ShopID = 2, Number = 4, Square = 25
},
new Cage {
ID = 5, ShopID = 2, Number = 5, Square = 40
},
};
foreach (Cage c in cages)
{
context.Cages.Add(c);
}
context.SaveChanges();
var colors = new Color[]
{
new Color {
ID = 1, Name = "білий"
},
new Color {
ID = 2, Name = "чорний"
},
new Color {
ID = 3, Name = "зелений"
},
new Color {
ID = 4, Name = "рудий"
},
new Color {
ID = 5, Name = "двокольоровий"
},
new Color {
ID = 6, Name = "без кольору"
},
new Color {
ID = 7, Name = "трикольоровий"
},
new Color {
ID = 8, Name = "коричневий"
},
new Color {
ID = 9, Name = "сірий"
},
new Color {
ID = 10, Name = "золотий"
}
};
foreach (Color c in colors)
{
context.Colors.Add(c);
}
context.SaveChanges();
var food = new Food[]
{
new Food {
ID = 1, Name = "трава"
},
new Food {
ID = 2, Name = "корм\"Ваше цуценя\""
},
new Food {
ID = 3, Name = "корм\"Ваше кошеня\""
},
new Food {
ID = 4, Name = "корм\"Ваша рибка\""
},
new Food {
ID = 5, Name = "м'ясо"
},
new Food {
ID = 6, Name = "капуста"
},
new Food {
ID = 7, Name = "молоко"
},
new Food {
ID = 8, Name = "корм\"Ваш гризун\""
},
new Food {
ID = 9, Name = "зерно"
},
new Food {
ID = 10, Name = "морква"
}
};
foreach (Food f in food)
{
context.Food.Add(f);
}
context.SaveChanges();
var species = new Species[]
{ new Species {
ID = 1, Name = "кіт", LifeTime = 18, Temperature = 20
},
new Species {
ID = 2, Name = "собака", LifeTime = 19, Temperature = 19
},
new Species {
ID = 3, Name = "коза", LifeTime = 16, Temperature = 21
},
new Species {
ID = 4, Name = "рибка", LifeTime = 1, Temperature = 25
},
new Species {
ID = 5, Name = "хом'як", LifeTime = 2, Temperature = 22
} };
foreach (Species s in species)
{
context.Species.Add(s);
}
context.SaveChanges();
var speciesfood = new SpeciesFood[]
{ new SpeciesFood {
ID = 1, SpeciesID = 1, FoodID = 5
},
new SpeciesFood {
ID = 2, SpeciesID = 1, FoodID = 3
},
new SpeciesFood {
ID = 3, SpeciesID = 1, FoodID = 7
},
new SpeciesFood {
ID = 4, SpeciesID = 2, FoodID = 5
},
new SpeciesFood {
ID = 5, SpeciesID = 2, FoodID = 2
},
new SpeciesFood {
ID = 6, SpeciesID = 3, FoodID = 1
},
new SpeciesFood {
ID = 7, SpeciesID = 3, FoodID = 6
},
new SpeciesFood {
ID = 8, SpeciesID = 3, FoodID = 10
},
new SpeciesFood {
ID = 9, SpeciesID = 4, FoodID = 4
},
new SpeciesFood {
ID = 10, SpeciesID = 5, FoodID = 9
},
new SpeciesFood {
ID = 11, SpeciesID = 5, FoodID = 8
},
new SpeciesFood {
ID = 12, SpeciesID = 5, FoodID = 10
} };
foreach (SpeciesFood sf in speciesfood)
{
context.SpeciesFood.Add(sf);
}
context.SaveChanges();
var animals = new Animal[]
{
new Animal {
ID = 1, Name = "Мурка", Sex = 'Ж', ShopID = 1, CageID = 1, SpeciesID = 1, Date = DateTime.Parse("2018-09-01"), ColorID = 1, Price = 100
},
new Animal {
ID = 2, Name = "Мурчик", Sex = 'Ч', ShopID = 2, CageID = 4, SpeciesID = 1, Date = DateTime.Parse("2018-12-10"), ColorID = 5, Price = 150
},
new Animal {
ID = 3, Name = "Ксюша", Sex = 'Ж', ShopID = 1, CageID = 2, SpeciesID = 3, Date = DateTime.Parse("2018-01-23"), ColorID = 2, Price = 10
},
new Animal {
ID = 4, Name = "Шарік", Sex = 'Ч', ShopID = 2, CageID = 5, SpeciesID = 2, Date = DateTime.Parse("2019-02-01"), ColorID = 4, Price = 250
},
new Animal {
ID = 5, Name = "", Sex = 'Ж', ShopID = 1, CageID = 2, SpeciesID = 4, Date = DateTime.Parse("2019-03-10"), ColorID = 10, Price = 50
},
new Animal {
ID = 6, Name = "Хома", Sex = 'Ч', ShopID = 2, CageID = 3, SpeciesID = 5, Date = DateTime.Parse("2018-12-21"), ColorID = 4, Price = 20
}
};
foreach (Animal a in animals)
{
context.Animals.Add(a);
}
try
{
context.SaveChanges();
}
catch (Exception e)
{ }
}
