Пример #1
0
        private void DelContributor(HttpContext context)
        {
            string un = context.Request.Params["un"];
            string id = context.Request.Params["boardid"];

            GetNailsProdContext1.Execute(string.Format(@"DELETE FROM BoardContributor
FROM     BoardContributor INNER JOIN
                  AppUsers ON BoardContributor.ContributorID = AppUsers.ID
WHERE  (BoardContributor.BoardID = {0}) AND (AppUsers.Name = '{1}')", id, un));
        }
Пример #2
0
        private void UserNameAvail(HttpContext context)
        {
            string _un = context.Request.Params["un"];

            if (Common.ReadValue("name") == _un)
            {
                context.Response.Write("This is your Current User Name");
            }
            else
            {
                int un = GetNailsProdContext1.Single <int>("Select count(*) from AppUsers where Name=@0", _un);
                context.Response.Write(string.Format(un > 0 ? @"{0} not available" : @"{0} is available", _un));
            }
        }