or
If hd_rowcount.Value > 499 Then
Me.rg_properties.PageSize = 500
Me.rg_properties.ExportSettings.IgnorePaging = False
End If
rgUsers.ExportSettings.ExportOnlyData = true;
rgUsers.ExportSettings.IgnorePaging = true;
rgUsers.ExportSettings.OpenInNewWindow = true;
rgUsers.MasterTableView.ExportToPdf();
<
ajci:JMGrid
ID
=
"ItemsGrid"
runat
=
"server"
DataSourceID
=
"edsAssetManager"
AutoGenerateColumns
=
"false"
Skin
=
"Windows7"
AllowAutomaticInserts
=
"true"
AllowAutomaticDeletes
=
"true"
AllowAutomaticUpdates
=
"false"
DataKeyNames
=
"id"
OnUpdateCommand
=
"GridOnUpdate"
>
<
ExportSettings
IgnorePaging
=
"true"
OpenInNewWindow
=
"true"
ExportOnlyData
=
"true"
FileName
=
"AssetList"
>
<
Excel
Format
=
"Html"
FileExtension
=
"xls"
/>
</
ExportSettings
>
<
MasterTableView
EditMode
=
"PopUp"
AllowFilteringByColumn
=
"true"
CommandItemDisplay
=
"Top"
CommandItemSettings-AddNewRecordText
=
"Add Items"
DataKeyNames
=
"id"
TableLayout
=
"Fixed"
>
<
EditFormSettings
CaptionFormatString
=
"Add/Edit Item"
PopUpSettings-Modal
=
"true"
EditFormType
=
"AutoGenerated"
>
</
EditFormSettings
>
<
CommandItemTemplate
>
<
asp:LinkButton
runat
=
"server"
ID
=
"lnkAdd"
Text
=
"Add Item"
CssClass
=
"iconAdd"
CommandName
=
"InitInsert"
></
asp:LinkButton
>
<
asp:LinkButton
ID
=
"btnManualRefresh"
CssClass
=
"iconRefresh"
runat
=
"server"
Text
=
"Refresh Data"
OnCommand
=
"GridRefresh"
/>
<
asp:LinkButton
ID
=
"ExportToExcelButton2"
runat
=
"server"
OnClick
=
"ExportData"
CommandArgument
=
"Excel"
Text
=
"Export To Excel"
CssClass
=
"buttonExcel"
/>
</
CommandItemTemplate
>
<
Columns
>
<
telerik:GridTemplateColumn
AllowFiltering
=
"false"
ItemStyle-Width
=
"100px"
HeaderStyle-Width
=
"100px"
ReadOnly
=
"true"
>
<
ItemTemplate
>
<
div
>
<
asp:LinkButton
ID
=
"btnEdit"
CommandName
=
"Edit"
runat
=
"server"
CssClass
=
"iconEdit"
Text
=
" "
></
asp:LinkButton
>
<
asp:LinkButton
ID
=
"lbDeleteRecord"
runat
=
"server"
CssClass
=
"iconDelete"
Text
=
" "
CommandName
=
"Delete"
CommandArgument='<%# Eval("id") %>' OnClientClick="javascript:return confirm('Removing this item will also clear its related history. Continue?')"></
asp:LinkButton
>
<
a
href
=
"#"
onclick
=
"openRadWindow('<%#DataBinder.Eval(Container.DataItem,"
id") %>'); return false;">
<
img
src
=
"../Assets/images/icons/icon-magnifying-glass.png"
/>
</
a
>
<
asp:Image
ID
=
"imgNote"
runat
=
"server"
ImageUrl
=
"../Assets/images/icons/icon-notes.png"
/>
<
telerik:RadToolTip
ID
=
"tooltpNotes"
runat
=
"server"
TargetControlID
=
"imgNote"
RelativeTo
=
"Element"
Position
=
"BottomCenter"
RenderInPageRoot
=
"true"
ManualClose
=
"true"
>
<
p
></
p
>
<
div
>
<
asp:Label
id
=
"ttpAssetNote"
runat
=
"server"
Text='<%# Eval("notes")%>'></
asp:Label
>
</
div
>
</
telerik:RadToolTip
>
<
asp:Image
ID
=
"imgComment"
runat
=
"server"
ImageUrl
=
"../Assets/images/icons/icon-comment.png"
/>
<
telerik:RadToolTip
ID
=
"tooltpComment"
runat
=
"server"
TargetControlID
=
"imgComment"
RelativeTo
=
"Element"
Position
=
"BottomCenter"
RenderInPageRoot
=
"true"
ManualClose
=
"true"
>
<
p
></
p
>
<
div
>
<
asp:Label
id
=
"ttpAssetComment"
runat
=
"server"
Text='<%# Eval("comment")%>'></
asp:Label
>
</
div
>
</
telerik:RadToolTip
>
<
asp:Image
ID
=
"imgQRTag"
runat
=
"server"
CssClass
=
"iconQR"
ImageUrl='<%# AssetManager.Helper.QRImage.GetQRIMageURL(Eval("tag.assetTag").ToString()) %>' />
<
telerik:RadToolTip
ID
=
"tltpQRStatus"
runat
=
"server"
TargetControlID
=
"imgQRTag"
RelativeTo
=
"Element"
Position
=
"BottomCenter"
RenderInPageRoot
=
"true"
EnableShadow
=
"true"
ManualClose
=
"true"
>
<
div
>
<
asp:HyperLink
ID
=
"HyperLink1"
runat
=
"server"
NavigateUrl='<%# AssetManager.Helper.QRImage.GetQRIMageURL(Eval("tag.assetTag").ToString()) %>' Target="_blank" Text="Asset QR Code"/>
</
div
>
<
div
id
=
"RenderedQR"
>
<
asp:Image
ID
=
"qrImage"
runat
=
"server"
ImageUrl='<%# AssetManager.Helper.QRImage.GetQRIMageURL(Eval("tag.assetTag").ToString()) %>'
Title='<%# Eval("tag.assetTag") + ".png" %>' ClientIDMode="Static"/>
</
div
>
<
div
>
<
asp:Label
ID
=
"lblQRAssetID"
runat
=
"server"
Text='<%# Eval("tag.assetTag") %>'></
asp:Label
>
</
div
>
</
telerik:RadToolTip
> </
div
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridDropDownColumn
UniqueName
=
"DDLassetTag"
DataSourceID
=
"edsAssetTag"
SortExpression
=
"assetTag"
ListTextField
=
"assetTag"
ListValueField
=
"id"
HeaderText
=
"AssetTag"
DataField
=
"tagID"
EmptyListItemText
=
"Choose an Asset Tag"
EmptyListItemValue
=
""
EnableEmptyListItem
=
"true"
HeaderStyle-HorizontalAlign
=
"Center"
FilterControlWidth
=
"95px"
HeaderStyle-Width
=
"135px"
ItemStyle-Width
=
"100px"
/>
<
telerik:GridBoundColumn
DataField
=
"itemName"
AllowFiltering
=
"true"
AllowSorting
=
"true"
HeaderText
=
"Item Name"
ItemStyle-HorizontalAlign
=
"Left"
HeaderStyle-HorizontalAlign
=
"Center"
FilterControlWidth
=
"120px"
HeaderStyle-Width
=
"160px"
></
telerik:GridBoundColumn
>
<
telerik:GridDropDownColumn
UniqueName
=
"DDLManufacturer"
DataSourceID
=
"edsManufacturer"
SortExpression
=
"mfgName"
ListTextField
=
"mfgName"
ListValueField
=
"id"
HeaderText
=
"Manufacturer"
DataField
=
"mfgID"
EmptyListItemText
=
"Choose a Manufacturer"
EmptyListItemValue
=
""
EnableEmptyListItem
=
"true"
FilterControlWidth
=
"65px"
HeaderStyle-Width
=
"105px"
/>
<
telerik:GridBoundColumn
DataField
=
"modelNumber"
AllowFiltering
=
"true"
AllowSorting
=
"true"
HeaderText
=
"Model Number"
ItemStyle-HorizontalAlign
=
"Left"
HeaderStyle-HorizontalAlign
=
"Center"
FilterControlWidth
=
"95px"
HeaderStyle-Width
=
"135px"
ItemStyle-Width
=
"100px"
></
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"notes"
UniqueName
=
"Notes"
HeaderText
=
"Notes"
Display
=
"false"
AllowFiltering
=
"false"
FilterControlWidth
=
"120px"
HeaderStyle-Width
=
"150px"
>
<
ItemTemplate
>
<%# Eval("notes") %>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"txtNotes"
Text='<%# Bind( "notes") %>' Columns="30" Rows="5"
TextMode="MultiLine" runat="server"></
asp:TextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"comment"
UniqueName
=
"Comments"
HeaderText
=
"Comments"
Visible
=
"false"
AllowFiltering
=
"false"
FilterControlWidth
=
"65px"
HeaderStyle-Width
=
"100px"
>
<
ItemTemplate
>
<%# Eval("comment") %>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"txtComments"
Text='<%# Bind( "comment") %>' Columns="30" Rows="5"
TextMode="MultiLine" runat="server"></
asp:TextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"serialNumber"
AllowFiltering
=
"true"
AllowSorting
=
"true"
HeaderText
=
"Serial Number"
ItemStyle-HorizontalAlign
=
"Left"
HeaderStyle-HorizontalAlign
=
"Center"
FilterControlWidth
=
"95px"
HeaderStyle-Width
=
"135px"
ItemStyle-Width
=
"100px"
></
telerik:GridBoundColumn
>
<
telerik:GridDropDownColumn
UniqueName
=
"DDLWho"
DataSourceID
=
"edsWho"
SortExpression
=
"name"
ListTextField
=
"name"
ListValueField
=
"id"
HeaderText
=
"User / Location"
DataField
=
"whoID"
EnableEmptyListItem
=
"true"
EmptyListItemText
=
""
HeaderStyle-HorizontalAlign
=
"Center"
FilterControlWidth
=
"95px"
HeaderStyle-Width
=
"135px"
ItemStyle-Width
=
"100px"
/>
<
telerik:GridDropDownColumn
UniqueName
=
"DDLStatus"
DataSourceID
=
"edsStatus"
SortExpression
=
"name"
ListTextField
=
"name"
ListValueField
=
"id"
HeaderText
=
"Status"
DataField
=
"statusID"
EmptyListItemText
=
"Choose a Status"
EmptyListItemValue
=
""
EnableEmptyListItem
=
"true"
HeaderStyle-HorizontalAlign
=
"Center"
FilterControlWidth
=
"95px"
HeaderStyle-Width
=
"135px"
ItemStyle-Width
=
"100px"
/>
<
telerik:GridCheckBoxColumn
DataField
=
"IPv6Compliant"
AllowFiltering
=
"false"
AllowSorting
=
"true"
HeaderText
=
"v6"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridCheckBoxColumn
>
</
Columns
>
</
MasterTableView
>
</
ajci:JMGrid
>
<
asp:EntityDataSource
runat
=
"server"
ID
=
"edsAssetManager"
EntitySetName
=
"assets"
ConnectionString
=
"name=AssetTagManager"
DefaultContainerName
=
"AssetTagManager"
EnableInsert
=
"true"
EnableDelete
=
"true"
Include
=
"tag"
OnInserting
=
"MyEdsInserting"
OnUpdating
=
"MyEdsInserting"
EnableUpdate
=
"true"
/>
protected void MyEdsInserting(object sender, EntityDataSourceChangingEventArgs e)
{
List<
string
> _error = new List<
string
>();
AssetManager.FormException FormException = new AssetManager.FormException();
AssetManagerDevModel.asset x = ((AssetManagerDevModel.asset)e.Entity);
if (e.Exception is EntityDataSourceValidationException && e.Exception is System.Web.DynamicData.IDynamicValidatorException)
{
foreach (KeyValuePair<
string
, Exception> innerException in ((System.Web.DynamicData.IDynamicValidatorException)e.Exception).InnerExceptions)
{
_error.Add(innerException.Key + " is Blank");
}
}
else
{
if (x.itemName == null)
_error.Add("Name cannot be blank");
if (x.tagID == null || x.tagID ==0)
_error.Add("You must select a tag from the list");
if (x.statusID == 0)
_error.Add("You must select an available status");
}
if (_error.Count > 0)
{
e.Cancel = true;
e.ExceptionHandled = true;
throw new Helper.DataInvalidException(_error);
}
else
{
x.modifyBy = HttpContext.Current.User.Identity.Name.Split('\\')[1];
x.modifyDate = DateTime.Now;
}
}
function
SetDatePickerReadOnly(picker, readOnly) {
picker.set_enabled(!readOnly);
// disable the overall control if readOnly is true (or the converse)
var
input = picker.get_dateInput();
//retrieves the inner DateInput portion of the DatePicker
input.enable();
// enable the input box only, leaving the calendar disabled (or the converse)
input._textBoxElement.readOnly = readOnly;
//the inner reference to the input object; changes appearance to "ReadOnly" style and not editable
// (or the converse)
}
var
dobPicker = $find(
"<%= DateOfBirthDatePicker.ClientID %>"
);
SetDatePickerReadOnly(dobPicker,
true
);