protected
void Page_Init(object sender, EventArgs e)
{
RadDockLayout1.LoadDockLayout+=
new DockLayoutEventHandler(RadDockLayout1_LoadDockLayout);
AddDocksByPosition(0);
{
/*** Get list of docks from DB and load it to the Docklayout****/
{
System.Web.Script.Serialization.
JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
string serializedList = DockPostionstr;
if (!string.IsNullOrEmpty(serializedList))
{
string[] states = serializedList.Split('|');
foreach (string stringState in states)
{
if (stringState != string.Empty)
{
DockState state = serializer.Deserialize<DockState>(stringState);
e.Positions[state.UniqueName] = state.DockZoneID;
e.Indices[state.UniqueName] = state.Index;
}
}
}
}
protected void SaveDockLayout1_LoadDockLayout(object sender, DockLayoutEventArgs e)
{
string dockState;
System.Web.Script.Serialization.
JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List<DockState> stateList = RadDockLayout1.GetRegisteredDocksState();
StringBuilder serializedList = new StringBuilder();
int i = 0;
while (i < stateList.Count)
{
serializedList.Append(serializer.Serialize(stateList[i]));
serializedList.Append(
"|");
i++;
}
dockState = serializedList.ToString();
/***** DB call to save Dashboard state per Tab******/
}
<asp:Panel ID="pnlGrid" runat="server" CssClass="panelGrid">
<telerik:RadGrid ID="myRadGrid" runat="server" Width="90%" Skin="Web20" CssClass="dvGridWrapper" AllowSorting="true">
<PagerStyle AlwaysVisible="true" />
<MasterTableView AutoGenerateColumns="false" Font-Size="10" DataKeyNames="intRecruitId" CommandItemDisplay="Bottom">
<CommandItemSettings ShowAddNewRecordButton="false" ShowRefreshButton="false" />
<HeaderStyle ForeColor="White" Font-Bold="true" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="#B0C4DE" HorizontalAlign="Center" />
<CommandItemTemplate>
<asp:LinkButton ID="lnkUpdateAll" runat="server" CommandName="UpdateAll" CommandArgument='<%#Bind("intRecruitId")%>'>Update All</asp:LinkButton>
</CommandItemTemplate>
<Columns>
<telerik:GridBoundColumn DataField="dtRSPStatusChanged" HeaderText="Last Changed" />
<telerik:GridTemplateColumn HeaderText="NAME">
<ItemTemplate>
<asp:LinkButton ID="lnkName" runat="server" Text='<%#Bind("Name")%>' CommandArgument='<%#Bind("intRecruitId")%>' CommandName="pnlOpen" ToolTip="Click to See Data"></asp:LinkButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="PHASE" UniqueName="Phase">
<ItemTemplate>
<asp:DropDownList ID="ddlPhase3" runat="server" SelectedValue='<%#Bind("intPhaseId")%>'>
<asp:ListItem Value="1" Text="Red" />
<asp:ListItem Value="2" Text="White1" />
<asp:ListItem Value="3" Text="White2" />
<asp:ListItem Value="4" Text="White3" />
<asp:ListItem Value="5" Text="Blue" />
<asp:ListItem Value="6" Text="Green" />
<asp:ListItem Value="7" Text="Gold" />
</asp:DropDownList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="dtShip" HeaderText="SHIP DATE">
<ItemTemplate>
<telerik:RadDatePicker ID="rdp_dtShip" runat="server" DbSelectedDate='<%#Bind("dtShip")%>' Width="100px"></telerik:RadDatePicker>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="ddDate" HeaderText="DROP DEAD DATE" />
<telerik:GridTemplateColumn DataField="dtProjReturn" HeaderText="EST RETURN DATE">
<ItemTemplate>
<telerik:RadDatePicker ID="rdp_Return" runat="server" DbSelectedDate='<%#Bind("dtProjReturn")%>' Width="100px"></telerik:RadDatePicker>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="STATUS" UniqueName="Status">
<ItemTemplate>
<asp:DropDownList ID="ddlStatus3" runat="server" SelectedValue='<%#Bind("intRSPStatusID")%>'>
<asp:ListItem Value="1" Text="Amber" />
<asp:ListItem Value="3" Text="DAT" />
<asp:ListItem Value="4" Text="Discharged" />
<asp:ListItem Value="5" Text="Green" />
<asp:ListItem Value="6" Text="Hardship" />
<asp:ListItem Value="7" Text="Test" />
<asp:ListItem Value="8" Text="OCS" />
<asp:ListItem Value="9" Text="Pend Dis" />
<asp:ListItem Value="10" Text="Prior SVC" />
<asp:ListItem Value="11" Text="Qualified" />
<asp:ListItem Value="12" Text="Red" />
<asp:ListItem Value="13" Text="Shipped" />
<asp:ListItem Value="18" Text="None" />
<asp:ListItem Value="19" Text="NAC" />
<asp:ListItem Value="20" Text="IST" />
<asp:ListItem Value="21" Text="Gold" />
<asp:ListItem Value="22" Text="Not Entered" />
<asp:ListItem Value="23" Text="Recruit Force Pool" />
</asp:DropDownList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="ISSUE" UniqueName="Issue">
<ItemTemplate>
<asp:DropDownList ID="ddlIssue3" runat="server" SelectedValue='<%#Bind("intRSPIssueID")%>' >
<asp:ListItem Value="1" Text="Admin" />
<asp:ListItem Value="2" Text="APFT" />
<asp:ListItem Value="3" Text="Attendance" />
<asp:ListItem Value="5" Text="BCT" />
<asp:ListItem Value="6" Text="Testing" />
<asp:ListItem Value="7" Text="Test2" />
<asp:ListItem Value="8" Text="Education Fail" />
<asp:ListItem Value="9" Text="Family hardship" />
<asp:ListItem Value="10" Text="Legal" />
<asp:ListItem Value="11" Text="Medical" />
<asp:ListItem Value="12" Text="New Trainee" />
<asp:ListItem Value="13" Text="Packet failure" />
<asp:ListItem Value="14" Text="None" />
<asp:ListItem Value="15" Text="Not Entered" />
<asp:ListItem Value="16" Text="Education HSJR" />
<asp:ListItem Value="17" Text="Education HSSR" />
<asp:ListItem Value="18" Text="Education GED" />
<asp:ListItem Value="19" Text="Pend PH2 Date" />
<asp:ListItem Value="20" Text="Pend IST" />
<asp:ListItem Value="21" Text="College" />
<asp:ListItem Value="22" Text="OCS" />
<asp:ListItem Value="23" Text="ROTC" />
<asp:ListItem Value="24" Text="ROTC SMP" />
<asp:ListItem Value="25" Text="Pend OCS Date" />
<asp:ListItem Value="26" Text="Pend RENO Out" />
<asp:ListItem Value="27" Text="Pending Commission" />
</asp:DropDownList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="EDUCATION" UniqueName="Ed">
<ItemTemplate>
<asp:DropDownList ID="ddlEd3" runat="server" SelectedValue='<%#Bind("intRSPEdID")%>' >
<asp:ListItem Value="1" Text="N/A" />
<asp:ListItem Value="2" Text="HSSR" />
<asp:ListItem Value="3" Text="HSJR" />
<asp:ListItem Value="4" Text="GED +" />
<asp:ListItem Value="5" Text="GED" />
<asp:ListItem Value="6" Text="GRAD" />
<asp:ListItem Value="7" Text="COLLEGE" />
</asp:DropDownList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="NOTES">
<ItemTemplate>
<asp:Image ID="imgLooker" runat="server" ImageUrl="~/Images/ViewResources.gif" ImageAlign="Middle" BorderStyle="None" />
<asp:PopupControlExtender ID="popInfo" runat="server" PopupControlID="pnlPop" TargetControlID="imgLooker" DynamicContextKey='<% #Eval("intRSPNotesID")%>'
DynamicControlID="pnlpop" DynamicServiceMethod="GetNotes" Position="bottom"></asp:PopupControlExtender>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="strRSPSiteLocation" HeaderText="RSP SITE" />
<telerik:GridBoundColumn DataField="strUIC" HeaderText="UIC" />
<telerik:GridTemplateColumn HeaderText="UPDATE">
<ItemTemplate>
<asp:LinkButton ID="lnkUpdate" runat="server" Text="Update" ToolTip="Click to Save Data" CommandArgument='<%#Bind("intRecruitId")%>' CommandName="Update"></asp:LinkButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
<BatchEditingSettings EditType="Cell" />
</MasterTableView>
</telerik:RadGrid>
If (e.CommandName = "UpdateAll") Then
Dim recruitid As Integer = Convert.ToInt32(e.CommandArgument = "intRecruitId")
'Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
Dim Phase As DropDownList = DirectCast(e.Item.FindControl("ddlPhase3"), DropDownList)
Dim Status As DropDownList = DirectCast(e.Item.FindControl("ddlStatus3"), DropDownList)
Dim Issue As DropDownList = DirectCast(e.Item.FindControl("ddlIssue3"), DropDownList)
Dim Ed As DropDownList = DirectCast(e.Item.FindControl("ddlEd3"), DropDownList)
Dim dtShip As TextBox = DirectCast(e.Item.FindControl("txtdtShip"), TextBox)
Dim dtReturn As TextBox = DirectCast(e.Item.FindControl("txtProjRtn"), TextBox)
Dim myDataGridItem As DataGridItem
For Each DataGridItem In myRadGrid.Items
 
sql =
"Update tblRSP SET dtProjReturn = '" & sanitizeString(dtReturn.Text) & "', intRSPStatusID = " & Status.SelectedValue & ", intRSPIssueID = " & Issue.SelectedValue & ", INTRSPEdID = " & Ed.SelectedValue & ", intPhaseID = " & Phase.SelectedValue & "" _
&
" Where intRecruitId =" & recruitid & " Update Recruit SET dtShip = '" & sanitizeString(dtShip.Text) & "' Where intRecruitId =" & recruitid
Response.Write(sql)
Response.End()
insertUpdateDelete(sql)
myRadGrid.Rebind()
Next
End If
Rewrote the queries to load the grids...
Dim
tblTable
As
DataTable =
DirectCast
(ViewState(
"dtTblData"
), DataTable)
''some codes ...
ViewState(
"dtTblData"
) = tblTable
rgInvoiceList.DataSource = tblTable
Try
Dim
expression1
As
GridGroupByExpression = GridGroupByExpression.Parse(
"ClaimsFor [Claims Type], count(ClaimsFor) Items [My Items], Sum(Total) [Group Total] Group By ClaimsFor"
)
Me
.CustomizeExpression(expression1)
Me
.rgInvoiceList.MasterTableView.GroupByExpressions.Add(expression1)
rgInvoiceList.Rebind()
Catch
ex
As
Exception
Console.WriteLine(
"error"
& ex.Message)
Finally
End
Try
<
telerik:RadGrid
ID
=
"rgInvoiceList"
runat
=
"server"
CellSpacing
=
"0"
GridLines
=
"None"
ShowFooter
=
"True"
Skin
=
"Hay"
AllowSorting
=
"True"
>
<
ClientSettings
EnablePostBackOnRowClick
=
"True"
>
<
Selecting
CellSelectionMode
=
"None"
AllowRowSelect
=
"True"
></
Selecting
>
</
ClientSettings
>
<
MasterTableView
DataKeyNames
=
"ID"
ClientDataKeyNames
=
"ID"
AllowCustomSorting
=
"true"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
>
<
RowIndicatorColumn
Visible
=
"True"
FilterControlAltText
=
"Filter RowIndicator column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
Visible
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldName
=
"Total"
/>
</
SelectFields
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"ClaimsFor"
SortOrder
=
"Descending"
/>
</
GroupByFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
>
</
telerik:RadGrid
>
<
telerik:RadGrid
ID
=
"HomeRadGrid"
runat
=
"server"
OnNeedDataSource
=
"HomeRadGrid_NeedDataSource"
EnableEmbeddedSkins
=
"False"
AllowPaging
=
"True"
AllowAutomaticUpdates
=
"false"
AllowAutomaticInserts
=
"false"
AllowAutomaticDeletes
=
"false"
AllowSorting
=
"True"
AllowFilteringByColumn
=
"True"
CellSpacing
=
"0"
Culture
=
"it-IT"
GridLines
=
"None"
OnItemCommand
=
"HomeRadGrid_ItemCommand"
OnGroupsChanging
=
"HomeRadGrid_GroupsChanging"
OnItemDataBound
=
"HomeRadGrid_ItemDataBound"
Skin
=
"MySkin"
ShowGroupPanel
=
"True"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
MasterTableView
AutoGenerateColumns
=
"False"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"Id"
>
<
ColumnGroups
>
<
telerik:GridColumnGroup
Name
=
"GeneralInformation"
HeaderText
=
"General Information"
HeaderStyle-HorizontalAlign
=
"Center"
/>
<
telerik:GridColumnGroup
Name
=
"WarningsIcon"
HeaderText
=
"Warnings"
HeaderStyle-HorizontalAlign
=
"Center"
/>
</
ColumnGroups
>
<
CommandItemSettings
RefreshText
=
""
ShowAddNewRecordButton
=
"false"
/>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldAlias
=
"Company"
FieldName
=
"Cdc.CompanyCode"
></
telerik:GridGroupByField
>
</
SelectFields
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"Cdc.CompanyCode"
SortOrder
=
"Descending"
></
telerik:GridGroupByField
>
</
GroupByFields
>
</
telerik:GridGroupByExpression
>
<
telerik:GridGroupByExpression
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldAlias
=
"Project"
FieldName
=
"Cdc.Code"
></
telerik:GridGroupByField
>
</
SelectFields
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"Cdc.Code"
></
telerik:GridGroupByField
>
</
GroupByFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Cdc.CompanyCode"
HeaderText
=
"Company Code"
SortExpression
=
"Cdc.CompanyCode"
UniqueName
=
"Cdc.CompanyCode"
Visible
=
"false"
ColumnGroupName
=
"GeneralInformation"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Cdc.Code"
HeaderText
=
"Project"
SortExpression
=
"Cdc.Code"
UniqueName
=
"Cdc.Code"
Visible
=
"false"
ColumnGroupName
=
"GeneralInformation"
>
</
telerik:GridBoundColumn
>
<
telerik:GridHyperLinkColumn
DataNavigateUrlFields
=
"Bt1Asset.Asset.Code,Cdc.CompanyCode, Bt1Asset.Code, Ambiente"
DataNavigateUrlFormatString
=
"Default.aspx?id={0}&filtro_soc2={1}&cgrcod={2}&amb_anag={3}&site=*&commessa=*&codicemezzo=*"
DataTextField
=
"Bt1Asset.Asset.Code"
UniqueName
=
"Bt1Asset.Asset.Code"
HeaderText
=
"Asset Code"
HeaderStyle-Width
=
"150px"
ColumnGroupName
=
"GeneralInformation"
></
telerik:GridHyperLinkColumn
>
<
telerik:GridBoundColumn
DataField
=
"Bt1Asset.Asset.Description"
HeaderText
=
"Asset Description"
SortExpression
=
"Bt1Asset.Asset.Description"
UniqueName
=
"Bt1Asset.Asset.Description"
Visible
=
"true"
ColumnGroupName
=
"GeneralInformation"
>
</
telerik:GridBoundColumn
>
<
telerik:GridImageColumn
HeaderText
=
"BT1"
AllowFiltering
=
"false"
HeaderStyle-Width
=
"50px"
ItemStyle-Width
=
"50px"
ColumnGroupName
=
"WarningsIcon"
UniqueName
=
"Bt1Asset.Bt1"
>
</
telerik:GridImageColumn
>
<
telerik:GridImageColumn
HeaderText
=
"BT2"
AllowFiltering
=
"false"
UniqueName
=
"Bt1Asset.Bt2"
HeaderStyle-Width
=
"50px"
ItemStyle-Width
=
"50px"
ColumnGroupName
=
"WarningsIcon"
>
</
telerik:GridImageColumn
>
<
telerik:GridImageColumn
HeaderText
=
"Tx/Rx"
AllowFiltering
=
"false"
HeaderStyle-Width
=
"50px"
ItemStyle-Width
=
"50px"
ColumnGroupName
=
"WarningsIcon"
>
</
telerik:GridImageColumn
>
<
telerik:GridImageColumn
HeaderText
=
"Alerts"
AllowFiltering
=
"false"
HeaderStyle-Width
=
"50px"
ItemStyle-Width
=
"50px"
ColumnGroupName
=
"WarningsIcon"
>
</
telerik:GridImageColumn
>
</
Columns
>
<
NestedViewTemplate
>
<
div
class
=
"carBackground"
>
<
div
style
=
"float: left; padding-left: 40px; padding-right:20px; padding-top:10px"
>
<
asp:Image
ID
=
"ItemImage"
runat
=
"server"
AlternateText
=
""
ImageUrl='<%# GetItemImageUrl(Container)%>' Width="200px" />
</
div
>
<
div
style
=
"float: left; width: 50%"
>
<
div
class
=
"carTitle"
>
<%# Eval("Bt1Asset.Asset.Code")%>
</
div
>
<
span
style
=
"color: #555555"
>
<%# Eval("Bt1Asset.Asset.Description")%>
times</
span
>
<
hr
class
=
"lineSeparator"
/>
<
table
width
=
"100%"
class
=
"carInfo"
>
<
tr
>
<
td
>
<
strong
>Site:</
strong
>
<%# Eval("Cdc.Site")%>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
strong
>Plate:</
strong
>
<%# Eval("Bt1Asset.Asset.Targa")%>
</
td
>
</
tr
>
</
table
>
</
div
>
<
div
style
=
"float: right; padding-right: 40px; padding-left:20px;padding-top:10px"
>
<
div
style
=
"width:200px; border:solid 1px black"
id
=
"small_map_div"
></
div
>
</
div
>
<
div
style
=
"clear: both"
>
</
div
>
</
div
>
</
NestedViewTemplate
>
</
MasterTableView
>
<
ClientSettings
ReorderColumnsOnClient
=
"True"
AllowDragToGroup
=
"True"
AllowColumnsReorder
=
"True"
>
<
ClientEvents
OnRowDblClick
=
"RowDblClick"
></
ClientEvents
>
<
Selecting
AllowRowSelect
=
"False"
></
Selecting
>
<
Resizing
AllowRowResize
=
"True"
AllowColumnResize
=
"True"
EnableRealTimeResize
=
"True"
ResizeGridOnColumnResize
=
"False"
></
Resizing
>
</
ClientSettings
>
<
GroupingSettings
ShowUnGroupButton
=
"true"
></
GroupingSettings
>
</
telerik:RadGrid
>
function RowDblClick(sender, args) {
//expand/collapse nested row
}