public ActionResult SearchResultsRead([DataSourceRequest] DataSourceRequest request)
{
EmployeeSearchAdditionalData employeeSearchAdditionalData = new EmployeeSearchAdditionalData();
TryUpdateModel(employeeSearchAdditionalData);
int searchType = FindSearchType(employeeSearchAdditionalData);
if (searchType == 0)
{
return(null);
}
string domain = ConfigurationManager.AppSettings["LDAPDomain"];
string serviceUser = ConfigurationManager.AppSettings["ServiceUser"];
string servicePassword = ConfigurationManager.AppSettings["ServicePassword"];
LdapDirectoryIdentifier ldapDirectoryIdentifier = new LdapDirectoryIdentifier(domain);
NetworkCredential myCredentials = new NetworkCredential(serviceUser, servicePassword);
LdapConnection connection = new LdapConnection(ldapDirectoryIdentifier, myCredentials, AuthType.Basic);
connection.SessionOptions.ProtocolVersion = 3;
DirectoryContext context = new DirectoryContext(connection);
var orders = context.Query <User>();
switch (searchType)
{
case 1:
orders = orders.Where(u => (u.FirstName.Contains(employeeSearchAdditionalData.Keyword)) || (u.LastName.Contains(employeeSearchAdditionalData.Keyword)));
break;
case 2:
orders = orders.Where(u => (u.CountryCode == employeeSearchAdditionalData.CountryCode1));
break;
case 3:
orders = orders.Where(u => ((u.FirstName.Contains(employeeSearchAdditionalData.Keyword)) || (u.LastName.Contains(employeeSearchAdditionalData.Keyword))) &&
(u.CountryCode == employeeSearchAdditionalData.CountryCode1));
break;
case 4:
if (!String.IsNullOrWhiteSpace(employeeSearchAdditionalData.FirstName))
{
orders = orders.Where(u => (u.FirstName.Contains(employeeSearchAdditionalData.FirstName)));
}
if (!String.IsNullOrWhiteSpace(employeeSearchAdditionalData.LastName))
{
orders = orders.Where(u => (u.LastName.Contains(employeeSearchAdditionalData.LastName)));
}
if (!String.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode2))
{
orders = orders.Where(u => (u.CountryCode == employeeSearchAdditionalData.CountryCode2));
}
if (!String.IsNullOrWhiteSpace(employeeSearchAdditionalData.Location))
{
orders = orders.Where(u => (u.Location == employeeSearchAdditionalData.Location));
}
if (!String.IsNullOrWhiteSpace(employeeSearchAdditionalData.PositionTitle))
{
orders = orders.Where(u => (u.PositionTitle.Contains(employeeSearchAdditionalData.PositionTitle)));
}
if (!String.IsNullOrWhiteSpace(employeeSearchAdditionalData.FunctionalArea))
{
orders = orders.Where(u => (u.FunctionalArea == employeeSearchAdditionalData.FunctionalArea));
}
break;
}
orders = orders.Where(c => (c.Status == "Actif"));
var total = orders.Count();
orders = orders.ApplyOrdersSorting(request.Groups, request.Sorts);
var x = orders.ApplyOrdersPaging(request.Page, request.PageSize, total);
var result = new DataSourceResult()
{
Data = x,
Total = total
};
return(Json(result));
}
public int FindSearchType(EmployeeSearchAdditionalData employeeSearchAdditionalData)
{
//Blank
if (
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Keyword) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode1) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FirstName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.LastName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode2) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Location) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.PositionTitle) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FunctionalArea)
)
{
return(0);
}
//Keyword
if (
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Keyword) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode1) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FirstName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.LastName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode2) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Location) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.PositionTitle) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FunctionalArea)
)
{
return(1);
}
//Country
if (
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Keyword) &&
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode1) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FirstName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.LastName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode2) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Location) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.PositionTitle) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FunctionalArea)
)
{
return(2);
}
//Keyword and Country
if (
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Keyword) &&
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode1) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FirstName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.LastName) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode2) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Location) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.PositionTitle) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FunctionalArea)
)
{
return(3);
}
//First
if (
(string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Keyword) &&
string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode1)) &&
(
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FirstName) ||
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.LastName) ||
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.CountryCode2) ||
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.Location) ||
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.PositionTitle) ||
!string.IsNullOrWhiteSpace(employeeSearchAdditionalData.FunctionalArea))
)
{
return(4);
}
return(0);
}
