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();
}
