Salesadmin.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Salesadmin.aspx.cs" Inherits="Salesadmin" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">

        .style17
    {
        width: 100%;
        height: 28px;
    }
        .style9
        {
            width: 1124px;
        }
        .style19
        {
            width: 811px;
            height: 130px;
        }
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <p>
        <asp:Label ID="Label7" runat="server" Font-Bold="True" Font-Size="Large" 
            Text="Search here" ForeColor="Black" style="color: #0099CC"></asp:Label>
        <asp:TextBox ID="TextBox7" runat="server" Width="202px"></asp:TextBox>
        <asp:Button ID="Button4" runat="server" Font-Bold="True" style="margin-left: 0px" 
            Text="Go" Width="40px" BackColor="#3366CC" ForeColor="White" 
            onclick="Button4_Click" />
</p>
    <p>
        &nbsp;</p>
<table class="style17">
    <tr>
        <td class="style9" valign="top">
            <br />
            <img alt="" class="style19" src="Photos/image-2.jpg" /></td>
        <td>
            <asp:Menu ID="Menu1" runat="server" BackColor="#003366" 
                DynamicHorizontalOffset="2" Font-Bold="True" Font-Names="Verdana" 
                Font-Size="Small" ForeColor="White" StaticSubMenuIndent="10px">
                <DynamicHoverStyle BackColor="#284E98" ForeColor="White" />
                <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                <DynamicMenuStyle BackColor="#B5C7DE" />
                <DynamicSelectedStyle BackColor="#507CD1" />
                <Items>
                    <asp:MenuItem Text="STAFF" Value="STAFF">
                        <asp:MenuItem NavigateUrl="~/Staff.aspx" Text="New Staff" Value="New Staff">
                        </asp:MenuItem>
                        <asp:MenuItem NavigateUrl="~/Upstaff.aspx" Text="Update" Value="Update">
                        </asp:MenuItem>
                    </asp:MenuItem>
                    <asp:MenuItem Text="Minerals" Value="Minerals" NavigateUrl="Minerals.aspx"></asp:MenuItem>
                    <asp:MenuItem Text="Tagged" Value="Tagged" NavigateUrl="Taggedadmin.aspx"></asp:MenuItem>
                    <asp:MenuItem Text="Sales" Value="Sales" NavigateUrl="Salesadmin.aspx"></asp:MenuItem>
                    <asp:MenuItem Text="Production" Value="Production" 
                        NavigateUrl="Productivityadmin.aspx"></asp:MenuItem>
                    <asp:MenuItem NavigateUrl="Teamadmin.aspx" Text="Team" Value="Team">
                    </asp:MenuItem>
                    <asp:MenuItem Text="Report" Value="Report">
                        <asp:MenuItem NavigateUrl="~/Reportproductivity.aspx" Text="All minerals mined" 
                            Value="SalesReport"></asp:MenuItem>
                        <asp:MenuItem Text="Untagged coltan" Value="TaggedReport" 
                            NavigateUrl="~/Repuntaggedcoltan.aspx"></asp:MenuItem>
                        <asp:MenuItem Text="Untagged cassterite" Value="ProductivityReport" 
                            NavigateUrl="~/Repuntaggedcass.aspx">
                        </asp:MenuItem>
                        <asp:MenuItem Text="Unsold cassterite" Value="StaffReport" 
                            NavigateUrl="~/Repunsoldcass.aspx"></asp:MenuItem>
                        <asp:MenuItem NavigateUrl="ColtanNotsolde.aspx" Text="Unsold Coltan" 
                            Value="Unsold Coltan"></asp:MenuItem>
                        <asp:MenuItem Text="All minerals sold" Value="Sales date report" 
                            NavigateUrl="~/SalesGeneral.aspx"></asp:MenuItem>
                        <asp:MenuItem NavigateUrl="~/ReportStaff.aspx" Text="Staff report" 
                            Value="Staff report"></asp:MenuItem>
                    </asp:MenuItem>
                </Items>
                <StaticHoverStyle BackColor="#284E98" ForeColor="White" />
                <StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                <StaticSelectedStyle BackColor="#507CD1" />
            </asp:Menu>
        </td>
    </tr>
