Exemplos de UsersDataContext.spGetMutualFriends em C# (CSharp)

Exemplo n.º 1

    public int ShowMutualFriends(int UserCode, int FriendCode)
    {
        UsersDataContext dc = new UsersDataContext();

        ConcatUrl = "&Keyword=" + Keyword;
        int ResultCount = 0;

        int SkipCount = PageSize * (PageNo - 1);

        System.Data.Linq.ISingleResult <spGetMutualFriendsResult> ItemList;
        int LoggedUserCode = Convert.ToInt32(Session["UserCode"]);

        ItemList = dc.spGetMutualFriends(UserCode, FriendCode);

        ResultCount = dc.vUserFriends.Where(p => p.UserCode.Equals(UserCode)).Skip(SkipCount).Count();

        rptItems.DataSource = ItemList;
        rptItems.DataBind();

        if (rptItems.Items.Count > 0)
        {
            string Message = "";
            if (rptItems.Items.Count >= 500)
            {
                Message = " بیشتر از 500 " + " نتیجه برای <b>" + Keyword + " پیدا شد </b> ";
            }
            else
            {
                Message = ResultCount + " نتیجه برای <b>" + Keyword + " پیدا شد </b>";
            }

            //msgBox.Text = Message;
            Page.Title        = "دوستان مشترک:" + " سفحه " + PageNo;
            lblPageTitle.Text = "دوستان مشترک";


            int PageCount = ResultCount / PageSize;
            if (ResultCount % PageSize > 0)
            {
                PageCount++;
            }
            pgrToolbar.PageNo    = PageNo;
            pgrToolbar.PageCount = PageCount;
            pgrToolbar.ConcatUrl = ConcatUrl;
            pgrToolbar.PageBind();
        }
        else
        {
            //msgBox.Text = " No results found for <b>" + Keyword + "</b>";
        }
        return(ResultCount);
    }