public void SaveProdutos(List <Livro> livros) { foreach (var livro in livros) { Microsoft.EntityFrameworkCore.DbSet <Produto> dbSets = contexto.Set <Produto>(); if (!dbSets.Where(p => p.Codigo == livro.Codigo).Any()) { dbSet.Add(new Produto(livro.Codigo, livro.Nome, livro.Preco)); } } contexto.SaveChanges(); }
public IQueryable <T> SearchFor(Expression <Func <T, bool> > predicate) { return(DbSet.Where(predicate)); }
public virtual List <T> Filter(Func <T, bool> where) { return(DbSet .Where(where) .ToList()); }
public IReadOnlyCollection <Coupon> ListAllByCompany(int companyId) { return(_coupons.Where <Coupon>(x => x.CompanyId == companyId).ToArray()); }
public IEnumerable <TEntity> Search(Expression <Func <TEntity, bool> > predicate) { return(DbSet.Where(predicate)); }
public async Task <ICollection <Elanat> > GetAllElanatsPaged(paggingData paggingData) { if (paggingData.Expression.IsNullOrEmpty()) { paggingData.Expression = ""; } if (paggingData.SortBy.IsNullOrEmpty()) { paggingData.SortBy = "ElanatId"; } var list = _entity.Where(c => c.MessageTopic.Contains(paggingData.Expression) || c.MessageText.Contains(paggingData.Expression)) .OrderBy(c => c.ElanatId); if (paggingData.SortMethod == "asc") { switch (paggingData.SortBy) { case "messageTopic": list = list.OrderBy(c => c.MessageTopic); break; case "messageText": list = list.OrderBy(c => c.MessageText); break; case "dateFrom": list = list.OrderBy(c => c.DateFrom); break; case "dateTo": list = list.OrderBy(c => c.DateTo); break; //case "DesLevel": // list = list.OrderBy(c => c.DesLevel); // break; default: list = list.OrderBy <Elanat>(paggingData.SortBy); break; } } else { switch (paggingData.SortBy) { case "messageTopic": list = list.OrderByDescending(c => c.MessageTopic); break; case "messageText": list = list.OrderByDescending(c => c.MessageText); break; case "dateFrom": list = list.OrderByDescending(c => c.DateFrom); break; case "dateTo": list = list.OrderByDescending(c => c.DateTo); break; default: list = list.OrderBy <Elanat>(paggingData.SortBy + " descending"); break; } } return(await Pagging.PagedResult(list, paggingData).ToListAsync()); }
public async Task <Maybe <Company> > FindCompanyByNameAsync(string name) { var company = await _companies.Where(x => x.Name == name).FirstOrDefaultAsync(); return(company.ToMaybe()); }