public async Task <bool> Exists( string folderName, CancellationToken cancellationToken) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT Count(*) "); sqlCommand.Append("FROM mp_SiteFolders "); sqlCommand.Append("WHERE FolderName = @FolderName ; "); FbParameter[] arParams = new FbParameter[1]; arParams[0] = new FbParameter("@FolderName", FbDbType.VarChar, 255); arParams[0].Value = folderName; object result = await AdoHelper.ExecuteScalarAsync( readConnectionString, CommandType.Text, sqlCommand.ToString(), arParams, cancellationToken); int count = Convert.ToInt32(result); return(count > 0); }
/// <summary> /// Gets a count of rows in the mp_GeoZone table. /// </summary> public async Task <int> GetCount( Guid countryGuid, CancellationToken cancellationToken) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT Count(*) "); sqlCommand.Append("FROM mp_GeoZone "); sqlCommand.Append("WHERE CountryGuid = @CountryGuid "); sqlCommand.Append("OR CountryGuid = UPPER(@CountryGuid) "); sqlCommand.Append(";"); FbParameter[] arParams = new FbParameter[1]; arParams[0] = new FbParameter("@CountryGuid", FbDbType.Char, 36); arParams[0].Value = countryGuid.ToString(); object result = await AdoHelper.ExecuteScalarAsync( readConnectionString, CommandType.Text, sqlCommand.ToString(), arParams, cancellationToken); return(Convert.ToInt32(result)); }
/// <summary> /// Gets a count of rows in the mp_GeoCountry table. /// </summary> public async Task <int> GetCount(CancellationToken cancellationToken) { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT Count(*) "); sqlCommand.Append("FROM mp_GeoCountry "); sqlCommand.Append(";"); object result = await AdoHelper.ExecuteScalarAsync( readConnectionString, CommandType.Text, sqlCommand.ToString(), null, cancellationToken); return(Convert.ToInt32(result)); }
public async Task <int> Create( int siteId, string userId, string claimType, string claimValue, CancellationToken cancellationToken) { FbParameter[] arParams = new FbParameter[4]; arParams[0] = new FbParameter(":UserId", FbDbType.VarChar, 128); arParams[0].Value = userId; arParams[1] = new FbParameter(":ClaimType", FbDbType.VarChar, -1); arParams[1].Value = claimType; arParams[2] = new FbParameter(":ClaimValue", FbDbType.VarChar, -1); arParams[2].Value = claimValue; arParams[3] = new FbParameter(":SiteId", FbDbType.Integer); arParams[3].Value = siteId; string statement = "EXECUTE PROCEDURE mp_USERCLAIMS_INSERT (" + AdoHelper.GetParamString(arParams.Length) + ")"; object result = await AdoHelper.ExecuteScalarAsync( writeConnectionString, CommandType.StoredProcedure, statement, true, arParams, cancellationToken); int newID = Convert.ToInt32(result); return(newID); }
public async Task <int> RoleCreate( Guid roleGuid, Guid siteGuid, int siteId, string roleName, CancellationToken cancellationToken) { FbParameter[] arParams = new FbParameter[5]; arParams[0] = new FbParameter(":SiteID", FbDbType.Integer); arParams[0].Value = siteId; arParams[1] = new FbParameter(":RoleName", FbDbType.VarChar, 50); arParams[1].Value = roleName; arParams[2] = new FbParameter(":DisplayName", FbDbType.VarChar, 50); arParams[2].Value = roleName; arParams[3] = new FbParameter(":SiteGuid", FbDbType.Char, 36); arParams[3].Value = siteGuid.ToString(); arParams[4] = new FbParameter(":RoleGuid", FbDbType.Char, 36); arParams[4].Value = roleGuid.ToString(); object result = await AdoHelper.ExecuteScalarAsync( writeConnectionString, CommandType.StoredProcedure, "EXECUTE PROCEDURE MP_ROLES_INSERT (" + AdoHelper.GetParamString(arParams.Length) + ")", true, arParams, cancellationToken); int newID = Convert.ToInt32(result); return(newID); }