/
AdminPost.aspx.cs
116 lines (95 loc) · 3.34 KB
/
AdminPost.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class AdminPost : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Email_ID"] == null)
{
Response.Redirect("Home.aspx");
}
lblCurrentUser.Text = Session["Email_ID"].ToString();
lblLoginTime.Text = DateTime.Now.ToString();
GridView1.Visible = true;
GridView1.SelectRow(-1);
GridView1.DataSourceID = "SqlDataSource1";
}
protected void btnManageUser_Click(object sender, EventArgs e)
{
Response.Redirect("AdminUser.aspx");
}
protected void btnManagePost_Click(object sender, EventArgs e)
{
Response.Redirect("AdminPost.aspx");
}
protected void btnManageComment_Click(object sender, EventArgs e)
{
Response.Redirect("AdminComment.aspx");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int postid = 0;
string postcontent = "";
DateTime modified = DateTime.Now;
string poststatus = "";
int rating = 0;
postid = Convert.ToInt16(((Label)GridView1.Rows[e.RowIndex].FindControl("lblpostid")).Text);
postcontent = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtPostContent")).Text;
poststatus = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtstatus")).Text;
rating = Convert.ToInt16(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtrating")).Text);
PostBLL pb = new PostBLL();
int i= pb.UpdatePost(postid,postcontent,modified,poststatus,rating);
if (i == 1)
{
Response.Write("<script language='javascript'>alert('Post has been updated !');</script>");
GridView1.DataBind();
}
else
{
Response.Write("<script language='javascript'>alert('Post is failed to be updated !');</script>");
GridView1.DataBind();
}
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int postid = 0;
postid = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
try
{
PostBLL pb = new PostBLL();
int i = pb.DeletePost(postid);
if (i == 1)
{
Response.Write("<script language='javascript'>alert('Post has been deleted !');</script>");
GridView1.DataBind();
}
else
Response.Write("<script language='javascript'>alert('Post is failed to be deleted !');</script>");
}
catch (SqlException ex)
{
Response.Write(ex.ToString());
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("ContactUs.aspx");
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
Session.Remove("Email_ID");
Response.Redirect("Home.aspx");
}
}