/// <summary>
/// Get filter
/// </summary>
/// <returns></returns>
private string GetSqlWhereClause()
{
string strWhere = string.Format(" AND EXISTS (SELECT 1 FROM Users WHERE RoleId=u.RoleId and UserId='{0}') AND UserEnabled=1 AND UserId<>{0}", this.nUserId);
if (UsersManager.IsCompanyUser(this.nUserId))
{
}
else if (UsersManager.IsRegionUser(this.nUserId))
{
strWhere += string.Format(@" AND (EXISTS (SELECT 1 FROM (SELECT UserId FROM GroupUsers gu WHERE EXISTS (SELECT 1 FROM Groups WHERE RegionID in
(SELECT RegionID from Groups as a INNER JOIN GroupUsers as b on a.GroupId = b.GroupID
INNER JOIN Users as c on b.UserID = c.UserId where OrganizationType='Region' and b.UserID='{0}'
) AND GroupId=gu.GroupID)) t1 WHERE u.UserId=t1.UserID))", this.nUserId);
}
else if (UsersManager.IsDivisionUser(this.nUserId))
{
strWhere += string.Format(@" AND (EXISTS (SELECT 1 FROM
(SELECT UserId FROM GroupUsers gu WHERE EXISTS (SELECT 1 FROM Groups WHERE DivisionID in
(
SELECT DivisionID FROM Groups AS a INNER JOIN GroupUsers AS b ON a.GroupId = b.GroupID
INNER JOIN Users AS c ON b.UserID = c.UserId WHERE OrganizationType='Division' AND b.UserID = '{0}'
) AND GroupId=gu.GroupID)) t1 WHERE u.UserId=t1.UserID))", this.nUserId);
}
else if (UsersManager.IsBranchUser(this.nUserId))
{
strWhere += string.Format(@" AND (EXISTS (SELECT 1 FROM
(SELECT UserId FROM GroupUsers gu WHERE EXISTS (SELECT 1 FROM Groups WHERE BranchID in
(
SELECT BranchID FROM Groups AS a INNER JOIN GroupUsers AS b ON a.GroupId = b.GroupID
INNER JOIN Users AS c ON b.UserID = c.UserId WHERE OrganizationType='Branch' AND b.UserID = '{0}'
) AND GroupId=gu.GroupID)) t1 WHERE u.UserId=t1.UserID))", this.nUserId);
}
else
{
strWhere += " AND 1=2";
}
return(strWhere);
}