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"; } }