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