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());
}
