public static IEnumerable <Firma> AllFromNameWildcards(string jmeno) { using (PersistLib p = new PersistLib()) { var sql = @"select * from Firma where jmeno like @jmeno"; var res = p.ExecuteDataset(cnnStr, System.Data.CommandType.Text, sql, new IDataParameter[] { new System.Data.SqlClient.SqlParameter("jmeno", Firma.JmenoBezKoncovky(jmeno) + "%") }); var found = new List <Firma>(); if (res.Tables.Count > 0 && res.Tables[0].Rows.Count > 0) { found.AddRange(res.Tables[0] .AsEnumerable() .Select(m => FromDataRow(m)) ); return(found); } else { return new Firma[] { } }; } }
private IEnumerable <string> _getPreviewTopValueFromItem(Newtonsoft.Json.Linq.JObject item, bool fromAllTopValues = false) { List <string> topTxts = new List <string>(); List <string> texts = new List <string>(); var props = GetMappingList("ICO"); foreach (var prop in props) { var o = item.SelectTokens(prop).FirstOrDefault(); string t = ""; if (o != null && o.GetType() == typeof(JValue)) { t = o.Value <string>() ?? ""; } //var t = ((string)Dynamitey.Dynamic.InvokeGetChain(item, prop)) ?? ""; if (HlidacStatu.Util.DataValidators.CheckCZICO(t)) { Firma f = Firmy.Get(t); if (f.Valid) { topTxts.Add(f.JmenoBezKoncovky() + ":"); if (!fromAllTopValues) { break; } } } } props = GetMappingList("Osobaid"); foreach (var prop in props) { var o = item.SelectTokens(prop).FirstOrDefault(); string t = ""; if (o != null && o.GetType() == typeof(JValue)) { t = o.Value <string>() ?? ""; } //var t = ((string)Dynamitey.Dynamic.InvokeGetChain(item, prop)) ?? ""; if (!string.IsNullOrEmpty(t)) { Osoba os = Osoby.GetByNameId.Get(t); if (os != null) { topTxts.Add(os.FullName() + ": "); if (!fromAllTopValues) { break; } } } } return(topTxts); }
public static Firma FromName(string name) { var res = Search(searchNameUrl, name); if (res.Count() == 0) { res = Search(searchNameUrl, Firma.JmenoBezKoncovky(name)); } string n1 = Devmasters.Core.TextUtil.RemoveDiacritics(Firma.JmenoBezKoncovky(name)).ToLowerInvariant(); var r1 = res .Where(r => Devmasters.Core.TextUtil.RemoveDiacritics(Firma.JmenoBezKoncovky(r.name)).ToLowerInvariant() == n1) .FirstOrDefault(); if (r1 == null) { return(Firma.NotFound); } else { return(r1.ToFirma()); } }