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