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