public void Insert() { Axapta ax; AxaptaRecord axRecord; try { ax = new Axapta(); ax.Logon(null, null, null, null); using (axRecord = ax.CreateAxaptaRecord(TABLE_NAME)) { ax.TTSBegin(); axRecord.Call("ESS_WriteValues", this.LeaveApplicationType, this.EmplId, this.RequestedBy, this.ScheduledLeaveDate, this.ScheduledReturnDate, this.ApprovalStatus, this.ExitVisaType, this.Comments, this.CommentsApproval); axRecord.Insert(); ax.TTSCommit(); } } catch (Exception e) { Console.WriteLine(e.Message); throw; } }
static void Main(string[] args) { Axapta Ax = new Axapta(); Ax.Logon(null, null, null, null); string className = "ZFS_TestXML"; string methodName = "getResultTable"; string paramList = null; AxaptaObject axObj = Ax.CreateAxaptaObject(className); AxaptaRecord ret = null; if (paramList != null) { ret = (AxaptaRecord)axObj.Call(methodName, paramList); } else { ret = (AxaptaRecord)axObj.Call(methodName); } while (ret.Found) { ret.get_Field(2); } axObj.Dispose(); }
public void Update() { Axapta ax; AxaptaRecord axRecord; try { ax = new Axapta(); ax.Logon(null, null, null, null); using (axRecord = ax.CreateAxaptaRecord(TABLE_NAME)) { string sql = string.Format("select forupdate * from %1 where %1.{0} == '{1}'", APPLICATION_ID, this.ApplicationId); axRecord.ExecuteStmt(sql); if (axRecord.Found) { ax.TTSBegin(); axRecord.set_Field(LEAVE_APP_TYPE, this.LeaveApplicationType); axRecord.set_Field(SCH_LEAVE_DATE, this.ScheduledLeaveDate); axRecord.set_Field(SCH_RETURN_DATE, this.ScheduledReturnDate); axRecord.set_Field(APPROVAL_STATUS, this.ApprovalStatus); axRecord.set_Field(EXIT_VISA_TYPE, this.ExitVisaType); axRecord.set_Field(COMMENTS, this.Comments); axRecord.set_Field(COMMENTS_APPROVAL, this.CommentsApproval); axRecord.Update(); ax.TTSCommit(); } } } catch (Exception e) { Console.WriteLine(e.Message); throw; } }
static void Main(string[] args) { // Create the .NET Business Connector objects. Axapta ax; AxaptaRecord axRecord; string tableName = "LabX_ResultTable"; // The Table field names for calls to // the AxRecord.get_field method. string strSampleField = "SampleID"; string strDescriptionField = "Description"; // The output variables for calls to the // AxRecord.get_Field method. object fieldSampleId, fieldDescription; try { // Login to Microsoft Dynamics AX. ax = new Axapta(); ax.Logon(null, null, null, null); // Create a query using the AxaptaRecord class // for the StateAddress table. using (axRecord = ax.CreateAxaptaRecord(tableName)) { // Execute the query on the table. axRecord.ExecuteStmt("select * from %1"); // Create output with a title and column headings // for the returned records. Console.WriteLine("List of selected records from {0}", tableName); Console.WriteLine("{0}\t{1}", strSampleField, strDescriptionField); // Loop through the set of retrieved records. while (axRecord.Found) { // Retrieve the record data for the specified fields. fieldSampleId = axRecord.get_Field(strSampleField); fieldDescription = axRecord.get_Field(strDescriptionField); // Display the retrieved data. Console.WriteLine(fieldSampleId + "\t" + fieldDescription); // Advance to the next row. axRecord.Next(); } } } catch (Exception e) { Console.WriteLine("Error encountered: {0}", e.Message); // Take other error action as needed. } Console.Read(); }
public static List <LeaveApp> GetLeaveApps() { var leaveApps = new List <LeaveApp>(); Axapta ax; AxaptaRecord axRecord; try { // Login to Microsoft Dynamics AX. ax = new Axapta(); ax.Logon(null, null, null, null); // Create a query using the AxaptaRecord class using (axRecord = ax.CreateAxaptaRecord(TABLE_NAME)) { // Execute the query on the table. axRecord.ExecuteStmt("select * from %1 "); while (axRecord.Found) { var leaveApp = new LeaveApp() { ApplicationId = axRecord.get_Field(APPLICATION_ID).ToString(), CreatedDateTime = (DateTime)axRecord.get_Field(CREATE_DATETIME), LeaveApplicationType = axRecord.get_Field(LEAVE_APP_TYPE).ToString(), DefaultLeaveCode = axRecord.get_Field(LEAVE_CODE).ToString(), EmplId = axRecord.get_Field(EMPLOYEE_ID).ToString(), RequestedBy = (long)axRecord.get_Field(REQUESTED_BY), ScheduledLeaveDate = (DateTime)axRecord.get_Field(SCH_LEAVE_DATE), ScheduledReturnDate = (DateTime)axRecord.get_Field(SCH_RETURN_DATE), Days = (int)axRecord.get_Field(DAYS), ApprovalStatus = axRecord.get_Field(APPROVAL_STATUS).ToString(), ExitVisaType = axRecord.get_Field(EXIT_VISA_TYPE).ToString(), Comments = axRecord.get_Field(COMMENTS).ToString(), CommentsApproval = axRecord.get_Field(COMMENTS_APPROVAL).ToString() }; leaveApps.Add(leaveApp); axRecord.Next(); } return(leaveApps); } } catch (Exception ex) { Console.WriteLine("Error encountered: {0}", ex.Message); throw; } }
static void Main(string[] args) { // Create the .NET Business Connector objects. Axapta ax; string sID = "@SYS21669"; object o; bool b; try { // Login to Microsoft Dynamics Ax. ax = new Axapta(); ax.Logon(null, null, null, null); } catch (Exception e) { Console.WriteLine("An error occurred in object creation or Axapta logon: {0}", e.Message); return; } // Logon was successful. try { // Call a static class method. // In this example, call SysLabel::labelId2String2 // to determine the label string for a particular label ID. o = ax.CallStaticClassMethod("SysLabel", "labelId2String2", sID); } catch (Exception e) { Console.WriteLine("An error has been encountered during CallStaticClassMethod: {0}", e.Message); b = ax.Logoff(); return; } // Display the returned string. Console.WriteLine("The label string for {0} is {1}.", sID, o.ToString()); // Log off from Microsoft Dynamics AX. b = ax.Logoff(); }
public static Employee GetEmployee(string personnelNumber) { Axapta ax; AxaptaRecord axRecord; try { // Login to Microsoft Dynamics AX. ax = new Axapta(); ax.Logon(null, null, null, null); // Create a query using the AxaptaRecord class // for the StateAddress table. using (axRecord = ax.CreateAxaptaRecord(TABLE_NAME)) { // Execute the query on the table. axRecord.ExecuteStmt(string.Format("select * from %1 where %1.PersonnelNumber == '{0}'", personnelNumber)); if (axRecord.Found) { var emp = new Employee() { PersonnelNumber = axRecord.get_Field(PERSONNEL_NUMBER).ToString(), Worker = (long)axRecord.get_Field(WORKER), EmplCompany = axRecord.Company, Name = axRecord.Call("name").ToString() }; return(emp); } else { return(null); } } } catch (Exception ex) { Console.WriteLine("Error encountered: {0}", ex.Message); return(null); } }
} // AX Company for create Employee Leaves #endregion #region Methods public static List <Employee> GetEmployees(string _supervisor = "") { var employees = new List <Employee>(); Axapta ax; AxaptaRecord axRecord; try { // Login to Microsoft Dynamics AX. ax = new Axapta(); ax.Logon(null, null, null, null); // Create a query using the AxaptaRecord class // for the StateAddress table. using (axRecord = ax.CreateAxaptaRecord(TABLE_NAME)) { // Execute the query on the table. axRecord.ExecuteStmt("select * from %1 "); while (axRecord.Found) { var emp = new Employee() { PersonnelNumber = axRecord.get_Field(PERSONNEL_NUMBER).ToString(), Worker = (long)axRecord.get_Field(WORKER), EmplCompany = axRecord.Company, Name = axRecord.Call("name").ToString() }; employees.Add(emp); axRecord.Next(); } return(employees); } } catch (Exception ex) { Console.WriteLine("Error encountered: {0}", ex.Message); throw; } }
static void Main(string[] args) { Axapta Ax = new Axapta(); Ax.Logon(null, null, null, null); string className = "ZFS_TestXML"; string methodName = "getResultTable"; string paramList = null; AxaptaObject axObj = Ax.CreateAxaptaObject(className); AxaptaRecord ret = null; if (paramList != null) ret = (AxaptaRecord)axObj.Call(methodName, paramList); else ret = (AxaptaRecord)axObj.Call(methodName); while (ret.Found) { ret.get_Field(2); } axObj.Dispose(); }