/// <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();");
}
