/// <summary>
/// Inserts a row in the mp_SystemLog table. Returns new integer id.
/// </summary>
/// <param name="logDate"> logDate </param>
/// <param name="ipAddress"> ipAddress </param>
/// <param name="culture"> culture </param>
/// <param name="url"> url </param>
/// <param name="shortUrl"> shortUrl </param>
/// <param name="thread"> thread </param>
/// <param name="logLevel"> logLevel </param>
/// <param name="logger"> logger </param>
/// <param name="message"> message </param>
/// <returns>int</returns>
public int Create(
DateTime logDate,
string ipAddress,
string culture,
string url,
string shortUrl,
string thread,
string logLevel,
string logger,
string message)
{
FbParameter[] arParams = new FbParameter[9];
arParams[0] = new FbParameter(":LogDate", FbDbType.TimeStamp);
arParams[0].Value = logDate;
arParams[1] = new FbParameter(":IpAddress", FbDbType.VarChar, 50);
arParams[1].Value = ipAddress;
arParams[2] = new FbParameter(":Culture", FbDbType.VarChar, 10);
arParams[2].Value = culture;
arParams[3] = new FbParameter(":Url", FbDbType.VarChar);
arParams[3].Value = url;
arParams[4] = new FbParameter(":ShortUrl", FbDbType.VarChar, 255);
arParams[4].Value = shortUrl;
arParams[5] = new FbParameter(":Thread", FbDbType.VarChar, 255);
arParams[5].Value = thread;
arParams[6] = new FbParameter(":LogLevel", FbDbType.VarChar, 20);
arParams[6].Value = logLevel;
arParams[7] = new FbParameter(":Logger", FbDbType.VarChar, 255);
arParams[7].Value = logger;
arParams[8] = new FbParameter(":Message", FbDbType.VarChar);
arParams[8].Value = message;
int newID = Convert.ToInt32(AdoHelper.ExecuteScalar(
writeConnectionString,
CommandType.StoredProcedure,
"EXECUTE PROCEDURE MP_SYSTEMLOG_INSERT ("
+ AdoHelper.GetParamString(arParams.Length) + ")",
true,
arParams));
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);
}
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);
}