/// <summary> /// Bind DDL Data Source /// </summary> private void BindDDLSource() { BLL.Users bllUser = new BLL.Users(); string strWhere = "AND RoleName='Loan Officer'"; if (CurrUser.bIsCompanyUser) { strWhere += " AND (UserId IN (SELECT UserId FROM GroupUsers WHERE GroupID IN(select GroupID from Groups where CompanyID in (SELECT CompanyID FROM Groups where GroupID in (select GroupID from GroupUsers WHERE UserID = " + CurrUser.iUserID.ToString() + ")))))"; } else if (CurrUser.bIsRegionUser) { strWhere += " AND (UserId IN (SELECT UserId FROM GroupUsers WHERE GroupID IN(select GroupID from Groups where RegionID in (SELECT RegionID FROM Groups where GroupID in (select GroupID from GroupUsers WHERE UserID = " + CurrUser.iUserID.ToString() + ")))))"; } else if (CurrUser.bIsDivisionUser) { strWhere += " AND (UserId IN (SELECT UserId FROM GroupUsers WHERE GroupID IN(select GroupID from Groups where DivisionID in (SELECT DivisionID FROM Groups where GroupID in (select GroupID from GroupUsers WHERE UserID = " + CurrUser.iUserID.ToString() + ")))))"; } else if (CurrUser.bIsBranchUser) { strWhere += " AND (UserId IN (SELECT UserId FROM GroupUsers WHERE GroupID IN(select GroupID from Groups where BranchID in (SELECT BranchID FROM Groups where GroupID in (select GroupID from GroupUsers WHERE UserID = " + CurrUser.iUserID.ToString() + ")))))"; } DataTable dtLoadOfficer = bllUser.GetUserList(strWhere); if (!dtLoadOfficer.Columns.Contains("LoanOfficer")) { dtLoadOfficer.Columns.Add("LoanOfficer"); } foreach (DataRow dr in dtLoadOfficer.Rows) { dr["LoanOfficer"] = dr["Name"].ToString(); } DataRow drNew = dtLoadOfficer.NewRow(); drNew["UserID"] = 0; drNew["LoanOfficer"] = "All"; dtLoadOfficer.Rows.Add(drNew); DataView dv = dtLoadOfficer.DefaultView; dv.Sort = "UserID "; DataTable dtLoadOfficerORder = dv.ToTable(); ddlLoanOfficer.DataSource = dtLoadOfficerORder; ddlLoanOfficer.DataTextField = "LoanOfficer"; ddlLoanOfficer.DataValueField = "UserID"; ddlLoanOfficer.SelectedValue = "0"; ddlLoanOfficer.DataBind(); }
/// <summary> /// Bind user gridview /// </summary> private void BindGrid() { // Get user branch info dtUserBranch = UsersManager.GetUserBranchInfo(); int pageSize = AspNetPager1.PageSize; int pageIndex = 1; if (isReset == true) { pageIndex = AspNetPager1.CurrentPageIndex = 1; } else { pageIndex = AspNetPager1.CurrentPageIndex; } string strWhare = GetSqlWhereClause(); int recordCount = 0; DataSet userList = null; try { //userList = UsersManager.GetListForGridView(pageSize, pageIndex, strWhare, out recordCount, OrderName, OrderType); userList = UsersManager.GetUserList(pageSize, pageIndex, strWhare, out recordCount, OrderName, OrderType); } catch (Exception exception) { LPLog.LogMessage(exception.Message); } AspNetPager1.PageSize = pageSize; AspNetPager1.RecordCount = recordCount; gridUserList.DataSource = userList; gridUserList.DataBind(); //ClientFun(this.updatePanel, "registerClearIds", "arrSelectedLOID = new Array(); arrSelectedUId = new Array();"); }