public FightBoard(GameScreen aGameScr)
{
InitializeComponent();
myGameScr = aGameScr;
// if the local full monster set is empty load it
if (myGameScr.gMonsterList is null)
{
BreadDB BreadNet = new BreadDB();
myMonsterList = BreadNet.LoadMonsterList();
myGameScr.gMonsterList = myMonsterList;
}
else
{
myMonsterList = myGameScr.gMonsterList;
}
//Get list of local monsters
//grab IDs of local monsters into a list
// *************handle if locaiton contains no encounters
List <clsMonster> locMonsters = new List <clsMonster>();
foreach (clsMonster m in myMonsterList)
{
if (m.Location == myGameScr.gMage.Location)
{
locMonsters.Add(m);
}
}
//possible work in to make more common or less common encounters? maybe roll a d20 or something and make rare flag on 20?
myMonster = locMonsters.ElementAt(myGameScr.gRandom.Next(0, (locMonsters.Count)));
/*
* old:
* string s = "Location = " + myGameScr.gMage.Location;
* DataTable vLocMonster = myGameScr.gMonsterList.Tables[0].Select(s).CopyToDataTable();
* s = "MonsterID = " + vLocMonster.Rows[myGameScr.gRandom.Next(0, vLocMonster.Rows.Count)]["MonsterID"];
* vLocMonster = vLocMonster.Select(s).CopyToDataTable();
*/
txtChatter.Clear();
txtChatter.Text = "Look out it's a " + myMonster.MonName + "!!!";
//myMonster = new clsMonster(myMonster);
myGameScr = aGameScr;
myGameScr.gMonster = myMonster;
myGameScr.bFight = this;
Load_Fight();
}
private void button1_Click(object sender, EventArgs e)
{
BreadDB BreadNet = new BreadDB();
OleDbConnection myConn = BreadNet.BreadConnect();
try
{
string msql = "SELECT * FROM MASTER";
OleDbCommand myCmd = new OleDbCommand(msql, myConn);
OleDbDataAdapter myAdap;
DataSet ds = new DataSet();
int i = 0;
myConn.Open();
myAdap = new OleDbDataAdapter(msql, myConn);
myAdap.Fill(ds);
myAdap.Dispose();
//myConn.Close();
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
if (ds.Tables[0].Rows[i].ItemArray[1].ToString() == "Settings")
{
MessageBox.Show("oh man");
}
if (ds.Tables[0].Rows[i].ItemArray[1].ToString() == "More")
{
myCmd.CommandText = "UPDATE MASTER " +
"set Field2 = Field2 + 300 where ID = @ID";
//myCmd.Parameters.AddWithValue("@f1", "Way cool, man");
myCmd.Parameters.AddWithValue("@ID", 4);
myCmd.ExecuteNonQuery();
}
MessageBox.Show(ds.Tables[0].Rows[i].ItemArray[0] + " -- " + ds.Tables[0].Rows[i].ItemArray[1] + " -- " + ds.Tables[0].Rows[i].ItemArray[3]);
}
MessageBox.Show("Connection Open ! ");
myCmd.Dispose();
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Can not open connection ! ");
}
/*
*
* connection = new OleDbConnection(connetionString);
* try
* {
* connection.Open();
* oledbAdapter = new OleDbDataAdapter(sql, connection);
* oledbAdapter.Fill(ds);
* oledbAdapter.Dispose();
* connection.Close();
*
* for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
* {
* MessageBox.Show (ds.Tables[0].Rows[i].ItemArray[0] + " -- " + ds.Tables[0].Rows[i].ItemArray[1]);
* }
*/
}
