or
protected
override
void
Page_Load(
object
sender, EventArgs e)
{
base
.Page_Load(sender, e);
windowsManager.MinimizeZoneID = minimizeZone.ClientID;
windowsManager.RestrictionZoneID = viewPane.ClientID;
}
public
void
OpenWindow(
string
name)
{
RadWindow window =
new
RadWindow();
window.ID = name;
window.ContentTemplate = Page.LoadTemplate(
"~/ControlPanel/Views/"
+ name +
".ascx"
);
windowsManager.Windows.Add(window);
window.VisibleOnPageLoad =
true
;
}
<
div
id
=
"viewPane"
runat
=
"server"
class
=
"cellDiv"
style
=
"height:100%;"
>
<
telerik:RadWindowManager
ID
=
"windowsManager"
runat
=
"server"
Behaviors
=
"Default"
EnableShadow
=
"true"
>
</
telerik:RadWindowManager
>
<
div
id
=
"minimizeZone"
runat
=
"server"
class
=
"minimizeZone"
>
</
div
>
</
div
>
if
(txtParentGridID.Text !=
string
.Empty)
{
string
cmbZipHandlerName = txtParentGridID.Text +
"_cmbZip_SelectedIndexChanged"
;
string
script =
"function "
+ cmbZipHandlerName +
"(sender, args) {"
+
"var grd = $telerik.findGrid('"
+ txtParentGridID.Text +
"', null);"
+
"ZipAutoFillCurrentEditForm(grd, args.get_item());"
+
"}"
;
// Set event handler
cmbZip.OnClientSelectedIndexChanged = cmbZipHandlerName;
// registering to the Page object works
ScriptManager.RegisterStartupScript(Page,
typeof
(Page), cmbZip.ClientID +
"_handler"
, script,
true
);
}
// These zip autofill related functions are separated in a script file
function
ZipAutoFillCurrentEditForm(grd, selectedItem) {
var
formItem;
formItem = GetCurrentFormItem(grd);
if
(formItem)
{
var
city;
var
state;
var
island;
var
county;
var
country;
city = FindInputInTemplateForm(formItem,
'txtCity'
);
state = FindInputInTemplateForm(formItem,
'txtState'
);
island = FindInputInTemplateForm(formItem,
'txtIsland'
);
county = FindInputInTemplateForm(formItem,
'txtCounty'
);
country = FindInputInTemplateForm(formItem,
'txtCountry'
);
FillZipFields(selectedItem, city, state, island, county, country);
}
}
// Get current form item of a grid
function
GetCurrentFormItem(grd) {
var
master = grd.get_masterTableView();
var
formItem;
if
(master.get_isItemInserted()) {
// insert mode
formItem = master.get_insertItem();
}
else
{
// @todo check Edit mode
// get_editItems() is blank
var
editItem = master.get_editItems()[0];
if
(editItem) {
formItem = editItem.get_editFormItem();
}
}
return
formItem;
}
/*
Looks for a HTML element (inputbox) for a given server control
- FormItem: HTML element of RadGrid's Insert/Edit form
- ServerID: Server-side Control ID
*/
function
FindInputInTemplateForm(formItem, serverID) {
if
(formItem !=
null
) {
var
inputs = formItem.getElementsByTagName(
"input"
);
for
(
var
i = 0; i < inputs.length; i++) {
var
input = inputs[i];
// test with city
if
(input.id.indexOf(serverID) < 0)
continue
;
if
(input.type && input.type ==
"text"
) {
return
input;
}
}
}
}
/*
Full all of the address fields that are dependent on zip code
- selected: selected item (RadComboBoxItem object)
- city, state, island, county, country: respective input element
*/
function
FillZipFields(selected, city, state, island, county, country) {
if
(selected !=
null
) {
var
attrs = selected.get_attributes();
city.value = attrs.getAttribute(
'City'
);
state.value = attrs.getAttribute(
'State'
);
island.value = attrs.getAttribute(
'Island'
);
county.value = attrs.getAttribute(
'County'
);
country.value = attrs.getAttribute(
'Country'
);
}
}
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
EnableTheming
=
"false"
CssClass
=
"myClass"
AllowPaging
=
"False"
OnNeedDataSource
=
"RadGrid1_NeedDataSource"
BorderStyle
=
"None"
style
=
"outline:none;"
EnableEmbeddedSkins
=
"false"
>
<
MasterTableView
DataKeyNames
=
"ID"
ShowHeader
=
"false"
ShowFooter
=
"false"
HierarchyDefaultExpanded
=
"true"
CommandItemDisplay
=
"None"
>
<
ItemTemplate
>
</
ItemTemplate
>
<
NestedViewTemplate
>
<
telerik:RadGrid
ID
=
"RadGrid2"
runat
=
"server"
EnableTheming
=
"false"
CssClass
=
"myClass"
EnableEmbeddedSkins
=
"false"
AllowPaging
=
"False"
OnNeedDataSource
=
"RadGrid2_NeedDataSource"
BorderStyle
=
"None"
OnItemDataBound
=
"RadGrid2_ItemDataBound"
style
=
"outline:none;"
>
<
MasterTableView
ShowHeader
=
"false"
ShowFooter
=
"false"
ShowGroupFooter
=
"false"
HierarchyDefaultExpanded
=
"false"
CommandItemDisplay
=
"None"
>
<
ItemTemplate
>
<
table
style="font-size:11px; width:100%;border: .1em solid #000000;table-layout: fixed; padding-left: 0px;
padding-right: 0px;">
<
tr
>
<
td
align
=
"center"
style
=
"width:40px;border: .1em solid #000000;"
">
<
asp:Label
ID
=
"lblRowNumber"
runat
=
"server"
/></
td
>
<
td
align
=
"center"
style
=
"width:70px;border: .1em solid #000000;"
>
<%# DataBinder.Eval(Container.DataItem,"CreationDate") %></
td
>
<
td
align
=
"center"
style
=
"width:50px;border: .1em solid #000000;"
>
<%# DataBinder.Eval(Container.DataItem, "Number")%></
td
>
<
td
align
=
"center"
style
=
"width:150px;border: .1em solid #000000;"
>
<
asp:Repeater
ID
=
"Repeater3"
runat
=
"server"
DataSource='<%# Eval("Owners") %>'>
<
ItemTemplate
>
<%# DataBinder.Eval(Container.DataItem, "CertificateNumber")%>
<%# DataBinder.Eval(Container.DataItem, "IssuedBy")%>
<%# DataBinder.Eval(Container.DataItem, "WhenIssued")%>
<%# DataBinder.Eval(Container.DataItem,"LegalObject")%>
<%# DataBinder.Eval(Container.DataItem, "individual.FIO")%>
<%# DataBinder.Eval(Container.DataItem, "legalEntity.Title")%>
<%# DataBinder.Eval(Container.DataItem, "legalEntity.INN")%>
<%# DataBinder.Eval(Container.DataItem, "legalEntity.OGRN")%>
<%# DataBinder.Eval(Container.DataItem, "legalEntity.Address")%>
<%# DataBinder.Eval(Container.DataItem, "legalEntity.LegalAddress")%>
</
ItemTemplate
>
<
SeparatorTemplate
>
,
</
SeparatorTemplate
>
</
asp:Repeater
>
</
td
>
</
tr
>
</
table
>
</
ItemTemplate
>
</
MasterTableView
>
<
ClientSettings
EnableAlternatingItems
=
"false"
>
<
Selecting
AllowRowSelect
=
"False"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
</
NestedViewTemplate
>
</
MasterTableView
>
<
ClientSettings
EnableAlternatingItems
=
"false"
Scrolling-AllowScroll
=
"false"
>
<
Selecting
AllowRowSelect
=
"False"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gestionScoreSheet.aspx.cs"
Inherits="GestionV2_gestionScoreSheet" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!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"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
div
id
=
"sdsGrouping"
>
<
asp:SqlDataSource
ID
=
"sdsJoueurVisiteur"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DB_36624_hlm_ConnectionString %>"
SelectCommand="SELECT tblPersonne.strNomPersonne + N', ' + tblPersonne.strPrenomPersonne AS strNomComplet, tblJoueurPosition.strNomPosition, tblSSSubEquipeSubJoueur.FKintIDJoueurPosition, tblSSSubEquipeSubJoueur.FKintIDPersonne, tblSSSubEquipe.intIDSSEquipe, tblSS.intIDSS, tblSS.FKintIDCedule, tblSSSubEquipe.FKintIDEquipe, tblSSSubEquipeSubJoueur.intIDSSJoueur, tblSSSubEquipeSubJoueur.ysnRegulier FROM tblSSSubEquipe INNER JOIN tblSS ON tblSSSubEquipe.FKintIDSS = tblSS.intIDSS INNER JOIN tblSSSubEquipeSubJoueur INNER JOIN tblPersonne ON tblSSSubEquipeSubJoueur.FKintIDPersonne = tblPersonne.intIDPersonne INNER JOIN tblJoueurPosition ON tblSSSubEquipeSubJoueur.FKintIDJoueurPosition = tblJoueurPosition.intIDJoueurPosition ON tblSSSubEquipe.intIDSSEquipe = tblSSSubEquipeSubJoueur.FKintIDSSEquipe WHERE (tblSSSubEquipe.FKintIDEquipe = @FKintIDEquipe) AND (tblSS.intIDSS = @intIDSS) ORDER BY strNomComplet"
UpdateCommand="spScoreSheetLineUPUpdate" UpdateCommandType="StoredProcedure"
DeleteCommand="spScoreSheetLineUPDelete" DeleteCommandType="StoredProcedure"
InsertCommand="spScoreSheetLineUpInsert" InsertCommandType="StoredProcedure">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"intIDSSJoueur"
Type
=
"Int32"
/>
</
DeleteParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"intIDSS"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"strRVSSEquipe"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"FKintIDPersonne"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"FKintIDJoueurPosition"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"ysnRegulier"
Type
=
"Boolean"
DefaultValue
=
"False"
/>
</
InsertParameters
>
<
SelectParameters
>
<
asp:Parameter
DefaultValue
=
"2144395403"
Name
=
"FKintIDEquipe"
/>
<
asp:Parameter
DefaultValue
=
"2146239473"
Name
=
"intIDSS"
/>
</
SelectParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"intIDSSJoueur"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"FKintIDPersonne"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"FKintIDJoueurPosition"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"ysnRegulier"
Type
=
"Boolean"
DefaultValue
=
"False"
/>
</
UpdateParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"sdsListePosition"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DB_36624_hlm_ConnectionString %>"
SelectCommand="SELECT * FROM [tblJoueurPosition]"></
asp:SqlDataSource
>
<%--sdsListePersonne select command = SELECT top (100) percent intIDPersonne, strNomPersonne + ', ' + strPrenomPersonne AS strNomComplet FROM tblPersonne order by strNomComplet--%>
<
asp:SqlDataSource
ID
=
"sdsListePersonne"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DB_36624_hlm_ConnectionString %>"
SelectCommand="spListePersonne" SelectCommandType="StoredProcedure"></
asp:SqlDataSource
>
<
br
/>
<
br
/>
<
div
>
<
telerik:RadGrid
ID
=
"rGridLineUpVisiteur"
runat
=
"server"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
Culture
=
"fr-FR"
DataSourceID
=
"sdsJoueurVisiteur"
GridLines
=
"None"
AllowAutomaticDeletes
=
"True"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
AllowMultiRowEdit
=
"True"
AllowSorting
=
"True"
ShowFooter
=
"True"
AutoGenerateDeleteColumn
=
"True"
AutoGenerateEditColumn
=
"True"
>
<
MasterTableView
DataSourceID
=
"sdsJoueurVisiteur"
DataKeyNames
=
"intIDSSJoueur"
EditMode
=
"InPlace"
CommandItemDisplay
=
"TopAndBottom"
>
<
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
>
<
Columns
>
<
telerik:GridTemplateColumn
DataField
=
"FKintIDPersonne"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter FKintIDPersonne column"
HeaderText
=
"Name of person"
SortExpression
=
"FKintIDPersonne"
UniqueName
=
"FKintIDPersonne"
>
<
EditItemTemplate
>
<
telerik:RadComboBox
ID
=
"radCombo_ListPerson"
runat
=
"server"
Culture
=
"fr-FR"
DataSourceID
=
"sdsListePersonne"
AutoPostBack
=
"true"
DataTextField
=
"strNomComplet"
DataValueField
=
"intIDPersonne"
EnableAutomaticLoadOnDemand
=
"true"
ShowMoreResultsBox
=
"true"
EnableVirtualScrolling
=
"true"
ItemsPerRequest
=
"30"
>
</
telerik:RadComboBox
>
</
EditItemTemplate
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblNamePerson"
runat
=
"server"
Text='<%# Eval("strNomComplet") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"FKintIDJoueurPosition"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter FKintIDJoueurPosition column"
HeaderText
=
"Position of person"
SortExpression
=
"FKintIDJoueurPosition"
UniqueName
=
"FKintIDJoueurPosition"
>
</
telerik:GridBoundColumn
>
<
telerik:GridCheckBoxColumn
DataField
=
"ysnRegulier"
DataType
=
"System.Boolean"
FilterControlAltText
=
"Filter ysnRegulier column"
HeaderText
=
"Full time player ?"
SortExpression
=
"ysnRegulier"
UniqueName
=
"ysnRegulier"
>
</
telerik:GridCheckBoxColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
>
</
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
>
</
FilterMenu
>
</
telerik:RadGrid
>
</
div
>
</
form
>
</
body
>
</
html
>