//Database Calls public static List <Bandit> GetAll() { List <Bandit> bandits = new List <Bandit> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM bandits INNER JOIN classes ON bandits.class_Id = classes.id;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { Bandit newBandit = new Bandit(rdr.GetInt32(0)); newBandit.Name = rdr.GetString(1); newBandit.Stats.CurrentHealth = rdr.GetInt32(2); newBandit.Stats.Name = rdr.GetString(6); newBandit.Stats.TotalHealth = rdr.GetInt32(7); newBandit.Stats.Strength = rdr.GetInt32(8); newBandit.Stats.Dexterity = rdr.GetInt32(9); bandits.Add(newBandit); } DB.Close(conn); return(bandits); }
// //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 Bandit GetBandit(string banditId) { int id = int.Parse(banditId); MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM bandits INNER JOIN classes ON bandits.class_Id = classes.id WHERE bandits.id = @bandit_id;"; cmd.Parameters.AddWithValue("@bandit_id", id); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; rdr.Read(); Bandit bandit = new Bandit(rdr.GetInt32(0)); bandit.Name = rdr.GetString(1); bandit.Stats.CurrentHealth = rdr.GetInt32(2); bandit.Stats.Name = rdr.GetString(6); bandit.Stats.TotalHealth = rdr.GetInt32(7); bandit.Stats.Strength = rdr.GetInt32(8); bandit.Stats.Dexterity = rdr.GetInt32(9); DB.Close(conn); return(bandit); }