public MyAccount() { pmsutil = new PMSUtil(); InitializeComponent(); NameTextbox.Text = pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString()); SyncMyLogs(); AccountNameHolder.Content = pmsutil.GetEmpName(Application.Current.Resources["uid"].ToString()); AccountRoleHolder.Content = pmsutil.GetAccountType(Application.Current.Resources["uid"].ToString()); }
internal void SyncAccounts() { accounts = new ObservableCollection <Account>(); accounts_final = new ObservableCollection <Account>(); ComboBoxItem ci = (ComboBoxItem)ItemsPerPage.SelectedItem; int itemsPerPage = Convert.ToInt32(ci.Content); int page = 1; int count = 0; dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); //AccountsItemContainer.Items.Clear(); if (dbman.DBConnect().State == ConnectionState.Open) { MySqlCommand cmd = dbman.DBConnect().CreateCommand(); cmd.CommandText = "SELECT * FROM accounts, accounts_info WHERE accounts.account_id = accounts_info.account_id;"; MySqlDataReader db_reader = cmd.ExecuteReader(); while (db_reader.Read()) { string acc_type; acc_type = pmsutil.GetAccountType(db_reader.GetString("account_id")); accounts.Add(new Account() { AccountID = db_reader.GetString("account_id"), Username = db_reader.GetString("user_name"), Role = acc_type, EmpName = db_reader.GetString("name"), CreationDate = DateTime.Parse(db_reader.GetString("date_created")).ToString("MMM dd, yyyy"), CreationTime = DateTime.Parse(db_reader.GetString("time_created")).ToString("hh:mm tt"), Page = page }); count++; if (count == itemsPerPage) { page++; count = 0; } } int temp = 1; foreach (var cur in accounts) { if (cur.Page == CurrentPage.Value) { accounts_final.Add(new Account() { No = temp, AccountID = cur.AccountID, Username = cur.Username, Role = cur.Role, EmpName = cur.EmpName, CreationDate = cur.CreationDate, CreationTime = cur.CreationTime, Page = cur.Page }); temp++; } } //close Connection dbman.DBClose(); //AccountsItemContainer.Items.Clear(); AccountsItemContainer.Items.Refresh(); AccountsItemContainer.ItemsSource = accounts_final; AccountsItemContainer.Items.Refresh(); } else { } }