/// <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;
}
