public static void AddWeapons() { var db = new WeaponSystemContext(); var megaCollection = ExcelReader.GetExcelFilesAsCollection("../../../../Weapons Source Data/w.zip"); var weaponsCat = db.WeaponCategoies.ToList(); var manufacturers = db.Manufacturers.ToList(); var calibers = db.Calibers.ToList(); var weaponType = db.WeaponTypes.ToList(); foreach (var collection in megaCollection) { foreach (var weaponItem in collection) { var weapon = new Weapon(); var weaponName = weaponItem[1]; var weaponCategory = weaponItem[0]; var weaponManufacturer = weaponItem[2]; var weaponCaliber = weaponItem[3]; var weaponImage = weaponItem[4]; weapon.Name = weaponName; weapon.Manufacturer = Parser.GetManufacturer(manufacturers, weaponManufacturer); weapon.Description = null; weapon.RelaseYear = 0; weapon.WeaponCategory = Parser.GetCategory(weaponsCat, weaponCategory); weapon.WeaponType = Parser.GetWeaponType(weaponType, weaponCategory); weapon.ImageUrl = weaponImage; weapon.Targets = null; weapon.Caliber = Parser.GetCaliber(calibers, weaponCaliber); if (!db.Weapons.Any(w => w.Name == weapon.Name)) { db.Weapons.Add(weapon); } } } db.SaveChanges(); }
public int Delete(Weapon id) { this.weapons.Delete(id); return this.weapons.SaveChanges(); }
public int Update(Weapon weapon) { this.weapons.Update(weapon); return this.weapons.SaveChanges(); }
public int Add(Weapon weapon) { this.weapons.Add(weapon); return this.weapons.SaveChanges(); }