Northwind Demo - Aspose.Slides Demos

The sample demo makes use of Northwind database. It covers almost all major features of Aspose.Slides. The demo runs a query on database and generates chart from the fetched data, gets its image and embeds it to slide.

It also shows how to work with text using Aspose.Slides, for example, it finds text inside the template presentation and replaces/updates it with new text which is fetched from the database and changes its formatting.

The other main features that it covers, includes; insertion of images, slide backgrounds, slide show, animation of shapes and working with tables.

Finally, it sends the output presentation to the client browser for downloading.

Choose demo parameters below and click Submit to see how demo generates a PPT or PDF file by utilizing user input and the Northwind database.

Presenter Name:

Company Picnic Date:

April

May 2012

June

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Reporting Location:

Reporting Year:

Reporting Month:

Company WebSite:

Company Name:

Company Address:

Company City:

State:

Zip:

3D Chart:

Type of Chart:

Select Export Type:

PPTPDF

ASP.NET

<%@ Page Language="C#" MasterPageFile="~/tpl/Demo.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Aspose.Slides.Northwind.Default" Title="Northwind Demo - Aspose.Slides Demos" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeaderContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table width="90%" align="center" cellspacing="0" cellpadding="0" border="0">
        <tr>
            <td height="41" valign="top">
                <img src="/Common/images/heading_lft.jpg" width="19" height="41" /></td>
            <td width="100%" class="demos-heading-bg">
                <h2 class="demos-heading-bg">
                    &nbsp;Northwind Demo - Aspose.Slides</h2>
            </td>
            <td valign="top">
                <img src="/Common/images/heading_rt.jpg" width="19" height="41" /></td>
        </tr>
    </table>
        <p class="componentDescriptionTxt">
        The sample demo makes use of <strong>Northwind</strong> database. It covers almost
        all major features of <strong>Aspose.Slides</strong>. The demo runs a query on database
        and generates chart from the fetched data, gets its image and embeds it to slide.
    </p>
    <p class="componentDescriptionTxt">
        It also shows how to work with text using <strong>Aspose.Slides</strong>, for example,
        it finds text inside the template presentation and replaces/updates it with new
        text which is fetched from the database and changes its formatting.
    </p>
    <p class="componentDescriptionTxt">
        The other main features that it covers, includes; insertion of images, slide backgrounds,
        slide show, animation of shapes and working with tables.
    </p>
    <p class="componentDescriptionTxt">
        Finally, it sends the output presentation to the client browser for downloading.</p>
    <hr />
    <br />
    <div class="demoContentArea">
        <p class="componentDescriptionTxt">
            Choose demo parameters below and click <b>Submit</b> to see how demo generates a
            PPT or PDF file by utilizing user input and the Northwind database.
        </p>

    
    <table class="genericTable" cellpadding="2" cellspacing="0">
        <tbody>
            <tr >
                <td>
                    <asp:Label ID="Label5" runat="server" Font-Bold="True">Presenter Name:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtPresenterName" runat="server" Width="156">John Doe</asp:TextBox>
                </td>
                <td rowspan="7">
                    <div style="width: 100%; text-align: center">
                        Company Picnic Date:</div>
                    <br />
                    <asp:Calendar ID="calPicnicDate" runat="server" BackColor="White" BorderColor="White"
                        BorderWidth="1px" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="190px"
                        NextPrevFormat="FullMonth" Width="350px">
                        <TodayDayStyle BackColor="#CCCCCC" />
                        <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
                        <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
                        <SelectedDayStyle BackColor="#333399" ForeColor="White" />
                        <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True"
                            Font-Size="12pt" ForeColor="#333399" />
                        <OtherMonthDayStyle ForeColor="#999999" />
                    </asp:Calendar>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label9" runat="server" Font-Bold="True">Reporting Location:</asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlEmployeeLocation" runat="server" Width="156px">
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label10" runat="server" Font-Bold="True">Reporting Year:</asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlReportingYear" runat="server" Width="156px">
                        <asp:ListItem Value="1996">1996</asp:ListItem>
                        <asp:ListItem Selected="True" Value="1997">1997</asp:ListItem>
                        <asp:ListItem Value="1998">1998</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label11" runat="server" Font-Bold="True" Height="12px">Reporting Month:</asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlReportingMonth" runat="server" Width="156px">
                        <asp:ListItem Value="1">January</asp:ListItem>
                        <asp:ListItem Value="2">Febuary</asp:ListItem>
                        <asp:ListItem Value="3">March</asp:ListItem>
                        <asp:ListItem Value="4">April</asp:ListItem>
                        <asp:ListItem Value="5">May</asp:ListItem>
                        <asp:ListItem Value="6">June</asp:ListItem>
                        <asp:ListItem Value="7">July</asp:ListItem>
                        <asp:ListItem Value="8">August</asp:ListItem>
                        <asp:ListItem Value="9">September</asp:ListItem>
                        <asp:ListItem Value="10">October</asp:ListItem>
                        <asp:ListItem Value="11">November</asp:ListItem>
                        <asp:ListItem Value="12">December</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label6" runat="server" Font-Bold="True">Company WebSite:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCompanyWebSite" runat="server">www.aspose.com</asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label4" runat="server" Font-Bold="True">Company Name:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCompanyName" runat="server" Width="156">Aspose</asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label3" runat="server" Font-Bold="True">Company Address:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCompanyAddress" runat="server">126 First St.</asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label7" runat="server" Font-Bold="True">Company City:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCompanyCity" runat="server">Tyler</asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label8" runat="server" Font-Bold="True">State:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCompanyState" runat="server" Width="35px">TX</asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label2" runat="server" Font-Bold="True">Zip:</asp:Label>
                </td>
                <td>
                    <asp:TextBox ID="txtCompanyZip" runat="server" Width="67px">75704</asp:TextBox>
                </td>
            </tr>
            <tr>
                <td colspan="3">
                    <asp:CheckBox ID="ckb3DChart" runat="server" Font-Bold="True" Text="3D Chart: " TextAlign="Left" />
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label13" runat="server" Font-Bold="True">Type of Chart:</asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="ddlTypeOfChart" runat="server" Width="159px">
                        <asp:ListItem Value="Area">Area</asp:ListItem>
                        <asp:ListItem Selected="True" Value="Bar">Bar</asp:ListItem>
                        <asp:ListItem Value="Cube">Cube</asp:ListItem>
                        <asp:ListItem Value="Curve">Curve</asp:ListItem>
                        <asp:ListItem Value="CurveArea">CurveArea</asp:ListItem>
                        <asp:ListItem Value="Line">Line</asp:ListItem>
                        <asp:ListItem Value="Pareto">Pareto</asp:ListItem>
                        <asp:ListItem Value="Point">Point</asp:ListItem>
                        <asp:ListItem Value="Radar">Radar</asp:ListItem>
                        <asp:ListItem Value="Scatter">Scatter</asp:ListItem>
                        <asp:ListItem Value="Step">Step</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:Label ID="Label14" runat="server" Font-Bold="True">Select Export Type:</asp:Label>
                </td>
                <td>
                    <asp:RadioButtonList ID="rblFileExportType" runat="server" RepeatDirection="Horizontal"
                        Width="147px">
                        <asp:ListItem Selected="True" Value="PPT">PPT</asp:ListItem>
                        <asp:ListItem Value="PDF">PDF</asp:ListItem>
                    </asp:RadioButtonList>
                </td>
            </tr>
        </tbody>
    </table>
   <asp:Button ID="btnGenPres" runat="server" Text="Generate Presentation" 
        onclick="btnGenPres_Click" />
