DevForce Community Forum : how to do serverside logic using a stored proc.

DevForce Community Forum : how to do serverside logic using a stored proc. http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : how to do serverside logic using a stored proc. Sat, 18 May 2013 14:53:53 -700 Fri, 29 Jun 2007 09:07:00 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=99 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ how to do serverside logic using a stored proc. : Thanks you for a quick reply :-) Dominique... http://www.ideablade.com/forum/forum_posts.asp?TID=99&PID=219#219 Author: Dominique
Subject: 99
Posted: 29-Jun-2007 at 9:07am

Thanks you for a quick reply :-)

Dominique]]> Fri, 29 Jun 2007 09:07:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=99&PID=219#219 how to do serverside logic using a stored proc. : Dominique, This seems like... http://www.ideablade.com/forum/forum_posts.asp?TID=99&PID=217#217 Author: davidklitzke
Subject: 99
Posted: 29-Jun-2007 at 8:55am

Dominique,

This seems like an ideal opportunity to use RPC. RPC allows you to have any type of return object (e.g., void, string, array), not just a list of Business Objects.

You can find this information (I agree it's sparse and hard to find) in Reference Help under ServerRpcDelegate Delegate

Here is an email example:

C#
// Sample showing invocation of server method PersistenceManager pm = PersistenceManager.DefaultManager; int orderId = 10250; bool mailSent = (bool) pm.InvokeServerMethod(Order.EmailOrderInfo, orderId); // sample method defined in Order class public class Order : OrderDataRow { //... // ServerRpcDelegate method, called from client [AllowRpc] public static Object EmailOrderInfo(IPrincipal pPrincipal, DataSourceResolver pResolver, params Object[] pArgs) { int orderId = Convert.ToInt32(pArgs[0]); // build and send an email message string from = "sales@mycompany.com"; string to = "customer@yourcompany.com"; System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(from, to); msg.Subject = "Order Information"; msg.Body = string.Format("Order id = {0} has been shipped", orderId); System.Net.Mail.SmtpClient mailClient = new System.Net.Mail.SmtpClient("localhost"); try { mailClient.Send(msg); } catch (Exception e) { TraceFns.WriteLine(e.Message); return false; } return true; } }

// Sample showing invocation of server method 
PersistenceManager pm = PersistenceManager.DefaultManager; 
int orderId = 10250; 
bool mailSent = (bool) pm.InvokeServerMethod(Order.EmailOrderInfo, orderId); 
 
// sample method defined in Order class 
public class Order : OrderDataRow { 
//... 
  // ServerRpcDelegate method, called from client 
  [AllowRpc] 
  public static Object EmailOrderInfo(IPrincipal pPrincipal, DataSourceResolver pResolver, params Object[] pArgs) { 
    int orderId = Convert.ToInt32(pArgs[0]); 
 
    // build and send an email message  
    string from = "sales@mycompany.com"; 
    string to = "customer@yourcompany.com"; 
    System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(from, to); 
    msg.Subject = "Order Information"; 
    msg.Body = string.Format("Order id = {0} has been shipped", orderId); 
 
    System.Net.Mail.SmtpClient mailClient = new System.Net.Mail.SmtpClient("localhost"); 
    try { 
      mailClient.Send(msg); 
    } catch (Exception e) { 
      TraceFns.WriteLine(e.Message); 
      return false; 
    } 
    return true; 
 } 
}

]]> Fri, 29 Jun 2007 08:55:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=99&PID=217#217 how to do serverside logic using a stored proc. : Hi, From my client applications(smart... http://www.ideablade.com/forum/forum_posts.asp?TID=99&PID=216#216 Author: Dominique
Subject: 99
Posted: 29-Jun-2007 at 8:14am

Hi,

From my client applications(smart client) I need to fetch serienumbers from a serie hold in a database table.
I use a stored procedure to pull out the right number and do the updates to the series. I want to have extra logic on the server like sending an email to our support if the remaining numbers goes under a limit.

Ideally I would like to call from my client a function like:
GetserieNumber (serieType, quantity) as ResponseObject
ResponseObject being a structure with for example
.serietype
.quantity_asked as int32
.firstSerieNumber as Integer?
.IsOk as boolean
.message as string

the minimum would be to get back an integer or "nothing" (dbnull or vb nothing)
I could build a webservice or use remoting but when using a BOS it looks like I could let the BOS do the remoting part of the job maybe with RPC.
Is it possible to have the BOS calling such a function (in-process?)? or do you have any proposition of how to do that when using Devforce?
btw, I didn't find examples with the RPC stuff, could you give me a pointer to it? (page in the dev. manual or weblink)

Dominique

Edited by Dominique - 29-Jun-2007 at 8:15am]]> Fri, 29 Jun 2007 08:14:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=99&PID=216#216