internal static void SetUserInfo(int ID)
{
//create connection and open it
MySqlConnection connection = DbInfo.Connection();
//try to connect to database
try
{
//Build Mysql command
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText =
"SELECT `ID`, `Firstname`, `Middlename`, `Lastname`, `Email`, `Password`, `Pin` FROM `users` WHERE `ID`=" + ID;
MySqlDataReader reader = cmd.ExecuteReader();
//if match is found
if (reader.Read())
{
//MessageBox.Show(reader["Firstname"] + " "+ reader["Middlename"].ToString());
Userinformation = new userinf(ID, reader["Firstname"].ToString(), reader["Middlename"].ToString(), reader["Lastname"].ToString(), reader["Email"].ToString());
}
}
//finally
finally
{
//check state and clone
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
//Setup Userinfo
internal void SetUserInfo()
{
userinf userinf = UserInfo.Userinformation;
FullName_Lbl.Content = userinf.firstname + " " + userinf.middlename + " " + userinf.lastname.ToString();
Adress_Lbl.Content = userinf.email;
SetupDatabases();
}
//Main
public MainWindow()
{
InitializeComponent();
userinf userinf = UserInfo.Userinformation;
//FullName_Lbl.Content = userinf.firstname + " " + userinf.middlename + " " + userinf.lastname;
//Adress_Lbl.Content = userinf.email;
//Set windows state so it fills the screen
this.WindowState = WindowState.Maximized;
this.WindowStartupLocation = WindowStartupLocation.CenterScreen;
TagContainer.Visibility = Visibility.Collapsed;
//TagContainer.SetZIndex(TagContainer, 999);
//Collaps all Content in side menu
Collaps(ProjectsContent);
Collaps(MySnippedsContent);
//Hide-Tab-Headers
foreach (TabItem item in MainMenuTabControl.Items)
{
item.Visibility = Visibility.Collapsed;
}
//Add Some languages examples
MySnipped_Languages_Cmb.Items.Add("All");
MySnipped_Languages_Cmb.Items.Add("C#");
MySnipped_Languages_Cmb.Items.Add("C++");
MySnipped_Languages_Cmb.Items.Add("Phyton");
MySnipped_Languages_Cmb.Items.Add("Html");
MySnipped_Languages_Cmb.Items.Add("Css");
MySnipped_Languages_Cmb.Items.Add("PHP");
MySnipped_Languages_Cmb.SelectedIndex = 0;
//Add Some Date examples
MySnipped_Date_Cmb.Items.Add("New/Old");
MySnipped_Date_Cmb.Items.Add("Old/New");
MySnipped_Date_Cmb.SelectedIndex = 0;
//Set some tag examples
for (int i = 0; i < 100; i++)
{
tags.Add(new Tags(i, "Example[" + i + "]"));
}
TagLineAmount(8);
}
