public async Task <Personal> GetWithInclude(int id, params Expression <Func <Personal, object> >[] includes) { var query = Context.Set <Personal>().OrderBy(s => s.Id); var data = await CommonRepositoryAsync.GetIncludeAsync(query, _includeUserInfo); return(data.FirstOrDefault(s => s.Id == id)); }
public async Task <PagingOutput <Polyclinic> > GetAllAsync(int page, int pageSize, SortOprions sortOrder, string search) { var query = from _ in Context.Set <Polyclinic>() orderby _.Id select _; if (search != "") { query = from _ in Context.Set <Polyclinic>() where _.Name.ToLower().Contains(search.ToLower()) orderby _.Id select _; } switch (sortOrder) { case SortOprions.Name: query = query.OrderBy(x => x.Name); break; case SortOprions.Name_desc: query = query.OrderByDescending(x => x.Name); break; default: break; } return(await CommonRepositoryAsync.GetAllWithPageAsync(query, page, pageSize, _includeInfo)); }
/// <summary> /// постраничное получение данных /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="sort"></param> /// <param name="search"></param> /// <returns></returns> public async Task <PagingOutput <UserInfo> > GetAllAsync(int page, int pageSize, SortOprions sort, string search = "") { var query = from _ in Context.Set <UserInfo>() where _.RoleInfoId == 1 orderby _.Id select _; if (search != "") { query = from _ in Context.Set <UserInfo>() where _.SurName.ToLower().Contains(search.ToLower()) || _.LastName.ToLower().Contains(search.ToLower()) || _.FirstName.ToLower().Contains(search.ToLower()) || _.PhoneNumber.ToLower().Contains(search.ToLower()) || _.Email.ToLower().Contains(search.ToLower()) orderby _.Id select _; } switch (sort) { case SortOprions.Email: query = query.OrderBy(x => x.Email); break; case SortOprions.Email_desc: query = query.OrderByDescending(x => x.Email); break; case SortOprions.Name: query = query.OrderBy(x => x.FirstName); break; case SortOprions.Name_desc: query = query.OrderByDescending(x => x.FirstName); break; case SortOprions.Number: query = query.OrderBy(x => x.Id); break; case SortOprions.Number_desc: query = query.OrderByDescending(x => x.Id); break; case SortOprions.PhoneNumber: query = query.OrderBy(x => x.PhoneNumber); break; case SortOprions.PhoneNumber_desc: query = query.OrderByDescending(x => x.PhoneNumber); break; default: break; } return(await CommonRepositoryAsync.GetAllWithPageAsync(query, page, pageSize, _includeUserInfo)); }
private async Task <PagingOutput <Schedule> > GetAllFilterAsync(IOrderedQueryable <Schedule> query, int page, int pageSize, SortOprions sort, string search = "") { if (search != "") { query = from _ in Context.Set <Schedule>() where _.Personal.UserInfo.SurName.ToLower().Contains(search.ToLower()) || _.Personal.UserInfo.LastName.ToLower().Contains(search.ToLower()) || _.Personal.UserInfo.FirstName.ToLower().Contains(search.ToLower()) || _.Personal.UserInfo.PhoneNumber.ToLower().Contains(search.ToLower()) || _.Personal.UserInfo.Email.ToLower().Contains(search.ToLower()) || _.Personal.Polyclinic.Name.ToLower().Contains(search.ToLower()) || _.Personal.Position.Name.ToLower().Contains(search.ToLower()) || _.Personal.Polyclinic.Address.ToLower().Contains(search.ToLower()) orderby _.Id select _; } switch (sort) { case SortOprions.Email: query = query.OrderBy(x => x.Personal.UserInfo.Email); break; case SortOprions.Email_desc: query = query.OrderByDescending(x => x.Personal.UserInfo.Email); break; case SortOprions.Name: query = query.OrderBy(x => x.Personal.UserInfo.FirstName); break; case SortOprions.Name_desc: query = query.OrderByDescending(x => x.Personal.UserInfo.FirstName); break; case SortOprions.Number: query = query.OrderBy(x => x.Id); break; case SortOprions.Number_desc: query = query.OrderByDescending(x => x.Id); break; case SortOprions.Position: query = query.OrderBy(x => x.Personal.Position.Name); break; case SortOprions.Position_desc: query = query.OrderByDescending(x => x.Personal.Position.Name); break; default: break; } return(await CommonRepositoryAsync.GetAllWithPageAsync(query, page, pageSize, _include)); }
public async Task <PagingOutput <Schedule> > GetAllForPersonalAsync(int id) { var query = from _ in Context.Set <Schedule>() where _.PersonalId == id orderby _.Id select _; return(await CommonRepositoryAsync.GetAllWithPageAsync(query, 1, 10, _include)); }
/// <summary> /// получение данных с вклбченными элементами /// </summary> /// <param name="id"></param> /// <param name="includes"></param> /// <returns></returns> public async Task <UserInfo> GetWithInclude(int id, params Expression <Func <UserInfo, object> >[] includes) { var query = Context.Set <UserInfo>().AsNoTracking().OrderBy(s => s.Id); var data = await CommonRepositoryAsync.GetIncludeAsync(query, _includeUserInfo); var result = data.FirstOrDefault(s => s.Id == id); Context.Entry(result).State = EntityState.Detached; return(result); }
/// <summary> /// получение данных по страницам /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <returns></returns> public async Task <PagingOutput <T> > GetAllAsync(int page, int pageSize) { return(await CommonRepositoryAsync.GetAllWithPageAsync(_entities.OrderBy(s => s), page, pageSize)); }