/// <summary>
/// Selects the user login assign.
/// </summary>
/// <param name="_UserLoginAssign">The _ user login assign.</param>
/// <returns></returns>
public List <UserLoginAssign> SelectUserLoginAssign(UserLoginAssign _UserLoginAssign)
{
List <UserLoginAssign> listUserLoginAssignSelect = new List <UserLoginAssign>();
try
{
listUserLoginAssignSelect = ApplicationState.DAClient.SelectUserLoginAssign(_UserLoginAssign);
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(listUserLoginAssignSelect);
}
public List <UserLoginAssign> SelectUserLoginAssign(UserLoginAssign parameter)
{
List <UserLoginAssign> list = new List <UserLoginAssign>();
try
{
var query = from a in _dataContext.UserLoginAssigns
.WhereIf(!String.IsNullOrEmpty(parameter.UserName), q => q.UserName == parameter.UserName)
.WhereIf(!String.IsNullOrEmpty(parameter.CompanyId), q => q.CompanyId == parameter.CompanyId)
.WhereIf(!String.IsNullOrEmpty(parameter.LocationId), q => q.LocationId == parameter.LocationId)
.WhereIf(parameter.DateOfEntry.HasValue, q => q.DateOfEntry == parameter.DateOfEntry.Value)
.WhereIf(!String.IsNullOrEmpty(parameter.EntryBy), q => q.EntryBy == parameter.EntryBy)
orderby a.UserName ascending
select a;
list = query.ToList <UserLoginAssign>();
}
catch (SqlException ex)
{
_ErrorHandler.ONSERRORProcessing(ex);
}
return(list);
}
