Counter.aspx

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

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
    .style4
        {
            width: 68%;
        }
        .style6
        {
            width: 153px;
            height: 40px;
        }
        .style7
        {
            height: 40px;
        }
        .style9
        {
            width: 51%;
        }
        .style12
        {
            height: 42px;
            width: 123px;
        }
        .style13
        {
            height: 42px;
            width: 119px;
        }
        .style11
        {
            height: 42px;
        }
        .style14
    {
        height: 42px;
        width: 362px;
    }

        .style17
    {
        width: 100%;
        height: 28px;
    }
    .style18
    {
        width: 810px;
    }
        .style19
        {
            width: 762px;
            height: 119px;
        }
        </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="style18" valign="top">
            <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="Sales" Value="Sales">
                        <asp:MenuItem NavigateUrl="Sales.aspx" Text="Add Minerals Sold" 
                            Value="Add Minerals Sold">
                        </asp:MenuItem>
                        <asp:MenuItem NavigateUrl="Soldlist.aspx" Text="Sales List" Value="Sales List">
                        </asp:MenuItem>
                    </asp:MenuItem>
                    <asp:MenuItem NavigateUrl="Counter.aspx" Text="Counters" Value="Counters">
                    </asp:MenuItem>
                    <asp:MenuItem NavigateUrl="Mineralslist2.aspx" Text="Minerals" Value="Minerals">
                    </asp:MenuItem>
                    <asp:MenuItem NavigateUrl="Salestagged.aspx" Text="Tagged Minerals" 
                        Value="Tagged Minerals"></asp:MenuItem>
                    <asp:MenuItem Text="Report" Value="Report">
                        <asp:MenuItem Text="Unsold coltan" Value="Sales Report" 
                            NavigateUrl="ColtanNotsolde.aspx"></asp:MenuItem>
                        <asp:MenuItem NavigateUrl="Repunsoldcass.aspx" Text="Unsold Cassterite" 
                            Value="Range report"></asp:MenuItem>
                        <asp:MenuItem NavigateUrl="SalesGeneral.aspx" Text="Total Sales report" 
                            Value="Total Sales report"></asp:MenuItem>
                    </asp:MenuItem>
                </Items>
                <StaticHoverStyle BackColor="#284E98" ForeColor="White" />
                <StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
                <StaticSelectedStyle BackColor="#003300" />
            </asp:Menu>
        </td>
    </tr>
</table>
    <p>
    
    <br />
</p>
    <asp:Panel ID="Panel1" runat="server" Height="334px" Width="737px" 
        BackColor="#99CCFF">
        <br />
        <table class="style4">
            <tr>
                <td class="style6">
                    &nbsp;</td>
                <td class="style6">
                    <asp:Label ID="Label12" runat="server" Font-Bold="True" Font-Size="Medium" 
                        style="color: #000000" Text="Counter_code"></asp:Label>
                </td>
                <td class="style7">
                    <asp:TextBox ID="textcode" runat="server" Width="221px" Font-Italic="False" 
                        Font-Size="Medium" Height="25px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style6">
                    &nbsp;</td>
                <td class="style6">
                    <asp:Label ID="Label13" runat="server" Font-Bold="True" Font-Size="Medium" 
                        style="color: #000000" Text="Name"></asp:Label>
                </td>
                <td class="style7">
                    <asp:TextBox ID="txtname" runat="server" Width="221px" Height="25px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style6">
                    &nbsp;</td>
                <td class="style6">
                    <asp:Label ID="Label14" runat="server" Font-Bold="True" Font-Size="Medium" 
                        style="color: #000000" Text="Location"></asp:Label>
                </td>
                <td class="style7">
                    <asp:TextBox ID="txtlocation" runat="server" Width="221px" Height="25px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style6">
                    &nbsp;</td>
                <td class="style6">
                    <asp:Label ID="Label15" runat="server" Font-Bold="True" Font-Size="Medium" 
                        style="color: #000000" Text="Telephone"></asp:Label>
                </td>
                <td class="style7">
                    <asp:TextBox ID="txtphone" runat="server" Height="25px" Width="221px"></asp:TextBox>
                </td>
            </tr>
        </table>
        <br />
        <br />
        <table class="style9">
            <tr>
                <td class="style14">
                    &nbsp; &nbsp;</td>
                <td class="style12">
                    <asp:Button ID="Button13" runat="server" BackColor="#3366CC" Height="34px" 
                        style="margin-left: 108px" Text="Add" Width="168px" 
                        onclick="Button13_Click" Font-Bold="True" Font-Size="Medium" 
                        ForeColor="White" />
                </td>
                <td class="style13">
                    &nbsp;</td>
                <td class="style11">
                    &nbsp;</td>
            </tr>
        </table>
        <br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConflictDetection="CompareAllValues" 
            ConnectionString="<%$ ConnectionStrings:SkymineralsConnectionString2 %>" 
            DeleteCommand="DELETE FROM [Counter] WHERE [Counter_code] = @original_Counter_code AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL)) AND (([Location] = @original_Location) OR ([Location] IS NULL AND @original_Location IS NULL)) AND (([Telephone] = @original_Telephone) OR ([Telephone] IS NULL AND @original_Telephone IS NULL))" 
            InsertCommand="INSERT INTO [Counter] ([Counter_code], [Name], [Location], [Telephone]) VALUES (@Counter_code, @Name, @Location, @Telephone)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [Counter]" 
            UpdateCommand="UPDATE [Counter] SET [Name] = @Name, [Location] = @Location, [Telephone] = @Telephone WHERE [Counter_code] = @original_Counter_code AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL)) AND (([Location] = @original_Location) OR ([Location] IS NULL AND @original_Location IS NULL)) AND (([Telephone] = @original_Telephone) OR ([Telephone] IS NULL AND @original_Telephone IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_Counter_code" Type="String" />
                <asp:Parameter Name="original_Name" Type="String" />
                <asp:Parameter Name="original_Location" Type="String" />
                <asp:Parameter Name="original_Telephone" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Counter_code" Type="String" />
                <asp:Parameter Name="Name" Type="String" />
                <asp:Parameter Name="Location" Type="String" />
                <asp:Parameter Name="Telephone" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Name" Type="String" />
                <asp:Parameter Name="Location" Type="String" />
                <asp:Parameter Name="Telephone" Type="String" />
                <asp:Parameter Name="original_Counter_code" Type="String" />
                <asp:Parameter Name="original_Name" Type="String" />
                <asp:Parameter Name="original_Location" Type="String" />
                <asp:Parameter Name="original_Telephone" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />
        <br />
        <br />
        <br />
        &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    </asp:Panel>
    <br />
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="Label17" runat="server" Font-Bold="True" Font-Size="Medium" 
        Font-Underline="True" Text="LIST OF MINING COUNTERS "></asp:Label>
    <br />
    <br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="Counter_code" DataSourceID="SqlDataSource1" 
        BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" 
        CellPadding="3">
        <Columns>
            <asp:BoundField DataField="Counter_code" HeaderText="Counter_code" 
                ReadOnly="True" SortExpression="Counter_code" />
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            <asp:BoundField DataField="Location" HeaderText="Location" 
                SortExpression="Location" />
            <asp:BoundField DataField="Telephone" HeaderText="Telephone" 
                SortExpression="Telephone" />
        </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 />
    <br />
    <br />
    <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 />
</asp:Content>