</table>
    <p>
        &nbsp;</p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" 
        CellPadding="3" DataKeyNames="Sales_id" DataSourceID="SqlDataSource1" 
        Width="978px">
        <Columns>
            <asp:CommandField ButtonType="Button" EditText="Update" HeaderText="Option" 
                ShowEditButton="True">
            <ControlStyle BackColor="Lime" Font-Bold="True" Font-Size="Small" 
                ForeColor="White" />
            </asp:CommandField>
            <asp:CommandField ButtonType="Button" HeaderText="Option" 
                ShowDeleteButton="True">
            <ControlStyle BackColor="Red" Font-Bold="True" ForeColor="White" />
            </asp:CommandField>
            <asp:BoundField DataField="Sales_id" HeaderText="Sales_id" ReadOnly="True" 
                SortExpression="Sales_id" />
            <asp:BoundField DataField="Tag_id" HeaderText="Tag_id" 
                SortExpression="Tag_id" />
            <asp:BoundField DataField="Staff_id" HeaderText="Staff_id" 
                SortExpression="Staff_id" />
            <asp:BoundField DataField="Tantale" HeaderText="Tantale" 
                SortExpression="Tantale" />
            <asp:BoundField DataField="Quantity_sold" HeaderText="Quantity_sold" 
                SortExpression="Quantity_sold" />
            <asp:BoundField DataField="Tantale_price" HeaderText="Tantale_price" 
                SortExpression="Tantale_price" />
            <asp:BoundField DataField="Counter_code" HeaderText="Counter_code" 
                SortExpression="Counter_code" />
            <asp:BoundField DataField="Sales_date" HeaderText="Sales_date" 
                SortExpression="Sales_date" />
        </Columns>
        <FooterStyle BackColor="White" ForeColor="#000066" />
        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
        <RowStyle ForeColor="#000066" />
        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#007DBB" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#00547E" />
    </asp:GridView>
    <br />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:SkymineralsConnectionString2 %>" 
        DeleteCommand="DELETE FROM [Minerals_sold] WHERE [Sales_id] = @Sales_id" 
        InsertCommand="INSERT INTO [Minerals_sold] ([Sales_id], [Tag_id], [Staff_id], [Tantale], [Quantity_sold], [Tantale_price], [Counter_code], [Sales_date]) VALUES (@Sales_id, @Tag_id, @Staff_id, @Tantale, @Quantity_sold, @Tantale_price, @Counter_code, @Sales_date)" 
        SelectCommand="SELECT * FROM [Minerals_sold]" 
        
    
    
        UpdateCommand="UPDATE [Minerals_sold] SET [Tag_id] = @Tag_id, [Staff_id] = @Staff_id, [Tantale] = @Tantale, [Quantity_sold] = @Quantity_sold, [Tantale_price] = @Tantale_price, [Counter_code] = @Counter_code, [Sales_date] = @Sales_date WHERE [Sales_id] = @Sales_id">
        <DeleteParameters>
            <asp:Parameter Name="Sales_id" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="Sales_id" Type="String" />
            <asp:Parameter Name="Tag_id" Type="String" />
            <asp:Parameter Name="Staff_id" Type="String" />
            <asp:Parameter Name="Tantale" Type="Double" />
            <asp:Parameter Name="Quantity_sold" Type="Double" />
            <asp:Parameter Name="Tantale_price" Type="Double" />
            <asp:Parameter Name="Counter_code" Type="String" />
            <asp:Parameter Name="Sales_date" Type="DateTime" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="Tag_id" Type="String" />
            <asp:Parameter Name="Staff_id" Type="String" />
            <asp:Parameter Name="Tantale" Type="Double" />
            <asp:Parameter Name="Quantity_sold" Type="Double" />
            <asp:Parameter Name="Tantale_price" Type="Double" />
            <asp:Parameter Name="Counter_code" Type="String" />
            <asp:Parameter Name="Sales_date" Type="DateTime" />
            <asp:Parameter Name="Sales_id" Type="String" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <br />
    <asp:GridView ID="GridView2" runat="server" BackColor="White" 
        BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" 
        CellSpacing="1" GridLines="None">
        <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
        <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
        <RowStyle BackColor="#DEDFDE" ForeColor="Black" />
        <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#594B9C" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#33276A" />
    </asp:GridView>
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    </asp:Content>