52 references to SqlHelper
System.Web.Extensions (52)
ClientServices\Providers\ClientData.cs (2)
213fileName = _IsolatedDir + "\\" + SqlHelper.GetPartialDBFileName(username, ".clientdata"); 225fileName = SqlHelper.GetFullDBFileName(username, ".clientdata");
ClientServices\Providers\ClientFormsAuthenticationMembershipProvider.cs (18)
117_ConnectionString = SqlHelper.GetDefaultConnectionString(); 125switch(SqlHelper.IsSpecialConnectionString(_ConnectionString)) 228SqlHelper.DeleteAllCookies(p.Identity.Name, _ConnectionString, _ConnectionStringProvider); 362SqlHelper.DeleteAllCookies(currentUser, _ConnectionString, _ConnectionStringProvider); 378using (DbConnection conn = SqlHelper.GetConnection(null, _ConnectionString, _ConnectionStringProvider)) { 416using (DbConnection conn = SqlHelper.GetConnection(null, _ConnectionString, _ConnectionStringProvider)) { 429SqlHelper.AddParameter(conn, cmd, "@UserName", username); 435SqlHelper.AddParameter(conn, cmd, "@Date", DateTime.Now.ToFileTimeUtc().ToString(CultureInfo.InvariantCulture)); 499using (DbConnection conn = SqlHelper.GetConnection(username, _ConnectionString, _ConnectionStringProvider)) { 508SqlHelper.AddParameter(conn, cmd, "@PasswordHashName", "PasswordHash_" + username); 514SqlHelper.AddParameter(conn, cmd, "@PasswordSaltName", "PasswordSalt_" + username); 521SqlHelper.AddParameter(conn, cmd, "@PasswordHashName", "PasswordHash_" + username); 522SqlHelper.AddParameter(conn, cmd, "@PasswordHashValue", passwordHash); 528SqlHelper.AddParameter(conn, cmd, "@PasswordSaltName", "PasswordSalt_" + username); 529SqlHelper.AddParameter(conn, cmd, "@PasswordSaltValue", passwordSalt); 619using (DbConnection conn = SqlHelper.GetConnection(username, _ConnectionString, _ConnectionStringProvider)) { 624SqlHelper.AddParameter(conn, cmd, "@PasswordHashName", "PasswordHash_" + username); 630SqlHelper.AddParameter(conn, cmd, "@PasswordSaltName", "PasswordSalt_" + username);
ClientServices\Providers\ClientRoleProvider.cs (13)
61_ConnectionString = SqlHelper.GetDefaultConnectionString(); 69switch(SqlHelper.IsSpecialConnectionString(_ConnectionString)) 218using (DbConnection conn = SqlHelper.GetConnection(_CurrentUser, _ConnectionString, _ConnectionStringProvider)) { 224SqlHelper.AddParameter(conn, cmd, "@UserName", _CurrentUser); 230SqlHelper.AddParameter(conn, cmd, "@RolesCachedDate", "RolesCachedDate_" + _CurrentUser); 265using (DbConnection conn = SqlHelper.GetConnection(_CurrentUser, _ConnectionString, _ConnectionStringProvider)) { 274SqlHelper.AddParameter(conn, cmd, "@UserName", _CurrentUser); 275SqlHelper.AddParameter(conn, cmd, "@RoleName", role); 281SqlHelper.AddParameter(conn, cmd, "@RolesCachedDate", "RolesCachedDate_" + _CurrentUser); 282SqlHelper.AddParameter(conn, cmd, "@Date", DateTime.UtcNow.ToFileTimeUtc().ToString(CultureInfo.InvariantCulture)); 320using (DbConnection conn = SqlHelper.GetConnection(_CurrentUser, _ConnectionString, _ConnectionStringProvider)) { 327SqlHelper.AddParameter(conn, cmd, "@RolesCachedDate", "RolesCachedDate_" + _CurrentUser); 340SqlHelper.AddParameter(conn, cmd, "@UserName", _CurrentUser);
ClientServices\Providers\ClientSettingsProvider.cs (17)
160_ConnectionString = SqlHelper.GetDefaultConnectionString(); 195switch(SqlHelper.IsSpecialConnectionString(_ConnectionString)) 683using (DbConnection conn = SqlHelper.GetConnection(Thread.CurrentPrincipal.Identity.Name, 784using (DbConnection conn = SqlHelper.GetConnection(username, GetConnectionString(), _ConnectionStringProvider)) { 792SqlHelper.AddParameter(conn, cmd, "@PropName", value.Property.Name); 800SqlHelper.AddParameter(conn, cmd, "@PropName", value.Property.Name); 803SqlHelper.AddParameter(conn, cmd, "@PropName", value.Property.Name); 804SqlHelper.AddParameter(conn, cmd, "@PropVal", (string) val); 807SqlHelper.AddParameter(conn, cmd, "@PropName", value.Property.Name); 808SqlHelper.AddParameter(conn, cmd, "@PropVal", Convert.ToBase64String((byte[])val)); 870using (DbConnection conn = SqlHelper.GetConnection(username, GetConnectionString(), _ConnectionStringProvider)) 874SqlHelper.AddParameter(conn, cmd, "@PropName", tagName); 881using (DbConnection conn = SqlHelper.GetConnection(username, GetConnectionString(), _ConnectionStringProvider)) { 884SqlHelper.AddParameter(conn, cmd, "@PropName", tagName); 889SqlHelper.AddParameter(conn, cmd, "@PropName", tagName); 890SqlHelper.AddParameter(conn, cmd, "@PropValue", tagValue); 950_ConnectionString = SqlHelper.GetDefaultConnectionString();
ClientServices\Providers\ProxyHelper.cs (2)
398return SqlHelper.GetCookieFromDB(cookieHeader.Substring(0, 32), username, connectionString, connectionStringProvider); 426string newCookieName = SqlHelper.StoreCookieInDB(cookieName, actualCookieValue, username, connectionString, connectionStringProvider);