Пример #1
0
    protected void AccessModulePermisssion()
    {
        objDO.intUserId          = Convert.ToInt32(ViewState["UserID"]);
        objDO.inGroupId          = Convert.ToInt32(ViewState["intGroupId"]);
        objgrp.inGroupId         = Convert.ToInt32(ViewState["intGroupId"]);
        objgrp.intRegistrationId = Convert.ToInt32(ViewState["UserID"]);
        DataSet   dschk    = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ViewGrpAssignUser);
        DataTable dtRoleAP = objDA.GetDataTable(objDO, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetGrpRoleRequestPermission);

        if (dschk.Tables[3].Rows.Count > 0)
        {
            if (dschk.Tables[3].Rows[0][0].ToString() == ViewState["UserID"].ToString())
            {
                // divSecondWall.Style.Add("display", "block");
                DivHome.Style.Add("display", "block");
                DivForumTab.Style.Add("display", "block");
                DivUploadTab.Style.Add("display", "block");
                DivPollTab.Style.Add("display", "block");
                DivEventTab.Style.Add("display", "block");
                //DivJobTab.Style.Add("display", "block");
                DivMemberTab.Style.Add("display", "block");
                return;
            }
        }

        if (dtRoleAP.Rows.Count > 0)
        {
            if (dtRoleAP.Rows[0]["IsAccepted"].ToString() != "0" && dtRoleAP.Rows[0]["IsAccepted"].ToString() != "2")
            {
                //divSecondWall.Style.Add("display", "block");
                DivHome.Style.Add("display", "block");
                DivForumTab.Style.Add("display", "block");
                DivUploadTab.Style.Add("display", "block");
                DivPollTab.Style.Add("display", "block");
                DivEventTab.Style.Add("display", "block");
                //DivJobTab.Style.Add("display", "block");
                DivMemberTab.Style.Add("display", "block");
            }
            else
            {
                Response.Redirect("Group-Profile.aspx?GrpId=" + ViewState["intGroupId"]);
            }
        }
        else
        {
            Response.Redirect("Group-Profile.aspx?GrpId=" + ViewState["intGroupId"]);
        }
    }
Пример #2
0
    public void GetAssignRole()
    {
        if (ViewState["intGroupId"] != null)
        {
            objgrp.intRegistrationId = Convert.ToInt32(ViewState["UserID"]);
            objgrp.inGroupId         = Convert.ToInt32(ViewState["intGroupId"]);
            DataSet dschk  = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ViewGrpAssignUser);
            string  Status = string.Empty;

            DataTable dtGrpOpt = objgrpDB.GetDataTable(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.ChkGroupOption);

            if (dtGrpOpt.Rows[0]["strAccess"].ToString() == "A")
            {
                DivHome.Style.Add("display", "block");
                DivForumTab.Style.Add("display", "block");
                DivUploadTab.Style.Add("display", "block");
                DivPollTab.Style.Add("display", "block");
                DivEventTab.Style.Add("display", "block");
                DivJobTab.Style.Add("display", "block");
                DivMemberTab.Style.Add("display", "block");
            }
            else
            {
                if (dschk.Tables[0].Rows[0][0].ToString() != "0")
                {
                    DivHome.Style.Add("display", "block");
                    DivForumTab.Style.Add("display", "block");
                    DivUploadTab.Style.Add("display", "block");
                    DivPollTab.Style.Add("display", "block");
                    DivEventTab.Style.Add("display", "block");
                    DivJobTab.Style.Add("display", "block");
                    DivMemberTab.Style.Add("display", "block");
                }
                else
                {
                    GetAccessModuleDetails();
                }
            }
        }
    }
