//INSERT public static int Save(GameBO gameToSave) { ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem; int result = 0; if (gameToSave.GameId > 0) { queryId = ExecuteTypeEnum.UpdateItem; } using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("usp_ExecuteGame", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@QueryId", queryId); myCommand.Parameters.AddWithValue("@GameId", gameToSave.GameId); if (gameToSave.GameName != null) { myCommand.Parameters.AddWithValue("@GameName", gameToSave.GameName); } //add return output parameter to command object myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue")); //Opens connection and executes query myConnection.Open(); myCommand.ExecuteNonQuery(); //Get return value from stored procedure and return Id result = Convert.ToInt32(myCommand.Parameters["@ReturnValue"].Value); } myConnection.Close(); } return result; }
/// <Summary Fill Data Record> /// Initializes a new instance of the Game class and fills it with the data from the IDataRecord /// </summary> /// <param name="myDataRecord"></param> /// <returns></returns> private static GameBO FillDataRecord(IDataRecord myDataRecord) { GameBO myGameObject = new GameBO(); myGameObject.GameDescription = new GameDescription(); myGameObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameName"))) { myGameObject.GameName = myDataRecord.GetString(myDataRecord.GetOrdinal("GameName")); } return myGameObject; }
/// <Summary Fill Data Record> /// Initializes a new instance of the Game class and fills it with the data from the IDataRecord /// </summary> /// <param name="myDataRecord"></param> /// <returns></returns> private static GameBO FillDataRecord(IDataRecord myDataRecord) { GameBO myGameObject = new GameBO(); myGameObject.GameDescription = new GameDescription(); myGameObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameName"))) { myGameObject.GameName = myDataRecord.GetString(myDataRecord.GetOrdinal("GameName")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameDescriptionId"))) { myGameObject.GameDescription.GameDescriptionId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameDescriptionId")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("HowToPlay"))) { myGameObject.GameDescription.HowToPlay = myDataRecord.GetString(myDataRecord.GetOrdinal("HowToPlay")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameDescription"))) { myGameObject.GameDescription.GameDescript = myDataRecord.GetString(myDataRecord.GetOrdinal("GameDescription")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameCost"))) { myGameObject.GameDescription.GameCost = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameCost")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("NumberOfBalls"))) { myGameObject.GameDescription.NumberOfBalls = myDataRecord.GetInt32(myDataRecord.GetOrdinal("NumberOfBalls")); } if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("SpecialBall"))) { myGameObject.GameDescription.SpecialBall = myDataRecord.GetInt32(myDataRecord.GetOrdinal("SpecialBall")); } return myGameObject; }