Visual Studio 2010 Web service example

Yahoo Archive
1
Thank you soooooo much - I will give it a try.

You are the MAN!

DaveO

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Here's an example that should get you started. You'll have to add a reference to Epicor.Mfg.BO.Part and Epicor.Mfg.IF.IPart
>
>
> Public Class Form1
> Â Â Â Dim _partDS As PartListDataSet
>
> Â Â Â Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
> Â Â Â Â Â Â Â Using epiSession As New Session("manager", "manager", "AppServerDC://", Session.LicenseType.Default)
> Â Â Â Â Â Â Â Â Â Â Â Dim _part As New Part(epiSession.ConnectionPool)
> Â Â Â Â Â Â Â Â Â Â Â _partDS = _part.GetList("Company='100' AND TypeCode='M'", 0, 0, False)
>
> Â Â Â Â Â Â Â Â Â Â Â cboParts.ValueMember = "PartNum"
> Â Â Â Â Â Â Â Â Â Â Â cboParts.DataSource = _partDS.Tables(0)
> Â Â Â Â Â Â Â Â Â Â Â cboParts.DropDownStyle = ComboBoxStyle.DropDownList
> Â Â Â Â Â Â Â Â Â Â Â cboParts.DrawMode = DrawMode.OwnerDrawFixed
> Â Â Â Â Â Â Â End Using
> Â Â Â End Sub
>
> Â Â Â Private Sub cboParts_DrawItem(sender As Object, e As System.Windows.Forms.DrawItemEventArgs) Handles cboParts.DrawItem
> Â Â Â Â Â Â Â e.DrawBackground()
> Â Â Â Â Â Â Â If e.Index >= 0 Then
> Â Â Â Â Â Â Â Â Â Â Â Using Brush As Brush = New SolidBrush(e.ForeColor)
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â e.Graphics.DrawString(_partDS.Tables(0).Rows(e.Index)("PartNum").ToString(), e.Font, Brush, e.Bounds.Left + 1, e.Bounds.Top)
> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â e.Graphics.DrawString(_partDS.Tables(0).Rows(e.Index)("PartDescription").ToString(), e.Font, Brush, e.Bounds.Left + 50, e.Bounds.Top)
> Â Â Â Â Â Â Â Â Â Â Â End Using
> Â Â Â Â Â Â Â End If
> Â Â Â End Sub
>
> End Class
>
>
>
>
> ________________________________
> From: DaveO <daveolender@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, December 27, 2012 3:27 PM
> Subject: [Vantage] Re: Visual Studio 2010 Web service example
>
> I was thinking as a start (I'm a total newbie) a drop down list of manufactured parts. The drop down would show the part number and description and return just the part number.
>
> I was thinking of using the Epicor.Mfg.BO.Part as an external reference and I would guess the GetList method?
>
> Any suggestions,
>
> DaveO
>
> --- In vantage@yahoogroups.com, Ted Koch <tkoch77@> wrote:
> >
> > Dave,
> >
> > What are you trying to return a dataset of?
> >
> >
> >
> >
> > ________________________________
> >Â From: DaveO <daveolender@>
> > To: vantage@yahoogroups.com
> > Sent: Thursday, December 27, 2012 12:54 PM
> > Subject: [Vantage] Re: Visual Studio 2010 Web service example
> >Â
> > Thank you Mr. Mark: I found your example in the files section. I modified the Close() call to Dispose() and it compiled and appears to login. Thank you so much. - This does look easier.
> >
> > Now I just need to figure out how to work with, return data sets.
> >
> > Thanks again,
> >
> > DaveO
> >
> > --- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@> wrote:
> > >
> > > Hi Dave,
> > >
> > > If you're writing programs that communicate directly with Epicor is VS,
> > > skip the web services and use the business objects directly. It's much
> > > faster. There are example programs in the Files section of the newsgroup.
> > >
> > > Mark W
> > >
> > > On Monday, December 24, 2012, DaveO wrote:
> > >
> > > > **
> > > >
> > > >
> > > > I have been trying to setup my Visual Studio to experiment using web
> > > > services to connect to the Epicor DB and I am running into a number or
> > > > technical stumbling blocks.
> > > >
> > > > I am NOT a programmer, but I have done a fair amount of VBA and ASP
> > > > programming.
> > > >
> > > > For instance, The developer example in the web services folder directs me
> > > > to "change the base class that the proxy inherits from" however I am unable
> > > > to find the Proxy Class they are referencing.
> > > >
> > > > Just wondering if anyone has a VS 2010 small project they would be willing
> > > > to share that I could use as a guide to using Web Services?
> > > >
> > > > Thank you for any help you can offer me,
> > > >
> > > > Dave Olender
> > > >
> > > >Â
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
2
I have been trying to setup my Visual Studio to experiment using web services to connect to the Epicor DB and I am running into a number or technical stumbling blocks.

I am NOT a programmer, but I have done a fair amount of VBA and ASP programming.

For instance, The developer example in the web services folder directs me to "change the base class that the proxy inherits from" however I am unable to find the Proxy Class they are referencing.

Just wondering if anyone has a VS 2010 small project they would be willing to share that I could use as a guide to using Web Services?

Thank you for any help you can offer me,

Dave Olender
3
Hi Dave,

If you're writing programs that communicate directly with Epicor is VS,
skip the web services and use the business objects directly. It's much
faster. There are example programs in the Files section of the newsgroup.

Mark W

On Monday, December 24, 2012, DaveO wrote:

> **
>
>
> I have been trying to setup my Visual Studio to experiment using web
> services to connect to the Epicor DB and I am running into a number or
> technical stumbling blocks.
>
> I am NOT a programmer, but I have done a fair amount of VBA and ASP
> programming.
>
> For instance, The developer example in the web services folder directs me
> to "change the base class that the proxy inherits from" however I am unable
> to find the Proxy Class they are referencing.
>
> Just wondering if anyone has a VS 2010 small project they would be willing
> to share that I could use as a guide to using Web Services?
>
> Thank you for any help you can offer me,
>
> Dave Olender
>
>
>


[Non-text portions of this message have been removed]
4
Thank you Mr. Mark: I found your example in the files section. I modified the Close() call to Dispose() and it compiled and appears to login. Thank you so much. - This does look easier.

Now I just need to figure out how to work with, return data sets.

Thanks again,

DaveO

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> Hi Dave,
>
> If you're writing programs that communicate directly with Epicor is VS,
> skip the web services and use the business objects directly. It's much
> faster. There are example programs in the Files section of the newsgroup.
>
> Mark W
>
> On Monday, December 24, 2012, DaveO wrote:
>
> > **
> >
> >
> > I have been trying to setup my Visual Studio to experiment using web
> > services to connect to the Epicor DB and I am running into a number or
> > technical stumbling blocks.
> >
> > I am NOT a programmer, but I have done a fair amount of VBA and ASP
> > programming.
> >
> > For instance, The developer example in the web services folder directs me
> > to "change the base class that the proxy inherits from" however I am unable
> > to find the Proxy Class they are referencing.
> >
> > Just wondering if anyone has a VS 2010 small project they would be willing
> > to share that I could use as a guide to using Web Services?
> >
> > Thank you for any help you can offer me,
> >
> > Dave Olender
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
5
Tracing is your friend! Also, search the newsgroup for data set access.
There are a lot of examples. Also see sites like
http://usdoing<http://usdoingthings.com>
stuff.com or http://epicor-dev.blogspot.com<http://epicor-dev.blogspot.com/?m=1>

Mark W.

On Thursday, December 27, 2012, DaveO wrote:

> **
>
>
> Thank you Mr. Mark: I found your example in the files section. I modified
> the Close() call to Dispose() and it compiled and appears to login. Thank
> you so much. - This does look easier.
>
> Now I just need to figure out how to work with, return data sets.
>
> Thanks again,
>
> DaveO
>
> --- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
> >
> > Hi Dave,
> >
> > If you're writing programs that communicate directly with Epicor is VS,
> > skip the web services and use the business objects directly. It's much
> > faster. There are example programs in the Files section of the newsgroup.
> >
> > Mark W
> >
> > On Monday, December 24, 2012, DaveO wrote:
> >
> > > **
> > >
> > >
> > > I have been trying to setup my Visual Studio to experiment using web
> > > services to connect to the Epicor DB and I am running into a number or
> > > technical stumbling blocks.
> > >
> > > I am NOT a programmer, but I have done a fair amount of VBA and ASP
> > > programming.
> > >
> > > For instance, The developer example in the web services folder directs
> me
> > > to "change the base class that the proxy inherits from" however I am
> unable
> > > to find the Proxy Class they are referencing.
> > >
> > > Just wondering if anyone has a VS 2010 small project they would be
> willing
> > > to share that I could use as a guide to using Web Services?
> > >
> > > Thank you for any help you can offer me,
> > >
> > > Dave Olender
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
6
Dave,

What are you trying to return a dataset of?




________________________________
From: DaveO <daveolender@...>
To: vantage@yahoogroups.com
Sent: Thursday, December 27, 2012 12:54 PM
Subject: [Vantage] Re: Visual Studio 2010 Web service example

Thank you Mr. Mark: I found your example in the files section. I modified the Close() call to Dispose() and it compiled and appears to login. Thank you so much. - This does look easier.

Now I just need to figure out how to work with, return data sets.

Thanks again,

DaveO

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> Hi Dave,
>
> If you're writing programs that communicate directly with Epicor is VS,
> skip the web services and use the business objects directly. It's much
> faster. There are example programs in the Files section of the newsgroup.
>
> Mark W
>
> On Monday, December 24, 2012, DaveO wrote:
>
> > **
> >
> >
> > I have been trying to setup my Visual Studio to experiment using web
> > services to connect to the Epicor DB and I am running into a number or
> > technical stumbling blocks.
> >
> > I am NOT a programmer, but I have done a fair amount of VBA and ASP
> > programming.
> >
> > For instance, The developer example in the web services folder directs me
> > to "change the base class that the proxy inherits from" however I am unable
> > to find the Proxy Class they are referencing.
> >
> > Just wondering if anyone has a VS 2010 small project they would be willing
> > to share that I could use as a guide to using Web Services?
> >
> > Thank you for any help you can offer me,
> >
> > Dave Olender
> >
> >Â
> >
>
>
> [Non-text portions of this message have been removed]
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
7
I was thinking as a start (I'm a total newbie) a drop down list of manufactured parts. The drop down would show the part number and description and return just the part number.

I was thinking of using the Epicor.Mfg.BO.Part as an external reference and I would guess the GetList method?

Any suggestions,

DaveO

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Dave,
>
> What are you trying to return a dataset of?
>
>
>
>
> ________________________________
> From: DaveO <daveolender@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, December 27, 2012 12:54 PM
> Subject: [Vantage] Re: Visual Studio 2010 Web service example
>
> Thank you Mr. Mark: I found your example in the files section. I modified the Close() call to Dispose() and it compiled and appears to login. Thank you so much. - This does look easier.
>
> Now I just need to figure out how to work with, return data sets.
>
> Thanks again,
>
> DaveO
>
> --- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@> wrote:
> >
> > Hi Dave,
> >
> > If you're writing programs that communicate directly with Epicor is VS,
> > skip the web services and use the business objects directly. It's much
> > faster. There are example programs in the Files section of the newsgroup.
> >
> > Mark W
> >
> > On Monday, December 24, 2012, DaveO wrote:
> >
> > > **
> > >
> > >
> > > I have been trying to setup my Visual Studio to experiment using web
> > > services to connect to the Epicor DB and I am running into a number or
> > > technical stumbling blocks.
> > >
> > > I am NOT a programmer, but I have done a fair amount of VBA and ASP
> > > programming.
> > >
> > > For instance, The developer example in the web services folder directs me
> > > to "change the base class that the proxy inherits from" however I am unable
> > > to find the Proxy Class they are referencing.
> > >
> > > Just wondering if anyone has a VS 2010 small project they would be willing
> > > to share that I could use as a guide to using Web Services?
> > >
> > > Thank you for any help you can offer me,
> > >
> > > Dave Olender
> > >
> > >Â
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
8
Here's an example that should get you started. You'll have to add a reference to Epicor.Mfg.BO.Part and Epicor.Mfg.IF.IPart


Public Class Form1
   Dim _partDS As PartListDataSet

   Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
       Using epiSession As New Session("manager", "manager", "AppServerDC://", Session.LicenseType.Default)
           Dim _part As New Part(epiSession.ConnectionPool)
           _partDS = _part.GetList("Company='100' AND TypeCode='M'", 0, 0, False)

           cboParts.ValueMember = "PartNum"
           cboParts.DataSource = _partDS.Tables(0)
           cboParts.DropDownStyle = ComboBoxStyle.DropDownList
           cboParts.DrawMode = DrawMode.OwnerDrawFixed
       End Using
   End Sub

   Private Sub cboParts_DrawItem(sender As Object, e As System.Windows.Forms.DrawItemEventArgs) Handles cboParts.DrawItem
       e.DrawBackground()
       If e.Index >= 0 Then
           Using Brush As Brush = New SolidBrush(e.ForeColor)
               e.Graphics.DrawString(_partDS.Tables(0).Rows(e.Index)("PartNum").ToString(), e.Font, Brush, e.Bounds.Left + 1, e.Bounds.Top)
               e.Graphics.DrawString(_partDS.Tables(0).Rows(e.Index)("PartDescription").ToString(), e.Font, Brush, e.Bounds.Left + 50, e.Bounds.Top)
           End Using
       End If
   End Sub

End Class




________________________________
From: DaveO <daveolender@...>
To: vantage@yahoogroups.com
Sent: Thursday, December 27, 2012 3:27 PM
Subject: [Vantage] Re: Visual Studio 2010 Web service example

I was thinking as a start (I'm a total newbie) a drop down list of manufactured parts. The drop down would show the part number and description and return just the part number.

I was thinking of using the Epicor.Mfg.BO.Part as an external reference and I would guess the GetList method?

Any suggestions,

DaveO

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Dave,
>
> What are you trying to return a dataset of?
>
>
>
>
> ________________________________
>Â From: DaveO <daveolender@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, December 27, 2012 12:54 PM
> Subject: [Vantage] Re: Visual Studio 2010 Web service example
>Â
> Thank you Mr. Mark: I found your example in the files section. I modified the Close() call to Dispose() and it compiled and appears to login. Thank you so much. - This does look easier.
>
> Now I just need to figure out how to work with, return data sets.
>
> Thanks again,
>
> DaveO
>
> --- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@> wrote:
> >
> > Hi Dave,
> >
> > If you're writing programs that communicate directly with Epicor is VS,
> > skip the web services and use the business objects directly. It's much
> > faster. There are example programs in the Files section of the newsgroup.
> >
> > Mark W
> >
> > On Monday, December 24, 2012, DaveO wrote:
> >
> > > **
> > >
> > >
> > > I have been trying to setup my Visual Studio to experiment using web
> > > services to connect to the Epicor DB and I am running into a number or
> > > technical stumbling blocks.
> > >
> > > I am NOT a programmer, but I have done a fair amount of VBA and ASP
> > > programming.
> > >
> > > For instance, The developer example in the web services folder directs me
> > > to "change the base class that the proxy inherits from" however I am unable
> > > to find the Proxy Class they are referencing.
> > >
> > > Just wondering if anyone has a VS 2010 small project they would be willing
> > > to share that I could use as a guide to using Web Services?
> > >
> > > Thank you for any help you can offer me,
> > >
> > > Dave Olender
> > >
> > >Â
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]