<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RpScriptManager"
runat
=
"server"
>
<
Scripts
>
<%--Needed for JavaScript IntelliSense in VS2010--%>
<%--For VS2008 replace RadScriptManager with ScriptManager--%>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/>
</
Scripts
>
</
telerik:RadScriptManager
>
<
script
type
=
"text/javascript"
>
//Put your JavaScript code here.
</
script
>
<
telerik:RadAjaxManager
ID
=
"RpAjaxManager"
runat
=
"server"
>
</
telerik:RadAjaxManager
>
<
telerik:RadSkinManager
ID
=
"RpSkinManager"
runat
=
"server"
Skin
=
"Black"
>
</
telerik:RadSkinManager
>
<
div
>
<!-- Logo & Navigation -->
<
div
class
=
"logo"
>
<
div
style
=
"float: right; width: 150px; margin: 40px 10px 10px 10px"
>
<
asp:ImageButton
runat
=
"server"
ID
=
"loginBtn"
ImageUrl
=
"../styles/images/login.png"
Width
=
"30px"
Height
=
"30px"
ToolTip
=
"Login"
OnClick
=
"loginBtn_Click"
/>
<
asp:ImageButton
runat
=
"server"
ID
=
"registerBtn"
ImageUrl
=
"../styles/images/signIn.png"
Width
=
"30px"
Height
=
"30px"
ToolTip
=
"Create new account"
Style
=
"margin-left: 10px"
OnClick
=
"registerBtn_Click"
/>
<
asp:ImageButton
runat
=
"server"
ImageUrl
=
"~/styles/images/logout.png"
ID
=
"logoutBtn"
Width
=
"30px"
Height
=
"30px"
ToolTip
=
"Log Out"
Visible
=
"false"
OnClick
=
"logoutBtn_Click"
/>
<
asp:Label
runat
=
"server"
ID
=
"userNameLbl"
Font-Size
=
"18px"
ForeColor
=
"White"
Visible
=
"false"
/>
</
div
>
<
div
id
=
"navigation"
>
<
telerik:RadMenu
ID
=
"MainMenu"
runat
=
"server"
Skin
=
"Bond"
EnableEmbeddedBaseStylesheet
=
"False"
EnableEmbeddedSkins
=
"False"
EnableTextHTMLEncoding
=
"true"
>
<
Items
>
<
telerik:RadMenuItem
runat
=
"server"
Text
=
"Main"
NavigateUrl
=
"~/Default.aspx"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
Text
=
"Investment Scheme"
NavigateUrl
=
"~/Pages/InvestScheme.aspx"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"~/Pages/Products.aspx"
Text
=
"Products"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"~/Pages/Help.aspx"
Text
=
"Need help"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"~/Pages/Support.aspx"
Text
=
"Support"
>
</
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenu
>
</
div
>
</
div
>
<!-- Content -->
<
telerik:RadFormDecorator
ID
=
"RpFormDecorator"
runat
=
"server"
Skin
=
"Black"
DecorationZoneID
=
"displayWizard"
DecoratedControls
=
"LoginControls"
/>
<
div
id
=
"regZone"
style
=
"width: 900px; margin: 0 auto"
align
=
"center"
>
<
asp:Image
runat
=
"server"
ID
=
"newUserImg"
ImageUrl
=
"~/styles/images/Actions-list-add-user-icon.png"
Width
=
"256px"
Height
=
"256px"
Style
=
"float: left; margin: 5px 20px 5px 60px"
/>
<
div
id
=
"displayWizard"
style
=
"padding-top: 50px"
>
<
asp:CreateUserWizard
ID
=
"CreateUserWizard1"
runat
=
"server"
FinishDestinationPageUrl
=
"~/Pages/User/Profile.aspx"
ContinueDestinationPageUrl
=
"~/Pages/User/Profile.aspx"
>
<
WizardSteps
>
<
asp:CreateUserWizardStep
ID
=
"CreateUserWizardStep1"
runat
=
"server"
>
</
asp:CreateUserWizardStep
>
<
asp:CompleteWizardStep
ID
=
"CompleteWizardStep1"
runat
=
"server"
>
</
asp:CompleteWizardStep
>
</
WizardSteps
>
</
asp:CreateUserWizard
>
</
div
>
</
div
>
<!-- Footer -->
<
br
class
=
"cleared"
/>
<
div
class
=
"footer"
>
</
div
>
</
div
>
</
form
>
<telerik:radgrid id="RadGrid1"
runat="server"
AllowAutomaticDeletes="True"
AllowSorting="True"
AllowPaging="True"
PagerStyle-HorizontalAlign="Center"
AllowMultiRowEdit="false"
AllowMultiRowSelection="false"
OnItemDataBound="RadGrid1_ItemDataBound"
OnItemUpdated="RadGrid1_ItemUpdated"
OnUpdateCommand="RadGrid1_ItemUpdate"
OnSelectedIndexChanged="RadGrid1_SelectedIndexChanged"
OnNeedDataSource="RadGrid1_NeedDataSource"
GridLines="None">
<ClientSettings EnablePostBackOnRowClick="true" >
<Selecting AllowRowSelect="True" />
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
<MasterTableView runat="server"
DataKeyNames="CaseNbr, Article, Item"
AllowSorting="true"
CommandItemDisplay="Top"
AutoGenerateColumns="false">
<EditFormSettings EditFormType="Template">
<EditColumn UniqueName="EditColumn"></EditColumn>
<FormTemplate>
<table>
<tr>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
<CommandItemSettings ShowAddNewRecordButton="false" ShowRefreshButton="true" />
<Columns>
<telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" HeaderText="Select" HeaderStyle-HorizontalAlign="Left" ItemStyle-Width="20px"></telerik:GridClientSelectColumn>
<telerik:GridBoundColumn DataField="RecCode" UniqueName="RecCode" Visible="false"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CaseNbr" HeaderText="Case Nbr" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" UniqueName="CaseNbr" SortExpression="CaseNbr" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Vic1" HeaderText="Victim" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" UniqueName="Vic1" SortExpression="Vic1" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Item" HeaderText="Item" HeaderStyle-Font-Bold="true" UniqueName="Item" SortExpression="Item" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Article" HeaderText="Art" HeaderStyle-Font-Bold="true" UniqueName="Article" SortExpression="Article" HeaderStyle-HorizontalAlign="Center"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ArticleType" HeaderText="Art Type" HeaderStyle-Font-Bold="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" HeaderStyle-Wrap="true" UniqueName="ArticleType" SortExpression="ArticleType" Visible="true"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ArticleName" HeaderText="Art Name" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="ArticleName" SortExpression="ArticleName" Visible="true" ></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SerialNbr" HeaderText="Serial #" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="SerialNbr" SortExpression="SerialNbr" Visible="true"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Location" HeaderText="Loc" HeaderStyle-Font-Bold="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="Location" SortExpression="Location"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="NextAct" HeaderText="NextAct" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="NextAct" SortExpression="NextAct"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="NextActDate" HeaderText="Next Date" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="NextActDate" SortExpression="NextActDate"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FinalAct" HeaderText="FinalAct" HeaderStyle-Font-Bold="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="FinalAct" SortExpression="FinalAct" ItemStyle-Width="50px"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FinalActDate" HeaderText="Final Date" HeaderStyle-Font-Bold="true" HeaderStyle-Wrap="true" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="true" UniqueName="FinalActDate" SortExpression="FinalActDate"> </telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn" ButtonType="ImageButton"
CancelImageUrl="~/Images/filterCancel.png"
UpdateImageUrl="~/Images/selecttag.png"
InsertImageUrl="~/Images/selecttag.png">
</EditColumn>
<FormTemplate>
<table>
<tr>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
<CommandItemTemplate>
<table>
<tr>
<td style="width:30%"> </td>
<td>
<asp:LinkButton ID="LinkButton8" OnClick="Gang_Update_Click" Text="Gang Update" Runat="server" Font-Size="Large" ForeColor="DarkRed" Font-Underline="true" Font-Bold="true" ToolTip="Update Selected Item"></asp:LinkButton>
</td>
<td style="width:28%; text-align:right;">
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/Refresh.gif" CommandName="Rebind" ToolTip="Refresh" />
</td>
<td style="width:1%; text-align:right; vertical-align:top">
<asp:LinkButton ID="LinkButton1" Text="Refresh" CommandName="Rebind" Runat="server"></asp:LinkButton>
</td>
<td style="width:1%"> </td>
</tr>
</table>
</CommandItemTemplate>
</MasterTableView>
<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True">
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
<Selecting AllowRowSelect="True" />
</ClientSettings>
<FilterMenu EnableImageSprites="False">
</FilterMenu>
</telerik:radgrid>
namespace
Evidence.Forms
{
public partial class Results : System.Web.UI.Page
{
private string gridMessage = null;
string status = "";
string qType = "";
string casenbr = "";
string item = "";
string art = "";
string article = "";
string name = "";
string arttype = "";
string artname = "";
string sernbr = "";
string fdate;
string tdate;
string uName = "";
//DateTime fdate;
//DateTime tdate;
static string prevPage = String.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string userName = HttpContext.Current.User.Identity.Name;
Session[
"Name"] = userName.Substring(userName.LastIndexOf('\\') + 1);
uName = userName.Substring(userName.LastIndexOf(
'\\') + 1);
Evidence_UserCollection records = new Evidence_UserCollection().Where("UserName", uName).Load();
Session[
"Access"] = "";
RadMenu menu = (RadMenu)Master.FindControl("RadMenu1");
RadMenuItem admin = menu.FindItemByText("Administration");
RadMenuItem delete = menu.FindItemByText("Delete");
//admin = menu.FindItemByText("Access");
// configure access prive based on role assigned
if (records.Count() > 0)
{
//GridItem cmdItem = RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)[0];
Evidence_User record = records.First();
switch (record.RoleId)
{
case 1:
admin.Visible =
true;
//cmdItem.FindControl("LinkButton2").Visible = true;
//cmdItem.FindControl("LinkButton3").Visible = true;
break;
case 2:
admin.Visible =
false;
//cmdItem.FindControl("LinkButton2").Visible = false;
//cmdItem.FindControl("LinkButton3").Visible = false;
break;
default:
admin.Visible =
false;
//cmdItem.FindControl("LinkButton2").Visible = false;
//cmdItem.FindControl("LinkButton3").Visible = false;
break;
}
}
Evidence_UserCollection users = new Evidence_UserCollection().Where("UserName", uName).Load();
Session[
"Access"] = "";
if (users.Count() > 0)
{
RadGrid1.MasterTableView.Columns[11].Visible =
true;
}
else
{
RadGrid1.MasterTableView.Columns[11].Visible =
false;
}
// first retrieve the query type and values and run the stored proc
//status = Request.QueryString["status"].ToUpper();
qType = Request.QueryString[
"qType"].ToUpper();
name = Request.QueryString[
"name"].ToUpper();
casenbr = Request.QueryString[
"casenbr"].ToUpper();
item = Request.QueryString[
"item"].ToUpper();
art = Request.QueryString[
"art"].ToUpper();
arttype = Request.QueryString[
"arttype"].ToUpper();
artname = Request.QueryString[
"artname"].ToUpper();
sernbr = Request.QueryString[
"sernbr"].ToUpper();
if (string.IsNullOrEmpty(name))
{
name =
null;
}
if (string.IsNullOrEmpty(casenbr))
{
casenbr =
null;
}
if (string.IsNullOrEmpty(item))
{
item =
null;
}
if (string.IsNullOrEmpty(art))
{
art =
null;
}
if (string.IsNullOrEmpty(arttype))
{
arttype =
null;
}
if (string.IsNullOrEmpty(artname))
{
artname =
null;
}
if (string.IsNullOrEmpty(sernbr))
{
sernbr =
null;
}
fdate = Request.QueryString[
"fDate"];
tdate = Request.QueryString[
"tDate"];
Session[
"status"] = status;
Session[
"qtype"] = qType;
Session[
"name"] = name;
Session[
"casenbr"] = casenbr;
Session[
"item"] = item;
Session[
"art"] = art;
Session[
"arttype"] = arttype;
Session[
"artname"] = artname;
Session[
"sernbr"] = sernbr;
Session[
"fdate"] = fdate;
Session[
"tdate"] = tdate;
if (!string.IsNullOrEmpty(fdate))
{
fdate = fdate.Substring(1, fdate.IndexOf(
" ") - 1);
}
if (!string.IsNullOrEmpty(tdate))
{
tdate = tdate.Substring(1, tdate.IndexOf(
" ") - 1);
}
if (RadGrid1.Items.Count > 0)
{
RadGrid1.DataBind();
}
}
}
protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
//status = Request.QueryString["status"].ToUpper();
qType = Request.QueryString[
"qType"].ToUpper();
name = Request.QueryString[
"name"].ToUpper();
casenbr = Request.QueryString[
"casenbr"].ToUpper();
item = Request.QueryString[
"item"].ToUpper();
art = Request.QueryString[
"art"].ToUpper();
arttype = Request.QueryString[
"arttype"].ToUpper();
artname = Request.QueryString[
"artname"].ToUpper();
sernbr = Request.QueryString[
"sernbr"].ToUpper();
fdate = Session[
"fdate"].ToString();
tdate = Session[
"tdate"].ToString();
DataSet ds = SPs.Get_Evidence(qType, name, casenbr, item, art, arttype, artname, sernbr, fdate, tdate, status).GetDataSet();
RadGrid1.VirtualItemCount = ds.Tables[0].Rows.Count;
RadGrid1.DataSource = ds;
}
<script type=
"text/javascript"
>
function
openWin() {
radopen(
null
,
"RadWindow1"
);
}
</script>
Private
Sub
RadGrid1_ItemDataBound(sender
As
Object
, e
As
Telerik.Web.UI.GridItemEventArgs)
Handles
RadGrid1.ItemDataBound
If
TypeOf
e.Item
Is
Telerik.Web.UI.GridDataItem
Then
Dim
dataItem
As
Telerik.Web.UI.GridDataItem =
DirectCast
(e.Item, Telerik.Web.UI.GridDataItem)
Dim
btnImage
As
Button =
DirectCast
(dataItem(
"column2"
).Controls(0), Button)
btnImage.Attributes.Add(
"OnClick"
,
"openWin(); return false;"
)
End
If
End
Sub
Id |
Desc |
Stats |
Action |
0 |
asas |
T |
A |
11 |
Public |
T |
A |
12 | asdgf | T | A |
888 | ghjk; | T | A |