protected void BtnEditors_Click(object sender, EventArgs e) { MultiView2.ActiveViewIndex = 2; // editörlük hakkında verileri çekme var connection = WebConfigurationManager.ConnectionStrings["DBConnection"]; SqlConnection sc = new SqlConnection(connection.ConnectionString); SqlCommand c = new SqlCommand("SELECT * FROM VEditors"); SqlCommand c2 = new SqlCommand("SELECT * FROM VEditorRequests"); SqlDataReader r; c.Connection = sc; c2.Connection = sc; try { sc.Open(); r = c.ExecuteReader(); RepeaterEditors.DataSource = r; RepeaterEditors.DataBind(); r.Close(); r = c2.ExecuteReader(); RepeaterRequests.DataSource = r; RepeaterRequests.DataBind(); r.Close(); } catch (SqlException ex) { Response.Write("Error!" + ex.Message); } finally { sc.Close(); sc.Dispose(); } }
protected void RepeaterRequests_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.CompareTo("RequestReject") == 0) { TextBox text = e.Item.FindControl("TextBoxRequestText") as TextBox; //reject CreditRequestAction cra = new CreditRequestAction(); cra.requestAction(Convert.ToInt32(e.CommandArgument.ToString()), 2, text.Text); RepeaterRequests.DataBind(); } if (e.CommandName.CompareTo("RequestVerify") == 0) { TextBox text = e.Item.FindControl("TextBoxRequestText") as TextBox; TextBox credit = e.Item.FindControl("TextBoxRequestVerifiedCredit") as TextBox; Label userid = e.Item.FindControl("LabelRequstUserId") as Label; Label type = e.Item.FindControl("LabelRequestType") as Label; int typeCode = 0; if (type.Text == "1") { typeCode = 3; } else { typeCode = 4; } //verify CreditRequestAction cra = new CreditRequestAction(); cra.requestAction(Convert.ToInt32(e.CommandArgument.ToString()), 1, text.Text); RepeaterRequests.DataBind(); //add credit CreditAdd ca = new CreditAdd(); ca.addCredit(Convert.ToInt32(userid.Text), typeCode, Convert.ToInt32(credit.Text), Convert.ToInt32(Session["UserId"]), text.Text); } }
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; } } 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; } } //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(); } }