private async Task CheckUpdateActiveOffersValidDates(EntityContext ctx, IQueryable<SpecialCommisionOffers> activeRecords)
 {
     for (int i = 0; i < activeRecords.Count(); i++)
     {
         if (_dateProvider.CompareDates(activeRecords.ElementAt(i).EndDate, _dateProvider.GetCurrentDateTime()))
         {
             ctx.SpecialCommisionOffers.Find(activeRecords.ElementAt(i).ID).ActiveStatus = false;
             await ctx.SaveChangesAsync();
         }
     }
 }
 public async Task <BoolMessage> SetDefaultCommisions(DefaultSettings settings)
 {
     try
     {
         using (var ctx = new EntityContext())
         {
             var newCommission = new DefaultCommisions
             {
                 Country     = ctx.Country.Find(settings.CountryId),
                 Currency    = ctx.Currency.Find(settings.CurrencyId),
                 PaymentType = ctx.PaymentTypes.Find(settings.PaymentType),
                 DefaultCommisionPercentage = 2.0F,
                 MaxCommissionEachPayment   = 20.0F,
                 MaxPaymentVolume           = 0,
                 MinCommissionEachPayment   = 0.5F,
                 MinimumPaymentVolume       = 1,
                 LastUpdatedBy   = 1,
                 LastUpdatedDate = _dateProvider.GetCurrentDateTime(),
             };
             ctx.DefaultCommisions.Add(newCommission);
             await ctx.SaveChangesAsync();
         }
         return(new BoolMessage {
             Success = true, Message = "success bitch"
         });
     }
     catch (Exception e)
     {
         return(new BoolMessage {
             Success = false, Message = "fail " + e.ToString()
         });
     }
 }