protected void addPlayer_Click(object sender, EventArgs e) { if (!IsPostBack) { return; } // Stops inserting when it refreshes. if (txtPlayerName.Text == "" || PhotoUpload.HasFile == false) { Label1.Text = "Please complete all sections and add an image."; } else { // Create player object from data. Label1.Text = ""; PlayersEntity insertPlayer = new PlayersEntity(); insertPlayer.PartitionKey = Session["userName"] as string; insertPlayer.PlayerName = txtPlayerName.Text; insertPlayer.Wins = "0"; insertPlayer.Losses = "0"; int newRowKey = GetNextPlayerRowKey(); insertPlayer.RowKey = Convert.ToString(newRowKey); // Get Cloud Table object for Players Table. CloudTable myPlayersCloudTable = GetPlayersCloudTable(); // Create Table Operation to insert new Player Entity. TableOperation insertOperation = TableOperation.Insert(insertPlayer); //Adds the photo if (PhotoUpload.HasFile) { CloudBlobContainer myBlobContainer = GetImagesBlobContainer(); CloudBlockBlob myBlobIdentity = myBlobContainer.GetBlockBlobReference(insertPlayer.PartitionKey + "-" + insertPlayer.RowKey); myBlobIdentity.UploadFromStream(PhotoUpload.FileContent); insertPlayer.ImageURI = myBlobIdentity.Uri.ToString(); } else { insertPlayer.ImageURI = string.Empty; } // Insert new player into Players Table. myPlayersCloudTable.Execute(insertOperation); // Update web form. Clear text boxes. txtPlayerName.Text = string.Empty; dataListPlayers.DataBind(); } }
private List <string> getPlayerDetails(string partKey, string rowKey) { CloudTable getCategoryTable = GetTable("PlayerTable"); TableOperation retrieveData = TableOperation.Retrieve <PlayersEntity>(partKey, rowKey); TableResult retrieveResult = getCategoryTable.Execute(retrieveData); PlayersEntity playerData = (PlayersEntity)retrieveResult.Result; List <string> playerDetails = new List <string> { playerData.PlayerName, playerData.Wins, playerData.Losses, playerData.PartitionKey, playerData.RowKey, playerData.Games }; return(playerDetails); }
protected void btnInsert3_Click(object sender, EventArgs e) { if (!IsPostBack) { return; } // Do not insert new message on browser refresh. // Create message object from web form data. PlayersEntity insertPlayer = new PlayersEntity(); insertPlayer.PlayerName = txtPlayerName.Text; insertPlayer.Wins = "0"; insertPlayer.Losses = "0"; int newRowKey = GetNextPlayerRowKey(); insertPlayer.RowKey = Convert.ToString(newRowKey); // Get Cloud Table object for Messages Table. CloudTable myPlayersCloudTable = GetPlayersCloudTable(); // Create Table Operation to insert new Message Entity. TableOperation insertOperation = TableOperation.Insert(insertPlayer); //New Photo Code if (PhotoUpload.HasFile) { CloudBlobContainer myBlobContainer = GetImagesBlobContainer(); CloudBlockBlob myBlobIdentity = myBlobContainer.GetBlockBlobReference(insertPlayer.PartitionKey + "-" + insertPlayer.RowKey); myBlobIdentity.UploadFromStream(PhotoUpload.FileContent); insertPlayer.ImageURI = myBlobIdentity.Uri.ToString(); } else { insertPlayer.ImageURI = string.Empty; } // Insert new message into Messages Table. myPlayersCloudTable.Execute(insertOperation); // Update web form. Clear text boxes. Refresh messages list. txtPlayerName.Text = string.Empty; dataListPlayers.DataBind(); }
private string updatePlayerTable(int playerWins, int playerLosses, string playerPartKey, string playerRowKey, int playerGames) { CloudTable playerCloudTable = GetTable("PlayerTable"); // Create a retrieve operation that takes a player entity. TableOperation retrieveOperation = TableOperation.Retrieve <PlayersEntity>(playerPartKey, playerRowKey); // Execute the operation. TableResult retrievedResult = playerCloudTable.Execute(retrieveOperation); // Assign the result to the PlayersEntity object. PlayersEntity updateEntity = (PlayersEntity)retrievedResult.Result; updateEntity.Wins = Convert.ToString(playerWins); updateEntity.Losses = Convert.ToString(playerLosses); updateEntity.Games = Convert.ToString(playerGames); // Create the Replace operation. TableOperation updateOperation = TableOperation.Replace(updateEntity); // Execute the operation. playerCloudTable.Execute(updateOperation); return(string.Empty); }