</div>    

</asp:Content>

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Drawing;
using System.Drawing.Imaging;
using System.Data.OleDb;
using Aspose.Slides;
using Aspose.Slides.Pptx;
using Aspose.Chart;

namespace Aspose.Slides.Northwind
{
    public partial class Default : System.Web.UI.Page
    {
        OleDbConnection cn = null;
        private Presentation pres = null;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                // Open the database connection
                openDBConnection();
                String selectString = "SELECT Distinct City FROM Employees";

                // Create an OleDbCommand object
                OleDbCommand cmd = new OleDbCommand(selectString, cn);

                // Send the CommandText to the connection, and then build an OleDbDataReader
                OleDbDataReader reader = cmd.ExecuteReader();

                ddlEmployeeLocation.DataSource = reader;
                ddlEmployeeLocation.DataTextField = "City";
                ddlEmployeeLocation.DataValueField = "City";
                ddlEmployeeLocation.DataBind();

                // Close the database connection
                closeDBConnection();
            }
        }
        private void openDBConnection()
        {
            // Use a string variable to hold the ConnectionString
            string connectString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + MapPath(".") + "\\db\\NorthWind.MDB";
            // Create an OleDbConnection object,
            cn = new OleDbConnection(connectString);
            // Open the connection
            cn.Open();
        }

        private void closeDBConnection()
        {
            // Close the connection
            cn.Close();
        }
        private Presentation setupSlideMaster(Presentation pres)
        {
            // Get slide master
            Slide slide = pres.Masters[0];
            // Set slide master propertires
            slide.Background.FillFormat.Type = FillType.Gradient;
            slide.Background.FillFormat.GradientColorType = GradientColorType.TwoColors;
            slide.Background.FillFormat.ForeColor = Color.Beige;
            slide.Background.FillFormat.BackColor = Color.DodgerBlue;
            return pres;
        }

        protected void btnGenPres_Click(object sender, EventArgs e)
        {
            // Open the database connection
            openDBConnection();

            // Set location of presentation file.
            string fileName = MapPath(".") + "\\template\\demo.ppt";

            // Create presentation object from presentation file
            pres = new Presentation(fileName);

            // Set SlideMaster Properties
            pres = setupSlideMaster(pres);

            // Get references to slides in presentation by position
            Slide slide1 = pres.GetSlideByPosition(1);
            Slide slide2 = pres.GetSlideByPosition(2);
            // Create a clone of slide2 and place it into position 3
            pres.CloneSlide(slide2, 3);
            Slide slide3 = pres.GetSlideByPosition(3);
            Slide slide4 = pres.GetSlideByPosition(4);
            Slide slide5 = pres.GetSlideByPosition(5);
            Slide slide6 = pres.GetSlideByPosition(6);
            Slide slide7 = pres.GetSlideByPosition(7);
            Slide slide8 = pres.GetSlideByPosition(8);

            // I have created methods for each slide to help seprate out the code
            slide1 = Slide1(slide1);
            slide2 = Slide2(slide2);
            slide3 = Slide3(slide3);
            slide4 = Slide4(slide4);
            slide5 = Slide5(slide5);
            slide6 = Slide6(slide6);
            slide7 = Slide7(slide7);
            slide8 = Slide8(slide8);
            pres.CloneSlide(slide1, 9);
            Slide slide9 = pres.GetSlideByPosition(9);
            slide9 = Slide9(slide9);

            // Close the database connection
            closeDBConnection();
            // Construct the response to be sent back to the web browser
            if (rblFileExportType.SelectedItem.Text == "PPT")
            {
                // Send the file
                pres.Save("demoppt.ppt",Aspose.Slides.Export.SaveFormat.Ppt,Response,false);
                Response.End();
            }
            else if (rblFileExportType.SelectedItem.Text == "PDF")
            {
                // Send the file
                pres.Save("demopdf.pdf", Aspose.Slides.Export.SaveFormat.Pdf, Response, false);
                Response.End();
            }
        }
        private Slide Slide1(Slide slide1)
        {
            // Introduction
            for (int j = 0; j < slide1.Shapes.Count; j++)
            {
                Shape shape = slide1.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    Paragraph para = tf.Paragraphs[0];
                    if (para.Text == "Presenter�s Name")
                    {
                        para.Alignment = TextAlignment.Center;
                        foreach (Portion port in para.Portions)
                        {
                            port.FontBold = false;
                            port.FontColor = Color.Black;
                            port.FontEmbossed = false;
                            port.FontItalic = false;
                            port.FontShadow = false;
                            port.FontUnderline = false;
                            port.FontHeight = 30;
                            port.Text = "Presented By: " + txtPresenterName.Text;
                        }
                    }
                    else if (para.Text == "HyperLink")
                    {
                        para.Alignment = TextAlignment.Left;
                        foreach (Portion port in para.Portions)
                        {
                            port.FontHeight = 20;
                            port.Text = txtCompanyWebSite.Text;
                            tf.Links.Clear();
                            Link link = tf.Links.AddLink();
                            link.SetInternalHyperlink(slide1);
                            link.Begin = 0;
                            link.End = tf.Text.Length;
                        }
                    }
                }
            }

            // Create Shape to Hold Business Info
            Shape shape1 = slide1.Shapes.AddRectangle(1550, 300, 2700, 1200);

            // Set Shape Properties
            shape1.FillFormat.Type = FillType.Solid;
            shape1.FillFormat.ForeColor = Color.BlanchedAlmond;
            shape1.LineFormat.ForeColor = Color.Black;
            shape1.LineFormat.Width = 3;
            shape1.FillFormat.Type = FillType.Texture;
            shape1.FillFormat.SetTextureStyle(TextureStyle.Newsprint);

            // Add Transition Effects
            shape1.AnimationSettings.EntryEffect = ShapeEntryEffect.StretchAcross;

            // Add A TextFrame to the Shape
            shape1.AddTextFrame("Shape1");

            if (shape1.TextFrame != null)
            {
                TextFrame tfsh1 = shape1.TextFrame;
                Paragraph parash1 = tfsh1.Paragraphs[0];
                parash1.Alignment = TextAlignment.Center;
                foreach (Portion port in parash1.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.DodgerBlue;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 30;
                    port.Text = txtCompanyName.Text;
                }
                // Add second paragraph to the shape
                tfsh1.Paragraphs.Add(new Paragraph(tfsh1.Paragraphs[0]));
                Paragraph para2sh1 = tfsh1.Paragraphs[1];
                foreach (Portion port in para2sh1.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.DodgerBlue;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 30;
                    port.Text = txtCompanyAddress.Text;
                }
                // Add third paragraph to the shape
                tfsh1.Paragraphs.Add(new Paragraph(tfsh1.Paragraphs[0]));
                Paragraph para3sh1 = tfsh1.Paragraphs[2];
                foreach (Portion port in para3sh1.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.DodgerBlue;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 30;
                    port.Text = txtCompanyCity.Text + ", " + txtCompanyState.Text + "  " + txtCompanyZip.Text;
                }
            }
            // Add Slide Transition Effect
            slide1.SlideShowTransition.EntryEffect = SlideTransitionEffect.FadeSmoothly;
            return slide1;
        }

        private Slide Slide2(Slide slide2)
        {
            // Employee Directory
            for (int j = 0; j < slide2.Shapes.Count; j++)
            {
                Shape shape = slide2.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Subtitle")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 30;
                                port.Text = "Location: " + ddlEmployeeLocation.SelectedItem.ToString();
                            }
                        }
                        else if (para.Text == "CH1")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 20;
                                port.Text = "Name";
                            }
                        }
                        else if (para.Text == "CH2")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 20;
                                port.Text = "Phone Number";
                            }
                        }
                    }
                }
            }

            // Find table
            Table table = null;
            for (int i = 0; i < slide2.Shapes.Count; i++)
            {
                if (slide2.Shapes[i] is Table)
                {
                    table = (Table)slide2.Shapes[i];
                    break;
                }
            }

            if (table != null)
            {
                String selectString = "SELECT count(*) FROM Employees where City='"
                                      + ddlEmployeeLocation.SelectedItem.Text + "'";

                // Create an OleDbCommand object
                OleDbCommand cmd = new OleDbCommand(selectString, cn);

                // Send the CommandText to the connection, and then build an OleDbDataReader
                OleDbDataReader reader = cmd.ExecuteReader();

                reader.Read();
                int recordCount = (int)reader.GetValue(0);
                reader.Close();

                selectString = "SELECT top 7 LastName, FirstName,HomePhone FROM Employees where " +
                               "City='" + ddlEmployeeLocation.SelectedItem.Text + "' order by LastName";

                // Create an OleDbCommand object
                cmd = new OleDbCommand(selectString, cn);

                // Send the CommandText to the connection, and then build an OleDbDataReader
                reader = cmd.ExecuteReader();

                // Make table contain correct number of rows
                if (recordCount == 1)
                {
                    table.DeleteRow(table.RowsNumber - 1);
                }
                else
                {
                    for (int i = 2; i < recordCount; i++)
                    {
                        table.AddRow();
                    }
                }
                int count = 0;
                while (reader.Read())
                {
                    TextFrame tfName = table.GetCell(0, count).TextFrame;
                    TextFrame tfPhoneNumber = table.GetCell(1, count).TextFrame;
                    if (tfName != null)
                    {
                        tfName.Paragraphs[0].Portions[0].Text = reader["LastName"].ToString() + ", "
                                                                + reader["FirstName"].ToString();
                        tfPhoneNumber.Paragraphs[0].Portions[0].Text = reader["HomePhone"].ToString();
                        // Left justify first column
                        tfName.Paragraphs[0].Alignment = TextAlignment.Left;
                        // Center justify second column
                        tfPhoneNumber.Paragraphs[0].Alignment = TextAlignment.Center;
                        // Disable default bullets
                        tfName.Paragraphs[0].HasBullet = false;
                        tfPhoneNumber.Paragraphs[0].HasBullet = false;
                        // Set Font Color
                        tfName.Paragraphs[0].Portions[0].FontColor = Color.Crimson;
                        tfPhoneNumber.Paragraphs[0].Portions[0].FontColor = Color.FromArgb(51, 153, 102);
                    }

                    count++;
                }
                reader.Close();
            }
            // Add entry effect to the table
            table.AnimationSettings.EntryEffect = ShapeEntryEffect.Spiral;
            // Add Slide Transition Effect
            slide2.SlideShowTransition.EntryEffect = SlideTransitionEffect.SplitVerticalOut;
            return slide2;
        }

        private Slide Slide3(Slide slide3)
        {
            // Top 5 Employees for the year
            for (int j = 0; j < slide3.Shapes.Count; j++)
            {
                Placeholder holder = slide3.Placeholders[j];
                if (holder is TextHolder)
                {
                    foreach (Paragraph para in ((TextHolder)holder).Paragraphs)
                    {
                        if (para.Text == "Employee Directory")
                        {
                            para.Alignment = TextAlignment.Default;
                            para.Depth = 0;
                            para.HasBullet = false;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.Text = "Top 5 Employees for " + ddlReportingYear.SelectedItem.ToString();
                            }
                        }
                    }
                }
                Shape shape = slide3.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Subtitle")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 30;
                                port.Text = "Ranked by Order Volume";
                            }
                        }
                        else if (para.Text == "CH1")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 20;
                                port.Text = "Name";
                            }
                        }
                        else if (para.Text == "CH2")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 20;
                                port.Text = "Order Volume";
                            }
                        }
                    }
                }
            }
            // Find table
            Table table = null;
            for (int i = 0; i < slide3.Shapes.Count; i++)
            {
                if (slide3.Shapes[i] is Table)
                {
                    table = (Table)slide3.Shapes[i];
                    break;
                }
            }
            if (table != null)
            {
                String selectString = "SELECT top 5 LastName, FirstName, count(Orders.OrderID) as numOrders " +
                                      "FROM Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID " +
                                      "WHERE  Orders.OrderDate > #01-01-" + ddlReportingYear.SelectedItem.ToString()
                                      + "# " +
                                      "and Orders.OrderDate < #12-31-" + ddlReportingYear.SelectedItem.ToString() + "# " +
                                      "Group by LastName, FirstName " +
                                      "order by count(Orders.OrderID) desc";

                // Create an OleDbCommand object
                OleDbCommand cmd = new OleDbCommand(selectString, cn);

                // Send the CommandText to the connection, and then build an OleDbDataReader
                OleDbDataReader reader = cmd.ExecuteReader();
                // Make table contain correct number of rows
                for (int i = 2; i < 5; i++)
                {
                    table.AddRow();
                }
                int count = 0;
                while (reader.Read())
                {
                    TextFrame tfName = table.GetCell(0, count).TextFrame;
                    TextFrame tfPhoneNumber = table.GetCell(1, count).TextFrame;
                    if (tfName != null)
                    {
                        tfName.Paragraphs[0].Portions[0].Text = reader["LastName"].ToString() + ", "
                                                                + reader["FirstName"].ToString();
                        tfPhoneNumber.Paragraphs[0].Portions[0].Text = reader["numOrders"].ToString();
                        // Left justify first column
                        tfName.Paragraphs[0].Alignment = TextAlignment.Left;
                        // Center justify second column
                        tfPhoneNumber.Paragraphs[0].Alignment = TextAlignment.Center;
                        // Disable default bullets
                        tfName.Paragraphs[0].HasBullet = false;
                        tfPhoneNumber.Paragraphs[0].HasBullet = false;
                        // Set Font Color
                        tfName.Paragraphs[0].Portions[0].FontColor = Color.Crimson;
                        tfPhoneNumber.Paragraphs[0].Portions[0].FontColor = Color.FromArgb(51, 153, 102);
                    }

                    count++;
                }
                reader.Close();

                // Add entry effect to the table
                table.AnimationSettings.EntryEffect = ShapeEntryEffect.Spiral;
            }
            // Add Slide Transition Effect
            slide3.SlideShowTransition.EntryEffect = SlideTransitionEffect.WipeRight;
            return slide3;
        }

        private Slide Slide4(Slide slide4)
        {
            // Employee of the Year
            String selectString = "SELECT count(*) FROM Employees";

            // Create an OleDbCommand object
            OleDbCommand cmd = new OleDbCommand(selectString, cn);

            // Send the CommandText to the connection, and then build an OleDbDataReader
            OleDbDataReader reader = cmd.ExecuteReader();

            reader.Read();
            int recordCount = (int)reader.GetValue(0);
            reader.Close();

            selectString = "SELECT LastName, FirstName, Title, City FROM Employees";

            // Create an OleDbCommand object
            cmd = new OleDbCommand(selectString, cn);

            // Send the CommandText to the connection, and then build an OleDbDataReader
            reader = cmd.ExecuteReader();
            string LastName = "", FirstName = "", Title = "", City = "";

            Random objRand = new Random();
            // Get a random employee
            while (City == "")
            {
                int intRand = objRand.Next(0, recordCount - 1);

                for (int i = 0; i < intRand; i++)
                {
                    reader.Read();
                    LastName = reader["LastName"].ToString();
                    FirstName = reader["FirstName"].ToString();
                    Title = reader["Title"].ToString();
                    City = reader["City"].ToString();
                }
            }
            reader.Close();

            for (int j = 0; j < slide4.Shapes.Count; j++)
            {
                Shape shape = slide4.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Name")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 40;
                                port.Text = FirstName + " " + LastName;
                            }
                            // Add Entry Effect for the Shape
                            shape.AnimationSettings.EntryEffect = ShapeEntryEffect.FlyFromLeft;
                        }
                        else if (para.Text == "Title")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 30;
                                port.Text = Title;
                            }
                            // Add Entry Effect for the Shape
                            shape.AnimationSettings.EntryEffect = ShapeEntryEffect.FlyFromRight;
                        }
                        else if (para.Text == "Location")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 30;
                                port.Text = City;
                            }
                            // Add Entry Effect for the Shape
                            shape.AnimationSettings.EntryEffect = ShapeEntryEffect.FlyFromLeft;
                        }
                    }
                }
            }
            // Add Slide Transition Effect
            slide4.SlideShowTransition.EntryEffect = SlideTransitionEffect.Dissolve;
            return slide4;
        }

        private Slide Slide5(Slide slide5)
        {
            // Item of the month
            String selectString = "SELECT top 1 ProductName, count([Order Details].ProductID) as numOrders " +
                                  "FROM " +
                                  "Products INNER JOIN (Orders INNER JOIN [Order Details] " +
                                  "ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID " +
                                  "WHERE " +
                                  "Orders.OrderDate >#" + ddlReportingMonth.SelectedItem.Value.ToString() + "-01-"
                                  + ddlReportingYear.SelectedItem.ToString() + "# " +
                                  "and Orders.OrderDate < #" + ddlReportingMonth.SelectedItem.Value.ToString() + "-" +
                                  DateTime.DaysInMonth(Convert.ToInt16(ddlReportingYear.SelectedItem.ToString()),
                                                       Convert.ToInt16(ddlReportingMonth.SelectedItem.Value.ToString()))
                                      .ToString() + "-" + ddlReportingYear.SelectedItem.ToString() + "# " +
                                  "and [Order Details].OrderID = Orders.OrderID " +
                                  "Group by " +
                                  "ProductName " +
                                  "order by count([Order Details].ProductID) desc";

            // Create an OleDbCommand object
            OleDbCommand cmd = new OleDbCommand(selectString, cn);

            // Send the CommandText to the connection, and then build an OleDbDataReader
            OleDbDataReader reader = cmd.ExecuteReader();
            string ProductName = "", NumberOfOrders = "";

            while (reader.Read())
            {
                ProductName = reader["ProductName"].ToString();
                NumberOfOrders = reader["numOrders"].ToString();
            }
            reader.Close();

            for (int j = 0; j < slide5.Shapes.Count; j++)
            {
                Shape shape = slide5.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Subtitle")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 30;
                                port.Text = "Top Selling Item by Volume for "
                                            + ddlReportingMonth.SelectedItem.ToString() + " " +
                                            ddlReportingYear.SelectedItem.ToString();
                            }
                        }
                        else if (para.Text == "Body1")
                        {
                            para.Alignment = TextAlignment.Left;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                if (ProductName != "")
                                {
                                    port.Text = "Item Name: " + ProductName;
                                }
                                else
                                {
                                    port.FontColor = Color.Red;
                                    port.Text = "No Sales Reported for this Time Period.";
                                    para.Alignment = TextAlignment.Center;
                                }
                            }
                            // Add Entry Effect for the Shape
                            shape.AnimationSettings.EntryEffect = ShapeEntryEffect.SplitHorizontalOut;
                        }
                        else if (para.Text == "Body2")
                        {
                            para.Alignment = TextAlignment.Left;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                if (NumberOfOrders != "")
                                {
                                    port.Text = "Number of Sales for the Month: " + NumberOfOrders;
                                }
                                else
                                {
                                    port.Text = "";
                                }
                                // Add Entry Effect for the Shape
                                shape.AnimationSettings.EntryEffect = ShapeEntryEffect.SplitHorizontalIn;
                            }
                        }
                    }
                }
            }
            // Add Slide Transition Effect
            slide5.SlideShowTransition.EntryEffect = SlideTransitionEffect.DiamondOut;
            return slide5;
        }

        private Slide Slide6(Slide slide6)
        {
            // Item of the Year
            String selectString = "SELECT top 1 ProductName, count([Order Details].ProductID) as numOrders " +
                                  "FROM " +
                                  "Products INNER JOIN (Orders INNER JOIN [Order Details] " +
                                  "ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID " +
                                  "WHERE " +
                                  "Orders.OrderDate >#01-01-" + ddlReportingYear.SelectedItem.ToString() + "# " +
                                  "and Orders.OrderDate < #12-31-" + ddlReportingYear.SelectedItem.ToString() + "# " +
                                  "and [Order Details].OrderID = Orders.OrderID " +
                                  "Group by " +
                                  "ProductName " +
                                  "order by count([Order Details].ProductID) desc";

            // Create an OleDbCommand object
            OleDbCommand cmd = new OleDbCommand(selectString, cn);

            // Send the CommandText to the connection, and then build an OleDbDataReader
            OleDbDataReader reader = cmd.ExecuteReader();
            string ProductName = "", NumberOfOrders = "";

            while (reader.Read())
            {
                ProductName = reader["ProductName"].ToString();
                NumberOfOrders = reader["numOrders"].ToString();
            }
            reader.Close();

            for (int j = 0; j < slide6.Shapes.Count; j++)
            {
                Shape shape = slide6.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Subtitle")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 30;
                                port.Text = "Top Selling Item by Volume for " + ddlReportingYear.SelectedItem.ToString();
                            }
                        }
                        else if (para.Text == "Body1")
                        {
                            para.Alignment = TextAlignment.Left;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                if (ProductName != "")
                                {
                                    port.Text = "Item Name: " + ProductName;
                                }
                            }
                            // Add Entry Effect for the Shape
                            shape.AnimationSettings.EntryEffect = ShapeEntryEffect.Swivel;
                        }
                        else if (para.Text == "Body2")
                        {
                            para.Alignment = TextAlignment.Left;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                if (NumberOfOrders != "")
                                {
                                    port.Text = "Number of Sales for the Year: " + NumberOfOrders;
                                }
                            }
                            // Add Entry Effect for the Shape
                            shape.AnimationSettings.EntryEffect = ShapeEntryEffect.WipeUp;
                        }
                    }
                }
            }
            // Add picture of item
            Picture pic1 = null;
            if (ProductName == "Gnocchi di nonna Alice")
            {
                pic1 = new Picture(pres, MapPath(".") + "/images/Gnocchi.jpg");
            }
            else if (ProductName == "Konbu")
            {
                pic1 = new Picture(pres, MapPath(".") + "/images/konbu.jpg");
            }
            else if (ProductName == "Gorgonzola Telino")
            {
                pic1 = new Picture(pres, MapPath(".") + "/images/Gorgonzola.gif");
            }
            int picid1 = pres.Pictures.Add(pic1);
            int pictureWidth = pres.Pictures[picid1 - 1].Image.Width * 5;
            int pictureHeight = pres.Pictures[picid1 - 1].Image.Height * 5;
            int slideWidth = slide6.Background.Width;
            int slideHeight = slide6.Background.Height;
            int pictureFrameX = Convert.ToInt32(slideWidth / 2 - pictureWidth / 2);
            int pictureFrameY = Convert.ToInt32(slideHeight / 2 - pictureHeight / 2 + 1000);
            PictureFrame pf =
                slide6.Shapes.AddPictureFrame(picid1, pictureFrameX, pictureFrameY, pictureWidth, pictureHeight);
            pf.AnimationSettings.EntryEffect = ShapeEntryEffect.ZoomIn;
            // Add Slide Transition Effect
            slide6.SlideShowTransition.EntryEffect = SlideTransitionEffect.CircleOut;
            return slide6;
        }

        private Slide Slide7(Slide slide7)
        {
            // Sales By Contry Chart for the year.
            // Creat the Chart Image
            createChart();

            slide7.FollowMasterBackground = false;
            slide7.Background.FillFormat.BackColor = Color.White;

            Picture pic1 = new Picture(pres, MapPath(".") + "/images/chart.gif");
            int picid1 = pres.Pictures.Add(pic1);
            int slideWidth = slide7.Background.Width;
            int slideHeight = slide7.Background.Height;
            PictureFrame pf = slide7.Shapes.AddPictureFrame(picid1, 0, 1400, slideWidth, slideHeight - 1400);

            // Add Entry Effect for the Chart Image
            pf.AnimationSettings.EntryEffect = ShapeEntryEffect.BoxOut;

            for (int j = 0; j < slide7.Shapes.Count; j++)
            {
                Shape shape = slide7.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Subtitle")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                port.Text = "A Graphical Comparison of Sales between";
                            }
                            // Add second paragraph to the shape
                            tf.Paragraphs.Add(new Paragraph(tf.Paragraphs[0]));
                            Paragraph para2 = tf.Paragraphs[1];
                            foreach (Portion port in para2.Portions)
                            {
                                port.FontBold = false;
                                port.FontColor = Color.Black;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = true;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                port.Text = "the United States and Europe for "
                                            + ddlReportingYear.SelectedItem.ToString();
                            }
                        }
                    }
                }
            }
            // Add Slide Transition Effect
            slide7.SlideShowTransition.EntryEffect = SlideTransitionEffect.CutThroughBlack;
            return slide7;
        }

        private Slide Slide8(Slide slide8)
        {
            // Company Picnic Promotion
            slide8.FollowMasterBackground = false;
            slide8.Background.FillFormat.Type = FillType.Picture;
            Picture pic1 = new Picture(pres, MapPath(".") + "/images/picnic.jpg");
            int picid = pres.Pictures.Add(pic1);
            slide8.Background.PictureId = picid;

            // Get date from Calendar or just set date 2 weeks into the future
            System.Globalization.DateTimeFormatInfo dtfi = new System.Globalization.DateTimeFormatInfo();
            string month, day, year;
            if (calPicnicDate.SelectedDate > DateTime.Now)
            {
                month = dtfi.GetMonthName(calPicnicDate.SelectedDate.Month);
                day = calPicnicDate.SelectedDate.Day.ToString();
                year = calPicnicDate.SelectedDate.Year.ToString();
            }
            else
            {
                DateTime dt = DateTime.Now.AddDays(21);
                month = dtfi.GetMonthName(dt.Month);
                day = dt.Day.ToString();
                year = dt.Year.ToString();
            }

            for (int k = 0; k < slide8.Placeholders.Count; k++)
            {
                Placeholder holder = slide8.Placeholders[k];
                if (holder is TextHolder)
                {
                    foreach (Paragraph para in ((TextHolder)holder).Paragraphs)
                    {
                        if (para.Text == "Company Picnic Announcement")
                        {
                            foreach (Portion port in para.Portions)
                            {
                                port.FontColor = Color.Red;
                            }
                        }
                    }
                }
            }

            for (int j = 0; j < slide8.Shapes.Count; j++)
            {
                Shape shape = slide8.Shapes[j];
                if (shape.TextFrame != null)
                {
                    TextFrame tf = shape.TextFrame;
                    if (tf.Paragraphs.Count != 0)
                    {
                        Paragraph para = tf.Paragraphs[0];
                        if (para.Text == "Subtitle")
                        {
                            para.Alignment = TextAlignment.Center;
                            foreach (Portion port in para.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Red;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                port.Text = "The Company Picnic will be held ";
                            }
                            // Add second paragraph to the shape
                            tf.Paragraphs.Add(new Paragraph(tf.Paragraphs[0]));
                            Paragraph para2 = tf.Paragraphs[1];
                            foreach (Portion port in para2.Portions)
                            {
                                port.FontBold = true;
                                port.FontColor = Color.Red;
                                port.FontEmbossed = false;
                                port.FontItalic = false;
                                port.FontShadow = false;
                                port.FontUnderline = false;
                                port.FontHeight = 25;
                                port.Text = month + " " + day + ", " + year + " at South Lake Shore Park";
                            }
                        }
                    }
                }
            }

            // Create 3 Shapes to hold text
            Shape shape1 = slide8.Shapes.AddRectangle(400, 1400, 2300, 800);
            shape1.FillFormat.Type = FillType.Texture;
            shape1.FillFormat.SetTextureStyle(TextureStyle.PurpleMesh);

            Shape shape2 = slide8.Shapes.AddRectangle(3100, 2200, 2300, 800);
            shape2.FillFormat.Type = FillType.Gradient;
            shape2.FillFormat.GradientColorType = GradientColorType.TwoColors;
            shape2.FillFormat.GradientFillAngle = 40;
            shape2.FillFormat.ForeColor = Color.LightSteelBlue;
            shape2.FillFormat.BackColor = Color.LightGreen;

            Shape shape3 = slide8.Shapes.AddRectangle(400, 3000, 2300, 800);
            shape3.FillFormat.Type = FillType.Solid;
            shape3.FillFormat.ForeColor = Color.Yellow;

            // Add a picture of a hotdog
            Picture pic2 = new Picture(pres, MapPath(".") + "/images/hotdog.gif");
            int picid1 = pres.Pictures.Add(pic2);
            int pictureWidth = pres.Pictures[picid1 - 1].Image.Width * 12;
            int pictureHeight = pres.Pictures[picid1 - 1].Image.Height * 12;
            int slideWidth = slide8.Background.Width;
            int slideHeight = slide8.Background.Height;
            PictureFrame pf = slide8.Shapes.AddPictureFrame(picid1, 3400, 3200, pictureWidth, pictureHeight);

            shape1.AddTextFrame("Shape1");

            // Add text to the shapes
            if (shape1.TextFrame != null)
            {
                TextFrame tf = shape1.TextFrame;
                Paragraph para = tf.Paragraphs[0];
                para.Alignment = TextAlignment.Center;
                foreach (Portion port in para.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.Green;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 20;
                    port.Text = "Fun for the Whole Family!";
                }
            }

            shape2.AddTextFrame("Shape2");

            if (shape2.TextFrame != null)
            {
                TextFrame tf = shape2.TextFrame;
                Paragraph para = tf.Paragraphs[0];
                para.Alignment = TextAlignment.Center;
                foreach (Portion port in para.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.DodgerBlue;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 20;
                    port.Text = "Live Entertainment!";
                }
            }

            shape3.AddTextFrame("Shape3");

            if (shape3.TextFrame != null)
            {
                TextFrame tf = shape3.TextFrame;
                Paragraph para = tf.Paragraphs[0];
                para.Alignment = TextAlignment.Center;
                foreach (Portion port in para.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.Purple;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 20;
                    port.Text = "Catered";
                }
                // Add second paragraph to the shape
                tf.Paragraphs.Add(new Paragraph(tf.Paragraphs[0]));
                Paragraph para2 = tf.Paragraphs[1];
                foreach (Portion port in para2.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.Purple;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 20;
                    port.Text = "by";
                }
                // Add third paragraph to the shape
                tf.Paragraphs.Add(new Paragraph(tf.Paragraphs[0]));
                Paragraph para3 = tf.Paragraphs[2];
                foreach (Portion port in para3.Portions)
                {
                    port.FontBold = false;
                    port.FontColor = Color.Purple;
                    port.FontEmbossed = false;
                    port.FontItalic = false;
                    port.FontShadow = true;
                    port.FontUnderline = false;
                    port.FontHeight = 20;
                    port.Text = "Ed's Catfish Saloon!";
                }
            }
            // Set Entry Effects
            slide8.Background.AnimationSettings.EntryEffect = ShapeEntryEffect.StretchAcross;
            slide8.Background.AnimationSettings.AnimationOrder = 1;
            shape1.AnimationSettings.EntryEffect = ShapeEntryEffect.Swivel;
            shape1.AnimationSettings.AnimationOrder = 2;
            shape2.AnimationSettings.EntryEffect = ShapeEntryEffect.Wedge;
            shape2.AnimationSettings.AnimationOrder = 3;
            shape3.AnimationSettings.EntryEffect = ShapeEntryEffect.Dissolve;
            shape3.AnimationSettings.AnimationOrder = 4;
            pf.AnimationSettings.EntryEffect = ShapeEntryEffect.Spiral;
            pf.AnimationSettings.AnimationOrder = 5;
            // Add Slide Transition Effect
            slide8.SlideShowTransition.EntryEffect = SlideTransitionEffect.Wedge;
            return slide8;
        }

        private Slide Slide9(Slide slide9)
        {
            // Closeing Slide
            // Clone of first slide
            return slide9;
        }
        private void createChart()
        {
            // Create a new Chart
            Chart.Chart Chart1 = new Chart.Chart();

            // Determine if 3D Chart is selected
            if (ckb3DChart.Checked)
            {
                Chart1.ChartArea.IsThreeD = true;
                Chart1.ChartArea.ThreeDDepth = 200;
            }
            else
            {
                Chart1.ChartArea.IsThreeD = false;
            }

            // Make Chart Area fully non-see though
            Chart1.ChartArea.Transparence = 255;

            // Set background color for the Chart
            Chart1.ChartArea.GradientType = GradientType.HorizontalCenter;
            Chart1.ChartArea.GradientBackColor = Color.PowderBlue;
            Chart1.ChartArea.AxisY.DefaultLabel.Format = "F0";

            // Activate Legend Box
            Chart1.ChartArea.LegendBox.LegendPositionType = LegendPositionType.Left;
            Chart1.ChartArea.LegendBox.IsVisible = true;

            // Format Axis Lables
            Chart1.ChartArea.AxisX.IntervalType = IntervalType.DateTime;
            Chart1.ChartArea.AxisX.DefaultLabel.Format = "MM-yyyy";
            Chart1.ChartArea.AxisX.DefaultLabel.FontAngle = -80;
            Chart1.ChartArea.AxisX.DefaultLabel.Color = Color.Blue;
            Chart1.ChartArea.AxisY.DefaultLabel.Color = Color.Blue;

            string selectString;
            string chartType = ddlTypeOfChart.SelectedItem.ToString();

            // Get America's Data
            Series a = new Series();
            a.DefaultDataPoint.BorderWidth = 3;
            a.ChartType = (ChartType)Enum.Parse(typeof(ChartType), chartType, true);
            for (int i = 1; i <= 12; i++)
            {
                selectString =
                    "SELECT count(Orders.OrderID) as OrderCount FROM Employees INNER JOIN Orders ON Employees.EmployeeID " +
                    "= Orders.EmployeeID WHERE (((Employees.City)<>'London')) and (Orders.OrderDate) > #" + i.ToString()
                    + "-1-" +
                    ddlReportingYear.SelectedItem.Text + "# and " + "(Orders.OrderDate) < #" + i.ToString() + "-" +
                    DateTime.DaysInMonth(Convert.ToInt16(ddlReportingYear.SelectedItem.Text), i).ToString() + "-" +
                    ddlReportingYear.SelectedItem.Text + "#;";

                // Create an OleDbCommand object
                OleDbCommand cmd = new OleDbCommand(selectString, cn);

                // Send the CommandText to the connection, and then build an OleDbDataReader
                OleDbDataReader reader = cmd.ExecuteReader();
                reader.Read();
                // Add point to Chart
                a.DataPoints.Add(
                    new DataPoint(i.ToString(), new DateTime(Convert.ToInt16(ddlReportingYear.SelectedItem.Text), i, 1),
                                  (int)reader.GetValue(0)));
                reader.Close();
            }
            Chart1.SeriesCollection.Add(a);

            // Get Europe's Data
            Series l = new Series();
            l.DefaultDataPoint.BorderWidth = 3;
            l.ChartType = (ChartType)Enum.Parse(typeof(ChartType), chartType, true);
            for (int i = 1; i <= 12; i++)
            {
                selectString =
                    "SELECT count(Orders.OrderID) as OrderCount FROM Employees INNER JOIN Orders ON Employees.EmployeeID " +
                    "= Orders.EmployeeID WHERE (((Employees.City)='London')) and (Orders.OrderDate) > #" + i.ToString()
                    + "-1-" +
                    ddlReportingYear.SelectedItem.Text + "# and " + "(Orders.OrderDate) < #" + i.ToString() + "-" +
                    DateTime.DaysInMonth(Convert.ToInt16(ddlReportingYear.SelectedItem.Text), i).ToString() + "-" +
                    ddlReportingYear.SelectedItem.Text + "#;";

                // Create an OleDbCommand object
                OleDbCommand cmd = new OleDbCommand(selectString, cn);

                // Send the CommandText to the connection, and then build an OleDbDataReader
                OleDbDataReader reader = cmd.ExecuteReader();
                reader.Read();
                // Add point to Chart
                l.DataPoints.Add(
                    new DataPoint(i.ToString(), new DateTime(Convert.ToInt16(ddlReportingYear.SelectedItem.Text), i, 1),
                                  (int)reader.GetValue(0)));
                reader.Close();
            }
            Chart1.SeriesCollection.Add(l);

            // Assign Legend Box series names
            Chart1.ChartArea.LegendBox.LegendItems[0].Name = "United States";
            Chart1.ChartArea.LegendBox.LegendItems[1].Name = "Europe";

            // Specifies  image file name and path of the chart.
            string imgPath = MapPath(".") + "\\images";
            // Save the Chart Image
            Chart1.Save(imgPath + "\\chart.gif", ImageFormat.Gif);
        }
    }
}