//-------------------------------------------------------------------------------------------------
public IEnumerable <UserForShowDto> FilterSerchingUsers(FilterUserRequestDto searchItem)
{
IEnumerable <UserForShowDto> res = null;
using (_db = new IdeaManagmentDatabaseEntities())
{
System.Linq.IQueryable <USER> users = _db.USERS;
if (searchItem.Username != null && searchItem.Username.Trim().Length > 0)
{
users = users.Where(u => u.USERNAME.Contains(searchItem.Username.Trim()));
}
if (searchItem.FullName != null && searchItem.FullName.Trim().Length > 0)
{
if (searchItem.FullName.Trim().Contains(" "))
{
var firstName = searchItem.FullName.Trim().Substring(0, searchItem.FullName.Trim().IndexOf(" "));
var lastName = searchItem.FullName.Trim().Substring(searchItem.FullName.Trim().IndexOf(" ") + 1);
users = users.Where(u => u.FIRST_NAME.Contains(firstName.Trim()) && u.LAST_NAME.Contains(lastName.Trim()));
}
else
{
users = users.Where(u => u.FIRST_NAME.Contains(searchItem.FullName.Trim()) || u.LAST_NAME.Contains(searchItem.FullName.Trim()));
}
}
switch (searchItem.RoleValue)
{
case 0:
users = users.Where(u => u.ADMIN_FLAG == false && u.COMMITTEE_FLAG == false);
break;
case 1:
users = users.Where(u => u.ADMIN_FLAG == false && u.COMMITTEE_FLAG == true);
break;
case 2:
users = users.Where(u => u.ADMIN_FLAG == true && u.COMMITTEE_FLAG == false);
break;
case 3:
users = users.Where(u => u.ADMIN_FLAG == true && u.COMMITTEE_FLAG == true);
break;
default:
break;
}
res = users.ToList().Select(x => new UserForShowDto()
{
CommitteFlag = x.COMMITTEE_FLAG,
AdminFlag = x.ADMIN_FLAG,
Email = x.EMAIL,
FirstName = x.FIRST_NAME,
LastName = x.LAST_NAME,
SaveDate = Persia.Calendar.ConvertToPersian(x.SAVE_DATE).Simple,
Username = x.USERNAME
});
}
return(res);
}
//-------------------------------------------------------------------------------------------------
public IEnumerable <UserForShowDto> FilterSerchingUsers(FilterUserRequestDto searchItem)
{
IEnumerable <UserForShowDto> res = null;
using (_db = new IdeaManagmentDatabaseEntities())
{
System.Linq.IQueryable <USER> users = _db.USERS;
if (searchItem.Username != null && searchItem.Username.Trim().Length > 0)
{
users = users.Where(u => u.USERNAME.Contains(searchItem.Username.Trim()));
}
if (searchItem.FullName != null && searchItem.FullName.Trim().Length > 0)
{
if (searchItem.FullName.Trim().Contains(" "))
{
var firstName = searchItem.FullName.Trim().Substring(0, searchItem.FullName.Trim().IndexOf(" "));
var lastName = searchItem.FullName.Trim().Substring(0, searchItem.FullName.Trim().IndexOf(" "));
}
else
{
users = users.Where(u => u.FIRST_NAME.Contains(searchItem.Username.Trim()) || u.LAST_NAME.Contains(searchItem.Username.Trim()));
}
}
switch (searchItem.PositionValue)
{
case 0:
users = users.Where(u => u.ADMIN_FLAG == false && u.COMMITTEE_FLAG == false);
break;
case 1:
users = users.Where(u => u.ADMIN_FLAG == false && u.COMMITTEE_FLAG == true);
break;
case 2:
users = users.Where(u => u.ADMIN_FLAG == true && u.COMMITTEE_FLAG == false);
break;
case 3:
default:
break;
}
res = users.Select(x => new UserForShowDto()
{
COMMITTEE_FLAG = x.COMMITTEE_FLAG,
ADMIN_FLAG = x.ADMIN_FLAG,
EMAIL = x.EMAIL,
FIRST_NAME = x.FIRST_NAME,
LAST_NAME = x.LAST_NAME,
SAVE_DATE = x.SAVE_DATE,
USERNAME = x.USERNAME
});
}
return(res);
}
public IEnumerable <UserForShowDto> FilterSerchingUsers(FilterUserRequestDto searchItem)
{
return(_Repository.FilterSerchingUsers(searchItem));
}
public IEnumerable <UserForShowDto> FilterSerchingUsers(FilterUserRequestDto searchItem)
{
return(_business.FilterSerchingUsers(searchItem));
}
