).
<%@ Page MasterPageFile="~/Master Pages/ManageMasterPage.master" Language="VB" AutoEventWireup="false" CodeFile="PendingOrders.aspx.vb" Inherits="ManagementDepartment_PendingOrders" EnableSessionState="True" %>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"ContentPlaceHolder2"
runat
=
"server"
>
<
table
class
=
"style1"
cellpadding
=
"0"
cellspacing
=
"0"
>
<
style
type
=
"text/css"
>
.viewWrap
{
padding: 15px;
background: #2291b5 0 0 url(Img/bluegradient.gif) repeat-x;
}
.contactWrap
{
padding: 10px 15px 15px 15px;
background: #fff;
color: #333;
}
.contactWrap td
{
padding: 0 20px 0 0;
}
.contactWrap td td
{
padding: 3px 20px 3px 0;
}
.contactWrap img
{
border: 3px solid #05679d;
}
</
style
>
<!-- end of custom head section -->
<
div
>
<
tr
>
<
td
bgcolor
=
"Black"
class
=
"style3"
>
>> Pending Orders</
td
>
</
tr
>
<
tr
>
<
td
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowAutomaticUpdates
=
"True"
AllowPaging
=
"True"
AllowSorting
=
"True"
AutoGenerateEditColumn
=
"True"
DataSourceID
=
"SqlDataSource1"
GridLines
=
"None"
ShowFooter
=
"True"
Skin
=
"Sunset"
>
<
MasterTableView
AutoGenerateColumns
=
"False"
DataKeyNames
=
"OrderID"
DataSourceID
=
"SqlDataSource1"
>
<
NestedViewSettings
DataSourceID
=
"SqlDataSource3"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"OrderID"
MasterKeyField
=
"OrderID"
/>
</
ParentTableRelation
>
</
NestedViewSettings
>
<
NestedViewTemplate
>
<
asp:Panel
ID
=
"NestedViewPanel"
runat
=
"server"
CssClass
=
"viewWrap"
>
<
div
class
=
"contactWrap"
>
<
fieldset
style
=
"padding: 10px;"
>
<
legend
style
=
"padding: 5px;"
><
b
>Detail for Order Number: <%#Eval("OrderID")%></
b
>
</
legend
>
<
table
>
<
tr
>
<
td
>
Division:
</
td
>
<
td
>
<
asp:Label
ID
=
"Label1"
Text='<%#Bind("DivisionName") %>' runat="server"></
asp:Label
>
</
td
>
<
td
>
<
asp:Image
ID
=
"Image1"
runat
=
"server"
EnableViewState
=
"true"
TabIndex
=
"0"
ToolTip
=
"This is Photo"
ImageAlign
=
"Right"
Width
=
"60px"
Height
=
"60px"
ImageUrl='<%#Eval("ThumbImage") %>'
Visible="true" />
</
td
>
</
tr
>
<
tr
>
<
td
>
Category:
</
td
>
<
td
>
<
asp:Label
ID
=
"titleLabel"
Text='<%#Bind("CategoryName") %>' runat="server"></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Item Type:
</
td
>
<
td
>
<
asp:Label
ID
=
"addressLabel"
Text='<%#Bind("TypeName") %>' runat="server"></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Code:
</
td
>
<
td
>
<
asp:Label
ID
=
"Label2"
Text='<%#Bind("CodeName") %>' runat="server"></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Full Code:
</
td
>
<
td
>
<
asp:Label
Font-Size
=
"Medium"
ForeColor
=
"Blue"
ID
=
"Label3"
Text='<%#Bind("FullCode") %>'
runat="server"></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Number of Pages:
</
td
>
<
td
>
<
asp:Label
ID
=
"Label4"
Text='<%#Bind("PagesNumber") %>' runat="server"></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Release Date:
</
td
>
<
td
>
<
asp:Label
ID
=
"Label5"
Text='<%#Bind("ReleaseDate") %>' runat="server"></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Discontinued:
</
td
>
<
td
>
<
asp:Label
ID
=
"Label6"
Text='<%#Bind("Discontinued") %>' runat="server"></
asp:Label
>
</
td
>
</
td
>
</
tr
>
<
tr
>
<
tr
>
<
td
>
Item ID:
</
td
>
<
td
>
<
asp:Label
ID
=
"Label7"
Text='<%#Bind("ItemID") %>' runat="server"></
asp:Label
>
</
td
>
</
tr
>
</
table
>
</
fieldset
>
</
div
>
</
asp:Panel
>
</
NestedViewTemplate
>
<
ExpandCollapseColumn
Visible
=
"True"
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"OrderID"
DataType
=
"System.Int32"
DefaultInsertValue
=
""
HeaderText
=
"Order Number"
ReadOnly
=
"True"
SortExpression
=
"OrderID"
UniqueName
=
"OrderID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"OrderDate"
DataType
=
"System.DateTime"
DefaultInsertValue
=
""
HeaderText
=
"Order Date"
ReadOnly
=
"True"
SortExpression
=
"OrderDate"
UniqueName
=
"OrderDate"
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"Quantity"
DataType
=
"System.Int32"
DefaultInsertValue
=
""
HeaderText
=
"Quantity"
SortExpression
=
"Quantity"
UniqueName
=
"Quantity"
Aggregate
=
"Sum"
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox1"
Runat
=
"server"
Culture
=
"English (United Kingdom)"
DbValue='<%# Bind("Quantity") %>'
ShowSpinButtons="True" Value="0" Width="100px">
<
NumberFormat
DecimalDigits
=
"0"
GroupSeparator
=
","
GroupSizes
=
"3"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"QuantityLabel"
runat
=
"server"
Text='<%# Eval("Quantity") %>'></
asp:Label
>
</
ItemTemplate
>
<
FooterStyle
Font-Bold
=
"True"
Font-Size
=
"Medium"
/>
<
ItemStyle
Font-Bold
=
"True"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
ForeColor
=
"Blue"
Wrap
=
"False"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"DateRequired"
DataFormatString
=
"{0:d}"
DataType
=
"System.DateTime"
DefaultInsertValue
=
""
HeaderText
=
"Date Required"
ReadOnly
=
"True"
SortExpression
=
"DateRequired"
UniqueName
=
"DateRequired"
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"OrderComment"
DefaultInsertValue
=
""
HeaderText
=
"Order Comment"
ReadOnly
=
"True"
SortExpression
=
"OrderComment"
UniqueName
=
"OrderComment"
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"ManageDate"
DataType
=
"System.DateTime"
HeaderText
=
"Manage Date"
SortExpression
=
"ManageDate"
UniqueName
=
"ManageDate"
DefaultInsertValue
=
""
>
<
EditItemTemplate
>
<
telerik:RadDatePicker
ID
=
"RadDatePicker1"
Runat
=
"server"
Culture
=
"English (United Kingdom)"
DbSelectedDate='<%# Bind("ManageDate") %>'
Width="175px">
<
Calendar
ID
=
"Calendar1"
runat
=
"server"
UseColumnHeadersAsSelectors
=
"False"
UseRowHeadersAsSelectors
=
"False"
ViewSelectorText
=
"x"
>
</
Calendar
>
<
DatePopupButton
HoverImageUrl
=
""
ImageUrl
=
""
/>
<
DateInput
ID
=
"DateInput1"
runat
=
"server"
DateFormat
=
"dd/MM/yyyy"
DisplayDateFormat
=
"dd/MM/yyyy"
>
</
DateInput
>
</
telerik:RadDatePicker
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"ManageDateLabel"
runat
=
"server"
Text='<%# Eval("ManageDate","{0:d}") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"OrderSpecs"
DefaultInsertValue
=
"No Specs"
HeaderText
=
"Order Specs"
SortExpression
=
"OrderSpecs"
UniqueName
=
"OrderSpecs"
>
<
EditItemTemplate
>
<
telerik:RadTextBox
ID
=
"RadTextBox1"
Runat
=
"server"
Text='<%# Bind("OrderSpecs") %>'
Width="250px" EmptyMessage="Print Specifications"
SelectionOnFocus="SelectAll">
</
telerik:RadTextBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"OrderSpecsLabel"
runat
=
"server"
Text='<%# Eval("OrderSpecs") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"ManageComment"
DefaultInsertValue
=
"No Comment"
HeaderText
=
"Manage Comment"
SortExpression
=
"ManageComment"
UniqueName
=
"ManageComment"
>
<
EditItemTemplate
>
<
telerik:RadTextBox
ID
=
"RadTextBox2"
Runat
=
"server"
Text='<%# Bind("ManageComment") %>' TextMode="MultiLine" Width="250px"
EmptyMessage="Message to Suppliers" SelectionOnFocus="SelectAll">
</
telerik:RadTextBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"ManageCommentLabel"
runat
=
"server"
Text='<%# Eval("ManageComment") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"SupplierName"
DefaultInsertValue
=
""
HeaderText
=
"Supplier"
SortExpression
=
"SupplierName"
UniqueName
=
"SupplierName"
>
<
EditItemTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBox1"
Runat
=
"server"
DataSourceID
=
"SqlDataSource2"
DataTextField
=
"SupplierName"
DataValueField
=
"SupplierID"
SelectedValue='<%# Bind("SupplierID") %>'
Width="200px">
</
telerik:RadComboBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"SupplierNameLabel"
runat
=
"server"
Text='<%# Eval("SupplierName") %>'></
asp:Label
>
</
ItemTemplate
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ItemID"
DataType
=
"System.Int32"
DefaultInsertValue
=
""
HeaderText
=
"ItemID"
ReadOnly
=
"True"
SortExpression
=
"ItemID"
UniqueName
=
"ItemID"
Visible
=
"False"
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DaysLeft"
DataType
=
"System.Int32"
DefaultInsertValue
=
""
HeaderText
=
"DaysLeft"
SortExpression
=
"DaysLeft"
UniqueName
=
"DaysLeft"
ReadOnly
=
"True"
>
<
ItemStyle
Font-Bold
=
"True"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
ForeColor
=
"Maroon"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridCheckBoxColumn
DataField
=
"ManageSubmit"
DataType
=
"System.Boolean"
DefaultInsertValue
=
"False"
HeaderText
=
"Submit"
SortExpression
=
"ManageSubmit"
UniqueName
=
"ManageSubmit"
>
<
ItemStyle
Font-Bold
=
"False"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"False"
/>
</
telerik:GridCheckBoxColumn
>
</
Columns
>
</
MasterTableView
>
<
HeaderStyle
Font-Bold
=
"True"
Font-Italic
=
"False"
Font-Overline
=
"False"
Font-Strikeout
=
"False"
Font-Underline
=
"False"
Wrap
=
"True"
/>
<
ClientSettings
EnablePostBackOnRowClick
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
bgcolor
=
"Black"
>
</
td
>
</
tr
>
</
table
>
<
asp:ScriptManager
ID
=
"ScriptManager1"
runat
=
"server"
/>
</
div
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @OrderID"
InsertCommand="INSERT INTO [Orders] ([Quantity], [ManageDate], [OrderSpecs], [ManageComment], [ManageSubmit], [SupplierID]) VALUES (@Quantity, @ManageDate, @OrderSpecs, @ManageComment, @ManageSubmit, @SupplierID)"
SelectCommand="SELECT Orders.OrderID, Orders.OrderDate, Orders.Quantity, Orders.DateRequired, Orders.OrderComment, Orders.OrderSubmit, Orders.ManageDate, Orders.OrderSpecs, Orders.ManageComment, Orders.ManageSubmit, Orders.ItemID, Orders.SupplierID, Supplier.SupplierName, Orders.DaysLeft FROM Orders INNER JOIN Supplier ON Orders.SupplierID = Supplier.SupplierID WHERE (Orders.OrderSubmit = 1) AND (Orders.ManageSubmit = 0)"
UpdateCommand="UPDATE [Orders] SET [Quantity] = @Quantity, [ManageDate] = @ManageDate, [OrderSpecs] = @OrderSpecs, [ManageComment] = @ManageComment, [ManageSubmit] = @ManageSubmit ,[SupplierID] = @SupplierID WHERE [OrderID] = @OrderID">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"OrderID"
Type
=
"Int32"
/>
</
DeleteParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"Quantity"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"ManageDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"OrderSpecs"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ManageComment"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ManageSubmit"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"SupplierID"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"OrderID"
Type
=
"Int32"
/>
</
UpdateParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"Quantity"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"ManageDate"
Type
=
"DateTime"
/>
<
asp:Parameter
Name
=
"OrderSpecs"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ManageComment"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ManageSubmit"
Type
=
"Boolean"
/>
<
asp:Parameter
Name
=
"SupplierID"
Type
=
"Int32"
/>
</
InsertParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
DeleteCommand="DELETE FROM [Supplier] WHERE [SupplierID] = @SupplierID"
InsertCommand="INSERT INTO [Supplier] ([SupplierName]) VALUES (@SupplierName)"
SelectCommand="SELECT [SupplierID], [SupplierName] FROM [Supplier] ORDER BY [SupplierName]"
UpdateCommand="UPDATE [Supplier] SET [SupplierName] = @SupplierName WHERE [SupplierID] = @SupplierID">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"SupplierID"
Type
=
"Int32"
/>
</
DeleteParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"SupplierName"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"SupplierID"
Type
=
"Int32"
/>
</
UpdateParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"SupplierName"
Type
=
"String"
/>
</
InsertParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource3"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
SelectCommand="SELECT Orders.OrderID, Division.DivisionName, Category.CategoryName, Type.TypeName, Code.CodeName, Item.FullCode, Item.PagesNumber, Item.UnitCost, Item.ItemCost, Item.ReleaseDate, Item.Discontinued, Item.ItemID, Item.ThumbImage FROM Orders INNER JOIN Item ON Orders.ItemID = Item.ItemID INNER JOIN Category ON Item.CategoryID = Category.CategoryID INNER JOIN Division ON Item.DivisionID = Division.DivisionID INNER JOIN Type ON Item.TypeID = Type.TypeID INNER JOIN Code ON Item.CodeID = Code.CodeID WHERE (Orders.OrderID = @OrderID)">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"RadGrid1"
Name
=
"OrderID"
PropertyName
=
"SelectedValue"
Type
=
"Int32"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource4"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:OrderSystemConn %>"
SelectCommand="SELECT Orders.OrderID, Division.DivisionName, Category.CategoryName, Type.TypeName, Code.CodeName, Item.FullCode, Item.PagesNumber, Item.UnitCost, Item.ItemCost, Item.ReleaseDate, Item.Discontinued, Item.ItemID, Item.ThumbImage FROM Orders INNER JOIN Item ON Orders.ItemID = Item.ItemID INNER JOIN Category ON Item.CategoryID = Category.CategoryID INNER JOIN Division ON Item.DivisionID = Division.DivisionID INNER JOIN Type ON Item.TypeID = Type.TypeID INNER JOIN Code ON Item.CodeID = Code.CodeID WHERE (Orders.OrderID = @OrderID)">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"RadGrid1"
Name
=
"OrderID"
PropertyName
=
"SelectedValue"
Type
=
"Int32"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
</
asp:Content
>
<
asp:Content
ID
=
"Content2"
runat
=
"server"
contentplaceholderid
=
"head"
>
<
style
type
=
"text/css"
>
.style3
{
text-align: center;
font-size: x-large;
color: #FFFFFF;
}
</
style
>
</
asp:Content
>