<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Main.aspx.vb" Inherits="Main" %>
<%@ Import Namespace="System.Data.OleDb" %>
 <%@ Import Namespace="System.Data.SqlClient" %>
 <%@ Import Namespace="System.Data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   <table width="971" height="553" border="1">
  <tr bordercolor="#999933" bgcolor="#F2F2FF">
    <td colspan="2" style="height: 116px; text-align: center;">&nbsp;
        <br />
        <strong><span style="font-size: 16pt; font-family: Tahoma"> </span></strong><br />
        <table id="table4" border="0" dir="rtl" height="44" style="position: static;" width="973">
            <tr>
                <td style="height: 1px" width="775">
                    <p align="left">
                        <span id="GlobalNewsItemControl2"><b>
                            <marquee id="LatestNewsM" align="left" class="scrollingNews" direction="right" onfinish="this.form.submit();"
                                scrollamount="4" style="border-right: #c0c4c7 1px solid; border-top: #c0c4c7 1px solid;
                                font-size: 12pt; border-left: #c0c4c7 1px solid; width: 864px; color: #000000;
                                border-bottom: #c0c4c7 1px solid; height: 21px; background-color: #ffffff">
                                 <% 
                                 
                      Dim a As New DataSet
                      Dim dr As SqlDataReader
                      Dim cn As SqlConnection
                      Dim cmd As SqlCommand
                      Dim prov As String
                      prov = "Data Source=.;Initial Catalog=order;User ID=sa"
                      cn = New SqlConnection(prov)
                      cmd = New SqlCommand("GetEvents", cn)
                      cmd.CommandType = CommandType.StoredProcedure
                      If cn.State = ConnectionState.Closed Then cn.Open()
                      dr = cmd.ExecuteReader()
                      
                      While dr.Read
                          If dr("Order_id").ToString = String.Empty Then
                          %><FONT face="Tahoma" color=#ff3300 size=3><%
                          Response.Write(" : ")%></FONT><A 
            style="TEXT-DECORATION: none" href="ViewReminder.aspx?id=<% Response.Write(dr("Id")) %>"><FONT face="Tahoma" 
            color=#0000 size=3><%  Response.Write(" " + dr("Source") + " ")
                                   Response.Write("(")%>
                            <u><%  Response.Write(" " + dr("Article"))%></u>
                               <%  Response.Write(" ) ...  ")
                          Else
                              %></FONT></A><FONT face="Tahoma" color=#ff3300 
            size=3><% Response.Write(" : ")%></FONT>
            <a href="Main.aspx?order_id=<% Response.Write(dr("order_id")) %>" style="text-decoration: none" ><font face="Tahoma" size="3" color="#0000">
								    <u><%Response.Write("" + dr("Article") + "")%></u>
								    <%Response.Write("" + "...   ")%></font></a><%
                          End If
                      End While
               %> 
                      
                      
                      </marquee>
                        </b></span>
                    </p>
                </td>
                <td style="height: 1px" width="92">
                    <p align="right">
                        <img align="right" border="0" onclick="document.all.LatestNewsM.direction='right';document.all.LatestNewsM.scrollAmount=document.all.LatestNewsM.scrollAmount+4"
                            src="App_Upload/ticker_right_arrow.jpg" style="cursor: pointer; height: 22px"
                            width="23" /><img align="right" border="0" hspace="2" onclick="document.all.LatestNewsM.scrollAmount=0"
                                src="App_Upload/ticker_stop_arrow.jpg" style="cursor: pointer; height: 22px"
                                width="27" /><img align="right" border="0" height="22" onclick="document.all.LatestNewsM.direction='left';document.all.LatestNewsM.scrollAmount=document.all.LatestNewsM.scrollAmount+4"
                                    src="App_Upload/ticker_left_arrow.jpg" style="cursor: pointer" width="23" /></p>
                </td>
            </tr>
        </table>
        <asp:LinkButton ID="LinkButton5" runat="server" Font-Bold="True" Font-Names="Tahoma"
            ForeColor="Red" Style="position: static"></asp:LinkButton></td>
  </tr>
  <tr>
    <td height="289" rowspan="4" style="vertical-align: middle; width: 781px; text-align: right" dir="rtl">
        <asp:GridView ID="GridArticals" runat="server" AutoGenerateColumns="False" Height="1px"
            PageSize="1" Style="position: static" Width="737px">
            <PagerSettings PageButtonCount="1" Visible="False" />
            <FooterStyle HorizontalAlign="Right" VerticalAlign="Middle" />
            <Columns>
                <asp:BoundField DataField="order_date" DataFormatString="{0:yyy/MM/dd}" HeaderText=""
                    HtmlEncode="False" SortExpression="order_date" />
                <asp:BoundField DataField="target_name" HeaderText="" SortExpression="target_name" />
                <asp:BoundField DataField="order_title" HeaderText="" SortExpression="order_title" />
                <asp:BoundField DataField="user_name" HeaderText=" " />
                <asp:BoundField DataField="state_name" HeaderText="" SortExpression="state_name" />
            </Columns>
            <RowStyle HorizontalAlign="Center" />
            <HeaderStyle BackColor="ControlLight" HorizontalAlign="Center" />
        </asp:GridView>
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        <asp:Label ID="Label2" runat="server" Font-Bold="True" Font-Size="16pt" Style="position: static"
            Text="" Font-Names="Arabic Transparent"></asp:Label>&nbsp; &nbsp; &nbsp;
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        <asp:LinkButton ID="LinkButton4" runat="server" Font-Bold="True" Font-Names="Arabic Transparent"
            ForeColor="Red" Style="position: static" Font-Size="12pt"></asp:LinkButton>&nbsp;
        <asp:TextBox ID="TextBox1" runat="server" Height="248px" Style="position: static"
            TextMode="MultiLine" Width="731px"></asp:TextBox></td>
    <td height="30" bordercolor="#ECE9D8" bgcolor="#EFEFCF" style="vertical-align: middle; width: 221px; text-align: right" dir="rtl">
        <span style="font-size: 10pt"><strong>   &nbsp;</strong></span><asp:DropDownList
            ID="DropDownList1" runat="server" AutoPostBack="True" Style="position: static"
            Width="120px">
        </asp:DropDownList></td>
  </tr>
  <tr>
    <td bordercolor="#999933" style="vertical-align: top; width: 221px; height: 118px; text-align: right" dir="rtl">
        <asp:ListBox ID="ListBox1" runat="server" AutoPostBack="True" Height="122px" Style="position: static"
            Width="224px"></asp:ListBox></td>
  </tr>
  <tr>
    <td height="31" bordercolor="#ECE9D8" bgcolor="#EFEFCF" style="vertical-align: middle; width: 221px; text-align: right" dir="rtl">
        <strong><span style="font-size: 10pt">  </span></strong>
        <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" Style="position: static"
            Width="112px">
        </asp:DropDownList></td>
  </tr>
  <tr>
    <td height="118" bordercolor="#999933" style="vertical-align: top; width: 221px; text-align: right" dir="rtl">
        <asp:ListBox ID="ListBox2" runat="server" AutoPostBack="True" Height="122px" Style="position: static"
            Width="224px"></asp:ListBox>&nbsp;</td>
  </tr>
  <tr>
    <td height="139" colspan="2" dir="rtl"><table width="962" height="135" border="1">
      <tr>
        <td style="vertical-align: top; height: 129px; width: 988px;" dir="rtl">
            <asp:Panel ID="Panel2" runat="server" Height="150px" ScrollBars="Vertical" Style="position: static"
                Width="470px">
                <asp:GridView ID="GridSader" runat="server" AllowSorting="True" AutoGenerateColumns="False"
                    Height="32px" PageSize="2" Style="vertical-align: top; position: static" Width="449px">
                    <PagerSettings Mode="NextPreviousFirstLast" NextPageText="" PreviousPageText="" />
                    <Columns>
                        <asp:TemplateField HeaderText=" ">
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Style="position: static" Text='<%# Eval("Expr2") %>'></asp:Label><br />
                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<asp:HyperLink ID="HyperLink1"
                                    runat="server" NavigateUrl='<%# Eval("exp") %>' Style="right: -16px; position: static;
                                    top: 27px"></asp:HyperLink><br />
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="user_name" HeaderText="" >
                            <ItemStyle BackColor="Lavender" />
                            <HeaderStyle BackColor="Lavender" />
                            <FooterStyle BackColor="Lavender" />
                        </asp:BoundField>
                        <asp:BoundField DataField="action_date" DataFormatString="{0:yyyy/MM/dd}" HeaderText=""
                            HtmlEncode="False" />
                    </Columns>
                    <RowStyle HorizontalAlign="Center" />
                    <HeaderStyle BackColor="ControlLight" HorizontalAlign="Center" />
                </asp:GridView>
            </asp:Panel>
        </td>
        <td style="vertical-align: top; height: 129px; width: 530px;" dir="rtl">
            <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Vertical" Style="position: static"
                Width="485px">
                <asp:GridView ID="GridWared" runat="server" AllowSorting="True" AutoGenerateColumns="False"
                    Height="71px" PageSize="2" Style="vertical-align: top; position: static" Width="464px">
                    <PagerSettings Mode="NextPreviousFirstLast" NextPageText="" PreviousPageText="" />
                    <Columns>
                        <asp:BoundField DataField="action_date" DataFormatString="{0:yyyy/MM/dd}" HeaderText=""
                            HtmlEncode="False" />
                        <asp:BoundField DataField="user_name" HeaderText="" >
                            <ItemStyle BackColor="Lavender" />
                            <HeaderStyle BackColor="Lavender" />
                            <FooterStyle BackColor="Lavender" />
                        </asp:BoundField>
                        <asp:TemplateField HeaderText="  ">
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Style="position: static" Text='<%# Eval("Expr2") %>'></asp:Label><br />
                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<asp:HyperLink ID="HyperLink1"
                                    runat="server" NavigateUrl='<%# Eval("exp") %>' Style="right: -16px; position: static;
                                    top: 27px"></asp:HyperLink><br />
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <RowStyle HorizontalAlign="Center" />
                    <HeaderStyle BackColor="ControlLight" HorizontalAlign="Center" />
                </asp:GridView>
            </asp:Panel>
        </td>
      </tr>
    </table>
        <asp:LinkButton ID="LinkButton3" runat="server" Style="position: static"> </asp:LinkButton>
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
        <asp:LinkButton
            ID="LinkButton2" runat="server" Font-Names="Tahoma" Style="position: static"></asp:LinkButton>
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
        <asp:LinkButton
                ID="LinkButton1" runat="server" Font-Names="Tahoma" Style="position: static"
                Width="61px"></asp:LinkButton></td>
  </tr>
</table>
    </div>
    </form>
</body>
</html>
