Look up and passing ranges in enterprise portal

protected void PriorApp_LookUp(object sender, AxLookupEventArgs e)
{
string Employee;
// AxBoundField boundField = (AxBoundField)sender;

AxLookup lookup = e.LookupControl;
using (Proxy.SysDataSetBuilder sysDataSetBuilder = Proxy.SysDataSetBuilder.constructLookupDataSet(this.AxSession.AxaptaAdapter, TableMetadata.TableNum(this.AxSession, "TrvExpTable")))
{
// Set the run time generated data set as the lookup data set
lookup.LookupDataSet = new Microsoft.Dynamics.Framework.Data.Ax.DataSet(this.AxSession, sysDataSetBuilder.toDataSet());
}


Employee = ApplicationProxy.TrvExpTable.EmployeeEP(this.AxSession.AxaptaAdapter, this.ExpNumber);
// Filter the lookup to only display acceptable account types
using (Proxy.Query query = lookup.LookupDataSet.DataSetViews[0].MasterDataSource.query())
{
// query.dataSourceNo(1).addRange(TableDataFieldMetadata.FieldNum(this.AxSession, "TrvExptable", "txt2")).value = Label_Purpose.Text;
query.dataSourceNo(1).addRange(TableDataFieldMetadata.FieldNum(this.AxSession, "TrvExptable", "Employee")).value = Employee;
query.dataSourceNo(1).addRange(TableDataFieldMetadata.FieldNum(this.AxSession, "TrvExptable", "asu_TypeOfRequest")).value = "1";
query.dataSourceNo(1).addRange(TableDataFieldMetadata.FieldNum(this.AxSession, "TrvExptable", "ApprovalStatus")).value = "3";
}
}

Comments

Post a Comment

Popular posts from this blog

Running runnable class through URL in Dynamics 365 for Operations

Hi Everyone , There are multiple ways you can run Runnable class. One way is we can attach it to Menu item and add it to any form and execute it using menu item. Another way is set it up you project as startup object and runnable class as startup object in Visual Studio and run it from Visual studio. Another way of running it is from your browser (IE/Chrome). https:// URL> /?cmp= &mi=SysClassRunner&cls= Parameters: Cmp = Your company name e.g USMF Cls = Your Runnable class name e.g. ShowInvoicedOrderCount https://usnconeboxax1aos.cloud.onebox.dynamics.com/?cmp=USMF&mi=SysClassRunner&cls=ShowInvoicedOrderCount Whenever you want to quickly verify anything this way is very useful and you don’t have to spent time seeing while visual studio opens diagnostic tool and load other windows.
Read more

D365FO Use of FileUpload control to Read CSV file

Image
In Dynamics Ax implementation very often we get requirement to upload data using csv files. Although  in Dynamics 365 for operations it can be easily done using data entities and data packages, in this blog we will see how can we use new FileUpload control and design classes to read, download files. In   Dynamics 365 for operations  application runs on cloud and the client is in web , so Microsoft has introduce new process to read files using Azure blob. When we upload file, that file gets uploaded to Azure blob and we have to read that file from Azure blob to retrieve data. Design classes: There are two main types of classes that developers can work with for the file upload control: Upload strategy class  – This class lets developers control various parameters that should be enforced for uploaded files, such as the types of files that a user can upload and the maximum size of a file. It also lets developers determine where and how ...
Read more

Customizing D365 with event handlers

With Dynamics 365 release we have to do most of the things using extensions and event handlers. You still have an option to over layer code. While creating new package if you choose select existing packages and modified any standard object which belongs to that package, you are doing overlaying.  In previous versions it was not a big  issue but with new release we should stop doing that and instead embrace a practice of doing customizations using extensions and event handlers. Source code and metadata of model elements can be extended without an over-layering using extensions. Today I will share some code snippets about how to  do few things while using event handlers How to get Form Datasource If you copy form event handler here is how you can get form datasource from XFormRun [FormEventHandler(formStr(HcmPosition), FormEventType::Initialized)] public static void HcmPosition_OnInitialized(xFormRun sender, FormEventArgs e) { FormDataSo...
Read more