/*
* Pre:
* Post: If all entered data is valid, a new audition is created in the database
*/
protected void btnSubmit_Click(object sender, EventArgs e)
{
Audition audition;
//make sure the entered data is valid before adding or updating
if (dataIsValid())
{
int districtId = Convert.ToInt32(ddlDistrict.SelectedValue);
//int numJudges = Convert.ToInt32(txtNumJudges.Text);
string chairperson = ddlChairPerson.SelectedValue;
DateTime auditionDate, freezeDate;
DateTime.TryParse(txtDate.Value, out auditionDate);
DateTime.TryParse(txtFreezeDate.Value, out freezeDate);
// Get session start and end times
TimeSpan session1StartTime = GetTime(ddlAmPmStart1, ddlHourStart1, ddlMinutesStart1);
TimeSpan session1EndTime = GetTime(ddlAmPmEnd1, ddlHourEnd1, ddlMinutesEnd1);
TimeSpan session2StartTime = GetTime(ddlAmPmStart2, ddlHourStart2, ddlMinutesStart2);
TimeSpan session2EndTime = GetTime(ddlAmPmEnd2, ddlHourEnd2, ddlMinutesEnd2);
TimeSpan session3StartTime = GetTime(ddlAmPmStart3, ddlHourStart3, ddlMinutesStart3);
TimeSpan session3EndTime = GetTime(ddlAmPmEnd3, ddlHourEnd3, ddlMinutesEnd3);
TimeSpan session4StartTime = GetTime(ddlAmPmStart4, ddlHourStart4, ddlMinutesStart4);
TimeSpan session4EndTime = GetTime(ddlAmPmEnd4, ddlHourEnd4, ddlMinutesEnd4);
string session1StartDisplayTime = GetDisplayTime(ddlAmPmStart1, ddlHourStart1, ddlMinutesStart1);
string session2StartDisplayTime = GetDisplayTime(ddlAmPmStart2, ddlHourStart2, ddlMinutesStart2);
string session3StartDisplayTime = GetDisplayTime(ddlAmPmStart3, ddlHourStart3, ddlMinutesStart3);
string session4StartDisplayTime = GetDisplayTime(ddlAmPmStart4, ddlHourStart4, ddlMinutesStart4);
string session1EndDisplayTime = GetDisplayTime(ddlAmPmEnd1, ddlHourEnd1, ddlMinutesEnd1);
string session2EndDisplayTime = GetDisplayTime(ddlAmPmEnd2, ddlHourEnd2, ddlMinutesEnd2);
string session3EndDisplayTime = GetDisplayTime(ddlAmPmEnd3, ddlHourEnd3, ddlMinutesEnd3);
string session4EndDisplayTime = GetDisplayTime(ddlAmPmEnd4, ddlHourEnd4, ddlMinutesEnd4);
//if a new audition is being created and the same audition doesn't already exist, add it
if (action == Utility.Action.Add && !DbInterfaceAudition.AuditionExists(districtId, auditionDate.Year))
{
audition = new Audition(districtId, /*numJudges*/ 0, txtVenue.Text, chairperson,
ddlTheorySeries.Text, auditionDate, freezeDate, session1StartTime,
session1EndTime, session2StartTime, session2EndTime, session3StartTime,
session3EndTime, session4StartTime, session4EndTime, session1StartDisplayTime,
session2StartDisplayTime, session3StartDisplayTime, session4StartDisplayTime,
session1EndDisplayTime, session2EndDisplayTime, session3EndDisplayTime, session4EndDisplayTime,
true);
//if the audition was successfully created, display a success message and clear the page
if (audition.auditionId != -1)
{
showSuccessMessage("The event was successfully created.");
clearPage();
}
else
{
showErrorMessage("Error: The audition could not be created. Please make sure all entered data is valid.");
}
}
//update the information of an existing audition
else if (action == Utility.Action.Edit)
{
int auditionId = Convert.ToInt32(txtIdHidden.Text);
audition = new Audition(auditionId, districtId, /*numJudges*/ 0, txtVenue.Text, chairperson, ddlTheorySeries.SelectedValue,
auditionDate, freezeDate, session1StartTime, session1EndTime, session2StartTime, session2EndTime,
session3StartTime, session3EndTime, session4StartTime, session4EndTime, session1StartDisplayTime,
session2StartDisplayTime, session3StartDisplayTime, session4StartDisplayTime, session1EndDisplayTime,
session2EndDisplayTime, session3EndDisplayTime, session4EndDisplayTime, true);
if (audition.auditionId != -1 && audition.updateInDatabase())
{
showSuccessMessage("The event was successfully updated.");
clearPage();
}
else
{
showErrorMessage("Error: An error occurred while updating the audition.");
}
}
//display an error message if the audition already exists
else
{
showErrorMessage("Error: An audition for this venue already exists.");
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "RefreshDatepickers", "refreshDatePickers()", true);
}
/*
* Pre:
* Post: If all entered data is valid, a new audition is created in the database
*/
protected void btnSubmit_Click(object sender, EventArgs e)
{
Audition audition;
clearErrors();
//make sure the entered data is valid before adding or updating
if (dataIsValid())
{
int districtId = Convert.ToInt32(ddlDistrict.SelectedValue);
int numJudges = Convert.ToInt32(txtNumJudges.Text);
string chairperson = ddlChairPerson.SelectedValue;
DateTime auditionDate, freezeDate;
DateTime.TryParse(txtDate.Value, out auditionDate);
DateTime.TryParse(txtFreezeDate.Value, out freezeDate);
TimeSpan startTime, endTime;
//get start time
string tempTime = txtStartTime.Value;
tempTime = tempTime.Substring(0, tempTime.Length - 2) + ":00 " + tempTime.Substring(tempTime.Length - 2, 2);
if (tempTime.Length == 10)
{
tempTime = "0" + tempTime;
}
if (tempTime.Substring(tempTime.Length - 2, 2).ToUpper().Equals("PM"))
{
tempTime = Utility.ConvertToPm(tempTime);
}
tempTime = tempTime.Substring(0, tempTime.Length - 2);
TimeSpan.TryParse(tempTime, out startTime);
//get end time
tempTime = txtEndTime.Value;
tempTime = tempTime.Substring(0, tempTime.Length - 2) + ":00 " + tempTime.Substring(tempTime.Length - 2, 2);
if (tempTime.Substring(tempTime.Length - 2, 2).ToUpper().Equals("PM"))
{
tempTime = Utility.ConvertToPm(tempTime);
}
tempTime = tempTime.Substring(0, tempTime.Length - 2);
TimeSpan.TryParse(tempTime, out endTime);
//if a new audition is being created and the same audition doesn't already exist, add it
if ((bool)Session[creatingNew] && !DbInterfaceAudition.AuditionExists(districtId, auditionDate.Year))
{
audition = new Audition(districtId, numJudges, txtVenue.Text, chairperson,
ddlTheorySeries.Text, auditionDate, freezeDate,
startTime, endTime, true);
//if the audition was successfully created, display a success message
if (audition.auditionId != -1)
{
displaySuccessMessageAndOptions();
Session[completed] = true;
}
else
{
lblErrorMsg.Text = "The audition could not be created. Please make sure " +
"all entered data is valid.";
lblErrorMsg.Visible = true;
}
}
//update the information of an existing audition
else if (!(bool)Session[creatingNew])
{
int auditionId = Convert.ToInt32(txtIdHidden.Text);
audition = new Audition(auditionId, districtId, numJudges, txtVenue.Text,
chairperson, ddlTheorySeries.SelectedValue, auditionDate,
freezeDate, startTime, endTime, true);
if (audition.auditionId != -1 && audition.updateInDatabase())
{
displaySuccessMessageAndOptions();
Session[completed] = true;
}
else
{
lblErrorMsg.Text = "An error occurred while updating the audition.";
lblErrorMsg.Visible = true;
}
}
//display an error message if the audition already exists
else
{
lblErrorMsg.Text = "An audition for this venue already exists";
lblErrorMsg.Visible = true;
}
}
}
/*
* Pre:
* Post: If all entered data is valid, a new audition is created in the database
*/
protected void btnSubmit_Click(object sender, EventArgs e)
{
Audition audition;
//make sure the entered data is valid before adding or updating
if (dataIsValid())
{
int districtId = Convert.ToInt32(ddlDistrict.SelectedValue);
//int numJudges = Convert.ToInt32(txtNumJudges.Text);
string chairperson = ddlChairPerson.SelectedValue;
DateTime auditionDate, freezeDate;
DateTime.TryParse(txtDate.Value, out auditionDate);
DateTime.TryParse(txtFreezeDate.Value, out freezeDate);
// Get session start and end times
TimeSpan session1StartTime = GetTime(ddlAmPmStart1, ddlHourStart1, ddlMinutesStart1);
TimeSpan session1EndTime = GetTime(ddlAmPmEnd1, ddlHourEnd1, ddlMinutesEnd1);
TimeSpan session2StartTime = GetTime(ddlAmPmStart2, ddlHourStart2, ddlMinutesStart2);
TimeSpan session2EndTime = GetTime(ddlAmPmEnd2, ddlHourEnd2, ddlMinutesEnd2);
TimeSpan session3StartTime = GetTime(ddlAmPmStart3, ddlHourStart3, ddlMinutesStart3);
TimeSpan session3EndTime = GetTime(ddlAmPmEnd3, ddlHourEnd3, ddlMinutesEnd3);
TimeSpan session4StartTime = GetTime(ddlAmPmStart4, ddlHourStart4, ddlMinutesStart4);
TimeSpan session4EndTime = GetTime(ddlAmPmEnd4, ddlHourEnd4, ddlMinutesEnd4);
string session1StartDisplayTime = GetDisplayTime(ddlAmPmStart1, ddlHourStart1, ddlMinutesStart1);
string session2StartDisplayTime = GetDisplayTime(ddlAmPmStart2, ddlHourStart2, ddlMinutesStart2);
string session3StartDisplayTime = GetDisplayTime(ddlAmPmStart3, ddlHourStart3, ddlMinutesStart3);
string session4StartDisplayTime = GetDisplayTime(ddlAmPmStart4, ddlHourStart4, ddlMinutesStart4);
string session1EndDisplayTime = GetDisplayTime(ddlAmPmEnd1, ddlHourEnd1, ddlMinutesEnd1);
string session2EndDisplayTime = GetDisplayTime(ddlAmPmEnd2, ddlHourEnd2, ddlMinutesEnd2);
string session3EndDisplayTime = GetDisplayTime(ddlAmPmEnd3, ddlHourEnd3, ddlMinutesEnd3);
string session4EndDisplayTime = GetDisplayTime(ddlAmPmEnd4, ddlHourEnd4, ddlMinutesEnd4);
bool duetsAllowed = false;
if (ddlDuets.SelectedValue.Equals("Yes"))
{
duetsAllowed = true;
}
//if a new audition is being created and the same audition doesn't already exist, add it
if (action == Utility.Action.Add && !DbInterfaceAudition.AuditionExists(districtId, auditionDate.Year))
{
audition = new Audition(districtId, /*numJudges*/ 0, txtVenue.Text, chairperson, "", auditionDate, freezeDate,
session1StartTime, session1EndTime, session2StartTime, session2EndTime,
session3StartTime, session3EndTime, session4StartTime, session4EndTime, session1StartDisplayTime,
session2StartDisplayTime, session3StartDisplayTime, session4StartDisplayTime, session1EndDisplayTime,
session2EndDisplayTime, session3EndDisplayTime, session4EndDisplayTime, duetsAllowed);
//if the audition was successfully created, display a success message
if (audition.auditionId != -1)
{
displaySuccessMessage();
}
else
{
showErrorMessage("Error: The competition could not be created. Please make sure all entered data is valid.");
}
}
//update the information of an existing audition
else if (action == Utility.Action.Edit)
{
int auditionId = Convert.ToInt32(txtIdHidden.Text);
audition = new Audition(auditionId, districtId, /*numJudges*/ 0, txtVenue.Text,
chairperson, "", auditionDate, freezeDate, session1StartTime, session1EndTime,
session2StartTime, session2EndTime, session3StartTime, session3EndTime, session4StartTime,
session4EndTime, session1StartDisplayTime, session2StartDisplayTime, session3StartDisplayTime,
session4StartDisplayTime, session1EndDisplayTime, session2EndDisplayTime, session3EndDisplayTime,
session4EndDisplayTime, duetsAllowed);
if (audition.auditionId != -1 && audition.updateInDatabase())
{
displaySuccessMessage();
}
else
{
showErrorMessage("Error: The competition could not be updated.");
}
}
//display an error message if the audition already exists
else
{
showWarningMessage("An competition for this venue already exists.");
}
}
}
