private bool IsFunctionName(string name, Bot ChatBot, User ChatUser, out SQLBot_Function function)
{
if (name == "UNKNOWN")
{
function = null;
}
else
{
try
{
BazaRelacyjnaDataContext dc = new BazaRelacyjnaDataContext();
function = dc.SQLBot_Function.Where(fn => fn.sqlfn_Name == name).FirstOrDefault();
}
catch (Exception)
{
function = null;
}
}
return function != null;
}
private SQLBot_Function findFunctionForWord(string word, Bot ChatBot, User ChatUser)
{
if (word == "UNKNOWN")
return null;
try
{
BazaRelacyjnaDataContext dc = new BazaRelacyjnaDataContext();
SQLBot_Function function = dc.SQLBot_Function.Where(fn => fn.sqlfn_Name == word).FirstOrDefault();
if (function != null)
{
return function;
}
else
{
return findFunctionForWord(AIMLWhatIs(word, ChatBot, ChatUser), ChatBot, ChatUser);
}
}
catch (Exception)
{
}
return null;
}
private string[] findTable(string name)
{
List<string> res = new List<string>();
try
{
BazaRelacyjnaDataContext dc = new BazaRelacyjnaDataContext();
SQLBot_Table[] table = dc.SQLBot_Table.Where(w => w.sqlt_Name == name).ToArray();
foreach (var tab in table)
{
res.Add(tab.sqlt_SQLName);
}
}
catch (Exception)
{
}
return res.ToArray();
}
private void findField(string name, out string[] sqlNames, out string[] sqlTables)
{
List<string> lNames = new List<string>();
List<string> lTables = new List<string>();
try
{
BazaRelacyjnaDataContext dc = new BazaRelacyjnaDataContext();
SQLBot_Field[] fields = dc.SQLBot_Field.Where(w => w.sqlf_ColumnName == name).ToArray();
foreach (var field in fields)
{
lNames.Add(field.sqlf_SQLColumnName);
lTables.Add(field.SQLBot_Table.sqlt_SQLName);
}
}
catch (Exception)
{
}
sqlNames = lNames.ToArray();
sqlTables = lTables.ToArray();
}
