-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathDefault.aspx
192 lines (191 loc) · 12.2 KB
/
Default.aspx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" title="Better Neighbors - For the Exchange of Free Stuff Between Neighbors." %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:Label ID="Label2" runat="server" Text="Better Neighbors is your source for offering a helping hand as well as receiving one. The purpose of Better Neighbors is to network people together so that they can share their wealth and need with each other. It is also an attempt to help keep our environment clean, as we share what we have rather than disposing of it into waste fills. If you still have questions please visit the Help! page." Font-Names="Verdana" Font-Size="0.8em" ForeColor="#284775"></asp:Label><br />
<br />
<!-- google_ad_section_start -->
<asp:MultiView ID="MultiView1" runat="server">
<asp:View ID="View1" runat="server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [States] ORDER BY State ASC" UpdateCommand="UPDATE Counties SET Users=Users+1"></asp:SqlDataSource>
<br />
<asp:Label ID="Label1" runat="server" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#284775"
Text="Please Select a State:"></asp:Label>
<asp:DropDownList ID="drpdwnlistSelectState" runat="server" DataSourceID="SqlDataSource1"
DataTextField="State" DataValueField="ID">
</asp:DropDownList>
<asp:Button ID="Button2" runat="server" Text="Go" />
<asp:Button ID="Button3" runat="server" Text="Default." />
<asp:Label ID="Label3" runat="server" Font-Names="Verdana" Font-Size="0.8em" ForeColor="Red"
Text="Sorry, you have to be a member to set a default."></asp:Label></asp:View>
<asp:View ID="View2" runat="server">
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SelectCounties" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="varID" Type="String" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="grdSelectCounties" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None" Visible="False" Width="519px">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="County" HeaderText="County" SortExpression="County" />
<asp:BoundField DataField="State1" HeaderText="State" SortExpression="State1" />
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
</asp:View>
<asp:View ID="View3" runat="server">
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Categories] ORDER BY Category ASC"></asp:SqlDataSource>
<center><asp:Button ID="Button4" runat="server" Text="Show All Available Items." /></center>
<br />
<br />
<asp:GridView ID="GridView2" runat="server" CellPadding="4"
DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None" Visible="False" DataKeyNames="ID" Width="519px" AutoGenerateColumns="False">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" SortExpression="ID" />
<asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" />
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<br />
</asp:View>
<asp:View ID="View4" runat="server">
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SelectItems" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="varCategory" Type="int16" />
<asp:Parameter Name="varCounty" Type="int16" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource7" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="ShowAllItems" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="varCounty" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataSourceID="SqlDataSource4" ForeColor="#333333" GridLines="None" Visible="False" AllowPaging="True" Width="595px">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" SortExpression="ID" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:BoundField DataField="Offerer" HeaderText="Offerer" SortExpression="Offerer" />
<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<EmptyDataTemplate>
<strong><span style="color: #284775; font-family: Verdana"><center>
<br />
<br />
SORRY<br />
We apologize, but at this time there are no items listed in this category. Since
the site is so new, this may be the state for a little while. In the meantime, we
recommend using the
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="ShippableItems.aspx">Shippable Items</asp:HyperLink> page which will show you all items available
across all states where people are willing to ship the items.</center></span></strong>
</EmptyDataTemplate>
</asp:GridView>
</asp:View>
<asp:View ID="View5" runat="server">
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="ShowItem" SelectCommandType="StoredProcedure" UpdateCommand="UpdateStatus" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="varItem" Type="int16" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="varItem" Type="int16" />
<asp:Parameter Name="varStatus" Type="int16" />
<asp:Parameter Name="varUser" Type="string" />
<asp:Parameter Name="varOfferer" Type="string" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" CellPadding="4"
DataSourceID="SqlDataSource5" ForeColor="#333333" GridLines="None" Height="50px"
Width="524px" Visible="False">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
<EditRowStyle BackColor="#999999" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<Fields>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
<asp:BoundField DataField="Offerer" HeaderText="Offerer" SortExpression="Offerer" />
<asp:BoundField DataField="State1" HeaderText="State" SortExpression="State1" />
<asp:BoundField DataField="County1" HeaderText="County" SortExpression="County1" />
<asp:BoundField DataField="Category1" HeaderText="Category" SortExpression="Category1" />
<asp:BoundField DataField="DatePosted" HeaderText="Date Posted" SortExpression="DatePosted" />
<asp:BoundField DataField="Status" HeaderText="Status" SortExpression="Status" />
<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
</Fields>
<FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:DetailsView>
<div style="z-index: 101; left: 461px; width: 137px; position: absolute; top: 1103px;
height: 100px">
<asp:Label ID="Label4" runat="server" Font-Names="Verdana" Font-Size="0.8em" ForeColor="Red"
Text="Sorry, but only registered users can request an item. The good news is - registeration is free!"></asp:Label></div>
<asp:Button ID="Button1" runat="server" Text="Request Item." Width="147px" />
<br />
</asp:View>
</asp:MultiView>
<!-- google_ad_section_end -->
<asp:SqlDataSource ID="SqlDataSource6" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" runat="server">
</asp:SqlDataSource>
<br />
<span style="font-size: 0.8em; font-family: Verdana"></span>
<br />
<!-- google_ad_section_start -->
<strong><center>The Place to Find Free Stuff!</center>
<center>
</center>
<center>
Other David Mackey Sites:<br />
<a href="http://www.dhq.nu/churchresources/">Church Resources.</a> - <a href="http://www.dhq.nu/christianfilms/">
Christian & Family Films.</a> - <a href="http://www.dhq.nu/koinegreek/">Koine Greek
Open Source Audio.</a> - <a href="http://www.dhq.nu/freewargames/">Free Computer War
and Strategy Games.</a> -<br />
<a href="http://www.dhq.nu/freewargames/"></a><a href="http://www.gamesecretary.com/">
GameSecretary.Com</a> - <a href="http://www.dhq.nu/hutsell/">W.R. Hutsell's Games.</a>
- <a href="http://www.dhq.nu/wanderingmind/">Wandering Mind's Quotation Collection.</a> <br />
- <a href="http://www.civilwarsearch.com/">Civil War Search Directory</a>.<br />
<span style="font-size: 8pt"><strong>
<br />
Copyright 2006 by David Mackey. All Rights Reserved.</strong></span></center>
</strong><br />
<!-- google_ad_section_end -->
<br />
<br />
<br />
<br />
</asp:Content>