Пример #3
0
    protected void GetGroupDetails()
    {
        objgrp.intAddedBy       = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
        objgrp.inGroupId        = Convert.ToInt32(ViewState["intGroupId"]);
        Session["GroupOwnerId"] = Convert.ToInt32(ViewState["intGroupId"]);

        DataSet ds = new DataSet();

        ds = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetOtherGroupDetailsByGroupId);

        if (ds.Tables[0].Rows.Count > 0)
        {
            ViewState["GetGroupDetailsByGroupId"] = ds;

            if (ds.Tables[0].Rows[0]["strLogoPath"].ToString() != "" && ds.Tables[0].Rows[0]["strLogoPath"].ToString() != string.Empty)
            {
                string imgPathPhysical = Server.MapPath("~/CroppedPhoto/" + Convert.ToString(ds.Tables[0].Rows[0]["strLogoPath"]));
                if (File.Exists(imgPathPhysical))
                {
                    imgGrp.Src = "~\\CroppedPhoto\\" + Convert.ToString(ds.Tables[0].Rows[0]["strLogoPath"]);
                }
                else
                {
                    imgGrp.Src = "~/images/photo1.png";
                }
            }
            else
            {
                imgGrp.Src = "~/images/photo1.png";
            }
            ViewState["GrpOwnerID"] = Convert.ToString(ds.Tables[0].Rows[0]["intRegistrationId"]);
            //lblOwner.Text = Convert.ToString(ds.Tables[0].Rows[0]["Name"]);

            lblGroupName.Text = Convert.ToString(ds.Tables[0].Rows[0]["strGroupName"]);
        }
    }
Пример #4
0
    protected void GetGroupDetails()
    {
        objgrp.intAddedBy       = Convert.ToInt32(Convert.ToString(Session["ExternalUserId"]));
        objgrp.inGroupId        = Convert.ToInt32(ViewState["intGroupId"]);
        Session["GroupOwnerId"] = Convert.ToInt32(ViewState["intGroupId"]);

        DataSet ds = new DataSet();

        ds = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetOtherGroupDetailsByGroupId);

        if (ds.Tables[0].Rows.Count > 0)
        {
            ViewState["GetGroupDetailsByGroupId"] = ds;

            if (ds.Tables[0].Rows[0]["strLogoPath"].ToString() != "" && ds.Tables[0].Rows[0]["strLogoPath"].ToString() != string.Empty)
            {
                string imgPathPhysical = Server.MapPath("~/CroppedPhoto/" + Convert.ToString(ds.Tables[0].Rows[0]["strLogoPath"]));
                if (File.Exists(imgPathPhysical))
                {
                    imgGrp.Src = "~\\CroppedPhoto\\" + Convert.ToString(ds.Tables[0].Rows[0]["strLogoPath"]);
                }
                else
                {
                    imgGrp.Src = "~/images/photo1.png";
                }
            }
            else
            {
                imgGrp.Src = "~/images/photo1.png";
            }
            ViewState["GrpOwnerID"] = Convert.ToString(ds.Tables[0].Rows[0]["intRegistrationId"]);
            lblOwner.Text           = Convert.ToString(ds.Tables[0].Rows[0]["Name"]);

            lblGroupName.Text = Convert.ToString(ds.Tables[0].Rows[0]["strGroupName"]);

            if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["dtAddedOn"])))
            {
                lblCreatedOn.Text = Convert.ToString(ds.Tables[0].Rows[0]["dtAddedOn"]);
            }
            if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["strSummary"])))
            {
                lblGroupSummary.Text = Convert.ToString(ds.Tables[0].Rows[0]["strSummary"]);
            }

            if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["strAccess"])))
            {
                if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A")
                {
                    lblGroupType.Text = "Auto Join";
                }

                else if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "R")
                {
                    lblGroupType.Text = "Request To Join";
                }
            }
        }

        if (Convert.ToString(ds.Tables[0].Rows[0]["intRegistrationId"]) == Convert.ToString(Session["ExternalUserId"]))
        {
            lnkJoin.Visible              = false;
            lnkMessage.Visible           = false;
            lnkEdit.Visible              = true;
            lnkAddMember.Visible         = true;
            spandropdownMenuLink.Visible = true;
            return;
        }

        if (ds.Tables[1].Rows.Count > 0)
        {
            if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0")
            {
                lnkJoin.InnerText = "Join";
                lnkJoin.Style.Remove("display");
                lnkShare.Visible = false;
            }
            else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1")
            {
                lnkJoin.InnerText = "Leave";

                spandropdownMenuLink.Visible = true;
                lnkLeave.Visible             = true;
                lnkJoin.Style.Add("display", "none");
            }
            else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2")
            {
                lnkJoin.InnerText = "Join";
                lnkJoin.Style.Remove("display");
                lnkShare.Visible = false;
            }
        }
        else
        {
            lnkJoin.InnerText = "Join";
            lnkJoin.Style.Remove("display");
            lnkShare.Visible = false;
        }
    }
