private void SetRowsCount()
{
BusinessObjectCollection <T> col = new BusinessObjectCollection <T>();
int recordCount;
col.LoadWithLimit("", Sort, 0, 0, out recordCount);
this.RowCount = recordCount;
}
/// <summary>
/// Gets a objects list for the specified page
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="rowsPerPage"></param>
/// <returns></returns>
protected virtual IList <T> GetDataPage(int pageNumber, int rowsPerPage)
{
_bindingListRequest.PageNumber = pageNumber;
_bindingListRequest.RowsPerPage = rowsPerPage;
BusinessObjectCollection <T> col = new BusinessObjectCollection <T>();
int recordCount;
col.LoadWithLimit(Filter, Sort, _bindingListRequest.StartIndex, _bindingListRequest.RowsPerPage, out recordCount);
this.RowCount = recordCount;
return(col);
}
public void Test_CollectionLoad_LoadWithLimit_FirstNegative_ThrowsError()
{
const int totalRecords = 3;
const int firstRecord = -1;
const int limit = 0;
SetupDefaultContactPersonBO();
ContactPersonTestBO[] contactPersonTestBOs = CreateSavedContactPeople(totalRecords);
BusinessObjectCollection<ContactPersonTestBO> col = new BusinessObjectCollection<ContactPersonTestBO>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
try
{
int totalNoOfRecords;
col.LoadWithLimit("", "Surname", firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
Assert.Fail("IndexOutOfRangeException exception expected");
}
catch (IndexOutOfRangeException ex)
{
Assert.AreEqual("FirstRecordToLoad should not be negative.", ex.Message);
}
}
public void Test_CollectionLoad_LoadWithLimit_FirstAtEnd_LimitBeyondEnd_RefreshWithAdditionalBO()
{
const int totalRecords = 5;
const int firstRecord = totalRecords - 1;
const int limit = 3;
SetupDefaultContactPersonBO();
var contactPersonTestBOs = CreateSavedContactPeople(totalRecords);
var contactPersonTestBOsPlusOne = new ContactPersonTestBO[totalRecords + 1];
contactPersonTestBOs.CopyTo(contactPersonTestBOsPlusOne, 0);
var col = new BusinessObjectCollection<ContactPersonTestBO>();
int totalNoOfRecords;
col.LoadWithLimit("", "Surname", firstRecord, limit, out totalNoOfRecords);
contactPersonTestBOsPlusOne[totalRecords] = ContactPersonTestBO.CreateSavedContactPerson
("ZZZZZZZZZZZZZZZZZ");
//---------------Assert Precondition----------------
Assert.AreEqual(1, col.Count);
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
Assert.AreEqual(totalRecords + 1, contactPersonTestBOsPlusOne.Length);
//---------------Execute Test ----------------------
col.Refresh();
//---------------Test Result -----------------------
totalNoOfRecords++;
AssertLimitedResultsCorrect
(firstRecord, limit, totalRecords + 1, 2, contactPersonTestBOsPlusOne, col, totalNoOfRecords);
}
public void Test_CollectionLoad_LoadWithLimit_FirstAfterEnd_LimitZero()
{
const int totalRecords = 3;
const int firstRecord = 4;
const int limit = 0;
SetupDefaultContactPersonBO();
var contactPersonTestBOs = CreateSavedContactPeople(totalRecords);
var col = new BusinessObjectCollection<ContactPersonTestBO>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
int totalNoOfRecords;
col.LoadWithLimit("", "Surname", firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
AssertLimitedResultsCorrect
(firstRecord, limit, totalRecords, 0, contactPersonTestBOs, col, totalNoOfRecords);
}
public void Test_CollectionLoad_LoadWithLimit_CriteriaObject_IncludesCriteriaMatchesWithinLimit()
{
//---------------Set up test pack-------------------
SetupDefaultContactPersonBO();
DateTime now = DateTime.Now;
ContactPersonTestBO cp1 = ContactPersonTestBO.CreateSavedContactPerson(now, "aaa");
ContactPersonTestBO cpLast = ContactPersonTestBO.CreateSavedContactPerson(now, "zzz");
ContactPersonTestBO cp2 = ContactPersonTestBO.CreateSavedContactPerson(now, "hhh");
ContactPersonTestBO.CreateSavedContactPerson(DateTime.Now.AddDays(-3), "bbb");
BusinessObjectCollection<ContactPersonTestBO> col = new BusinessObjectCollection<ContactPersonTestBO>();
Criteria criteria = new Criteria("DateOfBirth", Criteria.ComparisonOp.GreaterThan, now.AddHours(-1));
//---------------Assert Precondition ---------------
//---------------Execute Test ----------------------
// BORegistry.DataAccessor.BusinessObjectLoader.Refresh(col);
col.LoadWithLimit(criteria, "Surname", 2);
//---------------Test Result -----------------------
Assert.AreEqual(2, col.Count);
Assert.AreSame(cp1, col[0]);
Assert.AreSame(cp2, col[1]);
Assert.IsFalse(col.Contains(cpLast));
}
public void Test_CollectionLoad_LoadWithLimit_FirstAfterStart_LimitBeforeEnd()
//_NoRecords_StartRecords_First2Records()
{
const int totalRecords = 6;
const int firstRecord = 2;
const int limit = 2;
SetupDefaultContactPersonBO();
ContactPersonTestBO[] contactPersonTestBOs = CreateSavedContactPeople(totalRecords);
BusinessObjectCollection<ContactPersonTestBO> col = new BusinessObjectCollection<ContactPersonTestBO>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
int totalNoOfRecords;
col.LoadWithLimit("", "Surname", firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
AssertLimitedResultsCorrect
(firstRecord, limit, totalRecords, limit, contactPersonTestBOs, col, totalNoOfRecords);
}
public void Test_CollectionLoad_LoadWithLimit_WithSortCriteriaNullString_WhenCompositePK_ShouldNotRaiseError_FixBug567()
{
ContactPersonCompositeKey.DeleteAllContactPeople();
const int totalRecords = 6;
const int firstRecord = 2;
const int limit = 2;
const int expectedCount = 2;
ContactPersonCompositeKey.LoadClassDefs();
ContactPersonCompositeKey[] contactPersonTestBOs = CreateCompositeContactPeople(totalRecords);
IBusinessObjectCollection col = new BusinessObjectCollection<ContactPersonCompositeKey>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
int totalNoOfRecords;
col.LoadWithLimit((string)null, (string)null, firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
Assert.AreEqual
(totalRecords, totalNoOfRecords, "The returned total number of availabe records is incorrect");
Assert.AreEqual
(firstRecord, col.SelectQuery.FirstRecordToLoad,
"Collection query FirstRecordToLoad does not match expectation.");
Assert.AreEqual
(limit, col.SelectQuery.Limit, "Collection query limit does not match expectation.");
Assert.AreEqual(expectedCount, col.Count, "Collection size does not match expectation.");
}
public void Test_CollectionLoad_LoadWithLimit_WithSortCriteriaEmptyString_ShouldNotRaiseError_FixBug566()
{
ContactPersonTestBO.DeleteAllContactPeople();
const int totalRecords = 3;
const int firstRecord = 0;
const int limit = 2;
const int expectedCount = 2;
SetupDefaultContactPersonBO();
ContactPersonTestBO[] contactPersonTestBOs = CreateSavedSortedContactPeople(totalRecords);
IBusinessObjectCollection col = new BusinessObjectCollection<ContactPersonTestBO>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
int totalNoOfRecords;
col.LoadWithLimit("", "", firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
Assert.AreEqual
(totalRecords, totalNoOfRecords, "The returned total number of availabe records is incorrect");
Assert.AreEqual
(firstRecord, col.SelectQuery.FirstRecordToLoad,
"Collection query FirstRecordToLoad does not match expectation.");
Assert.AreEqual
(limit, col.SelectQuery.Limit, "Collection query limit does not match expectation.");
Assert.AreEqual(expectedCount, col.Count, "Collection size does not match expectation.");
}
public void Test_CollectionLoad_LoadWithLimit_WithSearchCriteriaNullString_ShouldNotRaiseError_FixBug565()
{
ContactPersonTestBO.DeleteAllContactPeople();
const int totalRecords = 3;
const int firstRecord = 0;
const int limit = 2;
const int expectedCount = 2;
SetupDefaultContactPersonBO();
ContactPersonTestBO[] contactPersonTestBOs = CreateSavedSortedContactPeople(totalRecords);
IBusinessObjectCollection col = new BusinessObjectCollection<ContactPersonTestBO>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
int totalNoOfRecords;
col.LoadWithLimit((string)null, "Surname", firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
AssertLimitedResultsCorrect
(firstRecord, limit, totalRecords, expectedCount, contactPersonTestBOs, col, totalNoOfRecords);
}
public void Test_CollectionLoad_LoadWithLimit_NoRecords2_StartRecord1_UsingWhereClause()
{
SetupDefaultContactPersonBO();
ContactPersonTestBO cp1 = ContactPersonTestBO.CreateSavedContactPerson("eeeee");
ContactPersonTestBO.CreateSavedContactPerson("gggggg");
ContactPersonTestBO.CreateSavedContactPerson("gggdfasd");
ContactPersonTestBO.CreateSavedContactPerson("bbbbbb");
ContactPersonTestBO.CreateSavedContactPerson("zazaza");
ContactPersonTestBO.CreateSavedContactPerson("zbbbbb");
ContactPersonTestBO.CreateSavedContactPerson("zccccc");
ContactPersonTestBO.CreateSavedContactPerson("zddddd");
BusinessObjectCollection<ContactPersonTestBO> col = new BusinessObjectCollection<ContactPersonTestBO>();
int totalNoOfRecords;
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
col.LoadWithLimit("Surname Not Like 'z%'", "Surname", 1, 2, out totalNoOfRecords);
//---------------Test Result -----------------------
Assert.AreEqual(1, col.SelectQuery.FirstRecordToLoad);
Assert.AreEqual(2, col.SelectQuery.Limit);
Assert.AreEqual(2, col.Count);
Assert.AreSame(cp1, col[0]);
}
public void Test_LoadWithLimit_LoadWithLimit_FirstAtEnd_LimitEqualsEnd()
{
const int totalRecords = 4;
const int firstRecord = totalRecords - 1;
const int limit = 1;
ContactPersonTestBO.LoadDefaultClassDef();
ContactPersonTestBO[] contactPersonTestBOs = CreateSavedSortedContactPeople(totalRecords);
IBusinessObjectCollection col = new BusinessObjectCollection<ContactPersonTestBO>();
//---------------Assert Precondition----------------
Assert.AreEqual(totalRecords, contactPersonTestBOs.Length);
//---------------Execute Test ----------------------
int totalNoOfRecords;
col.LoadWithLimit("", "Surname", firstRecord, limit, out totalNoOfRecords);
//---------------Test Result -----------------------
AssertLimitedResultsCorrect
(firstRecord, limit, totalRecords, limit, contactPersonTestBOs, col, totalNoOfRecords);
}
