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