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