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