public List <RISCentral> GetRISCentralNotIn(List <Guid> list) { List <RISCentral> data = null; string tabName = "VW_EsamiRadiologiciRISCasilino"; string query = "SELECT * FROM " + tabName + " WHERE IDRichiesta not in (" + string.Join(", ", list.ToArray()) + ")"; DataTable data_ = DBSQL.ExecuteQuery(HltDesktopConnectionString, query); log.Info(string.Format("Query Executed! Retrieved {0} records!", data_.Rows.Count)); if (data_ != null) { if (data_.Rows.Count == 1) { data = RISCentralMapper.DataRowToVO(data_.Rows); log.Info(string.Format("{0} Records mapped to {1}", data.Count, typeof(RISCentral).ToString())); } } return(data); }
public List <RISCentral> GetRISCentralAll() { List <RISCentral> data = null; string tabName = "VW_EsamiRadiologiciRISCasilino"; DataTable data_ = DBSQL.SelectOperation(HltDesktopConnectionString, tabName); log.Info(string.Format("Query Executed! Retrieved {0} records!", data_.Rows.Count)); if (data_ != null) { if (data_.Rows.Count == 1) { data = RISCentralMapper.DataRowToVO(data_.Rows); log.Info(string.Format("{0} Records mapped to {1}", data.Count, typeof(RISCentral).ToString())); } } return(data); }