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