public void DeleteFromDataBaseUnitTest() { //Arrange DatabaseContext db = new DatabaseContext(); db.Database.Migrate(); int ExpectedPostDeletedCount = 1; int ActualPostDeletedCount; //Act var TestItem = new Pistols { Image = "https://upload.wikimedia.org/wikipedia/commons/6/61/M9-pistolet.jpg", ModelName = "M9", Manufacturer = "Beretta", StartService = "1985", EndService = "Present", Designed = "1980", StartProduction = "1990", EndProduction = "Present", Weight = 0.97, Length = 217, BarrelLength = 125, Cartridge = "9x19mm Parabellum", Action = "Short Recoil", MuzzleVelocity = 381, EffectiveRange = 100, MaxRange = 200, FeedSystem = "15-round detachable box magazine", Sights = "Iron sights" }; var TestItem2 = new Howitzers { Image = "https://upload.wikimedia.org/wikipedia/commons/1/1b/M777_Light_Towed_Howitzer_1.jpg", ModelName = "M777", Manufacturer = "BAE Systems", StartService = "2005", EndService = "Present", Designed = "2000s", StartProduction = "2002", EndProduction = "Present", Shell = "M107 155mm HE", Weight = 4200, Length = 10.7, BarrelLength = 5.08, Carriage = "Split Trail", Crew = 8, MinimumElevation = 0, MaximumElevation = 71.7, RateOfFire = 5 }; DatabaseHelper.InsertItem(TestItem, "Small Arms", "Pistols"); DatabaseHelper.InsertItem(TestItem2, "Artillery", "Howitzers"); db.SaveChanges(); var FirstItem = db.SmallArms.First(); DatabaseHelper.DeleteItem(FirstItem); db.SaveChanges(); ActualPostDeletedCount = db.SmallArms.Count(); //Assert Assert.AreEqual(ExpectedPostDeletedCount, ActualPostDeletedCount); }
internal static void AddArt(object Item, string SType) { using (var db = new DatabaseContext()) { switch (SType) { case "AirDefense": AirDefense tempAD = new AirDefense(); foreach (PropertyInfo x in Item.GetType().GetProperties()) { x.SetValue(tempAD, x.GetValue(Item)); } db.Artillery.Add(tempAD); break; case "Howitzers": Howitzers tempH = new Howitzers(); foreach (PropertyInfo x in Item.GetType().GetProperties()) { x.SetValue(tempH, x.GetValue(Item)); } db.Artillery.Add(tempH); break; case "Mortars": Mortars tempM = new Mortars(); foreach (PropertyInfo x in Item.GetType().GetProperties()) { x.SetValue(tempM, x.GetValue(Item)); } db.Artillery.Add(tempM); break; } db.SaveChanges(); } }