protected void imgbtn_cardOne_Click(object sender, ImageClickEventArgs e)
{
if (Session["User"] != null)
{
user = (UserObject)Session["User"];
cardBattle = dataController.getCardBattleToday();
if (cardBattle != null && (int)cardBattle.cardBattleId == cardBattleID)
{
int? cardPickId = dataController.insertCardPick((int)user.userId, (int)cardBattle.cardBattleId, (int)cardBattle.cardOne.cardId);
if (cardPickId != null)
{
lbl_popupMessage.Text = "Thank you for voting!";
popupext_vote.Show();
}
else
{
lbl_popupMessage.Text = "There was an error with your vote. Please contact an admin for support.";
popupext_vote.Show();
}
}
else
{
lbl_popupMessage.Text = "This battle is no longer available for voting.";
popupext_vote.Show();
}
}
else
{
Response.Redirect("Default.aspx");
}
}
/// <summary>
/// Adds or updates a battle
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_addBattle_Click(object sender, EventArgs e)
{
CardBattleObject cardBattle = new CardBattleObject();
cardBattle.cardBattleId = cardBattleID;
cardBattle.cardOne = dataController.getCard(Convert.ToInt32(drpdwn_cardOne.SelectedValue));
cardBattle.cardTwo = dataController.getCard(Convert.ToInt32(drpdwn_cardTwo.SelectedValue));
cardBattle.battleDate = DateTime.ParseExact(txt_battleDate.Text, "MMM dd, yyyy", null);
if (dataController.checkIfBattleDateAvailable((DateTime)cardBattle.battleDate))
{
if (cardBattleID == -1)
{
int? newCardBattleId = dataController.insertCardBattle(cardBattle);
if (newCardBattleId != null)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SuccessfulInsert", "alert('Battle successfully created.'); window.location='Battle.aspx?ID=" + (int)newCardBattleId + "';", true);
}
}
else
{
bool? successfulUpdate = dataController.updateCardBattle(cardBattle);
if (successfulUpdate != null && (bool)successfulUpdate)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SuccessfulInsert", "alert('Battle successfully updated.'); window.location='Battle.aspx?ID=" + (int)cardBattle.cardBattleId + "';", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ErrorInsert", "alert('Another battle is already scheduled on the selected date.');", true);
}
}
private void loadBattle()
{
cardBattle = dataController.getCardBattleToday();
if (cardBattle != null)
{
cardBattleID = (int)cardBattle.cardBattleId;
lbl_cardOne.Text = cardBattle.cardOne.name;
imgbtn_cardOne.ImageUrl = IMAGE_OPEN_LOCATION + (int)cardBattle.cardOne.cardId + "/" + cardBattle.cardOne.imageURL;
imgbtn_cardOne.ToolTip = cardBattle.cardOne.description;
imgbtn_cardOne.Visible = true;
imgbtn_cardTwo.ImageUrl = IMAGE_OPEN_LOCATION + (int)cardBattle.cardTwo.cardId + "/" + cardBattle.cardTwo.imageURL;
lbl_cardTwo.Text = cardBattle.cardTwo.name;
imgbtn_cardTwo.ToolTip = cardBattle.cardTwo.description;
imgbtn_cardTwo.Visible = true;
img_vs.Visible = true;
if (Session["User"] != null)
{
user = (UserObject)Session["User"];
if (dataController.checkIfVotedToday((int)user.userId, (int)cardBattle.cardBattleId))
{
imgbtn_cardOne.OnClientClick = "return false;";
imgbtn_cardTwo.OnClientClick = "return false;";
conbtnext_cardOne.Enabled = false;
conbtnext_cardTwo.Enabled = false;
lbl_voteMessage.Text = "You have voted today!";
}
}
else
{
imgbtn_cardOne.OnClientClick = "return false;";
imgbtn_cardTwo.OnClientClick = "return false;";
conbtnext_cardOne.Enabled = false;
conbtnext_cardTwo.Enabled = false;
lbl_voteMessage.Visible = false;
tblcell_login.Visible = true;
}
DateTime battleDate = (DateTime)cardBattle.battleDate;
DateTime battleDateEnd = battleDate.AddDays(1);
countDownClock.Attributes["src"] = clockURL + battleDateEnd.ToString("yyyy-MM-dd") + "T00:00:00";
countDownClock.Visible = true;
countDownClock.Attributes.Add("onclick", "return false;");
//2014-05-08T00:00:00"
}
else
{
lbl_message.Text = "There is no battle today.";
lbl_message.Visible = true;
lbl_voteMessage.Visible = false;
lbl_cardOne.Visible = false;
lbl_cardTwo.Visible = false;
}
CardBattleObject cardBattleTomorrow = dataController.getCardBattleTomorrow();
if (cardBattleTomorrow != null)
{
int cardBattleIDTomorrow = (int)cardBattleTomorrow.cardBattleId;
//lbl_cardOne.Text = cardBattleTomorrow.cardOne.name;
img_cardOneTomorrow.ImageUrl = IMAGE_OPEN_LOCATION + (int)cardBattleTomorrow.cardOne.cardId + "/" + cardBattleTomorrow.cardOne.imageURL;
img_cardOneTomorrow.ToolTip = cardBattleTomorrow.cardOne.description;
img_cardOneTomorrow.Visible = true;
//lbl_cardTwo.Text = cardBattleTomorrow.cardTwo.name;
img_cardTwoTomorrow.ImageUrl = IMAGE_OPEN_LOCATION + (int)cardBattleTomorrow.cardTwo.cardId + "/" + cardBattleTomorrow.cardTwo.imageURL;
img_cardTwoTomorrow.ToolTip = cardBattleTomorrow.cardTwo.description;
img_cardTwoTomorrow.Visible = true;
tbl_tomorrowBattle.Visible = true;
}
}
/// <summary>
/// Inserts a battle
/// </summary>
/// <param name="card"></param>
/// <returns></returns>
public int? insertCardBattle(CardBattleObject cardBattle)
{
openSQLConnection();
int? cardBattleId = null;
using (SqlCommand cmd = new SqlCommand("monbattle.InsertCardBattle", this.sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BattleDate", SqlDbType.DateTime);
cmd.Parameters["@BattleDate"].Value = cardBattle.battleDate;
cmd.Parameters.Add("@CardOneID", SqlDbType.Int);
cmd.Parameters["@CardOneID"].Value = cardBattle.cardOne.cardId;
cmd.Parameters.Add("@CardTwoID", SqlDbType.Int);
cmd.Parameters["@CardTwoID"].Value = cardBattle.cardTwo.cardId;
SqlParameter parameter = cmd.Parameters.Add("@CardBattleID", SqlDbType.Int);
parameter.Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
cardBattleId = (int)cmd.Parameters["@CardBattleID"].Value;
}
catch (SqlException e)
{
throw e;
}
finally
{
closeSQLConnection();
}
}
return cardBattleId;
}
/// <summary>
/// Updates a card battle
/// </summary>
/// <param name="card"></param>
/// <returns></returns>
public bool? updateCardBattle(CardBattleObject cardBattle)
{
openSQLConnection();
bool? updateSuccessful = false;
using (SqlCommand cmd = new SqlCommand("monbattle.UpdateCard", this.sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CardBattleID", SqlDbType.Int);
cmd.Parameters["@CardBattleID"].Value = cardBattle.cardBattleId;
cmd.Parameters.Add("@BattleDate", SqlDbType.DateTime);
cmd.Parameters["@BattleDate"].Value = cardBattle.battleDate;
cmd.Parameters.Add("@CardOneID", SqlDbType.Int);
cmd.Parameters["@CardOneID"].Value = cardBattle.cardOne;
cmd.Parameters.Add("@CardTwoID", SqlDbType.Int);
cmd.Parameters["@CardTwoID"].Value = cardBattle.cardTwo;
try
{
cmd.ExecuteNonQuery();
updateSuccessful = true;
}
catch (SqlException e)
{
throw e;
}
finally
{
closeSQLConnection();
}
}
return updateSuccessful;
}
private CardBattleObject getCardBattleHelper(SqlDataReader cardBattleResult)
{
CardBattleObject cardBattle = null;
CardObject cardOne = null;
CardObject cardTwo = null;
if (cardBattleResult.Read())
{
int? CardBattleId = null;
int? winnerCardId = null;
DateTime? battleDate = null;
int? cardOneVotes = null;
int? cardTwoVotes = null;
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("CardBattleID")))
{
CardBattleId = cardBattleResult.GetInt32(cardBattleResult.GetOrdinal("CardBattleID"));
}
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("CardOneID")))
{
int cardOneId = cardBattleResult.GetInt32(cardBattleResult.GetOrdinal("CardOneID"));
cardOne = getCard(cardOneId);
}
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("CardTwoID")))
{
int cardTwoId = cardBattleResult.GetInt32(cardBattleResult.GetOrdinal("CardTwoID"));
cardTwo = getCard(cardTwoId);
}
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("WinnerCardID")))
{
winnerCardId = cardBattleResult.GetInt32(cardBattleResult.GetOrdinal("WinnerCardID"));
}
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("BattleDate")))
{
battleDate = cardBattleResult.GetDateTime(cardBattleResult.GetOrdinal("BattleDate"));
}
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("CardOneVotes")))
{
cardOneVotes = cardBattleResult.GetInt32(cardBattleResult.GetOrdinal("CardOneVotes"));
}
if (!cardBattleResult.IsDBNull(cardBattleResult.GetOrdinal("CardTwoVotes")))
{
cardTwoVotes = cardBattleResult.GetInt32(cardBattleResult.GetOrdinal("CardTwoVotes"));
}
cardBattle = new CardBattleObject(CardBattleId, battleDate, cardOne, cardTwo, winnerCardId, cardOneVotes, cardTwoVotes);
}
cardBattleResult.Close();
return cardBattle;
}
/// <summary>
/// Update a card battle
/// </summary>
/// <param name="cardBattle"></param>
/// <returns></returns>
public bool? updateCardBattle(CardBattleObject cardBattle)
{
bool? successfulUpdate = dataModel.updateCardBattle(cardBattle);
return successfulUpdate;
}
/// <summary>
/// Insert a new card battle
/// </summary>
/// <param name="cardBattle"></param>
/// <returns></returns>
public int? insertCardBattle(CardBattleObject cardBattle)
{
int? cardBattleId = dataModel.insertCardBattle(cardBattle);
return cardBattleId;
}