Пример #5
0
    protected void lstChildMyTag_ItemCommand(object sender, ListViewCommandEventArgs e)
    {
        HiddenField hdnPkId           = (HiddenField)e.Item.FindControl("hdnPkId");
        HiddenField hdnTableName      = (HiddenField)e.Item.FindControl("hdnTableName");
        Label       lblEmailId        = (Label)e.Item.FindControl("lblEmailId");
        Label       lblGroupName      = (Label)e.Item.FindControl("lblGroupName");
        HiddenField hdnrequserid      = (HiddenField)e.Item.FindControl("hdnrequserid");
        HiddenField hdnRegistrationId = (HiddenField)e.Item.FindControl("hdnRegID");
        LinkButton  lnkstrLink        = (LinkButton)e.Item.FindControl("lnkstrLink");
        HiddenField hdnShareInvitee   = (HiddenField)e.Item.FindControl("hdnShareInvitee");

        ViewState["lblGroupName"] = lblGroupName.Text;
        hdnEmailId.Value          = lblEmailId.Text;

        if (e.CommandName == "Details" && Convert.ToInt32(hdnRegistrationId.Value) != 0)
        {
            //Response.Redirect(lnkstrLink.CommandArgument);
            Response.Redirect("Home.aspx?RegId=" + hdnRegistrationId.Value);
        }
        else if (e.CommandName == "Details" && Convert.ToInt32(hdnRegistrationId.Value) == 0)
        {
            lnkName.Attributes["class"] = "remove-hover-anchor";
        }
        else
        if (e.CommandName == "ShareDetails")
        {
            if (hdnRegistrationId.Value != Convert.ToString(ViewState["UserID"]))
            {
                Response.Redirect("Group-Home.aspx?GrpId=" + hdnrequserid.Value);
            }
        }
        else
        if (e.CommandName == "Confirm")
        {
            if (hdnTableName.Value == "Scrl_UserRequestInvitationTbl")
            {
                objRegistration.intRequestInvitaionId = Convert.ToInt32(hdnPkId.Value);
                objRegistration.AddedBy   = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRegistration.IpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRegistration.IpAddress == null)
                {
                    objRegistration.IpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRegistrationDB.AddEditDel_Request(objRegistration, DA_Registrationdetails.RegistrationDetails.Update);
                SendMail(e.CommandName, hdnTableName.Value);
                ScriptManager.RegisterStartupScript(this, this.GetType(), "starScripts", "CallUserMethod();", true);
            }

            else if (hdnTableName.Value == "Scrl_UserGroupJoiningTbl")
            {
                objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDO.intAddedBy       = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.isAccepted       = 1;
                objGrpJoinDO.strIpAddress     = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objGrpJoinDO.strIpAddress == null)
                {
                    objGrpJoinDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Update);
                SendMail(e.CommandName, hdnTableName.Value);
            }

            else if (hdnTableName.Value == "Scrl_UserRecommendationTbl")
            {
                objRecmndDO.intRecommendationId = Convert.ToInt32(hdnPkId.Value);
                objRecmndDO.intAddedBy          = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRecmndDO.strIpAddress        = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRecmndDO.strIpAddress == null)
                {
                    objRecmndDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRecmndDA.Scrl_AddEditDelRecommendations(objRecmndDO, DA_Scrl_UserRecommendation.Scrl_UserRecommendation.Update);

                SendMail(e.CommandName, hdnTableName.Value);
            }
            else if (hdnTableName.Value == "Scrl_RequestGroupJoin")
            {
                objgrp.intAddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objgrp.inGroupId  = Convert.ToInt32(hdnShareInvitee.Value);
                DataSet ds = new DataSet();
                ds = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetOtherGroupDetailsByGroupId);

                if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A")
                {
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0")
                        {
                            objGrpJoinDO.isAccepted = 1;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1")
                        {
                            objGrpJoinDO.isAccepted = 2;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2")
                        {
                            objGrpJoinDO.isAccepted = 1;
                        }
                    }
                    else
                    {
                        if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A")
                        {
                            objGrpJoinDO.isAccepted = 1;
                        }
                    }
                }

                else if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "R")
                {
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0")
                        {
                            objGrpJoinDO.isAccepted = 1;

                            lblSuccess.Text      = "You have already send the group joining request.";
                            lblSuccess.ForeColor = System.Drawing.Color.Red;
                            divSuccess.Style.Add("display", "block");
                            return;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1")
                        {
                            objGrpJoinDO.isAccepted = 2;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2")
                        {
                            objGrpJoinDO.isAccepted = 0;
                        }
                    }
                }

                objGrpJoinDO.isAccepted       = 1;
                objGrpJoinDO.inGroupId        = Convert.ToInt32(hdnShareInvitee.Value);
                objGrpJoinDO.intInvitedUserId = Convert.ToInt32(ds.Tables[0].Rows[0]["intRegistrationId"]);

                string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (ip == null)
                {
                    ip = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDO.strIpAddress      = ip;
                objGrpJoinDO.intAddedBy        = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.intRegistrationId = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Insert);
                objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.UpdateGroupMember);
            }

            BindAllRequest();
        }
        else
        if (e.CommandName == "Delete")
        {
            ViewState["hdnTableName"]          = hdnTableName.Value;
            ViewState["intRequestInvitaionId"] = hdnPkId.Value;
            divSuccess.Style.Add("display", "block");
        }
    }
