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