public Contest Insert(Contest contest)
{
try
{
connection.Open();
var cmd = connection.CreateCommand() as SqlCommand;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Contest_Insert";
cmd.Parameters.Add(new SqlParameter("@startDate", contest.StartDate));
cmd.Parameters.Add(new SqlParameter("@endDate", contest.EndDate));
cmd.Parameters.Add(new SqlParameter("@shortTitle", contest.ShortTitle));
cmd.Parameters.Add(new SqlParameter("@title", contest.Title));
cmd.Parameters.Add(new SqlParameter("@description", contest.Description));
cmd.Parameters.Add(new SqlParameter("@regionId", contest.RegionId));
if (contest.ImageURL == null)
contest.ImageURL = "";
cmd.Parameters.Add(new SqlParameter("@imageUrl", contest.ImageURL));
var idParameter = new SqlParameter("@ID", SqlDbType.Int) { Direction = ParameterDirection.Output };
cmd.Parameters.Add(idParameter);
cmd.ExecuteNonQuery();
connection.Close();
return contest;
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage<Contest> Post(Contest contest, HttpRequestMessage<Contest> request)
{
if (contest != null)
{
var contestDB = contestRepository.Insert(contest);
var response = new HttpResponseMessage<Contest>(contestDB) { StatusCode = HttpStatusCode.Created };
return response;
}
return new HttpResponseMessage<Contest>(null) { StatusCode = HttpStatusCode.NotFound, };
}
public ContestWinner(Contest _contest)
{
InitializeComponent();
contest = _contest;
this.Title.Text = contest.Title;
if (Current.Instance.Earthwatcher.Id == contest.WinnerId)
{
this.WinnerGrid.Visibility = System.Windows.Visibility.Visible;
}
else
{
this.WinnerName.Text = contest.Description;
this.AnounceWinnerGrid.Visibility = System.Windows.Visibility.Visible;
}
this.Loaded += ContestWinner_Loaded;
this.ShareStoryBoard.Completed += ShareStoryBoard_Completed;
}