public void GetItems_WhenRequestSimpleSelect_ReturnExpectedValues()
{
var select = QueryBuilderUtilities.BuildSelectQuery("AccountType");
QueryBuilderUtilities.AddColumn(select, "Id");
QueryBuilderUtilities.AddColumn(select, "Name");
MockExecutePostRequest(
JsonConvert.SerializeObject(select),
"{\"rowConfig\":{\"Id\":{\"dataValueType\":0},\"Name\":{\"dataValueType\":1}},\"rows\":[{\"Id\":\"f2c0ce97-53e6-df11-971b-001d60e938c6\",\"Name\":\"Партнер\"},{\"Id\":\"57412fad-53e6-df11-971b-001d60e938c6\",\"Name\":\"Наша компания\"},{\"Id\":\"2b6b75b6-d794-47bf-b5df-31dd95aa012d\",\"Name\":\"Клиент\"},{\"Id\":\"47100649-74e0-44e9-a9ae-36004b8d03be\",\"Name\":\"Не определен\"},{\"Id\":\"ea99196c-bbe1-4f2b-951e-49c57425efb5\",\"Name\":\"Конкурент\"},{\"Id\":\"1165192e-e578-40bb-b7f9-569e6a3a7745\",\"Name\":\"Потенциальный партнер\"},{\"Id\":\"1f01baf0-64f4-443d-9e16-71ab53ccc1e6\",\"Name\":\"СМИ\"},{\"Id\":\"2dd4ed36-d652-4b10-a7fd-8ed853361785\",\"Name\":\"Поставщик\"},{\"Id\":\"be4dc5a1-88c7-493f-8c40-b70fd769a745\",\"Name\":\"Инвестор\"}],\"notFoundColumns\":[],\"rowsAffected\":9,\"nextPrcElReady\":false,\"success\":true}"
);
var response = _remoteDataProvider.GetItems(select);
Assert.IsTrue(response.Success);
Assert.AreEqual(9, response.Items.Count);
Assert.IsTrue(response.Items.All(x => (Guid)x["Id"] != Guid.Empty));
Assert.IsTrue(response.Items.All(x => !string.IsNullOrEmpty(x["Name"].ToString())));
Assert.IsTrue(response.Items.All(x => x.Count == 2));
}
public void GetItems_WhenRequestWithNotEqualFilterFilter_ReturnExpectedValues2()
{
var selectQuery = QueryBuilderUtilities.BuildSelectQuery("Contact", 10, 5);
QueryBuilderUtilities.AddColumn(selectQuery, "Id");
QueryBuilderUtilities.AddColumn(selectQuery, "Name");
selectQuery.Filters.Items.Add("f1", QueryBuilderUtilities.CreateComparisonFilter("Id", FilterComparisonType.Equal, DataValueType.Guid, "410006e1-ca4e-4502-a9ec-e54d922d2c00"));
selectQuery.Filters.Items.Add("f2", QueryBuilderUtilities.CreateComparisonFilter("Name", FilterComparisonType.NotEqual, DataValueType.Text, "WrongName"));
MockExecutePostRequest(JsonConvert.SerializeObject(selectQuery),
"{\"rowConfig\":{\"Id\":{\"dataValueType\":0},\"Name\":{\"dataValueType\":1},\"Photo\":{\"dataValueType\":16,\"isLookup\":true,\"referenceSchemaName\":\"SysImage\"}},\"rows\":[{\"Id\":\"410006e1-ca4e-4502-a9ec-e54d922d2c00\",\"Name\":\"Supervisor\",\"Photo\":\"\"}],\"notFoundColumns\":[],\"rowsAffected\":1,\"nextPrcElReady\":false,\"success\":true}"
);
var response = _realRemoteDataProvider.GetItems(selectQuery);
Assert.IsTrue(response.Success);
Assert.AreEqual(1, response.Items.Count);
Assert.AreEqual(new Guid("410006e1-ca4e-4502-a9ec-e54d922d2c00"), response.Items.First()["Id"]);
Assert.AreEqual("Supervisor", response.Items.First()["Name"]);
Assert.AreEqual(2, response.Items.First().Count);
}
