Loop keep picking the same records

See more:

C#

ASP.NET

MVC5

entity-framework

I'm saving a record in my database by passing 3 parameters, the number parameter is passed to pick the number of records from one table to another table. However the loop keep inserting the same number of records instead of checking for existing stickercodes in another IntermediaryAssignment table before inserting from sticker distribution table.the foreach statement seems not to be working well expecially
Hide Copy Code

if (dbSet.Any(s => s.StickerCode != sticker.StickerCode))

Kindly help.Also it doesn't update the IntermediaryDispatched as well

What I have tried:

public async Task<bool> Save(string company, int number,string
registrationNumber)
  {

      using (var trans = _dbContext.Database.BeginTransaction())
      {
          var db = new DatabaseContext();
         var dbSet = _dbContext.Set<IntermediaryAssignment>();

          // set the database
          var check =await  (from s in db.StickerDistributions
                       join i in db.IntermediaryAssignment
                       on s.CompanyCode equals i.CompanyCode
                       where s.Dispatched == false && s.CompanyCode == company
                        && s.StickerCode != i.StickerCode
                       select s).ToListAsync();

          var datas = await (from s in db.StickerDistributions
                            where s.Dispatched == false && s.CompanyCode ==
                            company && s.IntermediaryDispatched == false
                             select s).ToListAsync();

          var data = await (from s in db.StickerDistributions
                            where s.Dispatched == false && s.CompanyCode ==
                            company &&
                            s.IntermediaryDispatched == false
                            select s).Take(number).ToListAsync();

              var intermediary = (await _repo.FindBy(s => s.RegistrationNumber
             == registrationNumber && s.Status ==
              EntityStatus.Active)).FirstOrDefault();
       foreach (var sticker in data)
          {
              if (dbSet.Any(s => s.StickerCode != sticker.StickerCode))
              {
                  var entity = new IntermediaryAssignment();

                  entity.CompanyCode = sticker.CompanyCode;
                  entity.StickerCode = sticker.StickerCode;
                  entity.RegistrationNumber = intermediary.RegistrationNumber;
                  entity.Status = EntityStatus.Active;
                  entity.CreatedDate = DateTime.Now;
                  entity.Dispatched = false;
                  entity.IntermediaryType = intermediary.IntermediaryType;
                  // entity.Sticker.Id = sticker.Sticker.Id;
                  sticker.IntermediaryDispatched = true;
                  dbSet.Add(entity);
              }

          }
          Task results =  _dbContext.SaveChangesAsync() ;
           trans.Commit();
          return  true ;
      }

  }