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();
}
}
