or
<%@ 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>protected void SetAshGraph(RadChart RadChart, string bpAshValue, string apAshValue, string apTotSedi, string bpTotSedi, string ymax, string ymin, string steps, string title, string yaxislabel) { //------------------------------Setting Rad Chart Properties RadChart.Clear(); RadChart.RemoveAllSeries(); RadChart.Margins.Left = Unit.Percentage(25); RadChart.Margins.Bottom = Unit.Percentage(17); RadChart.Margins.Right = Unit.Percentage(10); RadChart.Title.Text = title; RadChart.Title.TextFont = new System.Drawing.Font("Verdana", 9, System.Drawing.FontStyle.Bold); RadChart.Title.Background.MainColor = Color.Transparent; RadChart.Title.Background.BorderColor = Color.Transparent; RadChart.Title.Background.FillStyle = FillStyle.Solid; //----------------------setting X porperties RadChart.XAxis.Clear(); //RadChart.XAxis.Label.TextFont = new System.Drawing.Font("Verdana", 3, System.Drawing.FontStyle.Regular); //RadChart.XAxis.Items.Font = new System.Drawing.Font("Verdana", 2, System.Drawing.FontStyle.Regular); RadChart.XAxis.AddItem(""); //RadChart.XAxis.Items[0].Visible = false; //RadChart.XAxis.Items[0].Value = -1; RadChart.XAxis.AddItem("BP \nAsh"); //RadChart.XAxis.Items[1].Value = 0; RadChart.XAxis.AddItem("AP \nAsh"); //RadChart.XAxis.Items[2].Value = 1; RadChart.XAxis.AddItem(""); //RadChart.XAxis.Items[3].Visible = false; //RadChart.XAxis.Items[3].Value = -2; RadChart.XAxis.AddItem("BP \nTSA"); //RadChart.XAxis.Items[4].Value = 2; RadChart.XAxis.AddItem("AP \nTSA"); //RadChart.XAxis.Items[5].Value = 3; RadChart.BarOverlapPercent = 0; RadChart.BarWidthPercent = 100; RadChart.XAxis.AddItem(""); //RadChart.XAxis.Items[6].Value = -3; //RadChart.XAxis.Items[6].Visible = false; RadChart.XAxis.AxisWidth = 1; RadChart.XAxis.AxisColor = Color.Black; RadChart.XAxis.Label.TextColor = Color.Black; //----------------------setting y porperties RadChart.YAxis.AddRange(double.Parse(ymin), double.Parse(ymax), double.Parse(steps)); // RadChart.YAxis.AutoScale = true; RadChart.YAxis.Label.Text = yaxislabel; RadChart.YAxis.Label.TextFont = new System.Drawing.Font("Verdana", 8, System.Drawing.FontStyle.Bold); RadChart.YAxis.AxisColor = Color.Black; RadChart.YAxis.Label.TextColor = Color.Black; RadChart.YAxis.AxisWidth = 1; RadChart.YAxis.DefaultItemColor = System.Drawing.Color.Black; //RadChart.YAxis.VisibleValues = ChartAxisVisibleValues.Positive; RadChart.XAxis.DefaultItemColor = System.Drawing.Color.Black; //RadChart.XAxis.VisibleValues = ChartAxisVisibleValues.Positive; //RadChart.XAxis.AutoScale = false; //RadChart.XAxis.AutoShrink = true; //------------------------------Adding Chart series Properties ChartSeries s = RadChart.CreateSeries("Series", Color.DarkViolet, ChartSeriesType.Bar); s.Items.Series.Appearance.FillStyle = FillStyle.Solid; s.Items.Series.Appearance.BorderColor = Color.Black; ChartSeriesItem items0 = new ChartSeriesItem(); items0.YValue = double.Parse(ymin); //items0.XValue = -1; s.Items.Add(items0); s.Items[0].Label = " "; //-----------------------------first Item i.e Bp/Ap reading ChartSeriesItem items1 = new ChartSeriesItem(); double dd; if (double.TryParse(bpAshValue, out dd)) { items1.YValue = dd; s.Items.Add(items1); //anks //s.Items[0].Appearance.MainColor = Color.FromArgb(153, 51, 101); //s.Items[0].Appearance.SecondColor = Color.FromArgb(153, 51, 101); s.Items[1].Appearance.MainColor = Color.FromArgb(198, 83, 138); s.Items[1].Appearance.SecondColor = Color.FromArgb(198, 83, 138); s.Items[1].Label = " "; } else { items1.YValue = dd; s.Items.Add(items1); s.Items[1].Label = " "; } ChartSeriesItem items2 = new ChartSeriesItem(); if (double.TryParse(apAshValue, out dd)) { items2.YValue = dd; s.Items.Add(items2); //anks //s.Items[1].Appearance.MainColor = Color.FromArgb(154, 153, 255); //s.Items[1].Appearance.SecondColor = Color.FromArgb(154, 153, 255); s.Items[2].Appearance.MainColor = Color.FromArgb(180, 179, 255); s.Items[2].Appearance.SecondColor = Color.FromArgb(180, 179, 255); s.Items[2].Label = " "; } ChartSeriesItem items3 = new ChartSeriesItem(); items3.YValue = double.Parse(ymin); //items3.XValue = -2; s.Items.Add(items3); s.Items[3].Label = " "; ChartSeriesItem items4 = new ChartSeriesItem(); if (double.TryParse(bpTotSedi, out dd)) { items4.YValue = dd; s.Items.Add(items4); //anks //s.Items[2].Appearance.MainColor = Color.FromArgb(153, 51, 101); //s.Items[2].Appearance.SecondColor = Color.FromArgb(153, 51, 101); s.Items[4].Appearance.MainColor = Color.FromArgb(198, 83, 138); s.Items[4].Appearance.SecondColor = Color.FromArgb(198, 83, 138); s.Items[4].Label = " "; } ChartSeriesItem items5 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { items5.YValue = dd; s.Items.Add(items5); //anks //s.Items[3].Appearance.MainColor = Color.FromArgb(154, 153, 255); //s.Items[3].Appearance.SecondColor = Color.FromArgb(154, 153, 255); s.Items[5].Appearance.MainColor = Color.FromArgb(180, 179, 255); s.Items[5].Appearance.SecondColor = Color.FromArgb(180, 179, 255); s.Items[5].Label = " "; } ChartSeriesItem items6 = new ChartSeriesItem(); items6.YValue = double.Parse(ymin); //items6.XValue = -3; s.Items.Add(items6); s.Items[6].Label = " "; RadChart.AddChartSeries(s); //anks ChartSeries s1 = RadChart.CreateSeries("LineSeries", Color.Black, ChartSeriesType.Line); s1.Items.Series.Appearance.FillStyle = FillStyle.Solid; s1.Items.Series.Appearance.BorderColor = Color.Black; s1.Items.Series.ShowLabels = true; //RadChart.XAxis.LayoutStyle = ChartAxisLayoutStyle.Between; RadChart.XAxis.LayoutStyle = ChartAxisLayoutStyle.Normal; ChartSeriesItem LineItems0 = new ChartSeriesItem(); if (double.TryParse(bpAshValue, out dd)) { LineItems0.YValue = 1.5; s1.Items.Add(LineItems0); s1.Items[0].Appearance.MainColor = Color.Black; s1.Items[0].Label = "This is a strip line line li"; s1.Items[0].Series.LabelAppearance.TextFont = new Font("Times New Roman", 9, FontStyle.Bold | FontStyle.Italic); s1.Items[0].Series.LabelAppearance.TextColor = Color.Black; //s1.Items[0].Series.LabelAppearance.TextColor = Color.Gold; } else { LineItems0.YValue = 1.5; s1.Items.Add(LineItems0); s1.Items[0].Label = " "; } ChartSeriesItem LineItems1 = new ChartSeriesItem(); if (double.TryParse(bpAshValue, out dd)) { LineItems1.YValue = 1.5; s1.Items.Add(LineItems1); s1.Items[1].Appearance.MainColor = Color.Black; s1.Items[1].Label = " "; } ChartSeriesItem LineItems2 = new ChartSeriesItem(); if (double.TryParse(apAshValue, out dd)) { LineItems2.YValue = 1.5; s1.Items.Add(LineItems2); s1.Items[2].Appearance.MainColor = Color.Black; s1.Items[2].Label = " "; } ChartSeriesItem LineItems3 = new ChartSeriesItem(); if (double.TryParse(bpTotSedi, out dd)) { LineItems3.YValue = 1.5; s1.Items.Add(LineItems3); s1.Items[3].Appearance.MainColor = Color.Black; s1.Items[3].Label = " "; } ChartSeriesItem LineItems4 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { LineItems4.YValue = 1.5; s1.Items.Add(LineItems4); s1.Items[4].Appearance.MainColor = Color.Black; s1.Items[4].Label = " "; } ChartSeriesItem LineItems5 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { LineItems5.YValue = 1.5; s1.Items.Add(LineItems5); s1.Items[5].Appearance.MainColor = Color.Black; s1.Items[5].Label = " "; } ChartSeriesItem LineItems6 = new ChartSeriesItem(); if (double.TryParse(apTotSedi, out dd)) { LineItems6.YValue = 1.5; s1.Items.Add(LineItems6); s1.Items[6].Appearance.MainColor = Color.Black; s1.Items[6].Label = " "; } RadChart.AddChartSeries(s1); }<telerik:GridViewDataColumn Width="*"
CellStyleSelector="{StaticResource InvalidHomePhoneStyleSelector}"
DataFormatString="{}{0:(###) ###-####}"
DataMemberBinding="{Binding HomePhone,
Converter={StaticResource PhoneNumberNumericConverter}}"
ShowDistinctFilters="False"
UniqueName="Phone" TextAlignment="Right">
<telerik:GridViewDataColumn.Header>
<TextBlock MaxHeight="32"
Text="{Binding Path=Resource.HomePhone,
Source={StaticResource Messages},
Mode=OneTime}"
TextTrimming="WordEllipsis"
TextWrapping="Wrap" />
</telerik:GridViewDataColumn.Header>
<telerik:GridViewDataColumn.CellEditTemplate>
<DataTemplate>
<telerik:RadMaskedTextBox EmptyContent="{Binding Path=Resource.EnterPhone,
Source={StaticResource Messages},
Mode=OneTime}"
FontStyle="Normal"
IsSpinEnabled="False"
Mask="(000) 000-0000"
MaskType="Standard"
Value="{Binding HomePhone,
Mode=TwoWay,
Converter={StaticResource PhoneNumberNumericConverter},
ConverterParameter=String}" TextAlignment="Right" HorizontalContentAlignment="Right" />
</DataTemplate>
</telerik:GridViewDataColumn.CellEditTemplate>
</telerik:GridViewDataColumn>

function droppedOnInput(args) { var target = args.get_htmlElement(); if (target.tagName == "INPUT") { target.style.cursor = "INPUT"; target.value += args.get_sourceNode().get_text(); args.set_cancel(true); return true; }