public IHttpActionResult GetAll(FilterReps filter)
{
if (filter == null)
{
filter = new FilterReps();
filter.PageSize = 25;
filter.CurrentPage = 1;
}
var response = repository.GetReps(filter, CurrentBusinessId.Value);
return(Ok <DataResponse <EntityList <EntityReps> > >(response));
}
public IHttpActionResult GetByFilter(FilterReps filter)
{
var repository = new RepositoryReps();
if (filter == null)
{
filter = new FilterReps {
PageSize = 25, CurrentPage = 1
}
}
;
var response = repository.GetReps(filter, CurrentBusinessId.Value);
return(Ok <DataResponse <EntityList <EntityReps> > >(response));
}
public DataResponse <EntityList <EntityReps> > GetReps(FilterReps filter, int currentBusineId, int take = 10, int skip = 0)
{
var response = new DataResponse <EntityList <EntityReps> >();
try
{
if (filter != null)
{
take = filter.Take;
skip = filter.Skip;
}
base.DBInit();
var query = DBEntity.Reps.Where(a => a.User.BusinessId == currentBusineId);
if (filter != null)
{
if (!String.IsNullOrEmpty(filter.KeyWords))
{
query = query.Where(ua => ua.User2.FirstName.ToLower().Contains(filter.KeyWords.ToLower()) ||
ua.User2.LastName.ToLower().Contains(filter.KeyWords.ToLower()) ||
(ua.User2.FirstName + " " + ua.User2.MiddleName).ToLower().Contains(filter.KeyWords.ToLower()) ||
(ua.User2.FirstName + " " + ua.User2.LastName).ToLower().Contains(filter.KeyWords.ToLower()) ||
(ua.User2.FirstName + " " + ua.User2.MiddleName + " " + ua.User2.LastName).ToLower().Contains(filter.KeyWords.ToLower()) ||
ua.User2.UserName.ToLower().Contains(filter.KeyWords.ToLower()) ||
ua.RepGroup.RepGroupName.ToLower().Contains(filter.KeyWords.ToLower()));
}
}
var selectQuery = query.Select(a => new EntityReps
{
Id = a.Id,
UserId = a.UserId,
RepName = a.User2.FirstName + " " + a.User2.LastName,
RepGroupName = a.RepGroup.RepGroupName,
RepGroupId = a.RepGroupId,
CreatedBy = a.CreatedBy,
CreatedOn = a.CreatedOn,
UpdatedBy = a.UpdatedBy,
UpdatedOn = a.UpdatedOn,
SignonDate = a.SignonDate,
IsActive = a.IsActive,
OldId = a.OldId,
CreatedByName = a.User.FirstName + " " + a.User.LastName,
UpdatedByName = a.User1.FirstName + " " + a.User1.LastName,
ServiceIds = a.RepServiceMappers.Select(b => b.ServiceId).ToList(),
RepGroupManagerNames = a.RepGroup.RepgroupManagerMappers.Select(b => b.User.FirstName + "" + b.User.LastName),
ServiceNames = a.RepServiceMappers.Where(b => b.RepId == a.Id).Select(p => p.LookupEnrolledService.ServiceName),
DirectorNames = a.RepGroup.RepgroupManagerMappers.Select(b => b.User.LastName)
});
if (string.IsNullOrEmpty(filter.SortKey) || string.IsNullOrEmpty(filter.SortOrder))
{
selectQuery = selectQuery.OrderByDescending(o => o.CreatedOn);
}
else
{
string orderBy = string.Format("{0} {1}", filter.SortKey, filter.SortOrder);
selectQuery = selectQuery.OrderBy(orderBy);
}
response = GetList <EntityReps>(selectQuery, skip, take);
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