Пример #6
0
    protected void lstNotification_ItemCommand(object sender, ListViewCommandEventArgs e)
    {
        HiddenField hdnReqID     = (HiddenField)e.Item.FindControl("hdnReqID");
        HiddenField hdnPkId      = (HiddenField)e.Item.FindControl("hdnPkId");
        HiddenField hdnTableName = (HiddenField)e.Item.FindControl("hdnTableName");
        Label       lblEmailId   = (Label)e.Item.FindControl("lblEmailId");
        //Label lblDescription = (Label)e.Item.FindControl("lblDescription");
        Label       lblUserType          = (Label)e.Item.FindControl("lblUserType");
        Label       lblGroupName         = (Label)e.Item.FindControl("lblGroupName");
        HiddenField hdnrequserid         = (HiddenField)e.Item.FindControl("hdnrequserid");
        HiddenField hdnRegistrationId    = (HiddenField)e.Item.FindControl("hdnRegID");
        HiddenField hdnintUserTypeId     = (HiddenField)e.Item.FindControl("hdnintUserTypeId");
        LinkButton  lnkConfirm           = (LinkButton)e.Item.FindControl("lnkConfirm");
        LinkButton  lnkCancel            = (LinkButton)e.Item.FindControl("lnkCancel");
        HiddenField hdnIsAccept          = (HiddenField)e.Item.FindControl("hdnIsAccept");
        HiddenField hdnStrRecommendation = (HiddenField)e.Item.FindControl("hdnStrRecommendation");
        HiddenField hdnShareInvitee      = (HiddenField)e.Item.FindControl("hdnShareInvitee");

        hdnEmailId.Value          = lblEmailId.Text;
        ViewState["lblGroupName"] = lblGroupName.Text;

        if (e.CommandName == "Details")
        {
            if (hdnRegistrationId.Value != Convert.ToString(ViewState["UserID"]))
            {
                Response.Redirect("Notifications_Details_2.aspx");
            }
        }

        if (e.CommandName == "ShareDetails")
        {
            if (hdnTableName.Value == "Scrl_GrpShareUserStatusTbl")
            {
                Response.Redirect(hdnStrRecommendation.Value);
                return;
            }

            if (hdnRegistrationId.Value != Convert.ToString(ViewState["UserID"]))
            {
                Response.Redirect("Group-Profile.aspx?GrpId=" + hdnrequserid.Value);
            }
        }

        if (e.CommandName == "QAShareDetails")
        {
            if (hdnRegistrationId.Value != Convert.ToString(ViewState["UserID"]))
            {
                Response.Redirect(hdnStrRecommendation.Value);
            }
        }
        if (e.CommandName == "BlogShareDetails")
        {
            if (hdnRegistrationId.Value != Convert.ToString(ViewState["UserID"]))
            {
                Response.Redirect(hdnStrRecommendation.Value);
            }
        }

        if (e.CommandName == "Confirm")
        {
            if (hdnTableName.Value == "Scrl_UserRequestInvitationTbl")
            {
                objRegistration.intRequestInvitaionId = Convert.ToInt32(hdnPkId.Value);
                objRegistration.AddedBy   = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRegistration.IpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRegistration.IpAddress == null)
                {
                    objRegistration.IpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRegistrationDB.AddEditDel_Request(objRegistration, DA_Registrationdetails.RegistrationDetails.Update);
                SendMail(e.CommandName, hdnTableName.Value);
                ScriptManager.RegisterStartupScript(this, this.GetType(), "starScripts", "CallUserMethod();", true);
            }

            else if (hdnTableName.Value == "Scrl_UserGroupJoiningTbl")
            {
                objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDO.intAddedBy       = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.isAccepted       = 1;
                objGrpJoinDO.strIpAddress     = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objGrpJoinDO.strIpAddress == null)
                {
                    objGrpJoinDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Update);
                SendMail(e.CommandName, hdnTableName.Value);
            }

            else if (hdnTableName.Value == "Scrl_UserRecommendationTbl")
            {
                objRecmndDO.intRecommendationId = Convert.ToInt32(hdnPkId.Value);
                objRecmndDO.intAddedBy          = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRecmndDO.strIpAddress        = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRecmndDO.strIpAddress == null)
                {
                    objRecmndDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRecmndDA.Scrl_AddEditDelRecommendations(objRecmndDO, DA_Scrl_UserRecommendation.Scrl_UserRecommendation.Update);
                SendMail(e.CommandName, hdnTableName.Value);
                if (lblmaster.InnerText == "Home")
                {
                    Response.Redirect("Home.aspx");
                }
            }
            else if (hdnTableName.Value == "Scrl_OrgEndorsement")
            {
                objRecmndDO.intOrgEndorseId = Convert.ToInt32(hdnPkId.Value);
                objRecmndDO.intAddedBy      = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRecmndDO.strIpAddress    = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRecmndDO.strIpAddress == null)
                {
                    objRecmndDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRecmndDA.Scrl_AddEditDelOrganization(objRecmndDO, DA_Scrl_UserRecommendation.Scrl_OrgMessage.UpdateEnodorsement);
            }
            else if (hdnTableName.Value == "Scrl_OrgnisationGroupJoiningTbl")
            {
                if (objGrpJoinDO.strIpAddress == null)
                {
                    objGrpJoinDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDO.intRequestJoinId  = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDO.intAddedBy        = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.intRegistrationId = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.isAccepted        = 1;
                objGrpJoinDA.AddEditDel_Scrl_OrgnisationGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_OrgnisationGroupJoin.Update);
            }
            else if (hdnTableName.Value == "Scrl_RequestGroupJoin")
            {
                objgrp.intAddedBy = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objgrp.inGroupId  = Convert.ToInt32(hdnShareInvitee.Value);
                DataSet ds = new DataSet();
                ds = objgrpDB.GetDataSet(objgrp, DA_Scrl_UserGroupDetailTbl.Scrl_UserGroupDetailTbl.GetOtherGroupDetailsByGroupId);

                if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A")
                {
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0")
                        {
                            objGrpJoinDO.isAccepted = 1;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1")
                        {
                            objGrpJoinDO.isAccepted = 2;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2")
                        {
                            objGrpJoinDO.isAccepted = 1;
                        }
                    }
                    else
                    {
                        if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "A")
                        {
                            objGrpJoinDO.isAccepted = 1;
                        }
                    }
                }

                else if (Convert.ToString(ds.Tables[0].Rows[0]["strAccess"]) == "R")
                {
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "0")
                        {
                            objGrpJoinDO.isAccepted = 1;
                            return;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "1")
                        {
                            objGrpJoinDO.isAccepted = 2;
                        }

                        else if (Convert.ToString(ds.Tables[1].Rows[0]["IsAccepted"]) == "2")
                        {
                            objGrpJoinDO.isAccepted = 0;
                        }
                    }
                }

                objGrpJoinDO.isAccepted       = 1;
                objGrpJoinDO.inGroupId        = Convert.ToInt32(hdnShareInvitee.Value);
                objGrpJoinDO.intInvitedUserId = Convert.ToInt32(hdnRegistrationId.Value);
                string ip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (ip == null)
                {
                    ip = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDO.strIpAddress = ip;

                objGrpJoinDO.intAddedBy        = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.intRegistrationId = Convert.ToInt32(Session["ExternalUserId"].ToString());
                DataTable dtt = objGrpJoinDA.GetDataTable(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.GetDataFrom);
                if (dtt.Rows.Count == 0)
                {
                    objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Insert);
                    objGrpJoinDO.intInvitedUserId  = Convert.ToInt32(Session["ExternalUserId"].ToString());
                    objGrpJoinDO.intAddedBy        = Convert.ToInt32(Session["ExternalUserId"].ToString());
                    objGrpJoinDO.intRegistrationId = Convert.ToInt32(hdnRegistrationId.Value);
                }
                else
                {
                    objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Insert);
                }
                objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.UpdateGroupMember);

                SendMail(e.CommandName, hdnTableName.Value);
            }
            BindAllRequest();
            BindNotificationRequest();
            BindTopNotifcations();

            if (lblmaster.InnerText == "All Notifications")
            {
                Response.Redirect("Notifications_Details_2.aspx");
            }
        }

        if (e.CommandName == "Delete")
        {
            if (hdnTableName.Value == "Scrl_UserRequestInvitationTbl")
            {
                objRegistration.intRequestInvitaionId = Convert.ToInt32(hdnPkId.Value);
                objRegistration.AddedBy   = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRegistration.IpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRegistration.IpAddress == null)
                {
                    objRegistration.IpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRegistrationDB.AddEditDel_Request(objRegistration, DA_Registrationdetails.RegistrationDetails.Delete);
                SendMail(e.CommandName, hdnTableName.Value);
            }
            else if (hdnTableName.Value == "Scrl_UserGroupJoiningTbl")
            {
                objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDO.intAddedBy       = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.isAccepted       = 2;
                objGrpJoinDO.strIpAddress     = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objGrpJoinDO.strIpAddress == null)
                {
                    objGrpJoinDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.Update);
                SendMail(e.CommandName, hdnTableName.Value);
            }
            else if (hdnTableName.Value == "Scrl_UserRecommendationTbl")
            {
                objRecmndDO.intRecommendationId = Convert.ToInt32(hdnPkId.Value);
                objRecmndDO.intAddedBy          = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRecmndDO.strIpAddress        = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRecmndDO.strIpAddress == null)
                {
                    objRecmndDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRecmndDA.Scrl_AddEditDelRecommendations(objRecmndDO, DA_Scrl_UserRecommendation.Scrl_UserRecommendation.Delete);
                SendMail(e.CommandName, hdnTableName.Value);
            }
            else if (hdnTableName.Value == "Scrl_OrgEndorsement")
            {
                objRecmndDO.intRecommendationId = Convert.ToInt32(hdnPkId.Value);
                objRecmndDO.intAddedBy          = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objRecmndDO.strIpAddress        = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objRecmndDO.strIpAddress == null)
                {
                    objRecmndDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objRecmndDA.Scrl_AddEditDelRecommendations(objRecmndDO, DA_Scrl_UserRecommendation.Scrl_UserRecommendation.Delete);
            }
            else if (hdnTableName.Value == "Scrl_RequestGroupJoin")
            {
                objGrpJoinDO.intAddedBy   = Convert.ToInt32(Session["ExternalUserId"].ToString());
                objGrpJoinDO.strIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
                if (objGrpJoinDO.strIpAddress == null)
                {
                    objGrpJoinDO.strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
                }
                objGrpJoinDO.intRequestJoinId = Convert.ToInt32(hdnPkId.Value);
                objGrpJoinDA.AddEditDel_Scrl_UserGroupJoin(objGrpJoinDO, DA_Scrl_UserGroupJoin.Scrl_UserGroupJoin.DeleteGroupMember);
                SendMail(e.CommandName, hdnTableName.Value);
            }

            BindNotificationRequest();
            BindTopNotifcations();

            if (lblmaster.InnerText == "All Notifications")
            {
                Response.Redirect("Notifications_Details_2.aspx");
            }
        }
    }