/// <summary> /// Constructor to set all member variables /// </summary> /// <param name="CardBattleId"></param> /// <param name="BattleDate"></param> /// <param name="CardOne"></param> /// <param name="CardTwo"></param> /// <param name="WinnerCardId"></param> public CardBattleObject(int? CardBattleId, DateTime? BattleDate, CardObject CardOne, CardObject CardTwo, int? WinnerCardId, int? CardOneVotes, int? CardTwoVotes) { cardBattleId = CardBattleId; battleDate = BattleDate; cardOne = CardOne; cardTwo = CardTwo; winnerCardId = WinnerCardId; cardOneVotes = CardOneVotes; cardTwoVotes = CardTwoVotes; }
/// <summary> /// Create a new card /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_createCard_Click(object sender, EventArgs e) { CardObject card = new CardObject(); card.name = txt_name.Text; card.description = txt_description.Text; if (fileUpload_picture.HasFile) { card.imageURL = fileUpload_picture.FileName; } try { int? cardId = dataController.insertCard(card); if (cardId != null) { if (fileUpload_picture.HasFile) { string filePath = Server.MapPath(IMAGE_SAVE_LOCATION + (int)cardId + "/"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } fileUpload_picture.SaveAs(filePath + fileUpload_picture.FileName); } } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SuccessfulInsert", "alert('Card successfully created.'); window.location='Card.aspx?ID=" + (int)cardId + "';", true); } catch (Exception error) { } }
/// <summary> /// Inserts a card /// </summary> /// <param name="card"></param> /// <returns></returns> public int? insertCard(CardObject card) { openSQLConnection(); int? cardId = null; using (SqlCommand cmd = new SqlCommand("monbattle.InsertCard", this.sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Name", SqlDbType.NVarChar); cmd.Parameters["@Name"].Value = card.name; cmd.Parameters.Add("@Description", SqlDbType.NVarChar); if (String.IsNullOrEmpty(card.description)) { cmd.Parameters["@Description"].Value = DBNull.Value; } else { cmd.Parameters["@Description"].Value = card.description; } cmd.Parameters.Add("@ImageURL", SqlDbType.NVarChar); if (String.IsNullOrEmpty(card.imageURL)) { cmd.Parameters["@ImageURL"].Value = DBNull.Value; } else { cmd.Parameters["@ImageURL"].Value = card.imageURL; } SqlParameter parameter = cmd.Parameters.Add("@CardID", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; try { cmd.ExecuteNonQuery(); cardId = (int)cmd.Parameters["@CardID"].Value; } catch (SqlException e) { throw e; } finally { closeSQLConnection(); } } return cardId; }
/// <summary> /// Updates a card /// </summary> /// <param name="card"></param> /// <returns></returns> public bool? updateCard(CardObject card) { openSQLConnection(); bool? updateSuccessful = false; using (SqlCommand cmd = new SqlCommand("monbattle.UpdateCard", this.sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CardID", SqlDbType.Int); cmd.Parameters["@CardID"].Value = card.cardId; cmd.Parameters.Add("@Name", SqlDbType.NVarChar); cmd.Parameters["@Name"].Value = card.name; cmd.Parameters.Add("@Description", SqlDbType.NVarChar); if (String.IsNullOrEmpty(card.description)) { cmd.Parameters["@Description"].Value = DBNull.Value; } else { cmd.Parameters["@Description"].Value = card.description; } cmd.Parameters.Add("@ImageURL", SqlDbType.NVarChar); if (String.IsNullOrEmpty(card.imageURL)) { cmd.Parameters["@ImageURL"].Value = DBNull.Value; } else { cmd.Parameters["@ImageURL"].Value = card.imageURL; } try { cmd.ExecuteNonQuery(); updateSuccessful = true; } catch (SqlException e) { throw e; } finally { closeSQLConnection(); } } return updateSuccessful; }
/// <summary> /// Update a card /// </summary> /// <param name="card"></param> /// <returns></returns> public bool? updateCard(CardObject card) { bool? successfulUpdate = dataModel.updateCard(card); return successfulUpdate; }
/// <summary> /// Insert a new card /// </summary> /// <param name="card"></param> /// <returns></returns> public int? insertCard(CardObject card) { int? cardId = dataModel.insertCard(card); return cardId; }
/// <summary> /// Get the card for the id specified /// </summary> /// <param name="cardId"></param> /// <returns></returns> public CardObject getCard(int cardId) { SqlDataReader cardResult = dataModel.getCard(cardId); CardObject card = null; if (cardResult.Read()) { int? CardId = null; string name = null; string description = null; string imageURL = null; DateTime? dateCreated = null; if (!cardResult.IsDBNull(cardResult.GetOrdinal("CardID"))) { CardId = cardResult.GetInt32(cardResult.GetOrdinal("CardID")); } if (!cardResult.IsDBNull(cardResult.GetOrdinal("Name"))) { name = cardResult.GetString(cardResult.GetOrdinal("Name")); } if (!cardResult.IsDBNull(cardResult.GetOrdinal("Description"))) { description = cardResult.GetString(cardResult.GetOrdinal("Description")); } if (!cardResult.IsDBNull(cardResult.GetOrdinal("ImageURL"))) { imageURL = cardResult.GetString(cardResult.GetOrdinal("ImageURL")); } if (!cardResult.IsDBNull(cardResult.GetOrdinal("DateCreated"))) { dateCreated = cardResult.GetDateTime(cardResult.GetOrdinal("DateCreated")); } card = new CardObject(CardId, name, description, imageURL, dateCreated); } cardResult.Close(); return card; }