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)); }
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)); } }