protected void ButtonBoardMessageAdd_Click(object sender, EventArgs e) { Int64 eventId = Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()); int userId = Convert.ToInt32(Session["UserId"]); Classes.Events ev = new Classes.Events(); bool status = ev.allowBoard(userId, eventId); if (status) { string message = TextBoxBoardMessageAdd.Text; Int16 status2 = ev.eventBoardMessagesAdd(eventId, userId, message); HiddenFieldBoardStatus.Value = "1"; } else { HiddenFieldBoardStatus.Value = "0"; } }
protected void Page_Load(object sender, EventArgs e) { //check to see if the user logged in or is a guest int UserId = 0; if (Session["UserId"] != null) { UserId = Convert.ToInt32(Session["UserId"]); } else { if (Request.Cookies["VC"] != null) { string VC = Request.Cookies["VC"].Values["VC"]; Classes.LoginSession ls = new Classes.LoginSession(); UserId = ls.getUserId(VC); if (UserId == 0) { //Response.Redirect("~/Login"); } } } int buttonsStatus = 2; //0 guest 1 owner 2 user not requested 3 user requested 4 user participant int OwnerId = -1; if (UserId == 0) { buttonsStatus = 0; } Int64 eventId = Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()); if (!IsPostBack) { // get info Classes.Events ev = new Classes.Events(); DataTable dt = ev.eventInfo(eventId, UserId); if (dt.Rows.Count == 0)// event doesn't exist { Response.Redirect("~/Error/EventNotFound"); } else { int eventStatus = Convert.ToInt32(dt.Rows[0]["Status"].ToString()); if (eventStatus == 4)// event is banned { Response.Redirect("~/Error/EventNotFound"); } //count available spots int participantsAvailable = Convert.ToInt32(dt.Rows[0]["ParticipantsAccepted"].ToString()); int participants = Convert.ToInt32(dt.Rows[0]["Participants"].ToString()); HiddenFieldOwnerId.Value = dt.Rows[0]["OwnerId"].ToString(); HiddenFieldEventId.Value = Page.RouteData.Values["EventId"].ToString(); LabelName.Text = dt.Rows[0]["Name"].ToString(); Page.Title = dt.Rows[0]["Name"].ToString(); HiddenFieldDate.Value = dt.Rows[0]["Date"].ToString(); LabelParticipants.Text = (participants + 1).ToString(); LabelParticipantsAvailable.Text = (participantsAvailable + 1).ToString(); LabelAddress.Text = dt.Rows[0]["Address"].ToString(); LabelDescriptions.Text = dt.Rows[0]["Descriptions"].ToString(); HiddenFieldUsername.Value = dt.Rows[0]["Username"].ToString(); HiddenFieldOwnerFullname.Value = dt.Rows[0]["OwnerName"].ToString(); HiddenFieldTypeId.Value = dt.Rows[0]["TypeId"].ToString(); HiddenFieldCoverId.Value = dt.Rows[0]["CoverId"].ToString(); OwnerId = Convert.ToInt32(dt.Rows[0]["OwnerId"].ToString()); Classes.Locations l = new Classes.Locations(); DataTable dtLocation = l.getLocationInfoByCityId(Convert.ToInt32(dt.Rows[0]["LocationId"].ToString())); if (dtLocation.Rows.Count == 0) { LabelLocation.Text = "Not Available!"; } else { LabelLocation.Text = dtLocation.Rows[0]["CountryName"].ToString() + " - " + dtLocation.Rows[0]["CityName"].ToString(); } //Owner photo url if (Convert.ToBoolean(dt.Rows[0]["OwnerHasPhoto"].ToString())) { HiddenFieldOwnerPhotoUrl.Value = "Files/ProfilesPhotos/" + dt.Rows[0]["OwnerId"].ToString() + "-100.jpg"; } else { HiddenFieldOwnerPhotoUrl.Value = "Images/nophoto.png"; } //owner rate int RateCount = Convert.ToInt32(dt.Rows[0]["RateCount"].ToString()); int RateScore = Convert.ToInt32(dt.Rows[0]["RateScore"].ToString()); int RateSufficient = Convert.ToInt32(ConfigurationManager.AppSettings["RateSufficient"].ToString()); if (RateCount >= RateSufficient) { int RatePercent = (20 * RateScore / RateCount); HiddenFieldOwnerRateScore.Value = RatePercent.ToString(); HiddenFieldOwnerRateCount.Value = RateCount.ToString(); } else { HiddenFieldOwnerRateScore.Value = "0"; HiddenFieldOwnerRateCount.Value = "0"; } switch (dt.Rows[0]["Status"].ToString()) { case "1": LabelStatus.Text = "Available"; break; case "2": LabelStatus.Text = "Full"; break; case "3": LabelStatus.Text = "Passed"; break; } if (UserId != 0) { //check to see if the user logged in or is a guest if (UserId.ToString() == dt.Rows[0]["OwnerId"].ToString()) { HyperLinkModify.Visible = true; HyperLinkModify.NavigateUrl = "~/Events/Modify/" + eventId.ToString(); buttonsStatus = 1; } //bookmark bool bookmarkStatus = ev.checkBookmark(UserId, eventId); if (bookmarkStatus == true) { ButtonBookmark.Text = "Remove Bookmark"; } else { ButtonBookmark.Text = "Add Bookmark"; } HiddenFieldButtonStatus.Value = buttonsStatus.ToString(); } } ////////////////// participants list DataTable dtParticipants = ev.eventParticipants(eventId); RepeaterParticipants.DataSource = dtParticipants; RepeaterParticipants.DataBind(); if (RepeaterParticipants.Items.Count == 0) { LabelNoRecord.Visible = true; } /////////////////////////////////////////////board messages bool status = ev.allowBoard(UserId, eventId); if (status) { getBoardMessages(eventId, Convert.ToInt32(dt.Rows[0]["OwnerId"].ToString())); HiddenFieldBoardStatus.Value = "1"; } else { HiddenFieldBoardStatus.Value = "0"; } } else { Page.Title = LabelName.Text; } if (UserId != 0) { if (UserId.ToString() == OwnerId.ToString()) { buttonsStatus = 1; } else { Classes.Requests r = new Classes.Requests(); int requestStatus = r.checkRequest(UserId, eventId); if (requestStatus == 0) { buttonsStatus = 2; } else if (requestStatus == 1) { buttonsStatus = 3; } else if (requestStatus == 2) { buttonsStatus = 4; } } } HiddenFieldRequestStatus.Value = buttonsStatus.ToString(); HiddenFieldButtonStatus.Value = buttonsStatus.ToString(); }