public int sendRequest(int userId, Int64 eventId) { Classes.Requests request = new Classes.Requests(); int result = request.requestSend(userId, eventId, ""); return(result); }
protected void ButtonRequest_Click(object sender, EventArgs e) { string message = TextBoxMessage.Text; if (message.Length > 85) { message = message.Substring(0, 85); } Classes.Requests r = new Classes.Requests(); int status = r.requestSend(Convert.ToInt32(Session["UserId"]), Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()), message); switch (status) { case -1: HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "request"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "You cannot send a request to your event!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; break; case 1: HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "request"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "You canceled your participation!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; HiddenFieldButtonStatus.Value = "2"; break; case 2: HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "request"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "You canceled your request!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; HiddenFieldButtonStatus.Value = "2"; break; case 3: HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "request"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "Your request has been successfully sent!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; HiddenFieldButtonStatus.Value = "3"; break; } }
public void requestResponse(int userId, Int64 requestId, bool response) { Classes.Requests r = new Classes.Requests(); var id = Convert.ToInt16(userId); if (response) { r.requestAccept(id, requestId); } else { r.requestReject(id, requestId); } }
protected void ButtonActionYes_Click(object sender, EventArgs e) { Classes.Requests r = new Classes.Requests(); int status = r.requestSend(Convert.ToInt32(Session["UserId"]), Convert.ToInt32(Page.RouteData.Values["EventId"].ToString()), "test"); switch (status) { case 1: LabelMessage.Text = "You cannot send a request to your event."; break; case 2: LabelMessage.Text = "You already send a request to this event."; break; case 3: LabelMessage.Text = "Your request has been sent."; break; } }
protected void Page_Load(object sender, EventArgs e) { //check login int UserId = 0; 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) //if user not logged in redirect to login { Response.Redirect("~/Login/Requests"); } else { Session["UserId"] = UserId.ToString(); } } else { Response.Redirect("~/Login/Requests"); } // Actions Int64 requestId = 0; int actionCode = 0; try { requestId = Convert.ToInt64(Page.RouteData.Values["RequestId"].ToString()); actionCode = Convert.ToInt32(Page.RouteData.Values["ActionCode"].ToString()); } catch (Exception ex) { } finally { } if (requestId != 0) { // accept if (actionCode == 1) { Classes.Requests r = new Classes.Requests(); int status = r.requestAccept(Convert.ToInt32(Session["UserId"]), requestId); if (status == 1) { //successful } else if (status == -1) { //unsuccessful } } // reject else if (actionCode == 2) { Classes.Requests r = new Classes.Requests(); r.requestReject(requestId); } Response.Redirect("~/Requests"); } //all read Classes.Requests re = new Classes.Requests(); re.allRead(UserId); DataTable dt = re.requestsList(UserId); if (dt.Rows.Count == 0) { LabelNoRecord.Visible = true; } else { LabelNoRecord.Visible = false; RepeaterRequests.DataSource = dt; RepeaterRequests.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //check login 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) //if user not logged in redirect to login { Response.Redirect("~/Login/Requests"); } else { Session["UserId"] = UserId.ToString(); } } else { Response.Redirect("~/Login/Requests"); } } //check user status string completionValue = Session["DoneCompletion"] as string; if (String.IsNullOrEmpty(completionValue)) { Classes.UserInfo ui = new Classes.UserInfo(); int userStatus = ui.getUserStatus(UserId); switch (userStatus) { case 1: Session["DoneCompletion"] = "1"; break; case 0: case 4: Response.Redirect("~/Completion"); break; case 2: Response.Redirect("~/Error/UserDisabled"); break; case 3: Response.Redirect("~/Error/UserDeactivated"); break; } } //all read Classes.Requests r = new Classes.Requests(); r.allRead(UserId); Classes.Requests re = new Classes.Requests(); Tuple<int, DataTable> result = re.requestsList(UserId); //status codes: 0 no event 1 requests 2 no request int status = result.Item1; HiddenFieldRequestsStatus.Value = status.ToString(); HiddenFieldTitle.Value = "Requests"; if (status == 1) { DataTable dt = result.Item2; RepeaterRequests.DataSource = dt; RepeaterRequests.DataBind(); } }
protected void ButtonRemoveParticipant_Click(object sender, EventArgs e) { int ownerId = Convert.ToInt32(Session["UserId"]); int userId = Convert.ToInt32(HiddenFieldParticipantValue.Value); Int64 eventId = Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()); Classes.Requests r = new Classes.Requests(); int status = r.removeParticipant(ownerId, userId, eventId); //0 user not owner 1 participants cancelled 2 user was not participant if (status == 0) { HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "participants"; HiddenFieldToastSmiley.Value = ":("; HiddenFieldToastMessage.Value = "You are not the owner of this event!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; } else if (status == 1) { ////////////////// participants list Classes.Events ev = new Classes.Events(); DataTable dtParticipants = ev.eventParticipants(eventId); RepeaterParticipants.DataSource = dtParticipants; RepeaterParticipants.DataBind(); if (RepeaterParticipants.Items.Count == 0) { LabelNoRecord.Visible = true; } HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "participants"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "The participant got removed!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; } else if (status == 2) { ////////////////// participants list Classes.Events ev = new Classes.Events(); DataTable dtParticipants = ev.eventParticipants(eventId); RepeaterParticipants.DataSource = dtParticipants; RepeaterParticipants.DataBind(); if (RepeaterParticipants.Items.Count == 0) { LabelNoRecord.Visible = true; } HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "participants"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "The user was not a participant!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; } }
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(); }
protected void Page_Load(object sender, EventArgs e) { //check login 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) //if user not logged in redirect to login { Response.Redirect("~/Login/Requests"); } else { Session["UserId"] = UserId.ToString(); } } else { Response.Redirect("~/Login/Requests"); } } //check user status string completionValue = Session["DoneCompletion"] as string; if (String.IsNullOrEmpty(completionValue)) { Classes.UserInfo ui = new Classes.UserInfo(); int userStatus = ui.getUserStatus(UserId); switch (userStatus) { case 1: Session["DoneCompletion"] = "1"; break; case 0: case 4: Response.Redirect("~/Completion"); break; case 2: Response.Redirect("~/Error/UserDisabled"); break; case 3: Response.Redirect("~/Error/UserDeactivated"); break; } } Int64 eventId = 0; try { eventId = Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()); } catch (Exception ex) { } finally { } if (eventId == 0) { Response.Redirect("~/Requests"); } int actionCode = 0; Int64 requestId = 0; try { actionCode = Convert.ToInt32(Page.RouteData.Values["ActionCode"].ToString()); requestId = Convert.ToInt64(Page.RouteData.Values["RequestId"].ToString()); } catch (Exception ex) { } finally { } if (actionCode != 0 && requestId != 0) { Classes.Requests r1 = new Classes.Requests(); if (actionCode == 1) { r1.requestAccept(UserId, requestId); } else if (actionCode == 2) { r1.requestReject(UserId, requestId); } Response.Redirect("~/Requests/" + eventId.ToString()); } // no action, just show the requests Classes.Requests r2 = new Classes.Requests(); DataTable dt = r2.eventRequestsList(UserId, eventId); if (dt.Rows.Count == 0) { Response.Redirect("~/Requests"); } else { RepeaterRequests.DataSource = dt; RepeaterRequests.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //check login 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) //if user not logged in redirect to login { Response.Redirect("~/Login/Requests"); } else { Session["UserId"] = UserId.ToString(); } } else { Response.Redirect("~/Login/Requests"); } } //check user status string completionValue = Session["DoneCompletion"] as string; if (String.IsNullOrEmpty(completionValue)) { Classes.UserInfo ui = new Classes.UserInfo(); int userStatus = ui.getUserStatus(UserId); switch (userStatus) { case 1: Session["DoneCompletion"] = "1"; break; case 0: case 4: Response.Redirect("~/Completion"); break; case 2: Response.Redirect("~/Error/UserDisabled"); break; case 3: Response.Redirect("~/Error/UserDeactivated"); break; } } Int64 eventId = 0; try { eventId = Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()); } catch (Exception ex) { } finally { } if (eventId == 0) { Response.Redirect("~/Requests"); } int actionCode = 0; Int64 requestId = 0; try { actionCode = Convert.ToInt32(Page.RouteData.Values["ActionCode"].ToString()); requestId = Convert.ToInt64(Page.RouteData.Values["RequestId"].ToString()); } catch (Exception ex) { } finally { } if (actionCode != 0 && requestId != 0) { Classes.Requests r1 = new Classes.Requests(); if(actionCode == 1) { r1.requestAccept(UserId, requestId); } else if (actionCode == 2) { r1.requestReject(UserId, requestId); } Response.Redirect("~/Requests/" + eventId.ToString()); } // no action, just show the requests Classes.Requests r2 = new Classes.Requests(); DataTable dt = r2.eventRequestsList(UserId, eventId); if (dt.Rows.Count == 0) { Response.Redirect("~/Requests"); } else { RepeaterRequests.DataSource = dt; RepeaterRequests.DataBind(); } }
protected void ButtonRemoveParticipant_Click(object sender, EventArgs e) { int ownerId = Convert.ToInt32(Session["UserId"]); int userId = Convert.ToInt32(HiddenFieldParticipantValue.Value); Int64 eventId = Convert.ToInt64(Page.RouteData.Values["EventId"].ToString()); Classes.Requests r = new Classes.Requests(); int status = r.removeParticipant(ownerId, userId, eventId); //0 user not owner 1 participants cancelled 2 user was not participant if(status == 0) { HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "participants"; HiddenFieldToastSmiley.Value = ":("; HiddenFieldToastMessage.Value = "You are not the owner of this event!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; } else if (status == 1) { ////////////////// participants list Classes.Events ev = new Classes.Events(); DataTable dtParticipants = ev.eventParticipants(eventId); RepeaterParticipants.DataSource = dtParticipants; RepeaterParticipants.DataBind(); if (RepeaterParticipants.Items.Count == 0) { LabelNoRecord.Visible = true; } HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "participants"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "The participant got removed!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; } else if (status == 2) { ////////////////// participants list Classes.Events ev = new Classes.Events(); DataTable dtParticipants = ev.eventParticipants(eventId); RepeaterParticipants.DataSource = dtParticipants; RepeaterParticipants.DataBind(); if (RepeaterParticipants.Items.Count == 0) { LabelNoRecord.Visible = true; } HiddenFieldToastStatus.Value = "1"; HiddenFieldToastMode.Value = "participants"; HiddenFieldToastSmiley.Value = ":)"; HiddenFieldToastMessage.Value = "The user was not a participant!"; HiddenFieldButton1Text.Value = "OK"; HiddenFieldButton1Color.Value = "d7432e"; } }
protected void Page_Load(object sender, EventArgs e) { //check login 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) //if user not logged in redirect to login { Response.Redirect("~/Login/Requests"); } else { Session["UserId"] = UserId.ToString(); } } else { Response.Redirect("~/Login/Requests"); } } //check user status string completionValue = Session["DoneCompletion"] as string; if (String.IsNullOrEmpty(completionValue)) { Classes.UserInfo ui = new Classes.UserInfo(); int userStatus = ui.getUserStatus(UserId); switch (userStatus) { case 1: Session["DoneCompletion"] = "1"; break; case 0: case 4: Response.Redirect("~/Completion"); break; case 2: Response.Redirect("~/Error/UserDisabled"); break; case 3: Response.Redirect("~/Error/UserDeactivated"); break; } } //all read Classes.Requests r = new Classes.Requests(); r.allRead(UserId); Classes.Requests re = new Classes.Requests(); Tuple <int, DataTable> result = re.requestsList(UserId); //status codes: 0 no event 1 requests 2 no request int status = result.Item1; HiddenFieldRequestsStatus.Value = status.ToString(); HiddenFieldTitle.Value = "Requests"; if (status == 1) { DataTable dt = result.Item2; RepeaterRequests.DataSource = dt; RepeaterRequests.DataBind(); } }