Shalabh Jain - Thursday, October 31, 2013 1:05 AM:
Dear All,
I am having one Windows GUI Application which is written in C# and using SQL database with mulitple table and Store Procedures for maintaining the data.
I want to merge my Application in ARAS System by reusing the maximum part of this application.
Could anybody help me to do the same?
Detailed and quick explanation will be highly appreciated.
Thanks and Regards,
Shalabh Jain
PeterSchroer - Thursday, October 31, 2013 4:25 AM:
Not knowing the details of your application, it is difficult to advise you. But in general, for each of your existing Tables, create an ItemType. Your C# code will be moved into Server Methods, and the stored procedures become SQL Items. In this way your entire application has been mapped into Aras Innovator, and it is easy to manage (meaning package, share with friends, upgrade).
Your windows GUI can still be used of course, but you are changing the data access functions under the user interface. Today, I can imagine that the C# in the Windows Application is directly accessing SQL tables. You will convert this to web services requests to the Innnovator Server. With a little bit of clever planning, you will retain the Windows Application, and you will also get a standard browser interface. In this approach, the server can now be on-site or in the Cloud, and your end-users will have the same functionality either way.
Good Luck!
--peter.
Shalabh Jain - Friday, November 1, 2013 1:43 AM:
Dear Peter,
Thanks a lot for your valuable reply.
I unterstood the ARAS system flow explained by you like mentioned below:
Webpage > Clientside Method > ServerSide Method > SQL Item > SQL Database Table
I am not clear about "ServerSide Method > SQL Item" communication; how to call SQL Item (Store Procedure) from ServerSide Method.
Could you please share some example for calling Store Procedure in ARAS Sysyem.
Thanks and Regards,
Shalabh Jain
