-
Notifications
You must be signed in to change notification settings - Fork 0
/
Adhikar.aspx
159 lines (142 loc) · 7.12 KB
/
Adhikar.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
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Adhikar.aspx.cs" Inherits="Adhikar1" %>
<!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></title>
<link href="themes2/bootstrap.css" rel="stylesheet" type="text/css" />
<script src="themes2/bootstrap.min.js" type="text/javascript"></script>
<script src="themes2/carbon.js" type="text/javascript"></script>
<script src="themes2/custom.js" type="text/javascript"></script>
<link href="themes2/custom.min.css" rel="stylesheet" type="text/css" />
<script src="themes2/gsd.js" type="text/javascript"></script>
<script src="themes2/ga.js" type="text/javascript"></script>
<script src="themes2/jquery-1.10.2.min.js" type="text/javascript"></script>
<style type="text/css">
.style1
{
width: 1017px;
}
.style2
{
width: 39px;
}
</style>
</head>
<body>
<form id="form1" runat="server" class="form-horizontal">
<div class="jumbotron">
<center>
<table width="100%">
<tr><td class="style2"></td><td align="center" class="style1">
<h1>Adhikar Patra Information</h1></td>
<td align="right">
<asp:ImageButton ID="ImageButton1" runat="server" Height="60px"
ImageUrl="~/icons/next.png" PostBackUrl="~/Adhikar1.aspx"
ToolTip="Enter New Adhikar Patra Information" Width="60px" /></td>
</tr>
</table>
</center>
</div>
<div class="progress">
<div class="progress-bar" style="width: 100%;"></div>
</div>
<div class="jumbotron">
<fieldset>
<div class="form-group">
<asp:Label ID="lblSelectYear" runat="server" Text="Select Year" CssClass="col-lg-3 control-label"></asp:Label>
<div class="col-lg-5">
<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Year" DataValueField="Year" AutoPostBack="True" CssClass="dropdown">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT DISTINCT [Year] FROM [SchoolTable] WHERE ([Year] IS NOT NULL)">
</asp:SqlDataSource>
</div></div>
<div class="form-group">
<asp:Label ID="lblSelectSchoolName" runat="server" Text="Select School Name" CssClass="col-lg-3 control-label"></asp:Label>
<div class="col-lg-5">
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource1"
DataTextField="SchoolName" DataValueField="SchoolName" AutoPostBack="True" CssClass="dropdown">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT DISTINCT [SchoolName] FROM [UnitLeaderTable] WHERE (([Year] = @Year) AND ([SchoolName] IS NOT NULL))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="Year"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div></div>
<div class="form-group">
<asp:Label ID="lblUnitName" runat="server" Text="Select Unit Name" CssClass="col-lg-3 control-label"></asp:Label>
<div class="col-lg-5">
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="Sqlds"
DataTextField="UnitName" DataValueField="UnitName" AutoPostBack="True" CssClass="dropdown">
</asp:DropDownList>
<asp:SqlDataSource ID="Sqlds" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [UnitName] FROM [UnitLeaderTable] WHERE (([Year] = @Year) AND ([SchoolName] = @SchoolName) AND ([UnitName] IS NOT NULL))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="Year"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList2" Name="SchoolName"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div></div>
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlFullName"
Width="100%">
<ItemTemplate>
<div class="form-group"><div class="col-lg-5">
<a href='Adhikar2.aspx?FullName=<%# Eval("FullName") %>&Year=<%#Eval("Year") %>&SchoolName=<%#Eval("SchoolName") %>&UnitName=<%#Eval("UnitName") %>' class="col-lg-9 control-label"><asp:Label ID="FullNameLabel" runat="server" Text='<%# Eval("FullName") %>' /></a>
</div></div>
</ItemTemplate>
<SeparatorTemplate>
<hr width="1px" />
</SeparatorTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlFullName" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [FullName], [Year], [SchoolName], [UnitName] FROM [UnitLeaderTable] WHERE (([SchoolName] = @SchoolName) AND ([UnitName] = @UnitName) AND ([Year] = @Year))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList2" Name="SchoolName"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="UnitName"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList3" Name="Year"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</fieldset>
<hr />
<center>
<div>
<table style="height:113px;">
<tr><td rowspan="2" width="107px" align="center">
<asp:Image ID="Image1" runat="server" Height="100px" ImageUrl="~/icons/eseva.jpg"
Width="100px" />
</td><td width="228px">
<center>
<asp:HyperLink ID="HyperLink1" runat="server" Font-Bold="True"
Font-Size="Large" ForeColor="#0099FF" NavigateUrl="~/Admin2.aspx">Back</asp:HyperLink></center>
</td><td width="228px">
<center>
<asp:HyperLink ID="HyperLink2" runat="server" Font-Bold="True"
Font-Size="Large" ForeColor="#0099FF" NavigateUrl="~/Admin2.aspx">Home</asp:HyperLink></center>
</td><td rowspan="2" width="107px" align="center">
<asp:Image ID="Image2" runat="server" Height="100px" ImageUrl="~/icons/eseva.jpg"
Width="100px" />
</td></tr>
<tr><td colspan="2" >
<center>
<marquee behavior="alternate"><asp:HyperLink ID="HyperLink3" runat="server" Font-Bold="True"
Font-Size="Large" ForeColor="#0099FF" NavigateUrl="~/Developers.aspx">Developer's Site</asp:HyperLink></marquee></center>
</td></tr>
</table>
</div>
</center>
</div>
</form>
</body>
</html>