internal static void AddNewCharacter(string name, int phy, int men, int vit, int luc, ulong userId)
{
using (CharacterContext db = new CharacterContext())
{
db.Characters.Add(new Character(name, phy, men, vit, luc, 2, userId));
db.SaveChanges();
}
}
internal static string GetItems()
{
string msg = "\n";
using (CharacterContext db = new CharacterContext())
{
List <Item> items = db.Items.ToList <Item>();
foreach (Item item in items)
{
msg += item.ItemID + " | " + item.ItemName + " | " + item.ItemDescription + " | " + item.ItemCost + "\n";
}
}
return(msg);
}
internal static string GetSkills()
{
string msg = "\n";
using (CharacterContext db = new CharacterContext())
{
List <Skill> skills = db.Skills.ToList <Skill>();
foreach (Skill skill in skills)
{
msg += skill.SkillID + " | " + skill.SkillName + " | " + skill.SkillDescription + "\n";
}
}
return(msg);
}
internal static string GetCharacters(string id)
{
string msg = "\n";
using (CharacterContext db = new CharacterContext())
{
List <Character> chars = db.Characters.ToList <Character>();
foreach (Character chr in chars)
{
if (chr.UserId == id)
{
msg += chr.CharacterID + " | " + chr.Name + " | " + chr.PHY + " | " + chr.MEN + " | " + chr.VIT + " | " + chr.LUC + " | " + chr.Cash + " | " + chr.SkillPoints + "\n";
}
}
}
return(msg);
}
internal static string GetCharacterItems(int selectedCharacter)
{
string msg = "\n";
using (CharacterContext db = new CharacterContext())
{
List <CharacterItem> items = db.CharacterItems.ToList <CharacterItem>();
foreach (CharacterItem item in items)
{
if (item.CharacterId == selectedCharacter)
{
msg += item.ItemID + " | " + item.ItemName + " | " + item.ItemDescription + " | " + item.ItemCost + " | " + item.QuantityOwned + "\n";
}
}
}
return(msg);
}
internal static void InitializeCharacterDatabase()
{
using (CharacterContext db = new CharacterContext())
{
//Add default items to CharacterDB
foreach (Item item in GenerateNewItemList())
{
db.Items.Add(item);
}
//Add default Skills to CharacterDB
foreach (Skill skill in GenerateNewSkillList())
{
db.Skills.Add(skill);
}
db.SaveChanges();
}
}
