public void Sum_Decimal_With_Predicate_Should_Return_Sum(IRepository <Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact {
Name = "Test User " + i, ContactTypeId = i, SumDecimal = 0.5m + i
};
repository.Add(contact);
}
repository.Sum(x => x.ContactTypeId > 1, x => x.SumDecimal).ShouldEqual(6m);
}
public void Sum_With_Specification_Should_Return_Sum(IRepository <Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact {
Name = "Test User " + i, ContactTypeId = i
};
repository.Add(contact);
}
repository.Sum(new Specification <Contact>(x => x.ContactTypeId > 1), x => x.ContactTypeId).ShouldEqual(5);
}
public void Sum_All_Should_Return_Sum(IRepository <Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact {
Name = "Test User " + i, ContactTypeId = i
};
repository.Add(contact);
}
repository.Sum(x => x.ContactTypeId).ShouldEqual(6);
}
public void Sum_Decimal_All_Should_Return_Sum(IRepository <Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact {
Name = "Test User " + i, ContactTypeId = i, SumDecimal = 0.5m + i
};
repository.Add(contact);
}
repository.Sum(x => x.SumDecimal).ShouldBe(7.5m);
}
public void Sum_With_Predicate_Should_Return_Sum(IRepository <Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact {
Name = "Test User " + i, ContactTypeId = i
};
repository.Add(contact);
}
repository.Sum(x => x.ContactTypeId > 1, x => x.ContactTypeId).ShouldBe(5);
}
public int AggregateValues(string fieldName, string filter = null)
{
if (!IsValidFieldName(fieldName) || !IsValidFilter(filter))
{
throw new InvalidOperationException("Invalid field name or filter specified.");
}
DateTime?dateFilter = null;
if (filter != null)
{
dateFilter = DateTime.Parse(filter, CultureInfo.InvariantCulture);
}
if (dateFilter != null)
{
var filterExpression = GetDateFilterExpression(dateFilter.Value);
return(repository.Sum(m => m.Calories.Value, filterExpression));
}
return(repository.Sum(m => m.Calories.Value));
}
public override double Sum(string columnName)
{
return(_repo.Sum(columnName));
}
public int Sum(Expression <Func <T, int> > selector)
{
return(Repository.Sum(selector));
}
public void Sum_With_Specification_Should_Return_Sum(IRepository<Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact { Name = "Test User " + i, ContactTypeId =i};
repository.Add(contact);
}
repository.Sum(new Specification<Contact>(x => x.ContactTypeId > 1), x => x.ContactTypeId).ShouldEqual(5);
}
public void Sum_Decimal_With_Predicate_Should_Return_Sum(IRepository<Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact { Name = "Test User " + i, ContactTypeId = i, SumDecimal = 0.5m + i };
repository.Add(contact);
}
repository.Sum(x => x.ContactTypeId > 1, x => x.SumDecimal).ShouldEqual(6m);
}
public void Sum_All_Should_Return_Sum(IRepository<Contact, string> repository)
{
for (var i = 1; i <= 3; i++)
{
var contact = new Contact { Name = "Test User " + i, ContactTypeId =i};
repository.Add(contact);
}
repository.Sum(x => x.ContactTypeId).ShouldEqual(6);
}
/// <summary>
///
/// </summary>
/// <param name="where"></param>
/// <param name="selector"></param>
/// <returns></returns>
public virtual int Sum(Expression <Func <TEntity, bool> > where, Expression <Func <TEntity, int> > selector)
{
return(_repository.Sum(where, selector));
}
