protected void GridViewFriends_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.CompareTo("FriendsReject") == 0) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd; try { sqlCmd = new SqlCommand("sp_requestsConnectionsFriendsReject", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@RequestId", SqlDbType.Int).Value = Convert.ToInt32(e.CommandArgument.ToString()); sqlConn.Open(); sqlCmd.ExecuteNonQuery(); } catch { } finally { sqlConn.Close(); } GridViewFriends.DataBind(); } if (e.CommandName.CompareTo("FriendsAccept") == 0) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlCommand sqlCmd; try { DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter("sp_requestsConnectionsFriendsVerify", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@RequestId", SqlDbType.Int).Value = Convert.ToInt32(e.CommandArgument.ToString()); sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]); sda.Fill(ds); dt = ds.Tables[0]; dt2 = ds.Tables[1]; NotificationsClass nc = new NotificationsClass(); nc.addNotification(1, Convert.ToInt32(dt.Rows[0]["FriendId"].ToString()), 7, dt2.Rows[0]["FullName"].ToString(), ""); } catch { } finally { sqlConn.Close(); } GridViewFriends.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { DataTable panelPopup = new DataTable(); panelPopup.Columns.Add("Input"); panelPopup.Columns.Add("Name"); panelPopup.Columns.Add("Output"); createActionTable("User", panelPopup); GridViewUser.DataSource = panelPopup; GridViewUser.DataBind(); panelPopup.Clear(); createActionTable("Friend", panelPopup); GridViewFriends.DataSource = panelPopup; GridViewFriends.DataBind(); panelPopup.Clear(); createActionTable("Album", panelPopup); GridViewAlbum.DataSource = panelPopup; GridViewAlbum.DataBind(); panelPopup.Clear(); createActionTable("Photo", panelPopup); GridViewPhoto.DataSource = panelPopup; GridViewPhoto.DataBind(); panelPopup.Clear(); createActionTable("Post", panelPopup); GridViewPost.DataSource = panelPopup; GridViewPost.DataBind(); panelPopup.Clear(); createActionTable("Video", panelPopup); GridViewVideo.DataSource = panelPopup; GridViewVideo.DataBind(); panelPopup.Clear(); createActionTable("Like", panelPopup); GridViewLike.DataSource = panelPopup; GridViewLike.DataBind(); panelPopup.Clear(); createActionTable("Comment", panelPopup); GridViewComment.DataSource = panelPopup; GridViewComment.DataBind(); }