static public bool OpenConnection() { try { checker = new SQLChecker(); sqlConnection = new MySqlConnection(""); sqlConnection.Open(); command = sqlConnection.CreateCommand(); command.Connection = sqlConnection; command.CommandText = "SELECT CURRENT_DATE FROM dual"; open = true; return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public ViewController(IntPtr handle) : base(handle) { if (!Backendoptions.IsOpen()) { if (!Backendoptions.OpenConnection()) { System.Diagnostics.Process.GetCurrentProcess().Kill(); } } checker = new SQLChecker(); if (Backendoptions.IsAdmin()) { AAUnitH = new NSComboBox(); AAddStClass = new NSComboBox(); AGrillParent = new NSComboBox(); AGrillStudent = new NSComboBox(); ACForm = new NSComboBox(); ACClass = new NSComboBox(); AALessClL = new NSComboBox(); AALessDay = new NSComboBox(); AALessRR = new NSComboBox(); AALessUH = new NSComboBox(); AALessSub = new NSComboBox(); AAClassForm = new NSComboBox(); AAClassProfile = new NSComboBox(); ADelGrillSt = new NSComboBox(); ADelGrillPar = new NSComboBox(); ADelSt = new NSComboBox(); ADelTea = new NSComboBox(); ADelPar = new NSComboBox(); AchCl = new NSComboBox(); AChSt = new NSComboBox(); ATeaList = new NSTextField(); AParList = new NSTextField(); AStList = new NSTextField(); } else { if (Backendoptions.IsParent()) { PChildList = new NSComboBox(); PMyInfo = new NSTextField(); PLegitimize = new NSComboBox(); PNotes = new NSTextField(); PWarnings = new NSTextField(); PPresance = new NSTextField(); } else { if (Backendoptions.IsTeacher()) { TClass = new NSComboBox(); TWSt = new NSComboBox(); TCNSt = new NSComboBox(); TCNVal = new NSComboBox(); TCNDesc = new NSComboBox(); TNCat = new NSComboBox(); TNSt = new NSComboBox(); TNSub = new NSComboBox(); TNVal = new NSComboBox(); TPreSt = new NSComboBox(); TPreStat = new NSComboBox(); TPreUnit = new NSComboBox(); TPrUnit = new NSComboBox(); TCheckPresance = new NSTextField(); TCheckStudent = new NSTextField(); TBest1 = new NSTextField(); } else if (Backendoptions.IsStudent()) { SWarnings = new NSTextField(); SPresance = new NSTextField(); SPoints = new NSTextField(); SNotes = new NSTextField(); SyInfo = new NSTextField(); } } } }