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