public List <ClubCloud_Land> GetLandenBySearch(string prefixText, int count, string contextKey, ClubCloud_Setting _settings = null) { if (_settings != null) { ValidateSettings(ref _settings); } List <string> landen = new List <string>(); using (new SPMonitoredScope("Landen GetLandenBySearch")) { try { bool enabled = false; //beheerModel.Database.SqlQuery<bool>("SELECT (CAST((FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))AS BIT))").FirstOrDefault(); List <ClubCloud_Land> entities = null; if (enabled) { var fts = BeheerFullTextInterceptor.Fts(prefixText); entities = beheerModel.ClubCloud_Landen.Where(e => e.Naam.Contains(fts) || e.Code.Contains(fts)).ToList(); } else { entities = beheerModel.Database.SqlQuery <ClubCloud_Land>("SELECT * FROM ClubCloud_Land WHERE Naam LIKE '%" + prefixText + "%' OR Code LIKE '%" + prefixText + "%'").ToList(); } if (entities != null && entities.Count > 0) { return(entities); } } catch (Exception ex) { Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message); } } return(new List <ClubCloud_Land>()); }
public List <ClubCloud_Address> GetAddressenBySearch(string prefixText, int count, string contextKey, ClubCloud_Setting _settings = null) { if (_settings != null) { ValidateSettings(ref _settings); } List <string> addressen = new List <string>(); using (new SPMonitoredScope("Addressen GetAddressenBySearch")) { try { bool enabled = false; //beheerModel.Database.SqlQuery<bool>("SELECT (CAST((FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))AS BIT))").FirstOrDefault(); List <ClubCloud_Address> entities = null; if (enabled) { var fts = BeheerFullTextInterceptor.Fts(prefixText); entities = beheerModel.ClubCloud_Addressen.Where(e => e.Stad.Contains(fts) || e.Provincie.Contains(fts) || e.Postcode.Contains(fts) || e.Straat.Contains(fts) || e.Nummer.Contains(fts) || e.Fax.Contains(fts) || e.Toevoeging.Contains(fts) || e.Postbus.Contains(fts) || e.TelefoonPrimair.Contains(fts) || e.TelefoonSecundair.Contains(fts) || e.TelefoonTertiair.Contains(fts) || e.Gemeente.Contains(fts)).ToList(); } else { entities = beheerModel.Database.SqlQuery <ClubCloud_Address>("SELECT * FROM ClubCloud_Address WHERE Stad LIKE '%" + prefixText + "%' OR Provincie LIKE '%" + prefixText + "%' OR Postcode LIKE '%" + prefixText + "%' OR Straat LIKE '%" + prefixText + "%' OR Nummer LIKE '%" + prefixText + "%' OR Fax LIKE '%" + prefixText + "%' OR Toevoeging LIKE '%" + prefixText + "%' OR Postbus LIKE '%" + prefixText + "%' OR TelefoonPrimair LIKE '%" + prefixText + "%' OR TelefoonSecundair LIKE '%" + prefixText + "%' OR TelefoonTertiair LIKE '%" + prefixText + "%' OR Gemeente LIKE '%" + prefixText + "%'").ToList(); } if (entities != null && entities.Count > 0) { return(entities); } } catch (Exception ex) { Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message); } } return(new List <ClubCloud_Address>()); }
public List <ClubCloud_Afhang> GetAfhangenBySearch(string prefixText, int count, string contextKey, ClubCloud_Setting _settings = null) { if (_settings != null) { ValidateSettings(ref _settings); } List <string> afhangen = new List <string>(); using (new SPMonitoredScope("Afhangen GetAfhangenBySearch")) { try { bool enabled = false; //beheerModel.Database.SqlQuery<bool>("SELECT (CAST((FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))AS BIT))").FirstOrDefault(); List <ClubCloud_Afhang> entities = null; if (enabled) { var fts = BeheerFullTextInterceptor.Fts(prefixText); } else { } if (entities != null && entities.Count > 0) { return(entities); } } catch (Exception ex) { Logger.WriteLog(Logger.Category.Unexpected, ex.Source, ex.Message); } } return(new List <ClubCloud_Afhang>()); }