private void Frm_AppLock_Activated(object sender, EventArgs e)
{
pnl_applock.Visible = true;
// lock
FormSetup.fillCombo(cmb_newLock, "Lock", "L_Name", "L_id", "L_locked=0", "L");
//Unlock
FormSetup.fillCombo(cmb_newUnlock, "Lock", "L_Name", "L_id", "L_locked=1", "L");
//datagrid view
FormSetup.fillDgv(dgv_currentlyLocked, "select L_name from Lock where L_locked=1 and L_User='******'");
if (dgv_currentlyLocked.RowCount > 0)
{
pnl_applock.Visible = false;
}
}
private void Frm_Info_Load(object sender, EventArgs e)
{
lab_user.Text = AppObject.UserName.ToUpper();
// CURRENTLY LOCKED APP
FormSetup.fillDgv(dgv_currentlyLocked, "select L_Name from Lock where L_locked=1 and L_User='******'");
if (dgv_currentlyLocked.RowCount > 0)
{
pnl_Lock.Visible = false;
}
// FREQUENTLY USED APPS
FormSetup.fillDgv(dgv_MostUsedApps, "SELECT DISTINCT stats_appname FROM Stats where Stats_Time>(SELECT AVG(Stats_Time)FROM Stats WHERE Stats_Month='" + Stats.currentMonth() + "')");
if (dgv_MostUsedApps.RowCount > 0)
{
pnl_FUsed.Visible = false;
}
}
private void Frm_Focus_Activated(object sender, EventArgs e)
{
FormSetup.fillDgv(dgv_MostUsedApps, "SELECT DISTINCT stats_appname FROM Stats where Stats_Time>(SELECT AVG(Stats_Time)FROM Stats WHERE Stats_Month='" + Stats.currentMonth().ToString() + "'And Stats_User='******')");
}