using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
namespace [Link]
{
public partial class adminHome : [Link]
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadTotalPendingUsersCount();
LoadTotalUsersCount();
}
}
private void LoadTotalPendingUsersCount()
{
string connectionString =
[Link]["EmployeeDBConnectionString"].ConnectionStri
ng;
int totalUsers = 0;
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
[Link]();
string query = "SELECT COUNT(*) FROM Employees"; // Get total
number of users
using (SqlCommand command = new SqlCommand(query, connection))
{
totalUsers = (int)[Link]();
}
}
catch (Exception ex)
{
[Link]("Cannot Load Requests." + ex);
}
}
[Link] = [Link](); // Assign count to
label
}
private void LoadTotalUsersCount()
{
string connectionString =
[Link]["EmployeeDBConnectionString"].ConnectionStri
ng;
int totalUsers = 0;
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
[Link]();
string query = "SELECT COUNT(*) FROM Users"; // Get total
number of users
using (SqlCommand command = new SqlCommand(query, connection))
{
totalUsers = (int)[Link]();
}
}
catch (Exception ex)
{
[Link]("Cannot Load Requests." + ex);
}
}
[Link] = [Link](); // Assign count to label
}
protected void btnManageRequests_Click(object sender, EventArgs e)
{
[Link]("[Link]
}
}
}