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