/*public static void AddOneSamurai(string name)
* {
* var samurai = new Samurai {Name = name};
* using (var context = new SamuraiContext())
* {
* context.Samurais.Add(samurai);
* context.SaveChanges();
* }
* }*/
public static int AddOneSamurai(string name)
{
var samurai = new Samurai {
Name = name
};
using (var context = new SamuraiContext())
{
context.Samurais.Add(samurai);
context.SaveChanges();
// Id gets its real value after this method.}
}
return(samurai.SamuraiId);
}
public static int AddSamuraiWithRelatedData()
{
Random random = new Random();
Array valuesHairStyle = Enum.GetValues(typeof(HairStyle));
Array valuesQuoteStyle = Enum.GetValues(typeof(QuoteStyle));
using var context = new SamuraiContext();
var endSamurai = new Samurai
{
Name = "Monkey D. Luffy",
HairStyle = (HairStyle)valuesHairStyle.GetValue(random.Next(valuesHairStyle.Length)),
QuotesCollection = new List <Quote>()
{
new Quote
{
QuoteStyle = (QuoteStyle)valuesQuoteStyle.GetValue(random.Next(valuesQuoteStyle.Length)),
Text = "There is nothing outside yourself that can ever " +
"enable you to get better, stronger, richer, quicker or smarter." +
"Everything is within. Everything exists. Seek nothing outside of yourself."
},
new Quote
{
Text = "The perfect blossom is a rare thing. " +
"You could spend your life looking for one, " +
"and it would not be a wasted life.",
QuoteStyle = (QuoteStyle)valuesQuoteStyle.GetValue(random.Next(valuesQuoteStyle.Length))
}
},
SamuraiBattle = new List <SamuraiBattle>()
{
new SamuraiBattle
{
BattleID = context.Battles.First().ID
}
},
SecretIdentity = new SecretIdentity
{
RealName = "Rurouni Kenshin"
}
};
context.Samurais.Add(endSamurai);
context.SaveChanges();
return(endSamurai.ID);
}
public static void UpdateSamuraiSetSecretIdentity(int samuraiId, string name)
{
using (var context = new SamuraiContext())
{
var samurai = context.Samurais
.Include(s => s.SecretIdentity)
.Where(s => s.Id == samuraiId)
.ToList();
foreach (var item in samurai)
{
item.SecretIdentity = new SecretIdentity();
item.SecretIdentity.RealName = name;
context.Samurais.Update(item);
context.SaveChanges();
}
}
}
public static int AddOneSamurai(string name)
{
Random random = new Random();
Array valuesHairStyle = Enum.GetValues(typeof(HairStyle));
HairStyle randomHairStyle = (HairStyle)valuesHairStyle.GetValue(random.Next(valuesHairStyle.Length));
var samurai = new Samurai {
Name = name, HairStyle = randomHairStyle
};
using (var context = new SamuraiContext())
{
context.Samurais.Add(samurai);
context.SaveChanges();
}
return(samurai.ID);
}
public static void ClearDataBase()
{
using (var context = new SamuraiContext())
{
context.RemoveRange(context.Samurais);
context.RemoveRange(context.Battles);
var props = typeof(SamuraiContext).GetProperties(System.Reflection.BindingFlags.Public
| System.Reflection.BindingFlags.Instance
| System.Reflection.BindingFlags.DeclaredOnly);
foreach (var prop in props)
{
if (prop.Name != "SamuraiBattles")
{
context.Database.ExecuteSqlRaw($"DBCC CHECKIDENT ('{prop.Name}', RESEED, 0)");
}
}
context.SaveChanges();
}
}
public static void UpdateSamuraiSetSecretIdentity(int samuraiId, string newRealName)
{
using (var context = new SamuraiContext())
{
var relevantSamurai = context.Samurais
.Include(s => s.SecretIdentity)
.Single(s => s.ID == samuraiId);
if (relevantSamurai.SecretIdentity != null)
{
relevantSamurai.SecretIdentity.RealName = newRealName;
}
else
{
relevantSamurai.SecretIdentity = new SecretIdentity {
RealName = newRealName
};
}
context.Samurais.Update(relevantSamurai);
context.SaveChanges();
}
}
public static ICollection <Samurai> AddSomeSamurais(ICollection <string> names)
{
Random random = new Random();
Array valuesHairStyle = Enum.GetValues(typeof(HairStyle));
ICollection <Samurai> addedSamurais = new List <Samurai>();
foreach (var name in names)
{
addedSamurais.Add(new Samurai {
Name = name, HairStyle = (HairStyle)valuesHairStyle.GetValue(random.Next(valuesHairStyle.Length))
});
}
using (var context = new SamuraiContext())
{
context.Samurais.AddRange(addedSamurais);
context.SaveChanges();
}
return(addedSamurais);
}
public static void AddSomeBattles()
{
ICollection <Battle> addedBattles = new List <Battle>()
{
new Battle
{
Name = "Battle of Sekigahara",
Description = "The Battle of Sekigahara was a decisive battle on October 21, 1600 " +
"(Keichō 5, 15th day of the 9th month), that preceded the establishment of " +
"the Tokugawa shogunate.",
IsBrutal = true,
StartDate = new DateTime(1600, 10, 21),
EndDate = new DateTime(1600, 10, 23),
BattleLog = new BattleLog
{
Name = "BattleLog for battle of sekigahara",
BattleEvent = new List <BattleEvent>()
{
new BattleEvent
{
Description = "Description of battleEvent 1.1",
Summary = "Summary of battleEvent 1.1",
Order = 1
},
new BattleEvent
{
Description = "Description of battleEvent 1.2",
Summary = "Summary of battleEvent 1.2",
Order = 2
},
new BattleEvent
{
Description = "Description of battleEvent 1.3",
Summary = "Summary of battleEvent 1.3",
Order = 3
}
}
}
},
new Battle
{
Name = "Battle of Kizugawa",
Description = "The 1614 battle of the Kizugawa was one of a number " +
"of battles surrounding the siege of Osaka, in which the " +
"Tokugawa shogunate destroyed the Toyotomi clan, the last " +
"major opposition to its control of Japan.",
IsBrutal = false,
StartDate = new DateTime(1614, 11, 29),
EndDate = new DateTime(1614, 11, 30),
BattleLog = new BattleLog
{
Name = "BattleLog for Battle of Kizugawa",
BattleEvent = new List <BattleEvent>()
{
new BattleEvent
{
Description = "Description of battleEvent 2.1",
Summary = "Summary of battleEvent 2.1",
Order = 1
},
new BattleEvent
{
Description = "Description of battleEvent 2.2",
Summary = "Summary of battleEvent 2.2",
Order = 2
},
new BattleEvent
{
Description = "Description of battleEvent 2.3",
Summary = "Summary of battleEvent 2.3",
Order = 3
}
}
}
},
new Battle
{
Name = "Battle of Noryang",
Description = "The Battle of Noryang, the last major battle of the Japanese invasions of " +
"Korea (1592–1598), was fought between the Japanese navy and the combined fleets " +
"of the Joseon Kingdom and the Ming dynasty. It took place in the early morning of 16 " +
"December (19 November in the Lunar calendar) 1598 and ended past dawn.",
IsBrutal = true,
StartDate = new DateTime(1598, 12, 16),
EndDate = new DateTime(1598, 12, 17),
BattleLog = new BattleLog
{
Name = "BattleLog for Battle of Noryang",
BattleEvent = new List <BattleEvent>()
{
new BattleEvent
{
Description = "Description of battleEvent 3.1",
Summary = "Summary of battleEvent 3.1",
Order = 1
},
new BattleEvent
{
Description = "Description of battleEvent 3.2",
Summary = "Summary of battleEvent 3.2",
Order = 2
},
new BattleEvent
{
Description = "Description of battleEvent 3.3",
Summary = "Summary of battleEvent 3.3",
Order = 3
}
}
}
},
new Battle
{
Name = "Siege of Ōtsu",
Description = "The siege of Ōtsu took place in 1600, concurrent with the battle of Sekigahara. " +
"Kyōgoku Takatsugu held Ōtsu castle for the Tokugawa, and commanded the garrison.",
IsBrutal = true,
StartDate = new DateTime(1600, 6, 20),
EndDate = new DateTime(1600, 10, 15),
BattleLog = new BattleLog
{
Name = "BattleLog for siege of Ōtsu",
BattleEvent = new List <BattleEvent>()
{
new BattleEvent
{
Description = "Description of battleEvent 4.1",
Summary = "Summary of battleEvent 4.1",
Order = 1
},
new BattleEvent
{
Description = "Description of battleEvent 4.2",
Summary = "Summary of battleEvent 4.2",
Order = 2
},
new BattleEvent
{
Description = "Description of battleEvent 4.3",
Summary = "Summary of battleEvent 4.3",
Order = 3
}
}
}
}
};
using (var context = new SamuraiContext())
{
context.Battles.AddRange(addedBattles);
context.SaveChanges();
}
}