public IEnumerator GetEnumerator()
{
var options = CreateNewContextOptions();
WithdrawalMethod courierMethod;
WithdrawalMethod creditCardMethod;
User user;
using (var db = new EntireMoneyProcessingContext(options))
{
ProcessingTestHelper.PopulateDefaultMoneyCtx(db);
courierMethod = db.Set <WithdrawalMethod>().First(it => it.Code == "courier".ToUpper());
creditCardMethod = db.Set <WithdrawalMethod>().First(it => it.Code == "creditCard".ToUpper());
user = db.Set <User>().First(it => it.UserName == "Andrew");
}
var serializerSettings = new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
DateFormatString = "dd-MM-yyyy" //,
// Culture = new CultureInfo("ru-ru")
//DateFormatHandling = DateFormatHandling.MicrosoftDateFormat
};
var withdrawalFilter = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id
};
yield return(new TestCaseData(options, withdrawalFilter, 5)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(withdrawalFilter, serializerSettings)));
var usercourierMethodFilter = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id
};
yield return(new TestCaseData(options, usercourierMethodFilter, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(usercourierMethodFilter, serializerSettings)));
var userCreditCardFilter = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = creditCardMethod.Id
};
yield return(new TestCaseData(options, userCreditCardFilter, 2)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCreditCardFilter, serializerSettings)));
var userCorierDateIntervalFilter1 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval = new Interval <DateTime?>()
{
End = DateTime.Now.AddDays(200)
}
};
yield return(new TestCaseData(options, userCorierDateIntervalFilter1, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalFilter1, serializerSettings)));
var userCorierDateIntervalFilter2 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval = new Interval <DateTime?>()
{
Start = DateTime.Now.AddDays(-14)
}
};
yield return(new TestCaseData(options, userCorierDateIntervalFilter2, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalFilter2, serializerSettings)));
var userCorierDateIntervalFilter3 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?>()
{
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
}
};
yield return(new TestCaseData(options, userCorierDateIntervalFilter3, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalFilter3, serializerSettings)));
var userCorierDateIntervalWithdrawalDateFilter1 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateFilter1, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateFilter1, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter1 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval = new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval = new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 0
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter1, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter1, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter2 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 0
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter2, 0)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter2, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter3 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 0
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter3, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter3, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter4 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 0, End = 100000
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter4, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter4, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter5 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 1001, End = 100000
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter5, 0)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter5, serializerSettings)));
;
var userCorierDateIntervalWithdrawalDateAmountFilter6 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?> {
Start = 1001
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter6, 0)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter6, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter7 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
End = 1001
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter7, 3)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter7, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter8 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 99, End = 999
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter8, 0)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter8, serializerSettings)));
var userCorierDateIntervalWithdrawalDateAmountFilter9 = new WithdrawalApplicationFilter <int, int?>
{
UserId = user.Id,
WithdrawalMethodId = courierMethod.Id,
DateCreatedInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(7), Start = DateTime.Now.AddDays(-14)
},
WithdrawalBeforeInterval =
new Interval <DateTime?> {
End = DateTime.Now.AddDays(15), Start = DateTime.Now.AddDays(-14)
},
Amount = new Interval <decimal?>()
{
Start = 99, End = 999
}
};
yield return(new TestCaseData(options, userCorierDateIntervalWithdrawalDateAmountFilter9, 0)
.SetName("GetApplications: Filter -> " + JsonConvert.SerializeObject(userCorierDateIntervalWithdrawalDateAmountFilter9, serializerSettings)));
;
}
public void GetApplications(DbContextOptions <EntireMoneyProcessingContext> options, WithdrawalApplicationFilter <int, int?> filter, int expectedCount)
{
try
{
IEnumerable <WithdrawalApplication> result = null;
using (var db = new EntireMoneyProcessingContext(options))
{
var repository = new WithdrawalProcessing(db);
Assert.DoesNotThrow(
() => result =
repository.GetApplications(filter));
Assert.True(result != null && result.Count() == expectedCount);
}
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
public IEnumerable <WithdrawalApplication> GetApplications(WithdrawalApplicationFilter <int, int?> filter)
{
try
{
var query = Db.Set <WithdrawalApplication>().Where(it => it.UserId == filter.UserId);
if (filter.WithdrawalMethodId.HasValue)
{
query = query.Where(it => it.WithdrawalMethodId == filter.WithdrawalMethodId);
}
//date created
if (filter.DateCreatedInterval != null)
{
if (filter.DateCreatedInterval.Start != null)
{
query = query.Where(it => it.DateCreated >= filter.DateCreatedInterval.Start);
}
if (filter.DateCreatedInterval.End != null)
{
query = query.Where(it => it.DateCreated <= filter.DateCreatedInterval.End);
}
}
//date Withdrawal Before
if (filter.WithdrawalBeforeInterval != null)
{
if (filter.WithdrawalBeforeInterval.Start != null)
{
query = query.Where(it => it.WithdrawalBefore >= filter.WithdrawalBeforeInterval.Start);
}
if (filter.WithdrawalBeforeInterval.End != null)
{
query = query.Where(it => it.WithdrawalBefore <= filter.WithdrawalBeforeInterval.End);
}
}
if (filter.Amount != null)
{
if (filter.Amount.Start != null)
{
query = query.Where(it => it.Amount >= filter.Amount.Start);
}
if (filter.Amount.End != null)
{
query = query.Where(it => it.Amount <= filter.Amount.End);
}
}
if (!string.IsNullOrEmpty(filter.Sidx))
{
query = filter.Sord.Equals("desc", StringComparison.OrdinalIgnoreCase)
? query.OrderByDescending(filter.Sidx)
: query.OrderBy(filter.Sidx);
}
if (filter.Page != 0 && filter.Rows != 0)
{
return(query.Skip(filter.Rows * (filter.Page - 1)).Take(filter.Rows));
}
return(query);
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
