Пример #1
0
        public string GetHelpText(RCData aRC, string sDB, string sItem) // expecting a Function or Procedure as cn.
        {
            string sDatabase = sDB;
            string sResult   = "";
            MMData d         = new MMData();

            try {
                DataSet ds = aRC.GetStProcDataSet("exec " + sDatabase + ".sys.sp_helptext @aObjName", new StProcParam[] { new StProcParam("@aObjName", DbType.String, sItem) });
                if (ds.Tables.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        sResult = sResult + Convert.ToString(dr["Text"]);
                    }
                }
            } catch (Exception e) {
                sResult = "Error while accessing sp_HelpText, " + e.Message;
            }

            return(sResult);
        }
Пример #2
0
        protected void cmdGo_Click(object sender, EventArgs e)
        {
            try
            {
                string strPlayer1 = AntiSqlInjection.ValidateSqlValue(txtHandle.Text);
                lblName.Text = strPlayer1;

                MMData mmd     = new MMData(GetConnectionString());
                int    nGameID = mmd.P2_MM_Initialize(strPlayer1, 6);

                CreateNewGameBoard(nGameID);
                hdnGameID.Value = nGameID.ToString();

                pnlName.Visible = false;
                pnlGame.Visible = true;
            }
            catch (Exception ex)
            {
                return;
            }
        }
Пример #3
0
        void CreateNewGameBoard(int GameID)
        {
            MMData mmd = new MMData(GetConnectionString());
            // Get this game's board
            DataSet ds = mmd.P2_MM_GetBoard(GameID);

            if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1)
            {
                throw new Exception("Game not found");
            }

            // The first table has the Game Info
            DataTable dtGame = ds.Tables[0];

            // Fill the game info
            lblName.Text = ds.Tables[0].Rows[0]["Player1"].ToString();

            // The second table has the Game Board layout
            DataTable dt = ds.Tables[1];

            int guessRow = dt.Rows.Count;
            int origRow  = guessRow;

            // Fill up a half-empty game with rows
            for (; guessRow < 10; guessRow++)
            {
                DataRow dr = dt.NewRow();
                dr[0] = (guessRow + 1);
                dr[1] = (int)MMPosStates.unselected;
                dr[2] = (int)MMPosStates.unselected;
                dr[3] = (int)MMPosStates.unselected;
                dr[4] = (int)MMPosStates.unselected;
                dr[5] = (int)MMPosStates.unselected;
                dt.Rows.Add(dr);
            }

            gvGame.DataSource = dt;
            gvGame.EditIndex  = origRow;
            gvGame.DataBind();
        }
Пример #4
0
        public string GetHelpText(TreeNode cn) // expecting a Function or Procedure as cn.
        {
            string sDBName   = cn.Parent.Parent.Parent.Text.ParseString(":", 0);
            string sDatabase = cn.Parent.Parent.Text;
            string sResult   = "";
            MMData d         = new MMData();

            try {
                DataSet ds = d.GetStProcDataSet(sDBName, "exec " + sDatabase + ".sys.sp_helptext @aObjName", new StProcParam[] { new StProcParam("@aObjName", DbType.String, cn.Text) });
                if (ds.Tables.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        sResult = sResult + Convert.ToString(dr["Text"]);
                    }
                }
            } catch (Exception e) {
                sResult = "Error while accessing sp_HelpText, " + e.Message;
            }

            return(sResult);
        }
Пример #5
0
        protected void gvGame_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "AddMove")
            {
                // Retrieve the row index stored in the CommandArgument property.
                int index = Convert.ToInt32(e.CommandArgument);

                // Retrieve the row that contains the button from the Rows collection.
                GridViewRow row = gvGame.Rows[index];

                // Get the individual values from the hidden controls
                HiddenField hf0 = (HiddenField)row.FindControl("hiddenPos0");
                HiddenField hf1 = (HiddenField)row.FindControl("hiddenPos1");
                HiddenField hf2 = (HiddenField)row.FindControl("hiddenPos2");
                HiddenField hf3 = (HiddenField)row.FindControl("hiddenPos3");

                // Check they are available
                if ((hf0 == null || hf0.Value.Length < 1) ||
                    (hf1 == null || hf1.Value.Length < 1) ||
                    (hf2 == null || hf2.Value.Length < 1) ||
                    (hf3 == null || hf3.Value.Length < 1))
                {
                    throw new Exception("Please enter a value for each field.");
                }

                // Check for SQL Injection
                string strGameID = AntiSqlInjection.ValidateSqlValue(hdnGameID.Value);
                string strG0     = AntiSqlInjection.ValidateInteger(hf0.Value);
                string strG1     = AntiSqlInjection.ValidateInteger(hf1.Value);
                string strG2     = AntiSqlInjection.ValidateInteger(hf2.Value);
                string strG3     = AntiSqlInjection.ValidateInteger(hf3.Value);

                // Convert to Integer in prep for inserting into DB
                int nGameID = Int32.Parse(strGameID);
                int nG0     = Int32.Parse(strG0);
                int nG1     = Int32.Parse(strG1);
                int nG2     = Int32.Parse(strG2);
                int nG3     = Int32.Parse(strG3);

                // Create the connection to the DB and insert it
                MMData    mmd = new MMData(GetConnectionString());
                DataTable dt  = mmd.P2_MM_NewMove(nGameID, nG0, nG1, nG2, nG3);

                if (dt == null || dt.Rows == null || dt.Rows.Count < 1)
                {
                    lblError.Text    = "This game is complete.  Start a new game.";
                    lblError.Visible = true;
                    return;
                }
                else
                {
                    lblError.Visible = false;
                }

                // Get the number of black and white pegs
                int nNumberCorrectPosition = 0;
                int nNumberCorrectColor    = 0;
                if (dt.Rows[0]["NumberCorrectPosition"] != null &&
                    dt.Rows[0]["NumberCorrectPosition"] != System.DBNull.Value)
                {
                    nNumberCorrectPosition = (int)dt.Rows[0]["NumberCorrectPosition"];
                }
                if (dt.Rows[0]["NumberCorrectColor"] != null &&
                    dt.Rows[0]["NumberCorrectColor"] != System.DBNull.Value)
                {
                    nNumberCorrectColor = (int)dt.Rows[0]["NumberCorrectColor"];
                }

                if (nNumberCorrectPosition == 4)
                {
                    lblNoGuesses.Text    = (index + 1).ToString();
                    litWinDialog.Visible = true;
                    return;
                }
                else
                {
                    litWinDialog.Visible = false;
                }


                CreateNewGameBoard(nGameID);
            }
        }