private void Execute(string query, string path) { using (Database_Handler.EduDB EX = new Database_Handler.EduDB()) { EX.Execute(query, path); } }
public List <string> GetCredentials(string query, string Datapath) { using (Database_Handler.EduDB qu = new Database_Handler.EduDB()) { return(qu.GetColumnList(query, Datapath)); } }
public void GetCredentials() { string query = $"SELECT * FROM USERS WHERE ID = {Identity}"; string path = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData) + @"/PawloCore/DBUSERS.sqlite"; using (Database_Handler.EduDB DBHandler = new Database_Handler.EduDB()) { CredentialsList = DBHandler.GetColumnList(query, $"Data Source={path}"); Login = CredentialsList[3]; FirstName = CredentialsList[1]; LastName = CredentialsList[2]; Email = CredentialsList[5]; DOB = CredentialsList[8] + "." + CredentialsList[7] + "." + CredentialsList[6]; City = CredentialsList[9]; Phone = CredentialsList[12]; Employment = CredentialsList[13]; Website = CredentialsList[14]; ServiceDataPath = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData) + @"/PawloCore/" + Identity + @"_user_data" + @"\EducationData\education.sqlite"; } }
public void UpdateProgramList(ComboBox List) { List.Items.Clear(); using (Database_Handler.EduDB GetList = new Database_Handler.EduDB()) { ProgramList = GetList.GetRowList($"SELECT ID FROM LEARNING_PROGRAM ORDER BY ID DESC", $"Data Source = {UserAccount.ServiceDataPath}"); DLIST.Clear(); DLIST.Add("EID", GetList.GetRowList($"SELECT ID FROM LEARNING_PROGRAM ORDER BY ID DESC ", $"Data Source = {UserAccount.ServiceDataPath}")); DLIST.Add("TYPE", GetList.GetRowList($"SELECT TYPE FROM LEARNING_PROGRAM ORDER BY TYPE DESC ", $"Data Source = {UserAccount.ServiceDataPath}")); DLIST.Add("START", GetList.GetRowList($"SELECT START FROM LEARNING_PROGRAM ORDER BY START DESC ", $"Data Source = {UserAccount.ServiceDataPath}")); DLIST.Add("FINISH", GetList.GetRowList($"SELECT FINISH FROM LEARNING_PROGRAM ORDER BY FINISH DESC ", $"Data Source = {UserAccount.ServiceDataPath}")); DLIST.Add("LEVEL", GetList.GetRowList($"SELECT LEVEL FROM LEARNING_PROGRAM ORDER BY LEVEL DESC ", $"Data Source = {UserAccount.ServiceDataPath}")); DLIST.Add("DIRECTION", GetList.GetRowList($"SELECT DIRECTION FROM LEARNING_PROGRAM ORDER BY DIRECTION DESC ", $"Data Source = {UserAccount.ServiceDataPath}")); string[] Row = new string[DLIST.Count]; try { int j = 0; for (int i = 0; i < ProgramList.Count; i++) { j = 0; if (DLIST.TryGetValue("EID", out ProgramList)) { Row[j] = ProgramList[i]; } j++; if (DLIST.TryGetValue("TYPE", out ProgramList)) { Row[j] = ProgramList[i]; } j++; if (DLIST.TryGetValue("START", out ProgramList)) { Row[j] = ProgramList[i]; } j++; if (DLIST.TryGetValue("FINISH", out ProgramList)) { Row[j] = ProgramList[i]; } j++; if (DLIST.TryGetValue("LEVEL", out ProgramList)) { Row[j] = ProgramList[i]; } j++; if (DLIST.TryGetValue("DIRECTION", out ProgramList)) { Row[j] = ProgramList[i]; } if (String.IsNullOrWhiteSpace(Row[4])) { if (Row[1] == "ELEMENTARY") { List.Items.Add(new Item("Szkoła podstawowa " + Row[2] + "-" + Row[3], Row[0])); } else if (Row[1] == "MIDDLE") { List.Items.Add(new Item("Liceum " + Row[2] + "-" + Row[3], Row[0])); } else if (Row[1] == "TECH") { List.Items.Add(new Item("Technikum " + Row[2] + "-" + Row[3], Row[0])); } } else if (Row[1] == "BRANCH") { List.Items.Add(new Item("Szkoła branżowa " + Row[2] + "-" + Row[3] + " " + Row[4] + ", stopień", Row[0])); } else if (Row[1] == "STUDY") { List.Items.Add(new Item("Studia wyższe " + Row[2] + "-" + Row[3] + " " + Row[4] + ", stopień," + " " + Row[5], Row[0])); } } } catch { } } }