private List <int> GetAuthorizedFormResultIds(IFormsSql formsSql) { DataTable dtFormResults = new DataTable(); for (int j = 0; j < SessionHelper.LoginStatus.appGroupPermissions.Count; j++) { StringBuilder stringBuilder = new StringBuilder("SELECT formResultId FROM def_FormResults"); stringBuilder.Append(" WHERE EnterpriseID = " + SessionHelper.LoginStatus.EnterpriseID); if (!SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups.Contains(0)) { stringBuilder.Append(" AND ("); for (int i = 0; i < SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups.Count; i++) { stringBuilder.Append("GroupID = " + SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups[i]); if (i < SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups.Count - 1) { stringBuilder.Append(" OR "); } } stringBuilder.Append(")"); } if (!UAS_Business_Functions.hasPermission(PermissionConstants.GROUP_WIDE, j, PermissionConstants.ASSMNTS)) { stringBuilder.Append(" AND " + " assigned = " + SessionHelper.LoginStatus.UserID); } stringBuilder.Append(" AND formStatus < " + (int)FormResults_formStatus.COMPLETED); String qry = stringBuilder.ToString(); try { SqlConnection sqlConn = new SqlConnection(formsSql.GetConnectionString()); sqlConn.Open(); SqlCommand cmd = new SqlCommand(qry, sqlConn); if (j == 0) { dtFormResults.Load(cmd.ExecuteReader()); } else { DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); dtFormResults.Merge(dt); } sqlConn.Close(); } catch (Exception ex) { Debug.WriteLine("GetAuthorizedFormResultIds: " + ex.Message); return(null); } } List <int> formResultIds = (from fr in dtFormResults.Select() select fr.Field <int>(0)).ToList(); return(formResultIds); }
private void GetAuthorizedFormResultIds(IFormsSql formsSql, out List <int> formResultIds, out List <int?> contactIds) { DataTable dtFormResults = new DataTable(); for (int j = 0; j < SessionHelper.LoginStatus.appGroupPermissions.Count; j++) { StringBuilder stringBuilder = new StringBuilder("SELECT formResultId, subject FROM def_FormResults"); stringBuilder.Append(" WHERE EnterpriseID = " + SessionHelper.LoginStatus.EnterpriseID); if (!SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups.Contains(0)) { stringBuilder.Append(" AND ("); for (int i = 0; i < SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups.Count; i++) { stringBuilder.Append("GroupID = " + SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups[i]); if (i < SessionHelper.LoginStatus.appGroupPermissions[j].authorizedGroups.Count - 1) { stringBuilder.Append(" OR "); } } stringBuilder.Append(")"); } stringBuilder.Append(" AND assigned = " + SessionHelper.LoginStatus.UserID); stringBuilder.Append(" AND formStatus = " + (int)FormResults_formStatus.NEW); stringBuilder.Append(" AND deleted = 0"); String qry = stringBuilder.ToString(); try { SqlConnection sqlConn = new SqlConnection(formsSql.GetConnectionString()); sqlConn.Open(); SqlCommand cmd = new SqlCommand(qry, sqlConn); if (j == 0) { dtFormResults.Load(cmd.ExecuteReader()); } else { DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); dtFormResults.Merge(dt); } sqlConn.Close(); } catch (Exception ex) { Debug.WriteLine("GetAuthorizedFormResultIds: " + ex.Message); formResultIds = null; contactIds = null; return; } } formResultIds = (from fr in dtFormResults.Select() select fr.Field <int>(0)).ToList(); contactIds = (from fr in dtFormResults.Select() select fr.Field <int?>(1)).ToList(); }