private void LoadCounter() { try { InstituteBLL instituteBLL = new InstituteBLL(); DataTable dtInstitute = instituteBLL.GetAllActive(); lblTotalUniversity.Text = Convert.ToString(dtInstitute.Rows.Count); LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dtLenderBank = lenderBankBLL.GetAllActive(); lblTotalBank.Text = Convert.ToString(dtLenderBank.Rows.Count); CourseBLL courseBLL = new CourseBLL(); DataTable dtCourse = courseBLL.GetAllActive(); lblTotalCourse.Text = Convert.ToString(dtCourse.Rows.Count); BlogPostBLL blogPostBLL = new BlogPostBLL(); DataTable dtBlogPost = blogPostBLL.GetAllActive(); lblTotalBlogPost.Text = Convert.ToString(dtBlogPost.Rows.Count); UserBLL userBLL = new UserBLL(); DataTable dtUser = userBLL.GetAllActiveMember(); lblTotalMember.Text = Convert.ToString(dtUser.Rows.Count); } catch (Exception) { //throw; } }
private void LoadCourse() { try { CourseBLL courseBLL = new CourseBLL(); DataTable dt = courseBLL.GetAllActive(); ddlCourse.DataSource = dt; ddlCourse.DataTextField = "Name"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, "--- Please Select ---"); } catch (Exception) { //throw; } }
private void LoadDashboardInfo() { try { //Total Member UserBLL userBLL = new UserBLL(); DataTable dtUser = userBLL.GetAllActive(); lblTotalMember.Text = (dtUser == null) ? "0" : Convert.ToString(Convert.ToInt32(dtUser.Rows.Count)); //Total University //InstituteBLL instituteBLL = new InstituteBLL(); //DataTable dtInstitute = instituteBLL.GetAllActive(); RankingBLL rankingBLL = new RankingBLL(); DataTable dtRanking = rankingBLL.GetAllActive(); lblTotalUniversity.Text = (dtRanking == null) ? "0" : Convert.ToString(dtRanking.Rows.Count); //Total Course CourseBLL courseBLL = new CourseBLL(); DataTable dtCourse = courseBLL.GetAllActive(); lblTotalCourse.Text = (dtCourse == null) ? "0" : Convert.ToString(dtCourse.Rows.Count); //Total Bank LenderBankBLL lenderBankBLL = new LenderBankBLL(); DataTable dtLenderBank = lenderBankBLL.GetAllActive(); lblTotalBank.Text = (dtLenderBank == null) ? "0" : Convert.ToString(dtLenderBank.Rows.Count); //Total Blog Post BlogPostBLL blogPostBLL = new BlogPostBLL(); DataTable dtBlogPost = blogPostBLL.GetAllActive(); lblTotalBlogPost.Text = (dtBlogPost == null) ? "0" : Convert.ToString(dtBlogPost.Rows.Count); } catch (Exception) { //throw; } }