private void GetUserDetails(int sort,string Location)
{
try
{
Attendance.BAL.Report obj = new Report();
DataTable dt = obj.GetUsers(Location.Trim(), sort);
Session["AllusersData"] = dt;
if (dt.Rows.Count > 0)
{
if (sort == 0)
{
lblTotal.Text = "Total employee: " + dt.Rows[0]["TotalCount"].ToString() + " " + " " + " " + " " + "Active employee: " + dt.Rows[0]["ActiveCount"].ToString() + " " + " " + " " + " " + "Incative employee: " + dt.Rows[0]["InactiveCount"].ToString();
}
else if (sort == 1)
{
lblTotal.Text = "Total employee: " + dt.Rows[0]["TotalCount"].ToString() + " " + " " + " " + " " + "Active employee: " + dt.Rows[0]["ActiveCount"].ToString() + " " + " " + " " + " " + "Incative employee: " + dt.Rows[0]["InactiveCount"].ToString();
}
else
{
lblTotal.Text = "Total employee: " + dt.Rows[0]["TotalCount"].ToString() + " " + " " + " " + " " + "Active employee: " + dt.Rows[0]["ActiveCount"].ToString() + " " + " " + " " + " " + "Incative employee: " + dt.Rows[0]["InactiveCount"].ToString();
}
grdUsers.DataSource = dt;
grdUsers.DataBind();
BizUtility.GridSortInitail("Ascending", "Firstname", grdUsers, 0, dt);
}
}
catch (Exception ex)
{
}
}
private void GetUserDetails(int sort,int shiftID)
{
try
{
Attendance.BAL.Report obj = new Report();
DataTable dt = obj.GetUsers(Session["LocationName"].ToString().Trim(), sort,shiftID);
Session["AllusersData"] = dt;
if (dt.Rows.Count > 0)
{
// Total employee: 30 Active employee: 25 Incative employee: 5
if(sort==0)
{
lblTotal.Text = "Total employee: " + dt.Rows[0]["TotalCount"].ToString() + " " + " " + " " + " " + "Active employee: " + dt.Rows[0]["ActiveCount"].ToString() +" "+" "+" "+" "+"Incative employee: " + dt.Rows[0]["InactiveCount"].ToString();
}
else if (sort ==1)
{
lblTotal.Text = "Total employee: " + dt.Rows[0]["TotalCount"].ToString() + " " + " " + " " + " " + "Active employee: " + dt.Rows[0]["ActiveCount"].ToString() +" "+" "+" "+" "+"Incative employee: " + dt.Rows[0]["InactiveCount"].ToString();
}
else
{
lblTotal.Text = "Total employee: " + dt.Rows[0]["TotalCount"].ToString() + " " + " " + " " + " " + "Active employee: " + dt.Rows[0]["ActiveCount"].ToString() +" "+" "+" "+" "+"Incative employee: " + dt.Rows[0]["InactiveCount"].ToString();
}
grdUsers.DataSource = dt;
grdUsers.DataBind();
lblGrdNodata.Text = "";
dvNodata.Style["display"] = "none";
BizUtility.GridSortInitail("Ascending", "Firstname", grdUsers, 0, dt);
}
else
{
lblTotal.Text = "";
lblGrdNodata.Text = "No data found";
dvNodata.Style["display"] = "block";
grdUsers.DataSource = null;
grdUsers.DataBind();
}
}
catch (Exception ex)
{
}
}