public static Item GetItem(string itemId) { using (var db = new BOTCContext()) { var item = db.Item.Where(b => b.Id == int.Parse(itemId)).FirstOrDefault(); return(item); } }
public static User GetUserByName(string userName) { using (var db = new BOTCContext()) { User user = db.User.Where(b => b.UserName == userName).FirstOrDefault(); return(user); } }
public static Classes GetClasses(int classId) { using (var db = new BOTCContext()) { var banditClass = db.Classes.Where(c => c.Id == classId).FirstOrDefault(); return(banditClass); } }
//Database Calls public static List <Classes> GetAllClasses() { using (var db = new BOTCContext()) { var allClasses = db.Classes.ToList(); return(allClasses); } }
public static User GetUser(string sessionId) { using (var db = new BOTCContext()) { var user = db.User.Where(b => b.SessionId == sessionId).FirstOrDefault(); return(user); } }
public static bool CheckForUserByName(string userName) { using (var db = new BOTCContext()) { var user = db.User.Where(b => b.UserName == userName).FirstOrDefault(); return(user != null); } }
public static bool CheckForUserById(string sessionId) { using (var db = new BOTCContext()) { var user = db.User.Where(b => b.SessionId == sessionId).FirstOrDefault(); return(user != null); } }
public static List <Item> GetAllItem() { using (var db = new BOTCContext()) { List <Item> item = db.Item.ToList(); return(item); } }
//Items public static string CreateItem(Item item) { using (var db = new BOTCContext()) { db.Item.Add(item); db.SaveChanges(); } return(item.Name); }
//Database Calls public static List <Bandit> GetAll(string sessionId) { using (var db = new BOTCContext()) { var user = db.User.Where(b => b.SessionId == sessionId).FirstOrDefault(); var bandits = db.Bandit.Where(b => b.User == user).Include("Class").ToList(); return(bandits); } }
public static void UpdateUserSessionId(string userName, string sessionId) { using (var db = new BOTCContext()) { var user = db.User.Where(b => b.UserName == userName).FirstOrDefault(); user.SessionId = sessionId; db.SaveChanges(); } }
public static void DeleteItem(string itemId) { using (var db = new BOTCContext()) { var item = db.Item.Where(b => b.Id == int.Parse(itemId)).FirstOrDefault(); db.Remove(item); db.SaveChanges(); } }
public static Bandit GetBandit(string banditId) { int id = int.Parse(banditId); using (var db = new BOTCContext()) { var bandit = db.Bandit.Where(b => b.Id == id).Include("Class").FirstOrDefault(); return(bandit); } }
public static Classes GetClass(string classId) { int id = int.Parse(classId); using (var db = new BOTCContext()) { var classType = db.Classes.Where(b => b.Id == id).FirstOrDefault(); return(classType); } }
public static void CreateUser(string userName, string password, string sessionId, string privileges) { using (var db = new BOTCContext()) { User user = new User() { UserName = userName, Password = password, SessionId = sessionId, Privileges = "" }; db.User.Add(user); db.SaveChanges(); } }
public static object GetItemStats(string itemId, string type) { using (var db = new BOTCContext()) { if (type == "weapon") { var weapon = db.Weapon.Where(b => b.Id == int.Parse(itemId)).FirstOrDefault(); return(weapon); } } return(null); }
// //CreateClass saves new classes to db public static string CreateClass(string className, string totalHealth, string currentHealth, string strength, string dexterity) { using (var db = new BOTCContext()) { Classes newClass = new Classes() { Name = className, CurrentHealth = int.Parse(currentHealth), TotalHealth = int.Parse(totalHealth), Strength = int.Parse(strength), Dexterity = int.Parse(dexterity) }; db.Classes.Add(newClass); db.SaveChanges(); return(newClass.Id.ToString()); } }
// //CreateBandit saves new bandit to db public static string CreateBandit(string name, string sessionId, int classId) { using (var db = new BOTCContext()) { Classes banditClass = db.Classes.Where(c => c.Id == classId).FirstOrDefault(); User user = db.User.Where(u => u.SessionId == sessionId).FirstOrDefault(); Bandit bandit = new Bandit() { Name = name, CurrentHealth = 100, User = user, Class = banditClass }; db.Bandit.Add(bandit); db.SaveChanges(); return(bandit.Id.ToString()); } }
public static string CreateWeapon(Item item, Weapon weapon) { using (var db = new BOTCContext()) { db.Weapon.Add(weapon); db.SaveChanges(); } using (var db = new BOTCContext()) { item.Type_Id = weapon.Id; db.Item.Add(item); db.SaveChanges(); } return(item.Id.ToString()); }