Blog: Posts from July, 2010

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Posts from July, 2010
Monday, July 5, 2010PrintSubscribe
Building ASP.NET+AJAX Appointment Manager

Suppose that you need to create an appointment manager for your business. You have a receptionist in the front office and salesmen ready to service customers. Whenever a customer comes in requesting a consultation, the receptionist will make an appointment in the Appointment Manager. The next automatically assigned salesman will be rotated by the application. If a customer requests a specific salesman, then that appointment will not affect the rotation process.

When a new appointment is created, the salesman that performed the smallest number of appointments will be assigned. The rotation process will ensure fair distribution of appointments.

We will show you how to create an ASP.NET+AJAX Appointment Manager web application generated with Code OnTime and enhanced in Visual Web Developer.

Download the step-by-step guide (1029 KB)

Thursday, July 1, 2010PrintSubscribe
Sending Email in Response to Action

Q. Is it possible to send email via OnTime? For example, click a record that has an email field and using Form Mail, generate an smtp connection (with username and password and smtp info) to send the email?

A.

It is possible to perform any sort of business logic in response to selection of a user interface action including sending an email.

Modify your project in Designer to create a user interface action that will be triggering an email. Declare a business rules handler for the data controller and implement the code that will send email. Selected row field values are passed from the client to the server code and can be used to determine the email recipient and any other action-specific parameters.

Here is a how you can define  a business rules handler and action.

See this and many other video tutorials on our YouTube channel at http://www.youtube.com/watch?v=M45hyY185Ck.

We have modified the sample project by adding Send Email action to Customers data controller.

The screen shot below shows the email option in action:

image 

The business rules class shows how to handle the action by sending an email from an existing gmail account to the selected recipient. Notice that the order of parameters in the business rule method is arbitrary. You can list every single field available in client-side view or limit the list of arguments  to only those that are really needed to compose an email. 

If you enable multiple selection of rows as described at /blog/2010/04/globalization-localization-multi-select.html then primary key values of selected rows can be selected by accessing Arguments.SelectedValues property within the business rules method.

VB.NET:

Imports MyCompany.Data
Imports System
Imports System.Collections.Generic
Imports System.Data
Imports System.Linq
Imports System.Net.Mail
Imports System.Net

Namespace MyCompany.Rules

    Partial Public Class CustomersBusinessRules
        Inherits MyCompany.Data.BusinessRules

        <ControllerAction("Customers", "Custom", "SendEmail")> _
        Sub SendAnEmailToACustomer(ByVal companyName As String, ByVal contactName As String, ByVal customerID As String)
            Dim message As MailMessage = New MailMessage()
            message.From = New MailAddress("SENDER@gmail.com", "Sales, Code OnTime")

            ' prepare smtp client
            Dim smtp As SmtpClient = New SmtpClient("smtp.gmail.com", 587)
            smtp.EnableSsl = True
            smtp.UseDefaultCredentials = False
            smtp.Credentials = New NetworkCredential("SENDER@gmail.com", "PASSWORD")

            ' compose and send an email message

            ' use CustomerID to find the recipient's email
            Dim sendTo As String = "recipient@contoso.com"

            message.To.Add(sendTo)
            message.Subject = String.Format("Hello {0} at {1}.", contactName, companyName)
            message.Body = "Hello there!"
            smtp.Send(message)

            Result.ShowAlert("Email has been sent.")

        End Sub

    End Class
End Namespace

C#:

using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using MyCompany.Data;
using System.Net.Mail;
using System.Net;

namespace MyCompany.Rules
{
    public partial class CustomersBusinessRules : MyCompany.Data.BusinessRules
    {

        [ControllerAction("Customers", "Custom", "SendEmail")]
        public void SendAnEmailToACustomer(string companyName, string contactName, string customerId)
        {
            MailMessage message = new MailMessage();
            message.From = new MailAddress("SENDER@gmail.com", "Sales, Code OnTime");

            // prepare smtp client
            SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
            smtp.EnableSsl = true;
            smtp.UseDefaultCredentials = false;
            smtp.Credentials = new NetworkCredential("SENDER@gmail.com", "PASSWORD");

            // compose and send an email message

            // use CustomerID to find the recipient's email
            string sendTo = "recipient@contoso.com";

            message.To.Add(sendTo);
            message.Subject = String.Format("Hello {0} at {1}.", contactName, companyName);
            message.Body = "Hello there!";
            smtp.Send(message);

            Result.ShowAlert("Email has been sent.");

        }
    }
}

The following confirmation is displayed in the client browser.

image