static void Main(string[] args)
{
AnimalData db = new AnimalData();
using (db) //safely closing all connections to database
{
//AnimalInfo SuffolkF = new AnimalInfo() { ID = 200, TBTesting = true };
//AnimalInfo SuffolkM = new AnimalInfo() { ID = 201, TBTesting = true };
//AnimalInfo GalwayM = new AnimalInfo() { ID = 150, TBTesting = false };
//AnimalInfo GalwayF = new AnimalInfo() { ID = 270, TBTesting = true };
//AnimalInfo RyelandF = new AnimalInfo() { ID = 302, TBTesting = true };
//AnimalInfo RyelandM = new AnimalInfo() { ID = 303, TBTesting = true };
//AnimalInfo DexterM = new AnimalInfo() { ID = 1400, TBTesting = false };
//AnimalInfo DexterF = new AnimalInfo() { ID = 12, TBTesting = true };
//AnimalInfo AngusM = new AnimalInfo() { ID = 780, TBTesting = true };
//AnimalInfo AngusF = new AnimalInfo() { ID = 130, TBTesting = true };
//AnimalInfo LimousinM = new AnimalInfo() { ID = 160, TBTesting = true };
//AnimalInfo LimousinF = new AnimalInfo() { ID = 560, TBTesting = false};
//AnimalInfo FriesianF = new AnimalInfo() { ID = 740, TBTesting = true };
//AnimalInfo FriesianM = new AnimalInfo() { ID = 400, TBTesting = true };
//AnimalInfo JerseyM = new AnimalInfo() { ID = 16, TBTesting = false };
//AnimalInfo JerseyF = new AnimalInfo() { ID = 1700, TBTesting = true };
//AnimalInfo SimmnatalF = new AnimalInfo() { ID = 30, TBTesting = true };
//AnimalInfo SimmnatalM = new AnimalInfo() { ID = 31, TBTesting = true };
Animal Sheep1 = new Animal
{
Breed = "Suffolk",
Gender = "F",
DOB = new DateTime(2019, 2, 1),
Description = "Breeding Ewe",
Cost = 110m,
ID = 200,
TBTesting = true
};
Animal Sheep2 = new Animal
{
Breed = "Suffolk",
Gender = "M",
DOB = new DateTime(2019, 4, 1),
Description = "Breeding Ram",
Cost = 100m,
ID = 201,
TBTesting = true
};
Animal Sheep3 = new Animal
{
Breed = "Galway",
Gender = "M",
DOB = new DateTime(2019, 5, 14),
Description = "Ram",
Cost = 70m,
ID = 150,
TBTesting = true
};
Animal Sheep4 = new Animal
{
Breed = "Galway",
Gender = "F",
DOB = new DateTime(2019, 3, 3),
Description = "Ewe",
Cost = 140m,
ID = 270,
TBTesting = true
};
Animal Sheep5 = new Animal
{
Breed = "Ryeland",
Gender = "F",
DOB = new DateTime(2019, 5, 17),
Description = "Ewe",
Cost = 91m,
ID = 302,
TBTesting = true
};
Animal Sheep6 = new Animal
{
Breed = "Ryeland",
Gender = "M",
DOB = new DateTime(2019, 5, 16),
Description = "Hogget",
Cost = 100m,
ID = 303,
TBTesting = true
};
//Beef Details
Animal Beef1 = new Animal
{
Breed = "Dexter",
Gender = "F",
DOB = new DateTime(2019, 2, 1),
Description = "Heifer",
Cost = 400m,
ID = 1400,
TBTesting = true
};
Animal Beef2 = new Animal
{
Breed = "Dexter",
Gender = "M",
DOB = new DateTime(2019, 4, 1),
Description = "Bullock",
Cost = 600m,
TBTesting = true
};
Animal Beef3 = new Animal
{
Breed = "Angus",
Gender = "M",
DOB = new DateTime(2019, 5, 14),
Description = "Calf",
Cost = 450m,
ID = 780,
TBTesting = true
};
Animal Beef4 = new Animal
{
Breed = "Angus",
Gender = "F",
DOB = new DateTime(2019, 3, 3),
Description = "Heifer",
Cost = 600m,
ID = 160,
TBTesting = true
};
Animal Beef5 = new Animal
{
Breed = "Limousin",
Gender = "M",
DOB = new DateTime(2019, 5, 17),
Description = "Bull",
Cost = 350m,
ID = 130,
TBTesting = true
};
Animal Beef6 = new Animal
{
Breed = "Limousin",
Gender = "M",
DOB = new DateTime(2019, 5, 16),
Description = "Male Calf",
Cost = 250m,
ID = 560,
TBTesting = true
};
//Dairy Details
Animal Dairy1 = new Animal
{
Breed = "Friesian",
Gender = "F",
DOB = new DateTime(2019, 2, 1),
Description = "Heifer",
Cost = 600m,
ID = 740,
TBTesting = true
};
Animal Dairy2 = new Animal
{
Breed = "Friesian",
Gender = "M",
DOB = new DateTime(2019, 4, 1),
Description = "Bullock",
Cost = 150m,
ID = 400,
TBTesting = true
};
Animal Dairy3 = new Animal
{
Breed = "Jersey",
Gender = "M",
DOB = new DateTime(2019, 5, 14),
Description = "Bullock",
Cost = 200m,
ID = 16,
TBTesting = true
};
Animal Dairy4 = new Animal
{
Breed = "Jersey",
Gender = "F",
DOB = new DateTime(2019, 3, 3),
Description = "Heifer",
Cost = 550m,
ID = 1700,
TBTesting = true
};
Animal Dairy5 = new Animal
{
Breed = "Simmnetal",
Gender = "M",
DOB = new DateTime(2019, 5, 17),
Description = "Bullock",
Cost = 250m,
ID = 31,
TBTesting = true
};
Animal Dairy6 = new Animal
{
Breed = "Simmnetal",
Gender = "M",
DOB = new DateTime(2019, 5, 16),
Description = "Calf",
Cost = 400m,
ID = 32,
TBTesting = true
};
//db.Info.Add(SuffolkF);
//db.Info.Add(SuffolkM);
//db.Info.Add(GalwayF);
//db.Info.Add(GalwayM);
//db.Info.Add(RyelandF);
//db.Info.Add(RyelandM);
//db.Info.Add(DexterF);
//db.Info.Add(DexterM);
//db.Info.Add(AngusF);
//db.Info.Add(AngusM);
//db.Info.Add(LimousinF);
//db.Info.Add(LimousinM);
//db.Info.Add(FriesianF);
//db.Info.Add(FriesianM);
//db.Info.Add(JerseyF);
//db.Info.Add(JerseyM);
//db.Info.Add(SimmnatalF);
//db.Info.Add(SimmnatalM);
Console.WriteLine("Animal info added to database");
db.Livestock.Add(Sheep1);
db.Livestock.Add(Sheep2);
db.Livestock.Add(Sheep3);
db.Livestock.Add(Sheep4);
db.Livestock.Add(Sheep5);
db.Livestock.Add(Sheep6);
db.Livestock.Add(Beef1);
db.Livestock.Add(Beef2);
db.Livestock.Add(Beef3);
db.Livestock.Add(Beef4);
db.Livestock.Add(Beef5);
db.Livestock.Add(Beef6);
db.Livestock.Add(Dairy1);
db.Livestock.Add(Dairy2);
db.Livestock.Add(Dairy3);
db.Livestock.Add(Dairy4);
db.Livestock.Add(Dairy5);
db.Livestock.Add(Dairy6);
Console.WriteLine("Added livestock to database");
db.SaveChanges();
Console.WriteLine("Saved to database");
}
}