コード例 #1
0
        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();
        }
コード例 #2
0
        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();
            }
        }