public async Task TestFindWildcard()
{
Login();
fms.SetLayout("FRUIT_utility");
var find = fms.FindRequest();
var request = find.SearchCriterium();
request.AddFieldSearch("country", "*");
var getFindResponse = await find.Execute();
Logout();
// default search with no other criteria returns 100 records
Assert.True(getFindResponse.ErrorCode == 0 && getFindResponse.returnedRecordCount == 100);
}
private async Task PopulateData(int itemRecordId, int productRecordId)
{
var productPortalAndRecordId = await GetProductGraphicsPortalAndRecordID(Convert.ToInt32(productRecordId)); //getting portal data
var graphicsPortalData = productPortalAndRecordId.GraphicsPortalData;
var productRecordID = productPortalAndRecordId.RecordID;
fmServer.SetLayout(itemLayout);
var getItemBySearchFields = fmServer.FindRequest();
var searchFields = getItemBySearchFields.SearchCriterium();
searchFields.AddFieldSearch("specs_PRODUCTS::RecordID", productRecordID); // to apply search for 9 images, had to apply searchFields
searchFields.AddFieldSearch("ProjectRecordID", projectRecordId);
getItemBySearchFields.AddPortal("Spec_to_Graphics", 9);
RecordsGetResponse getItemSearchFieldsResponse = await getItemBySearchFields.Execute();
var itemGraphicsPortalData = getItemSearchFieldsResponse.data.foundSet.records.First().relatedRecordSets.First().records;
var itemDetails = getItemSearchFieldsResponse.data.foundSet.records.First().fieldsAndData;
lblItemNumber.Text = itemDetails["ItemNumber"];
lblItemName.Text = itemDetails["ItemName"];
for (int i = 0; i < 9; i++) // this loop displays images, set ids to be able to create and edit a image on button click
{
var currentButton = GetCurrentButton(i);
if (i < itemGraphicsPortalData.Count())
{
try
{
var currentRow = itemGraphicsPortalData.ElementAt(i);
fmServer.SetLayout(graphicLayout);
var graphicImageId = currentRow.fieldsAndData["GraphicImage_ID"];
var getGraphicRequest = fmServer.FindRequest();
searchFields = getGraphicRequest.SearchCriterium();
searchFields.AddFieldSearch("ImageRecordID", graphicImageId);
var getGraphicResponse = await getGraphicRequest.Execute();
var graphicRecordId = getGraphicResponse.data.foundSet.records.First().recordId;
var file = getGraphicResponse.data.foundSet.records.First().fieldsAndData["File"];
WebClient client = new WebClient();
byte[] bytes = client.DownloadData(file);
MemoryStream ms = new MemoryStream(bytes);
currentButton.Tag = $"{graphicRecordId}, {productRecordId}"; // sets tag to be used later to edit,create image
currentButton.BackgroundImage = Image.FromStream(ms);
currentButton.BackgroundImageLayout = ImageLayout.Stretch;
}
catch (Exception ex)
{
currentButton.Tag = $", {productRecordId}";
currentButton.BackgroundImage = ResizedSelectImage();
MessageBox.Show($"Error: {ex.Message}");
}
}
else
{
currentButton.Tag = $", {productRecordId}";
currentButton.BackgroundImage = ResizedSelectImage();
}
}
}