public IHttpActionResult GetAllPracticespecialities(PracticeSpecialityFilter filter) { if (filter == null) { filter = new PracticeSpecialityFilter(); filter.PageSize = 25; filter.CurrentPage = 1; } var response = repository.GetAllSpecialityType(filter); return(Ok <DataResponse <EntityList <EntityPracticeSpecialityType> > >(response)); }
public DataResponse <EntityList <EntityPracticeSpecialityType> > GetAllSpecialityType(PracticeSpecialityFilter filter, int take = 10, int skip = 0) { var response = new DataResponse <EntityList <EntityPracticeSpecialityType> >(); try { base.DBInit(); if (filter != null) { take = filter.Take; skip = filter.Skip; } var query = DBEntity.LookupPracticeSpecialityTypes.Where(a => 1 == 1); if (!string.IsNullOrEmpty(filter.KeyWords)) { query = query.Where(ua => ua.PracticeSpecialityType.ToLower().Contains(filter.KeyWords.ToLower())); } var selectQuery = query.Select(a => new EntityPracticeSpecialityType { Id = a.Id, PracticeSpecialityType = a.PracticeSpecialityType, CreatedUser = a.User.FirstName, CreatedOn = a.CreatedOn, Updateduser = a.User1 == null ? null : a.User1.FirstName, UpdatedOn = a.UpdatedOn, IsActive = a.IsActive }); 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 <EntityPracticeSpecialityType>(selectQuery, skip, take); } catch (Exception ex) { ex.Log(); } finally { base.DBClose(); } return(response); }