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