protected void JoinEvent_Click(object sender, EventArgs e)
{
string userName = this.User.Identity.Name;
DataAccess databaseAccess = DataAccess.Instance();
EventData eventDetailsTable = DataAccess.Instance().retrieveEventDetailsFromId(eventRecId);
if (databaseAccess.getNumberOfParticipantsInEvent(eventRecId) + 1 <= eventDetailsTable.MaxParticipants || eventDetailsTable.MaxParticipants == 0)
{
databaseAccess.joinEvent(eventRecId, userName);
//Alert.Show("Congratulations! You have successfully registered to " + EventTitle.Text);
LeaveEvent.Visible = true;
JoinEvent.Visible = false;
UrlParameterPasser urlWrapper = new UrlParameterPasser("EventDetail.aspx");
urlWrapper["eventId"] = eventRecId.ToString();
urlWrapper.PassParameters();
}
else
{
Alert.Show("Sorry, but this event is already full.");
LeaveEvent.Visible = false;
JoinEvent.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Receive the parameters
UrlParameterPasser urlWrapper = new UrlParameterPasser();
String filterDate = urlWrapper["filterDate"];
this.filterOnDate(filterDate);
}
protected void AddComment(object sender, EventArgs e)
{
DataAccess accessDataBase = DataAccess.Instance();
UrlParameterPasser urlWrapper;
accessDataBase.addComment(eventRecId, this.User.Identity.Name, txtCommentBody.Text.Trim());
// Reload page
urlWrapper = new UrlParameterPasser("EventDetail.aspx");
urlWrapper["eventId"] = eventRecId.ToString();
urlWrapper.PassParameters();
}
protected void AddEvent_Click(object sender, EventArgs e)
{
string ownerUserName = this.User.Identity.Name;
int maxNumParticipants = 0;
int minNumParticipants = 0;
string eventId;
UrlParameterPasser urlWrapper;
if (this.IsValid)
{
//Insert to TtlerEventsDB
DataAccess insertEventToDB = DataAccess.Instance();
if (MaxParticipants.Text != "")
{
maxNumParticipants = Int32.Parse(MaxParticipants.Text);
}
if (MinParticipants.Text != "")
{
minNumParticipants = Int32.Parse(MinParticipants.Text);
}
insertEventToDB.insertEvent(
EventTitle.Text,
EventLocation.Text,
EventStartDateTime.Text,
EventEndDateTime.Text,
EventDescription.Text,
maxNumParticipants,
minNumParticipants,
ownerUserName);
eventId = insertEventToDB.getEventIdFromEventNameAndDateTime(EventTitle.Text, EventStartDateTime.Text);
insertEventToDB.joinEvent(Int64.Parse(eventId), ownerUserName);
// Pass textbox values to ReceiveQueryString.aspx
urlWrapper = new UrlParameterPasser("EventDetail.aspx");
// Add some values
urlWrapper["eventId"] = eventId;
// Redirect to the page, passing the parameters in the querystring
urlWrapper.PassParameters();
}
}
protected void LeaveEvent_Click(object sender, EventArgs e)
{
string userName = this.User.Identity.Name;
DataAccess addPartiicipantToDB = DataAccess.Instance();
addPartiicipantToDB.leaveEvent(eventRecId, userName);
LeaveEvent.Visible = false;
JoinEvent.Visible = true;
//Alert.Show("You have left the event " + EventTitle.Text);
UrlParameterPasser urlWrapper = new UrlParameterPasser("EventDetail.aspx");
urlWrapper["eventId"] = eventRecId.ToString();
urlWrapper.PassParameters();
}
protected void Page_Load(object sender, EventArgs e)
{
string eventId;
string userName = this.User.Identity.Name;
DataAccess databaseAccess = DataAccess.Instance();
// Receive the parameters
UrlParameterPasser urlWrapper = new UrlParameterPasser();
eventId = urlWrapper["eventId"];
if (eventId == null){
Response.Redirect("/MyEvents");
}
else{
eventRecId = Convert.ToInt64(eventId);
EventData eventDetailsTable = DataAccess.Instance().retrieveEventDetailsFromId(eventRecId);
// Set the form data
if (!IsPostBack)
{
SaveEvent.Visible = false;
//Need new stored procedure to get the data and count of all registered participants
EventTitle.Text = eventDetailsTable.EventName;
EventOwner.Text = databaseAccess.getUserNameFromUserName(eventDetailsTable.OwnerId);
EventStartDateTime.Text = eventDetailsTable.StartDateTime;
EventEndDateTime.Text = eventDetailsTable.StartDateTime;
EventLocation.Text = eventDetailsTable.Location;
EventDescription.Text = eventDetailsTable.Description;
MinParticipants.Text = eventDetailsTable.MinParticipants.ToString();
MaxParticipants.Text = eventDetailsTable.MaxParticipants.ToString();
//Progress Bar data
int minParticipants = eventDetailsTable.MinParticipants;
int maxParticipants = eventDetailsTable.MaxParticipants;
int registeredParticipants = databaseAccess.getNumberOfParticipantsInEvent(eventRecId);
SetTheProgressBar(minParticipants, maxParticipants, registeredParticipants);
}
if (!databaseAccess.checkUserNameBelongsToUserId(eventDetailsTable.OwnerId, this.User.Identity.Name))
{
DeleteEvent.Visible = false;
EditEvent.Visible = false;
if (databaseAccess.checkUserIsAlreadyParticipant(eventRecId, userName))
{
JoinEvent.Visible = false;
LeaveEvent.Visible = true;
}
}
else
{
DeleteEvent.Visible = true;
EditEvent.Visible = true;
JoinEvent.Visible = false;
}
if (!this.IsPostBack)
{
this.PopulateComments();
}
ParticipantsDataSource.SelectParameters["EventId"].DefaultValue = eventId;
AttendeesList.DataBind();
}
}
