or
<
telerik:RadGrid
runat
=
"server"
ID
=
"RadGrid1"
AllowPaging
=
"True"
AllowSorting
=
"True"
PageSize
=
"20"
AllowFilteringByColumn
=
"True"
EnableViewState
=
"False"
AutoGenerateColumns
=
"False"
Skin
=
"Office2007"
GridLines
=
"None"
OnItemCreated
=
"RadGrid1_ItemCreated"
OnPreRender
=
"RadGrid1_PreRender"
OnNeedDataSource
=
"PC_NeedDataSource"
>
<
telerik:GridBoundColumn
SortExpression
=
"ClientName"
DataField
=
"ClientName"
HeaderText
=
"Client Name"
HeaderStyle-Width
=
"300px"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxClientName"
DataTextField
=
"ClientName"
DataValueField
=
"ClientName"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientName").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="ClientNameIndexChanged" Skin="Office2007">
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ClientNameIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
if (args.get_item().get_value() == "0") { tableView.filter("ClientName", args.get_item().get_value(), "NoFilter");
}
else {
tableView.filter("ClientName", args.get_item().get_value(), "EqualTo");
}
}
</
script
> </
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridBoundColumn
>
protected void RadGrid1_ItemCreated(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridFilteringItem)
{
GridFilteringItem filterItem = (GridFilteringItem)e.Item;
RadComboBox combo = (RadComboBox)filterItem["ClientName"].FindControl("RadComboBoxClientName");
if (Session["AdvisorClientID"] == null)
{
ClientDataContext db = new ClientDataContext();
var clients = (from c in db.Clients
select new
{
c.ClientID,
c.ClientName,
})
.OrderBy(c => c.ClientName);
combo.DataSource = clients;
RadComboBoxItem newItem = new RadComboBoxItem();
newItem.Text = "*** ALL ***";
newItem.Value = "0";
combo.Items.Insert(0, newItem);
int test = RadGrid1.MasterTableView.FilterExpression.IndexOf("ClientName = \"");
if (test > 0)
{
string clientName = RadGrid1.MasterTableView.FilterExpression.Replace("(ClientName = \"", "");
clientName = clientName.Replace("\")", "");
combo.SelectedValue = clientName;// combo.FindItemByValue(clientName);
}
}
else
{
combo.Visible = false;
}
}
}
.PlannerItemColorScheme
12
Color
00
{
background-color
:
#72EDDE
; }
protected
void
RadScheduler1_AppointmentDataBound(
object
sender, Telerik.Web.UI.SchedulerEventArgs e)
{
e.Appointment.CssClass =
"MyCustomAppointmentStyle"
;
}
<
a
href
=
"http://~#~CURRENT_SERVER~#~/_blogcontrol/a.aspx?~#~approveURL~#~"
>APPROVE THIS COMMENT</
a
>
txtEmailContent.ContentFilters = Telerik.Web.UI.EditorFilters.None;
<
script
type
=
"text/javascript"
>
Telerik.Web.UI.RadWebControl.prototype._clearParentShowHandlers = function ()
{
var array = this._invisibleParents;
for (var i = 0; i <
array.length
; i++)
{
this.remove_parentShown(array[i]);
}
this._invisibleParents = [];
this._parentShowDelegate
=
null
;
}
</script>
Parent Window
<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/IPSMaster.Master" CodeBehind="WBC IMP Timberline Data.aspx.vb" Inherits="IPS_Gateway.WBC_IMP_Timberline_Data" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="act" %>
<
asp:Content
ID
=
"cntMain"
ContentPlaceHolderID
=
"cphMainContent"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ShowImportDetail(ExecutionId) {
var NewWindow = window.radopen("WBF IMP Timberline Data Detail Popup.aspx?ImportExecutionID=" + ExecutionId, "rwdImportDetail");
NewWindow.set_modal(true);
}
</
script
>
<
asp:SqlDataSource
ID
=
"SQLDS_ImportList"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="[Imports].[DSP_SELECT-ImportProcesses]" />
<
asp:SqlDataSource
ID
=
"SQLDS_ImportLogHeader"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="[Imports].[DSP_SELECT-ImportHeader]" />
<
asp:panel
ID
=
"pnlPage"
runat
=
"server"
SkinId
=
"skn_GPC01_Panel_MainContent"
>
<
asp:panel
ID
=
"pnlPageHeader"
runat
=
"server"
cssClass
=
"css_GPC01_Panel_PageHeading"
>
<
telerik:RadToolBar
ID
=
"rtbImportData"
runat
=
"server"
AutoPostBack
=
"false"
EnableEmbeddedSkins
=
"True"
OnButtonClick
=
"rtbImportData_ButtonClick"
Skin
=
"Black"
>
<
Items
>
<
telerik:RadToolBarButton
runat
=
"server"
CommandName
=
"tbtClearSelection"
ImageUrl
=
"~/App_Themes/Images/Redo Undo/Undo Green 16.png"
Text
=
"Clear Selected Items"
ToolTip
=
"Clear Selected Itmes"
/>
<
telerik:RadToolBarButton
runat
=
"server"
CommandName
=
"tbtRequeryImportDetail"
ImageUrl
=
"~/App_Themes/Images/Reload/Reload Blue 16.png"
Text
=
"Refresh Import Detail"
ToolTip
=
"Requery Import Detail Grid"
/>
<
telerik:RadToolBarButton
runat
=
"server"
CommandName
=
"tbtImportData"
ImageUrl
=
"~/App_Themes/Images/Processing/Import Data Blue 16.ico"
Text
=
"Import Data"
ToolTip
=
"Import Data"
/>
</
Items
>
</
telerik:RadToolBar
>
<
asp:Label
ID
=
"txtPageTitle"
runat
=
"server"
CssClass
=
"css_GPC01_Label_PageTitle"
Text
=
"Import Timberline Data"
/>
<
asp:ImageButton
ID
=
"ibtPageInformation"
runat
=
"server"
SkinID
=
"skn_GPC01_ImageButton_PageInformation"
/>
<
asp:HiddenField
ID
=
"hdfObjectID"
runat
=
"server"
/>
</
asp:panel
>
<
asp:Panel
ID
=
"pnlPageContent"
runat
=
"server"
cssClass
=
"css_GPC01_Panel_PageContent"
>
<
asp:UpdatePanel
ID
=
"uppUpdateList"
runat
=
"server"
>
<
ContentTemplate
>
<%-- Hidden fields are used to store the values for the select parameters for the SQLDataSource SQLDS_ImportLogHeader--%>
<
asp:HiddenField
ID
=
"hdfStartId"
runat
=
"server"
Value
=
"1"
EnableViewState
=
"true"
/>
<
asp:HiddenField
ID
=
"hdfEndId"
runat
=
"server"
Value
=
"10000"
EnableViewState
=
"true"
/>
<
asp:Timer
ID
=
"tmrImportStatus"
runat
=
"server"
Interval
=
"5000"
></
asp:Timer
>
<
asp:Label
ID
=
"lblRecordsSelected"
runat
=
"server"
CssClass
=
"css_GFS01_Label_Small"
Text
=
"Records Selected:"
/>
<
asp:TextBox
ID
=
"txtRecordsSelectedCount"
runat
=
"server"
CssClass
=
"css_GFS01_Text_MediumLeft"
Text
=
"0"
Width
=
"25px"
BorderStyle
=
"None"
/>
<
asp:TextBox
ID
=
"txtRecordsSelected"
runat
=
"server"
CssClass
=
"css_GFS01_Text_MediumLeft"
Width
=
"740"
/>
<
asp:TextBox
ID
=
"txtImportStatus"
runat
=
"server"
CssClass
=
"css_GFS01_Text_Status"
Text
=
"Idle"
Width
=
"100px"
/>
<
telerik:RadGrid
ID
=
"rgvImportList"
runat
=
"server"
DataSourceID
=
"SQLDS_ImportList"
AllowPaging
=
"True"
ItemStyle-Wrap
=
"false"
AutoGenerateColumns
=
"False"
Height
=
"137px"
Width
=
"1038px"
PageSize
=
"4"
GridLines
=
"None"
Skin
=
"Web20"
>
<
ItemStyle
Wrap
=
"False"
/>
<
MasterTableView
DataKeyNames
=
"ImportID"
DataSourceID
=
"SQLDS_ImportList"
>
<
Columns
>
<
telerik:GridTemplateColumn
UniqueName
=
"chkSelectRow"
HeaderText
=
""
HeaderStyle-Width
=
"30px"
ItemStyle-Width
=
"30px"
ItemStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
asp:CheckBox
ID
=
"chkSelectRow"
runat
=
"server"
AutoPostBack
=
"true"
OnCheckedChanged
=
"chkSelectRow_OnCheckChanged"
/>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
UniqueName
=
"ImportStatus"
HeaderText
=
"Req Status"
HeaderStyle-Width
=
"90px"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtRequestStatus"
runat
=
"server"
ImageURL='<%# Bind("RequestStatusImage") %>' />
<
asp:Label
ID
=
"lblRequestStatus"
runat
=
"server"
Text='<%# Bind("RequestStatus") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ImportID"
UniqueName
=
"ImportID"
HeaderText
=
"ID"
HeaderStyle-Width
=
"30px"
HeaderStyle-HorizontalAlign
=
"Left"
DataType
=
"System.Int32"
/>
<
telerik:GridBoundColumn
DataField
=
"ImportName"
UniqueName
=
"ImportName"
HeaderText
=
"Import Name"
HeaderStyle-Width
=
"120px"
HeaderStyle-HorizontalAlign
=
"Left"
ItemStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridTemplateColumn
UniqueName
=
"ImportStatus"
HeaderText
=
"Status"
HeaderStyle-Width
=
"100px"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtImportStatus"
runat
=
"server"
ImageURL='<%# Bind("ExecutionStatusImage") %>' />
<
asp:Label
ID
=
"lblImportStatus"
runat
=
"server"
Text='<%# Bind("LastExecutionStatus") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"LastExecutedBy"
UniqueName
=
"LastExecutedBy"
HeaderText
=
"Executed By"
HeaderStyle-Width
=
"110px"
HeaderStyle-HorizontalAlign
=
"Left"
ItemStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"LastExecutionStartTime"
UniqueName
=
"Start Date"
HeaderText
=
"Start Date"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Left"
DataType
=
"System.DateTime"
DataFormatString
=
"{0:MM/dd/yy}"
/>
<
telerik:GridBoundColumn
DataField
=
"LastExecutionStartTime"
UniqueName
=
"LastExecutionStartTime"
HeaderText
=
"Start Time"
HeaderStyle-Width
=
"70px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.DateTime"
DataFormatString
=
"{0:h:mm:ss t}"
/>
<
telerik:GridBoundColumn
DataField
=
"LastExecutionEndTime"
UniqueName
=
"LastExecutionEndTime"
HeaderText
=
"End Time"
HeaderStyle-Width
=
"70px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.DateTime"
DataFormatString
=
"{0:h:mm:ss t}"
/>
<
telerik:GridBoundColumn
DataField
=
"LastExecutionTimeElapsed"
UniqueName
=
"LastExecutionTimeElapsed"
HeaderText
=
"Time Elapsed"
HeaderStyle-Width
=
"130px"
HeaderStyle-HorizontalAlign
=
"Left"
ItemStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"ExecutionCount"
UniqueName
=
"ExecutionCount"
HeaderText
=
"Exec #"
HeaderStyle-Width
=
"60px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.Int32"
/>
<
telerik:GridBoundColumn
DataField
=
"AverageExecutionTimeElapsed"
UniqueName
=
"AverageExecutionTimeElapsed"
HeaderText
=
"Avg Time Elapsed"
/>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowColumnsReorder
=
"false"
ReorderColumnsOnClient
=
"false"
Scrolling-AllowScroll
=
"True"
Scrolling-UseStaticHeaders
=
"True"
Selecting-AllowRowSelect
=
"True"
/>
</
telerik:RadGrid
>
<
br
/>
<
telerik:RadGrid
ID
=
"rgvImportHeader"
runat
=
"server"
ShowGroupPanel
=
"False"
Height
=
"380px"
Width
=
"1038px"
Skin
=
"Web20"
EnableViewState
=
"true"
>
<
MasterTableView
DataSourceID
=
"SQLDS_ImportLogHeader"
AutoGenerateColumns
=
"false"
DataKeyNames
=
"ImportExecutionID"
AllowPaging
=
"true"
ItemStyle-Wrap
=
"false"
PageSize
=
"20"
Caption="<span
style
=
'font-weight:bold'
>Import Header</
span
>" >
<
RowIndicatorColumn
HeaderStyle-Width
=
"10px"
ItemStyle-BackColor
=
"#FFFFF"
/>
<
Columns
>
<
telerik:GridTemplateColumn
UniqueName
=
"ImportStatus"
HeaderText
=
"Status"
HeaderStyle-Width
=
"100px"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtPackageStatus"
runat
=
"server"
ImageURL='<%# Bind("ImportStatusImage") %>' />
<
asp:Label
ID
=
"lblImportStatus"
runat
=
"server"
Text='<%# Bind("ImportStatus") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ImportExecutionID"
UniqueName
=
"ImportExecutionID"
HeaderText
=
"Execution Id"
Display
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"ImportId"
UniqueName
=
"ImportId"
HeaderText
=
"Id"
HeaderStyle-Width
=
"30px"
HeaderStyle-HorizontalAlign
=
"Center"
DataType
=
"System.Int32"
/>
<
telerik:GridTemplateColumn
UniqueName
=
"Process Name"
HeaderText
=
"Status"
HeaderStyle-Width
=
"120px"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblImportName"
runat
=
"server"
Text='<%# Bind("ImportName") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ImportErrorCount"
UniqueName
=
"ImportErrorCount"
HeaderText
=
"Errors"
HeaderStyle-Width
=
"50px"
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.Int32"
/>
<
telerik:GridBoundColumn
DataField
=
"SystemUser"
UniqueName
=
"SystemUser"
HeaderText
=
"User"
HeaderStyle-Width
=
"100px"
HeaderStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"ImportStartTime"
UniqueName
=
"ImportStartDate"
HeaderText
=
"Import Date"
HeaderStyle-Width
=
"90px"
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-HorizontalAlign
=
"Center"
DataFormatString
=
"{0:MM/dd/yy}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"ImportStartTime"
UniqueName
=
"ImportStartTime"
HeaderText
=
"Start Time"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"ImportEndTime"
UniqueName
=
"ImportEndTime"
HeaderText
=
"End Time"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"ImportTimeElapsed"
UniqueName
=
"ImportTimeElapsed"
HeaderText
=
"Time Elapsed"
HeaderStyle-Width
=
"120px"
HeaderStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusStatus"
UniqueName
=
"ArgusStatus"
HeaderText
=
"Argus Status"
HeaderStyle-Width
=
"150px"
HeaderStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusStartTime"
UniqueName
=
"ArgusStartTime"
HeaderText
=
"Start Time"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusEndTime"
UniqueName
=
"ArgusEndTime"
HeaderText
=
"End Time"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusTimeElapsed"
UniqueName
=
"ArgusTimeElapsed"
HeaderText
=
"Time Elapsed"
HeaderStyle-Width
=
"120px"
HeaderStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"PackageStatus"
UniqueName
=
"PackageStatus"
HeaderText
=
"Package Status"
HeaderStyle-Width
=
"150px"
HeaderStyle-HorizontalAlign
=
"Left"
/>
<
telerik:GridBoundColumn
DataField
=
"PackageStartTime"
UniqueName
=
"PackageStartTime"
HeaderText
=
"Start Time"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"PackageEndTime"
UniqueName
=
"PackageEndTime"
HeaderText
=
"End Time"
HeaderStyle-Width
=
"80px"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"PackageTimeElapsed"
UniqueName
=
"PackageTimeElapsed"
HeaderText
=
"Time Elapsed"
headerStyle-Width
=
"120px"
HeaderStyle-HorizontalAlign
=
"Left"
/>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowColumnsReorder
=
"false"
EnablePostBackOnRowClick
=
"true"
AllowDragToGroup
=
"false"
ReorderColumnsOnClient
=
"false"
Selecting-AllowRowSelect
=
"True"
Scrolling-AllowScroll
=
"True"
Scrolling-UseStaticHeaders
=
"True"
/>
</
telerik:RadGrid
>
</
ContentTemplate
>
</
asp:UpdatePanel
>
<
telerik:RadWindowManager
ID
=
"rwmImportDetail"
runat
=
"server"
Behaviors
=
"Close, Move, Resize,Maximize"
DestroyOnClose
=
"true"
/>
</
asp:Panel
>
</
asp:panel
>
</
asp:Content
>
Rad Popup Window
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WBF IMP Timberline Data Detail Popup.aspx.vb" Inherits="IPS_Gateway.WBF_IMP_Timberline_Data_Detail_Popup" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="act" %>
<!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
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
act:ToolkitScriptManager
ID
=
"ToolkitScriptManager1"
runat
=
"server"
/>
<
script
type
=
"text/javascript"
>
Telerik.Web.UI.RadWebControl.prototype._clearParentShowHandlers = function ()
{
var array = this._invisibleParents;
for (var i = 0; i <
array.length
; i++)
{
this.remove_parentShown(array[i]);
}
this._invisibleParents = [];
this._parentShowDelegate
=
null
;
}
</script>
<
asp:SqlDataSource
ID
=
"SQLDS_ImportHeader"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="[Imports].[DSP_SELECT-ImportHeader]" />
<
asp:SqlDataSource
ID
=
"SQLDS_ImportSSISDetail"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="[Imports].[DSP_SELECT-ImportSSISPackageDetail]" />
<
asp:SqlDataSource
ID
=
"SQLDS_ImportArgusDetail"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="[Imports].[DSP_SELECT-ImportArgusDetail]" />
<
asp:Panel
ID
=
"pnlPage"
runat
=
"server"
CssClass
=
"css_IMP01_Panel_FullPage_BlueHeading"
>
<%-- Page Header --%>
<
div
style
=
"position:relative;left:40px;top:5px;"
>
<
asp:FormView
ID
=
"frvImportHeader"
runat
=
"server"
DataSourceID
=
"SQLDS_ImportHeader"
DataKeyNames
=
"ImportExecutionID"
>
<
ItemTemplate
>
- <
asp:Table
ID
=
"tblImportHeader"
runat
=
"server"
CellSpacing
=
"0"
Caption='<%# "Import Status " + Eval("ImportName") %>' Width="1150px" Height="70px" Font-Names="Verdana" ForeColor="White" >
<
asp:TableRow
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayRight"
><
asp:Label
ID
=
"lblProcess"
runat
=
"server"
Text
=
"Process"
/> </
asp:TableCell
>
<
asp:TableCell
width
=
"17px"
> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_Heading"
><
asp:Label
ID
=
"lblStatus"
runat
=
"server"
Text
=
"Status"
/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_Heading"
><
asp:Label
ID
=
"lblStartDate"
runat
=
"server"
Text
=
"Start Date"
/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_Heading"
><
asp:Label
ID
=
"lblStartTime"
runat
=
"server"
Text
=
"Start Time"
/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_Heading"
><
asp:Label
ID
=
"lblEndTime"
runat
=
"server"
Text
=
"End Time"
/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_Heading"
><
asp:Label
ID
=
"lblTimeElapsed"
runat
=
"server"
Text
=
"Time Elapsed:"
/> </
asp:TableCell
>
</
asp:TableRow
>
<
asp:TableRow
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayRight"
><
asp:Label
ID
=
"lblImport"
runat
=
"server"
Text
=
"Import:"
/> </
asp:TableCell
>
<
asp:TableCell
width
=
"17px"
> <
asp:Image
ID
=
"imgImportStatus"
runat
=
"server"
ImageUrl='<%# Eval("ImportStatusImage") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblImportStatus"
runat
=
"server"
Text='<%# Eval("ImportStatus") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblImportStartDate"
runat
=
"server"
Text='<%# Eval("ImportStartTime" , "{0:MM/dd/yy}") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblImportStartTime"
runat
=
"server"
Text='<%# Eval("ImportStartTime" , "{0:hh:mm:ss t}") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblImportEndTime"
runat
=
"server"
Text='<%# Eval("ImportEndTime" , "{0:hh:mm:ss t}") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblImportTimeElapsed"
runat
=
"server"
Text='<%# Eval("ImportTimeElapsed") %>' /> </
asp:TableCell
>
</
asp:TableRow
>
<
asp:TableRow
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayRight"
><
asp:Label
ID
=
"lblArgus"
runat
=
"server"
Text
=
"Argus:"
/> </
asp:TableCell
>
<
asp:TableCell
width
=
"17px"
> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblArgusStatus"
runat
=
"server"
Text='<%# Eval("ArgusStatus") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblArgusStartDate"
runat
=
"server"
Text='<%# Eval("ArgusStartTime" , "{0:MM/dd/yy}") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblArgusStartTime"
runat
=
"server"
Text='<%# Eval("ArgusStartTime" , "{0:hh:mm:ss t}") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblArgsEndTime"
runat
=
"server"
Text='<%# Eval("ArgusEndTime" , "{0:hh:mm:ss t}") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblArgusTimeElapsed"
runat
=
"server"
Text='<%# Eval("ArgusTimeElapsed") %>' /> </
asp:TableCell
>
</
asp:TableRow
>
<
asp:TableRow
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayRight"
><
asp:Label
ID
=
"lblPackage"
runat
=
"server"
Text
=
"Package:"
/> </
asp:TableCell
>
<
asp:TableCell
width
=
"17px"
> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblPackageStatus"
runat
=
"server"
Text='<%# Eval("PackageStatus") %>' /> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblPackageStartDate"
runat
=
"server"
Text='<%# Eval("PackageStartTime" , "{0:MM/dd/yy}") %>'/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblPackageStartTime"
runat
=
"server"
Text='<%# Eval("PackageStartTime" , "{0:hh:mm:ss t}") %>'/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblPackageEndTime"
runat
=
"server"
Text='<%# Eval("PackageEndTime" , "{0:hh:mm:ss t}") %>'/> </
asp:TableCell
>
<
asp:TableCell
CssClass
=
"css_IMP01_TableCell_DisplayCenter"
><
asp:Label
ID
=
"lblPackageTimeElapsed"
runat
=
"server"
Text='<%# Eval("PackageTimeElapsed") %>' /> </
asp:TableCell
>
</
asp:TableRow
>
</
asp:Table
>
</
ItemTemplate
>
</
asp:FormView
>
</
div
>
<
act:Accordion
ID
=
"accImportDetail"
runat
=
"Server"
SelectedIndex
=
"1"
HeaderCssClass
=
"css_IMP01_Accordion_Header"
HeaderSelectedCssClass
=
"css_IMP01_Accordion_HeaderSelected"
AutoSize
=
"None"
ContentCssClass
=
"css_IMP01_Accordion_Content"
Width
=
"1202px"
CssClass
=
"css_IMP01_Accordion"
FadeTransitions
=
"true"
TransitionDuration
=
"75"
FramesPerSecond
=
"100"
RequireOpenedPane
=
"false"
SuppressHeaderPostbacks
=
"True"
>
<
Panes
>
<
act:AccordionPane
ID
=
"acpArgus"
runat
=
"server"
>
<
Header
>Anterra Detail</
Header
>
<
Content
>
<
telerik:RadGrid
ID
=
"rgvImportDetailArgus"
runat
=
"server"
DataSourceID
=
"SQLDS_ImportArgusDetail"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
ItemStyle-Wrap
=
"false"
ShowGroupPanel
=
"False"
Height
=
"480px"
Width
=
"1185px"
>
<
AlternatingItemStyle
BackColor
=
"#DFEBE6"
/>
<
MasterTableView
DataSourceID
=
"SQLDS_ImportArgusDetail"
DataKeyNames
=
"ImportExecutionID"
PageSize
=
"300"
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"10px"
/>
<
ItemStyle
BackColor
=
"#FFFFF"
/>
</
RowIndicatorColumn
>
<
Columns
>
<
telerik:GridTemplateColumn
HeaderText
=
"Status"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtArgusStatus"
runat
=
"server"
ImageURL='<%# Bind("ArgusStatusImage") %>' />
<
asp:Label
ID
=
"lblStatus"
runat
=
"server"
Text='<%# Bind("ArgusStatus") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Errors"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtShowArgusErrors"
runat
=
"server"
ImageUrl='<%# Eval("ErrorImage") %>' OnClick="ibtShowArgusErrors_OnClick" />
<
asp:Label
ID
=
"lblErrorMessage"
runat
=
"server"
Text='<%# Eval("ErrorFlag") %>' />
<
asp:HiddenField
ID
=
"hdfArgusErrorMessage"
runat
=
"server"
Value='<%# Eval("ImportErrorMessage") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ImportExecutionID"
UniqueName
=
"ImportExecutionID"
HeaderText
=
"Id"
Display
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusDBID"
UniqueName
=
"ArgusDBID"
HeaderText
=
"DBID"
ItemStyle-HorizontalAlign
=
"Left"
ReadOnly
=
"True"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusTableName"
UniqueName
=
"ArgusTableName"
HeaderText
=
"Table Name"
ItemStyle-HorizontalAlign
=
"Left"
ReadOnly
=
"True"
/>
<
telerik:GridBoundColumn
DataField
=
"TableStartTime"
UniqueName
=
"StartDate"
HeaderText
=
"Start Date"
DataFormatString
=
"{0:MM/dd/yy}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"TableStartTime"
UniqueName
=
"StartTime"
HeaderText
=
"Start Time"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"TableEndTime"
UniqueName
=
"EndTime"
HeaderText
=
"End Time"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"TableTimeElapsed"
UniqueName
=
"TimeElapsed"
HeaderText
=
"Time Elapsed"
/>
<
telerik:GridBoundColumn
DataField
=
"TimberlineRecordCount"
UniqueName
=
"TimberlineRecordCount"
HeaderText
=
"Timberline Count"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.Int32"
/>
<
telerik:GridBoundColumn
DataField
=
"ArgusRecordCount"
UniqueName
=
"ArgusRecordCount"
HeaderText
=
"Argus Count"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.Int32"
/>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowColumnsReorder
=
"false"
EnablePostBackOnRowClick
=
"true"
AllowDragToGroup
=
"false"
ReorderColumnsOnClient
=
"false"
Selecting-AllowRowSelect
=
"True"
Scrolling-AllowScroll
=
"True"
Scrolling-UseStaticHeaders
=
"True"
/>
</
telerik:RadGrid
>
</
Content
>
</
act:AccordionPane
> <%-- Page Detail --%>
<
act:AccordionPane
ID
=
"acpPackage"
runat
=
"server"
>
<
Header
>Package Detail</
Header
>
<
Content
>
<
telerik:RadGrid
ID
=
"rgvImportDetailPackage"
runat
=
"server"
DataSourceID
=
"SQLDS_ImportSSISDetail"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
ItemStyle-Wrap
=
"false"
ShowGroupPanel
=
"False"
Height
=
"480px"
Width
=
"1185px"
>
<
AlternatingItemStyle
BackColor
=
"#DFEBE6"
/>
<
MasterTableView
DataSourceID
=
"SQLDS_ImportSSISDetail"
DataKeyNames
=
"ImportExecutionID"
PageSize
=
"300"
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"10px"
/>
<
ItemStyle
BackColor
=
"#FFFFF"
/>
</
RowIndicatorColumn
>
<
Columns
>
<
telerik:GridTemplateColumn
UniqueName
=
"ImportDetails"
HeaderText
=
"Details"
HeaderStyle-Width
=
"50px"
>
<
ItemTemplate
>
<
a
href
=
"#"
onclick
=
"ShowDetailsClick('<%# DataBinder.Eval(Container.DataItem, "
PackageErrorMessage") %>'); return false;"> Details
</
a
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Status"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtPackageStatus"
runat
=
"server"
ImageURL='<%# Bind("ExecutionStatusImage") %>' />
<
asp:Label
ID
=
"lblStatus"
runat
=
"server"
Text='<%# Bind("ExecutionStatus") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Warnings"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtShowWarnings"
runat
=
"server"
ImageUrl='<%# Eval("WarningImage") %>' OnClick="ibtShowWarnings_OnClick" />
<
asp:Label
ID
=
"lblWarningMessage"
runat
=
"server"
Text='<%# Eval("PackageWarningCount") %>'></
asp:Label
>
<
asp:HiddenField
ID
=
"hdfWarningMessage"
runat
=
"server"
Value='<%# Eval("PackageWarningMessage") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Errors"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtShowErrors"
runat
=
"server"
ImageUrl='<%# Eval("ErrorImage") %>' OnClick="ibtShowErrors_OnClick" />
<
asp:Label
ID
=
"lblErrorMessage"
runat
=
"server"
Text='<%# Eval("PackageErrorCount") %>' />
<
asp:HiddenField
ID
=
"hdfErrorMessage"
runat
=
"server"
Value='<%# Eval("PackageErrorMessage") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Source Name"
>
<
ItemTemplate
>
<
asp:ImageButton
ID
=
"ibtShowDescription"
runat
=
"server"
ImageUrl='<%# Eval("InformationImage") %>' OnClick="ibtShowDescription_OnClick" />
<
asp:Label
ID
=
"lblSourceName"
runat
=
"server"
Text='<%# Eval("SourceName") %>'/>
<
asp:HiddenField
ID
=
"hdfTaskId"
runat
=
"server"
Value='<%# Eval("TaskID") %>' />
<
asp:HiddenField
ID
=
"hdfSourceDescription"
runat
=
"server"
Value='<%# Eval("SourceDescription") %>' />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ImportExecutionID"
UniqueName
=
"ImportExecutionID"
HeaderText
=
"Id"
Display
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"SourceID"
UniqueName
=
"SourceID"
HeaderText
=
"Source ID"
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-HorizontalAlign
=
"Center"
ReadOnly
=
"True"
/>
<
telerik:GridBoundColumn
DataField
=
"StartTime"
UniqueName
=
"StartDate"
HeaderText
=
"Start Date"
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-HorizontalAlign
=
"Center"
DataFormatString
=
"{0:MM/dd/yy}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"StartTime"
UniqueName
=
"StartTime"
HeaderText
=
"Start Time"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"EndTime"
UniqueName
=
"EndTime"
HeaderText
=
"End Time"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataFormatString
=
"{0:h:mm:ss t}"
DataType
=
"System.DateTime"
/>
<
telerik:GridBoundColumn
DataField
=
"TimeElapsed"
UniqueName
=
"TimeElapsed"
HeaderText
=
"Time Elapsed"
/>
<
telerik:GridBoundColumn
DataField
=
"PercentComplete"
UniqueName
=
"PercentComplete"
HeaderText
=
" % Complete"
HeaderStyle-HorizontalAlign
=
"Right"
ItemStyle-HorizontalAlign
=
"Right"
DataType
=
"System.Int32"
/>
<
telerik:GridBoundColumn
DataField
=
"PackageErrorMessage"
UniqueName
=
"PackageErrorMessage"
HeaderText
=
"Error"
Display
=
"false"
/>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowColumnsReorder
=
"false"
EnablePostBackOnRowClick
=
"true"
AllowDragToGroup
=
"false"
ReorderColumnsOnClient
=
"false"
Selecting-AllowRowSelect
=
"True"
Scrolling-AllowScroll
=
"True"
Scrolling-UseStaticHeaders
=
"True"
/>
</
telerik:RadGrid
>
</
Content
>
</
act:AccordionPane
>
</
Panes
>
</
act:Accordion
>
</
asp:Panel
>
</
form
>
</
body
>
</
html
>
ScriptManager scriptManager = ScriptManager.GetCurrent(
this
.Page);
if
(scriptManager ==
null
)
{
scriptManager =
new
RadScriptManager();
this
.Page.Form.Controls.AddAt(0, scriptManager);
}