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 { }
}
}
