public static bool LogError(ICPHelper relativityConnectionHelper, Int32 userId, String errorMsg)
{
var parameters = new List <SqlParameter> {
new SqlParameter {
ParameterName = "@Date", SqlDbType = SqlDbType.DateTime, Value = Functions.FormatDateForSql(DateTime.UtcNow)
},
new SqlParameter {
ParameterName = "@UserId", SqlDbType = SqlDbType.Int, Value = userId
},
new SqlParameter {
ParameterName = "@ErrorMessage", SqlDbType = SqlDbType.NVarChar, Value = errorMsg
}
};
Int32 affectedRows = relativityConnectionHelper.GetDBContext(-1).ExecuteNonQuerySQLStatement(SQL.LogError, parameters);
return(affectedRows > 0);
}
public static IEnumerable <Models.Disclaimer> GetEligibleDisclaimers(ICPHelper relativityConnectionHelper, Int32 userId)
{
var workspaceArtifactId = Functions.FindFirstWorkspaceWhereAppIsInstalled(relativityConnectionHelper.GetDBContext(-1), Constants.Guids.Applications.DisclaimerAcceptanceLog);
var allDisclaimers = Functions.GetDisclaimers(workspaceArtifactId, relativityConnectionHelper).Where(x => x.Enabled).ToList();
var eligibleDisclaimers = new List <Models.Disclaimer>();
foreach (var disclaimer in allDisclaimers)
{
var usersWhoNeedToAcceptDislcaimer = Functions.FindUsersWhoNeedToAcceptDisclaimer(relativityConnectionHelper.GetDBContext(-1), disclaimer);
if (usersWhoNeedToAcceptDislcaimer.Contains(userId))
{
eligibleDisclaimers.Add(disclaimer);
}
}
return(eligibleDisclaimers);
}
public static bool AcceptDisclaimer(ICPHelper relativityConnectionHelper, Int32 userId, Int32 disclaimerId)
{
var parameters = new List <SqlParameter> {
new SqlParameter {
ParameterName = "@DisclaimerId", SqlDbType = SqlDbType.Int, Value = disclaimerId
},
new SqlParameter {
ParameterName = "@UserId", SqlDbType = SqlDbType.Int, Value = userId
},
new SqlParameter {
ParameterName = "@Date", SqlDbType = SqlDbType.DateTime, Value = Functions.FormatDateForSql(DateTime.UtcNow)
}
};
var affectedRows = relativityConnectionHelper.GetDBContext(-1).ExecuteNonQuerySQLStatement(SQL.AcceptDisclaimer, parameters);
return(affectedRows > 0);
}