public static void CreateCharacter(long accountId, string characterName, int jobId) // Creates Character and Inventory
{
using (Ms2DbContext context = new Ms2DbContext())
{
Character character = new Character() // Set default values here (Refer to character.cs for column names)
{
AccountId = accountId,
Name = characterName,
JobId = jobId,
MapId = 2000062,
CoordX = 2850,
CoordY = 2550,
CoordZ = 1800,
Level = 70,
PrestigeLvl = 100,
Motto = "This works!",
HomeName = "My Home Works!",
InsigniaId = 29,
TitleId = 10000292
};
context.Characters.Add(character);
context.SaveChanges();
InventoryManager inventory = new InventoryManager();
character = context.Characters.First(column => column.Name.ToLower() == characterName.ToLower());
InventoryManager.CreateInventory(character.CharacterId);
}
}
public static void EditCharInfo(/*Character character*/)
{
using (Ms2DbContext context = new Ms2DbContext())
{
context.SaveChanges();
}
}
public static void EditSkill(/*SkillTree skill*/)
{
using (Ms2DbContext context = new Ms2DbContext())
{
context.SaveChanges();
}
}
public static void EditItem(/*Item item*/)
{
using (Ms2DbContext context = new Ms2DbContext())
{
context.SaveChanges();
}
}
public void EditCharInfo(Character character)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Character Character = character;
Context.SaveChanges();
}
}
public Character GetCharInfo(long characterId)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Character Character = Context.Characters.FirstOrDefault(a => a.CharacterId == characterId);
return(Character);
}
}
public void SetCharInfo(Character CharIn)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Character character = CharIn;
context.SaveChanges();
}
}
public void EditItem(Item item)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Item Item = item;
Context.SaveChanges();
}
}
public Account GetAccountByName(string username)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Account account = context.Accounts.FirstOrDefault(column => column.Username.ToLower() == username.ToLower()); // Retrieve entry by username
return(account);
}
}
public Account GetAccInfoByUser(string username)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Account Account = Context.Accounts.FirstOrDefault(a => a.Username.ToLower() == username.ToLower()); // Retrieve entry by username
return(Account);
}
}
public void UpdateSkill(SkillTree skillObject)
{
using (Ms2DbContext context = new Ms2DbContext())
{
SkillTree skill = skillObject;
context.SaveChanges();
}
}
public Account GetAccInfoById(long id) // Queries db and retrieves account entry by Id
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Account Account = Context.Accounts.FirstOrDefault(a => a.AccountId == id); // Retrieve entry by Id
return(Account);
}
}
public void EditSkill(SkillTree skill)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
SkillTree Skill = skill;
Context.SaveChanges();
}
}
public Character GetCharacterInfo(long characterId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Character character = context.Characters.FirstOrDefault(column => column.CharacterId == characterId);
return(character);
}
}
public void UpdateCharInfo(Character characterObject)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Character character = characterObject;
context.SaveChanges();
}
}
public static void UpdateItem(Item itemObject)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Item item = itemObject;
context.SaveChanges();
}
}
public Account GetAccountById(long id) // Queries db and retrieves account entry by Id
{
using (Ms2DbContext context = new Ms2DbContext())
{
Account account = context.Accounts.FirstOrDefault(column => column.AccountId == id); // Retrieve entry by Id
return(account);
}
}
public void DeleteCharacter(long characterId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Character character = context.Characters.FirstOrDefault(column => column.CharacterId == characterId);
context.Remove(character);
context.SaveChanges();
}
}
public void DeleteAccount(long id)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Account Account = Context.Accounts.Find(id);
Context.Remove(Account);
Context.SaveChanges();
}
}
public Item findItem(long uid)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Item Item = Context.Items.Find(uid);
return(Item);
}
}
public static SkillTree FindSkill(long characterId, long skillId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
SkillTree skill = context.SkillTrees.Where(c => c.CharacterId == characterId).FirstOrDefault(s => s.SkillId == skillId);
return(skill);
}
}
public static Item FindItem(long uid)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Item item = context.Items.Find(uid);
return(item);
}
}
public static void DeleteAccount(long id)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Account account = context.Accounts.Find(id);
context.Remove(account);
context.SaveChanges();
}
}
public static void DeleteCharacter(long characterId, string characterName = "")
{
using (Ms2DbContext context = new Ms2DbContext())
{
Character character = context.Characters.FirstOrDefault(a => (a.CharacterId == characterId) || (a.Name.ToLower() == characterName.ToLower()));
context.Remove(character);
context.SaveChanges();
}
}
public List <SkillTree> GetSkillTree(long characterId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
List <SkillTree> skillTree = context.SkillTrees.Where(column => column.CharacterId == characterId)
.ToList();
return(skillTree);
}
}
public void DeleteItem(long uid)
{
using (Ms2DbContext Context = new Ms2DbContext())
{
Item Item = Context.Items.Find(uid);
Context.Remove(Item);
Context.SaveChanges();
}
}
public SkillTree GetSkill(long characterId, long skillId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
SkillTree skill = context.SkillTrees.Where(column => column.CharacterId == characterId)
.FirstOrDefault(column => column.SkillId == skillId);
return(skill);
}
}
public static void DeleteSkill(long characterId, long skillId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
SkillTree skill = context.SkillTrees.Where(column => column.CharacterId == characterId)
.FirstOrDefault(column => column.SkillId == skillId);
context.Remove(skill);
context.SaveChanges();
}
}
public List <Character> GetCharacterList(long accountId)
{
using (Ms2DbContext context = new Ms2DbContext())
{
List <Character> characters = context.Characters.Include(table => table.Account)
.Where(column => column.Account.AccountId == accountId)
.ToList();
return(characters);
}
}
public static void DeleteItem(long uid)
{
using (Ms2DbContext context = new Ms2DbContext())
{
Item item = context.Items.Find(uid);
context.Remove(item);
context.SaveChanges();
}
}
