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