private void launchGame(int difficulty)
{
fmPlayGame fPG = new fmPlayGame(0, PlayerName, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, difficulty, 0, "", 0);
this.Hide();
fPG.ShowDialog();
this.Close();
}
private void btnPlaySaved_Click(object sender, EventArgs e)
{
StartGameStatus = 1;
fmLogin loginUser = new fmLogin();
// Justo - Working with the dataset, may be easier to get stuff this way
//HBDataSet hbData = new HBDataSet();
//HBDataSetTableAdapters.PlayerHistoryTableAdapter playerHistory = new HBDataSetTableAdapters.PlayerHistoryTableAdapter();
//playerHistory.Fill(hbData.PlayerHistory);
//foreach (DataRow dr in hbData.PlayerHistory)
//{
// if ((string)dr["UserName"] == PlayerName)
// {
// FloorNo = (int)dr["FloorNo"];
// FloorX = (int)dr["FloorX"];
// FloorY = (int)dr["FloorY"];
// }
//}
string filename = "HauntedBuilding.mdf";
string connectionInfo = String.Format(@"Data Source=(LocalDB)\v11.0;
AttachDbFilename=|DataDirectory|\{0};Integrated Security=True;", filename);
SqlConnection Cnn = new SqlConnection(connectionInfo);
//SqlConnection Cnn = new SqlConnection();
//Cnn.ConnectionString = "Data Source=WIN-PC;Initial Catalog=HauntedBuilding;Integrated Security=True";
SqlCommand oCmd = new SqlCommand();
//SqlDataReader DR= oCmd.ExecuteReader();
//oCmd.Connection.ConnectionString="Data Source=WIN-PC; Initial Ctalog=HauntedBuilding; Integrated Security=True"; //oConn is a Module which create a connection to sql
oCmd.Connection = Cnn;
oCmd.CommandTimeout = 0;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spGetPlayerData";
oCmd.Parameters.Add("@UserName", SqlDbType.NVarChar);
oCmd.Parameters["@UserName"].Value = PlayerName;
oCmd.Parameters.Add("@FloorNo", SqlDbType.Int, 4);
oCmd.Parameters["@FloorNo"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@FloorX", SqlDbType.Int, 4);
oCmd.Parameters["@FloorX"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@FloorY", SqlDbType.Int, 4);
oCmd.Parameters["@FloorY"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@FirstDgtPass", SqlDbType.Int, 4);
oCmd.Parameters["@FirstDgtPass"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@SecDgtPass", SqlDbType.Int, 4);
oCmd.Parameters["@SecDgtPass"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@ThirdDgtPass", SqlDbType.Int, 4);
oCmd.Parameters["@ThirdDgtPass"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@CaseStatus", SqlDbType.Int, 4);
oCmd.Parameters["@CaseStatus"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@HaveCase", SqlDbType.Int, 4);
oCmd.Parameters["@HaveCase"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@Note", SqlDbType.Int, 4);
oCmd.Parameters["@Note"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@Phone", SqlDbType.Int, 4);
oCmd.Parameters["@Phone"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@Audio", SqlDbType.Int, 4);
oCmd.Parameters["@Audio"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@Difficulty", SqlDbType.Int, 4);
oCmd.Parameters["@Difficulty"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@TimeRemain", SqlDbType.Int, 4);
oCmd.Parameters["@TimeRemain"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@CaseHint", SqlDbType.NVarChar, 5);
oCmd.Parameters["@CaseHint"].Direction = ParameterDirection.Output;
oCmd.Parameters.Add("@ScareMeter", SqlDbType.Int, 4);
oCmd.Parameters["@ScareMeter"].Direction = ParameterDirection.Output;
SqlDataReader DR;
try
{
Cnn.Open();
DR = oCmd.ExecuteReader();
DR.Close();
FloorNo = Convert.ToInt16(oCmd.Parameters["@FloorNo"].Value);
FloorX = Convert.ToInt16(oCmd.Parameters["@FloorX"].Value);
FloorY = Convert.ToInt16(oCmd.Parameters["@FloorY"].Value);
FirstDgtPass = Convert.ToInt16(oCmd.Parameters["@FirstDgtPass"].Value);
SecDgtPass = Convert.ToInt16(oCmd.Parameters["@SecDgtPass"].Value);
ThirdDgtPass = Convert.ToInt16(oCmd.Parameters["@ThirdDgtPass"].Value);
CaseStatus = Convert.ToInt16(oCmd.Parameters["@CaseStatus"].Value);
HaveCase = Convert.ToInt16(oCmd.Parameters["@HaveCase"].Value);
HaveNote = Convert.ToInt16(oCmd.Parameters["@Note"].Value);
HavePhone = Convert.ToInt16(oCmd.Parameters["@Phone"].Value);
HaveAudio = Convert.ToInt16(oCmd.Parameters["@Audio"].Value);
Difficulty = Convert.ToInt16(oCmd.Parameters["@Difficulty"].Value);
TimeRemain = Convert.ToInt16(oCmd.Parameters["@TimeRemain"].Value);
CaseHint = Convert.ToString(oCmd.Parameters["@CaseHint"].Value);
ScareMeter = Convert.ToInt16(oCmd.Parameters["@ScareMeter"].Value);
fmPlayGame fPG = new fmPlayGame(StartGameStatus, PlayerName, FloorNo, FloorX, FloorY, FirstDgtPass, SecDgtPass, ThirdDgtPass, CaseStatus, HaveCase, HaveNote, HavePhone, HaveAudio,Difficulty,TimeRemain,CaseHint,ScareMeter);
//fmPlayGame fPG = new fmPlayGame();
this.Hide();
fPG.ShowDialog();
this.Close();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
this.btnPlaySaved.Enabled = false;
}
finally
{
Cnn.Close();
}
}
