Questions on UI for ASP.NET AJAX Forum

110,806 questions

1 answer

334 views

I'm trying to have a linkbutton in my grid and databind the text to a field in my dataset and it doesn't seem to be working. Here are my code snippets

@ Page Language="C#" AutoEventWireup="true" CodeBehind="OpenItemsInventory.aspx.cs"

Inherits="Sterling.SNEF.Tax.Web.OpenItemsInventory" %>

@ 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>Open Items Inventory</title>

head>

telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

script type="text/javascript">

var rad_val;

function onFutureInventory(sender, args) {

document.getElementById(

'<%= btnFutureInventory.ClientID %>').disabled = true;

GetRadioValue();

var windowURL = "FutureInventoryDialog.aspx?ViewByType=" + rad_val

var oWnd = $find("<%= dlgFutureInventory.ClientID%>");

oWnd.setUrl(windowURL);

oWnd.SetSize(500, 500);

oWnd.show();

oWnd.set_initialBehaviors(Telerik.Web.UI.WindowBehaviors.Close);

oWnd.set_behaviors(Telerik.Web.UI.WindowBehaviors.Close);

oWnd.SetModal(

true);

}

function GetRadioValue()

{

message =

"";

surplusMessage =

"";

if (document.getElementById('<%= rdoAssignee.ClientID %>').checked)

{

rad_val =

"Assignee";

}

else

{

rad_val =

"State";

}

function onFutureInventoryClose(sender, eventArgs) {

document.getElementById(

'<%= btnFutureInventory.ClientID %>').disabled = false;

}

script>

telerik:RadCodeBlock>

body>

<telerik:RadScriptManager ID="OpenItemsInventoryScriptManager" runat="server">

</telerik:RadScriptManager>

<telerik:RadWindow ID="dlgFutureInventory" runat="server" Skin="Web20" EnableViewState="False"

KeepInScreenBounds="True" ReloadOnShow="True" ShowContentDuringLoad="False" VisibleStatusbar="False"

Behaviors="None" OnClientClose="onFutureInventoryClose" onclientOverlay="True">

</telerik:RadWindow>

<asp:Label ID="lblViewBy" runat="server" Font-Bold="True" Text="View By:"></asp:Label>

<asp:RadioButton ID="rdoAssignee" runat="server" Text="Assignee" GroupName="ViewByGroup"

OnCheckedChanged="ViewByGroup_CheckedChanged" Checked="true" AutoPostBack="true" />  

<asp:RadioButton ID="rdoState" runat="server" Text="State" GroupName="ViewByGroup"

OnCheckedChanged="ViewByGroup_CheckedChanged" AutoPostBack="true" />

<br />

<tr>

<asp:Label ID="lblhdrAssignee" runat="server" Text="Assignee" Font-Bold="True"></asp:Label>

</td>

<asp:Label ID="Label2" runat="server" Text="Jurisdictions" Font-Bold="True"></asp:Label>

</td>

<asp:Label ID="Label3" runat="server" Text="Open Items by Age" Font-Bold="True"></asp:Label>

</td>

<asp:Label ID="Label4" runat="server" Text="Items Left to Pay" Font-Bold="True"></asp:Label>

</td>

<asp:Label ID="Label5" runat="server" Text="%Complete" Font-Bold="True"></asp:Label>

</td>

</tr>

<tr>

<asp:Label ID="Label6" runat="server" Text="Prior" Font-Bold="True"></asp:Label>

</td>

<asp:Label ID="Label7" runat="server" Text="Current" Font-Bold="True"></asp:Label>

</td>

</tr>

<tr>

<asp:Label ID="Label1" runat="server" Text="Totals" Font-Bold="True"></asp:Label>

</td>

<asp:Label ID="lblhdrJurisdictions" runat="server"></asp:Label>

</td>

<asp:Label ID="lblhdrPrior" runat="server"></asp:Label>

</td>

<asp:Label ID="lblhdrCurrent" runat="server"></asp:Label>

</td>

<asp:Label ID="lblhdrItemsLeft" runat="server"></asp:Label>

</td>

<asp:Label ID="lblhdrPctComplete" runat="server"></asp:Label>

</td>

</tr>

</table>

<br />

<table>

<tr>

<td>

<asp:Label ID="lblCurrentandPrior" runat="server" Font-Bold="True" Font-Size="Large">Current and

Prior Inventory by Assignee

</asp:Label>

</td>

</tr>

<tr>

<td>

<telerik:RadGrid ID="grdCurrentandPrior" runat="server" AllowSorting="True" AutoGenerateColumns="False"

GridLines="None" Skin="Outlook" Style="margin-right: 0px" Width="673px" Height="260px" >

</ExportSettings>

<telerik:GridTemplateColumn HeaderText="Assignee" UniqueName="clmAssigneeState">

<asp:LinkButton ID="dataInfo" runat="server" Text='<%# Eval("Assignee") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Jurisdictions" UniqueName="clmJurisdictions">

<asp:LinkButton ID="jurisdiction" runat="server" Text='<%# Eval("JurisdictionCount") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="TemplateColumn">

<tr>

<b>Open Items by Age</b>

</td>

</tr>

<tr>

<b>Prior</b>

</td>

<b>Current</b>

</td>

</tr>

</table>

</HeaderTemplate>

<tr>

<asp:LinkButton ID="LftToPay" runat="server" Text='<%# Eval("OpenItemsCountPrior") %>' />

</td>

<asp:LinkButton ID="LinkButton1" runat="server" Text='<%# Eval("OpenItemsCountELD") %>' />

</td>

</tr>

</table>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Items Left to Pay" UniqueName="clmItemsLefttoPay">

<asp:LinkButton ID="LftToPay" runat="server" Text='<%# Eval("TotalRemainingItems") %>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="% Complete" UniqueName="clmPctComplete" DataField="PercentComplete">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AssigneeEmployeeKey" ReadOnly="True"

UniqueName="AssigneeEmployeeKey" Visible="False">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</ClientSettings>

</telerik:RadGrid>

</td>

</tr>

</table>

<br />

<table>

<tr>

<td>

<asp:Button ID="btnFutureInventory" runat="server" Text="Future Inventory" SkinID="Web20" OnClientClick="onFutureInventory(); return false;"

Width="164px" UseSubmitBehavior="false" />

</td>

</tr>

</table>

</form>

body>

html>

and here is the datatable I'm trying to bind to.

DataTable

myDataTable = new DataTable();

DataColumn myDataColumn;

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.String");

myDataColumn.ColumnName =

"Assignee";

myDataColumn.DefaultValue =

"Dixon, Kristi";

myDataTable.Columns.Add(myDataColumn);

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.Int32");

myDataColumn.ColumnName =

"JurisdictionCount";

myDataColumn.DefaultValue =

"15";

myDataTable.Columns.Add(myDataColumn);

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.Int32");

myDataColumn.ColumnName =

"OpenItemsCountPrior";

myDataColumn.DefaultValue =

"2";

myDataTable.Columns.Add(myDataColumn);

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.Int32");

myDataColumn.ColumnName =

"OpenItemsCountELD";

myDataColumn.DefaultValue =

"153";

myDataTable.Columns.Add(myDataColumn);

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.Int32");

myDataColumn.ColumnName =

"TotalRemainingItems";

myDataColumn.DefaultValue =

"155";

myDataTable.Columns.Add(myDataColumn);

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.Decimal");

myDataColumn.ColumnName =

"PercentComplete";

myDataColumn.DefaultValue =

"0.00";

myDataTable.Columns.Add(myDataColumn);

myDataColumn =

new DataColumn();

myDataColumn.DataType =

Type.GetType("System.Int32");

myDataColumn.ColumnName =

"AssigneeEmployeeKey";

myDataColumn.DefaultValue =

"1113";

myDataTable.Columns.Add(myDataColumn);

grdCurrentandPrior.DataSource = myDataTable.DefaultView;

grdCurrentandPrior.DataBind();

and another question when this is done will it allow me to sort the column by the text on the link button?

Thanks
Kristi

Grid

answered on 22 Jul 2011

2 answers

188 views

Fitting Control to 100% width and 100% height

Hello

I would like to fit the ImageEditor control to 100% of the available space on the page. However when I set the height to 100% and the width to 100% it makes the control look all funny. What setting do I do to fit the control in 100%.

Regards,
Simon

ImageEditor

answered on 22 Jul 2011

1 answer

129 views

Mouse Cursor is not enabled while editing combobox text

Hi..

we are using RadCombobox in our web application. While editing the combobox text through mouse, the text is highlighted instead place the cursor in clicked position of the text.User may sometimes need to edit only part of the text that is already present. When you click on edit, the text is highlighted. Instead what you need is the cursor. Please provide us the solution to enable the cursor position while click the text instead highlight the whole word.
As i referred your forums, http://www.telerik.com/community/forums/aspnet-ajax/combobox/radcombobox-selection-changes-on-enter-press.aspx , these same kind of bug has been fixed in your version 2010.1.216. But we are using 2010.3.1109.40 version which is advanced than mentioned. but still the issue is persist.
Please let me know if you need any other info.
it would be grate and helpful if u come up with the solution soon.

Code piece :

<telerik:RadComboBox ID="radCmbSearch" runat="server" EmptyMessage="Search" Height="100px"

Width="200px" DataTextField="Text" DataValueField="Value" DropDownWidth="200px" HighlightTemplatedItems="true" EnableLoadOnDemand="true" OnItemsRequested="radCmbSearch_ItemsRequested"> <FooterTemplate> <table> <tr> <td valign="bottom"> <asp:CheckBox runat="server" ID="chkSoundex" AutoPostBack="true" Checked="false" Width="5%" OnCheckedChanged="chkSoundex_CheckChanged"/></td> <td valign="middle"> <asp:Label runat="server" ID="lblSoundex" Text="Soundex " Width="90%"/></td> </tr> </table> </FooterTemplate> </telerik:RadComboBox>

Thanks,

ComboBox

answered on 22 Jul 2011

1 answer

114 views

Mouse Cursor is not enabled while editing combobox custom text

Hi..

we are using RadCombobox in my our web application. While editing the combobox text , the text is highlighted instead place the cursor in clicked position of the text.User may sometimes need to edit only part of the text that is already present. When you click on edit, the text is highlighted. Instead what you need is the cursor. At the moment, the cursor is obtainable if the user clicks Home or End button.

Please provide us the solution to enable the cursor position while click the text instead highlight the whole word.
As i referred your forums, http://www.telerik.com/community/forums/aspnet-ajax/combobox/radcombobox-selection-changes-on-enter-press.aspx , these same kind of bug has been fixed in your version 2010.1.216. But we are using 2010.3.1109.40 version which is advanced than mentioned. but still the issue is persist.
Please let me know if you need any other info.
it would be grate and helpful if u come up with the solution soon.

Code piece :

<telerik:RadComboBox ID="radCmbSearch" runat="server" EmptyMessage="Search" Height="100px"

Thanks,
Priya

ComboBox

answered on 22 Jul 2011

4 answers

141 views

RadCalendar.FocusedDate doesn't work correct

Hello.

I have problem when I use RadCalendar.FocusedDate on server-side. This method doesn't navigate to focused date.
I think it set focused date to right date, but calendar stay at previous focused date. And when I try to navigate next or previous month(using "<" or ">"), it seems that focused date set to right value, but why calendar don't navigate to this date after setting RadCalendar.FocusedDate???
At server-side there isn't function to navigate to date like client-side navigateToDate()?

Javascript:

function CalendarViewChanging(sender) {

var baseName = sender.id.substr(0, sender.id.lastIndexOf("_") + 1);

var calendar = $find(baseName.concat("activityCalendar"));

if (sender.id == baseName.concat("btnPrev")) {

__doPostBack(calendar.get_id().replace(/_/g, '$'), 'n:-1');

}

if (sender.id == baseName.concat("btnNext")) {

__doPostBack(calendar.get_id().replace(/_/g, '$'), 'n:1');

}

ASPX:

<asp:UpdatePanel ID="UpdatePanel" runat="server">

<ContentTemplate>

<asp:Button runat="server" ID="btnPrev" CssClass="btn btn-prev" OnClientClick="CalendarViewChanging(this);return false;" />

<telerik:RadCalendar ID="activityCalendar" AutoPostBack="true" CssClass="calendar"

EnableNavigation="false" EnableMonthYearFastNavigation="false" UseColumnHeadersAsSelectors="false"

UseRowHeadersAsSelectors="false" MultiViewColumns="3" MultiViewRows="1" runat="server"

RangeSelectionMode="OnKeyHold" OnSelectionChanged="ActivityCalendar_SelectionChanged">

</telerik:RadCalendar>

<asp:Button runat="server" ID="btnNext" CssClass="btn btn-next" OnClientClick="CalendarViewChanging(this);return false;" />

</ContentTemplate>

</asp:UpdatePanel>

ASPX.CS:

protected void ActivityCalendar_SelectionChanged(object sender, SelectedDatesEventArgs e)

{

RadCalendar calendar = sender as RadCalendar;

if (calendar.RangeSelectionStartDate != calendar.RangeMinDate && calendar.RangeSelectionEndDate !=  calendar.RangeMaxDate)

{

int diffMonths;

if (calendar.RangeSelectionStartDate.Year == calendar.RangeSelectionEndDate.Year)

{

diffMonths = calendar.RangeSelectionEndDate.Month - calendar.RangeSelectionStartDate.Month;

}

else

{

diffMonths = calendar.RangeSelectionEndDate.Month + 12 - calendar.RangeSelectionStartDate.Month;

}

switch (diffMonths)

{

case 0:

calendar.FocusedDate = calendar.RangeSelectionStartDate.AddMonths(-1);

break;

case 1:

calendar.FocusedDate = calendar.RangeSelectionStartDate;

break;

default:

calendar.FocusedDate = calendar.RangeSelectionStartDate;

break;

}

Please help me, and tip how to resolve this issue.

Thank you.

Calendar

answered on 22 Jul 2011

5 answers

215 views

radEditor control Within radTabStrip’s RadMultiPage

I am having problem validating my radEditor control. I have placed the radEditor inside radTabStrip’s RadMultiPage. Also I am using radAjaxPanel on the page. When I enter text in radEditor it still gives required field error. Here is the code :

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<%@ Register Assembly="RadTabStrip.Net2" Namespace="Telerik.WebControls" TagPrefix="rad" %>

<%@ Register namespace="Telerik.WebControls" assembly="RadEditor.Net2" tagPrefix="radE" %>

<%@ Register Assembly="RadAjax.Net2" Namespace="Telerik.WebControls" TagPrefix="rad" %>

<%@ Register Assembly="RadAjax.Net2" Namespace="Telerik.WebControls" TagPrefix="radA" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<rad:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Height="200px" Width="300px">

<rad:RadTabStrip ID="rtsTabMain" runat="server" MultiPageID="rmpTabMain" Skin="ClassicGrey" AutoPostBack="True" CausesValidation="False">

<Tabs>

<rad:Tab ID="Tab1" runat="server" PageViewID="pvProfile" Text="Profile">

</rad:Tab>

<rad:Tab ID="Tab2" runat="server" PageViewID="pvMail" Text="Mail">

</rad:Tab>

<rad:Tab ID="Tab3" runat="server" PageViewID="pvBlogs" Text="Blogs">

</rad:Tab>

<rad:Tab ID="Tab4" runat="server" PageViewID="pvPPVPickem" Text="PPV Pick’em">

</rad:Tab>

<rad:Tab ID="Tab5" runat="server" PageViewID="pvSettings" Text="Settings">

</rad:Tab>

</Tabs>

</rad:RadTabStrip><radA:AjaxLoadingPanel id="AjaxLoadingPanel2" runat="server" Width="75px" Height="75px">

<asp:Image ID="Image2" runat="server" AlternateText="Loading..." ImageUrl="~/RadControls/Ajax/Skins/Default/Loading.gif" />

</radA:AjaxLoadingPanel>

<rad:RadMultiPage ID="rmpTabMain" runat="server" Width="100%" RenderSelectedPageOnly="True" SelectedIndex="0">

<rad:PageView ID="pvProfile" runat="server"></rad:PageView>

<rad:PageView ID="pvMail" runat="server"></rad:PageView>

<rad:PageView ID="pvBlogs" runat="server">

<asp:validationsummary id="vsBlog" runat="server" CssClass="error" HeaderText="You have the following errors:" ValidationGroup="a"></asp:validationsummary>

<asp:textbox id="txbTitle" runat="server" Width="270" ValidationGroup="a"></asp:textbox>

<asp:requiredfieldvalidator id="rfvTitle" runat="server" ErrorMessage="Title" CssClass="error" ControlToValidate="txbTitle" ValidationGroup="a">*</asp:requiredfieldvalidator>

<asp:RequiredFieldValidator ID="rfvBlog" runat="server" ErrorMessage="Blog" Text="*" ControlToValidate="reTxt" ValidationGroup="a"></asp:RequiredFieldValidator>

<radE:RadEditor ID="reTxt" runat="server" ToolsFile="RadControls/Editor/BasicTools.xml" ConvertTagsToLower="True" ConvertToXhtml="False" DocumentsFilters="*.*" EnableClientSerialize="True" EnableContextMenus="True" EnableDocking="True" EnableEnhancedEdit="True" EnableHtmlIndentation="True" EnableServerSideRendering="True" EnableTab="True" ImagesFilters="*.gif,*.xbm,*.xpm,*.png,*.ief,*.jpg,*.jpe,*..jpeg,*.tiff,*.tif,*.rgb,*.g3f,*.xwd,*.pict,*.ppm,*.pgm,*.pbm,*.pnm,*.bmp,*.ras,*.pcd,*.cgm,*.mil,*.cal,*.fif,*.dsf,*.cmx,*.wi,*.dwg,*.dxf,*.svf" MediaFilters="*.asf,*.asx,*.wm,*.wmx,*.wmp,*.wma,*.wax,*.wmv,*.wvx,*.avi,*.wav,*.mpeg,*.mpg,*.mpe,*.mov,*.m1v,*.mp2,*.mpv2,*.mp2v,*.mpa,*.mp3,*.m3u,*.mid,*.midi,*.rm,*.rma,*.rmi,*.rmv,*.aif,*.aifc,*.aiff,*.au,*.snd" PassSessionData="True" RenderAsTextArea="False" Skin="Monochrome" SpellEditDistance="1" TemplateFilters="*.html,*.htm" ToolbarMode="Default" ToolsWidth="" ShowSubmitCancelButtons="false" ValidationGroup="a"></radE:RadEditor>

<asp:Button ID="btnSave" runat="server" Text="Save" ValidationGroup="a" />

<asp:Button ID="btnUpdate" Visible="false" runat="server" Text="Update" ValidationGroup="a" />

</rad:PageView>

<rad:PageView ID="pvPPVPickem" runat="server"></rad:PageView>

<rad:PageView ID="pvSettings" runat="server"></rad:PageView>

</rad:RadMultiPage>

</rad:RadAjaxPanel>

</form>

</body>

</html>

TabStrip

answered on 22 Jul 2011

1 answer

121 views

Tab Separator

Is there any way to create a separator between tabs to give the tabs a little while space around them so they aren't so close together?

RibbonBar

answered on 22 Jul 2011

2 answers

145 views

Gridview Hirarchy Exporting to Excel

gviewFormBlok.PreRender += new EventHandler(gviewFormBlok_PreRender);

gviewFormBlok.ExportSettings.ExportOnlyData = true;

gviewFormBlok.HeaderStyle.Wrap = false;

gviewFormBlok.ExportSettings.OpenInNewWindow = true;

gviewFormBlok.MasterTableView.ExportToExcel();

protected void gviewFormBlok_PreRender(object sender, EventArgs e)

{

for (int i = 0; i <= gviewFormBlok.MasterTableView.Items.Count - 1; i++)

{

gviewFormBlok.MasterTableView.Items[i].Expanded = true;

for (int j = 0; j <= gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items.Count - 1; j++)

{

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].Expanded = true;

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j]["ExpandColumn"].Visible = false;

for (int

K = 0; K <= gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].ChildItem.NestedTableViews[0].Items.Count - 1; K++)

{

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].ChildItem.NestedTableViews[0].Items[K].Expanded =

true;

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].ChildItem.NestedTableViews[0].Items[K]["ExpandColumn"].Visible = false;

}

1) I've resolved the issue displaying hirarchy button simbles in exported excel sheet but it is showing the data inproper way means user doesn't understand columns with respected values like attachment #1 (ExportToExcel).

To generate above sheet I'm using above block code

2)I've done some more R&D on this finally I got similar one and it is displaying data properly with user understanding but problem is it is showing only 2 hirarchys instead of 4 hirarchys.

For this I used below code and I got the attachment2 (ExportToExcel_LooksGood)

gviewFormBlok.MasterTableView.HierarchyDefaultExpanded = true;

gviewFormBlok.ExportSettings.ExportOnlyData = true;

gviewFormBlok.ExportSettings.IgnorePaging = true;

gviewFormBlok.MasterTableView.PageSize = 10000;

gviewFormBlok.MasterTableView.Rebind();

//add some big enough number;

gviewFormBlok.ExportSettings.OpenInNewWindow = true;

(gviewFormBlok.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem)["ExpandColumn"].Visible = false;

foreach (GridDataItem dataItem in gviewFormBlok.MasterTableView.Items)

{

dataItem["ExpandColumn"].Style["display"] = "none";

dataItem["ExpandColumn"].Visible = false;

foreach (GridDataItem dataItem1 in gviewFormBlok.MasterTableView.Items[dataItem.ItemIndex].ChildItem.NestedTableViews[0].Items)

{

dataItem1["ExpandColumn"].Style["display"] = "none";

dataItem1["ExpandColumn"].Visible = false;

}

gviewFormBlok.MasterTableView.ExportToExcel();

Finally my query is how to dispaly attachment1 (ExportToExcel) data using above code.

Grid

answered on 22 Jul 2011

9 answers

172 views

Detail data display no data in a simple hierarchical grid

Hello Guys,

I have a strange issue on a simple hierarchical grid. When I click on a row to expand on detailed rows, it shows nothing even there are data in the DB, can somebody help me to find out where the problem is? Here is my code;

<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage2.master" AutoEventWireup="false" CodeFile="Local_HRs_PersonnalMovements.aspx.vb" Inherits="Local_HRs_Local_HRs_PersonnalMovements" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Main" Runat="Server">

<asp:SqlDataSource ID="SDS_Employees" runat="server"

ConflictDetection="CompareAllValues"

ConnectionString="<%$ ConnectionStrings:DBCentreList %>"

DeleteCommand="DELETE FROM db_owner.[MDE_Employees] WHERE [EmployeeID] = @original_EmployeeID AND (([GlobeID] = @original_GlobeID) OR ([GlobeID] IS NULL AND @original_GlobeID IS NULL)) AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Birthdate] = @original_Birthdate AND [GenderID] = @original_GenderID AND (([Initials] = @original_Initials) OR ([Initials] IS NULL AND @original_Initials IS NULL))"

InsertCommand="INSERT INTO db_owner.MDE_GlobeEmployeeIDs (GlobeEmployeeID) VALUES (@GlobeID);INSERT INTO db_owner.[MDE_Employees] ([GlobeID], [FirstName], [LastName], [Birthdate], [GenderID], [Initials]) VALUES (@GlobeID, @FirstName, @LastName, @Birthdate, @GenderID, @Initials)"

OldValuesParameterFormatString="original_{0}"

SelectCommand="SELECT [EmployeeID], [GlobeID], [FirstName], [LastName], [Birthdate], [GenderID], [Initials] FROM db_owner.[MDE_Employees]"

UpdateCommand="UPDATE db_owner.[MDE_Employees] SET [GlobeID] = @GlobeID, [FirstName] = @FirstName, [LastName] = @LastName, [Birthdate] = @Birthdate, [GenderID] = @GenderID, [Initials] = @Initials WHERE [EmployeeID] = @original_EmployeeID AND (([GlobeID] = @original_GlobeID) OR ([GlobeID] IS NULL AND @original_GlobeID IS NULL)) AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Birthdate] = @original_Birthdate AND [GenderID] = @original_GenderID AND (([Initials] = @original_Initials) OR ([Initials] IS NULL AND @original_Initials IS NULL))">

<DeleteParameters>

<asp:Parameter Name="original_EmployeeID" Type="Int32" />

<asp:Parameter Name="original_GlobeID" Type="Int32" />

<asp:Parameter Name="original_FirstName" Type="String" />

<asp:Parameter Name="original_LastName" Type="String" />

<asp:Parameter Name="original_Birthdate" Type="DateTime" />

<asp:Parameter Name="original_GenderID" Type="Int32" />

<asp:Parameter Name="original_Initials" Type="String" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="GlobeID" Type="Int32" />

<asp:Parameter Name="FirstName" Type="String" />

<asp:Parameter Name="LastName" Type="String" />

<asp:Parameter Name="Birthdate" Type="DateTime" />

<asp:Parameter Name="GenderID" Type="Int32" />

<asp:Parameter Name="Initials" Type="String" />

<asp:Parameter Name="original_EmployeeID" Type="Int32" />

<asp:Parameter Name="original_GlobeID" Type="Int32" />

<asp:Parameter Name="original_FirstName" Type="String" />

<asp:Parameter Name="original_LastName" Type="String" />

<asp:Parameter Name="original_Birthdate" Type="DateTime" />

<asp:Parameter Name="original_GenderID" Type="Int32" />

<asp:Parameter Name="original_Initials" Type="String" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="GlobeID" Type="Int32" />

<asp:Parameter Name="FirstName" Type="String" />

<asp:Parameter Name="LastName" Type="String" />

<asp:Parameter Name="Birthdate" Type="DateTime" />

<asp:Parameter Name="GenderID" Type="Int32" />

<asp:Parameter Name="Initials" Type="String" />

</InsertParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SDS_Positions" runat="server"

ConflictDetection="CompareAllValues"

ConnectionString="<%$ ConnectionStrings:DBCentreList %>"

DeleteCommand="DELETE FROM db_owner.[TRE_Positions] WHERE [PositionID] = @original_PositionID AND [EmployeeID] = @original_EmployeeID AND [StatusID] = @original_StatusID AND [WorkContractID] = @original_WorkContractID AND [StartDate] = @original_StartDate AND (([EndDate] = @original_EndDate) OR ([EndDate] IS NULL AND @original_EndDate IS NULL)) AND [OrgUnitID] = @original_OrgUnitID AND [GroupingID] = @original_GroupingID AND [SubGroupingID] = @original_SubGroupingID AND [WorkRate] = @original_WorkRate AND [TransferReasonID] = @original_TransferReasonID"

InsertCommand="INSERT INTO db_owner.[TRE_Positions] ([EmployeeID], [StatusID], [WorkContractID], [StartDate], [EndDate], [OrgUnitID], [GroupingID], [SubGroupingID], [WorkRate], [TransferReasonID]) VALUES (@EmployeeID, @StatusID, @WorkContractID, @StartDate, @EndDate, @OrgUnitID, @GroupingID, @SubGroupingID, @WorkRate, @TransferReasonID)"

OldValuesParameterFormatString="original_{0}"

SelectCommand="SELECT [PositionID], [EmployeeID], [StatusID], [WorkContractID], [StartDate], [EndDate], [OrgUnitID], [GroupingID], [SubGroupingID], [WorkRate], [TransferReasonID] FROM db_owner.[TRE_Positions] WHERE ([EmployeeID] = @EmployeeID)"

UpdateCommand="UPDATE db_owner.[TRE_Positions] SET [EmployeeID] = @EmployeeID, [StatusID] = @StatusID, [WorkContractID] = @WorkContractID, [StartDate] = @StartDate, [EndDate] = @EndDate, [OrgUnitID] = @OrgUnitID, [GroupingID] = @GroupingID, [SubGroupingID] = @SubGroupingID, [WorkRate] = @WorkRate, [TransferReasonID] = @TransferReasonID WHERE [PositionID] = @original_PositionID AND [EmployeeID] = @original_EmployeeID AND [StatusID] = @original_StatusID AND [WorkContractID] = @original_WorkContractID AND [StartDate] = @original_StartDate AND (([EndDate] = @original_EndDate) OR ([EndDate] IS NULL AND @original_EndDate IS NULL)) AND [OrgUnitID] = @original_OrgUnitID AND [GroupingID] = @original_GroupingID AND [SubGroupingID] = @original_SubGroupingID AND [WorkRate] = @original_WorkRate AND [TransferReasonID] = @original_TransferReasonID">

<SelectParameters>

<asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />

</SelectParameters>

<DeleteParameters>

<asp:Parameter Name="original_PositionID" Type="Int32" />

<asp:Parameter Name="original_EmployeeID" Type="Int32" />

<asp:Parameter Name="original_StatusID" Type="Int32" />

<asp:Parameter Name="original_WorkContractID" Type="Int32" />

<asp:Parameter Name="original_StartDate" Type="DateTime" />

<asp:Parameter Name="original_EndDate" Type="DateTime" />

<asp:Parameter Name="original_OrgUnitID" Type="Int32" />

<asp:Parameter Name="original_GroupingID" Type="Int32" />

<asp:Parameter Name="original_SubGroupingID" Type="Int32" />

<asp:Parameter Name="original_WorkRate" Type="Int32" />

<asp:Parameter Name="original_TransferReasonID" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

<asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />

<asp:Parameter Name="StatusID" Type="Int32" />

<asp:Parameter Name="WorkContractID" Type="Int32" />

<asp:Parameter Name="StartDate" Type="DateTime" />

<asp:Parameter Name="EndDate" Type="DateTime" />

<asp:Parameter Name="OrgUnitID" Type="Int32" />

<asp:Parameter Name="GroupingID" Type="Int32" />

<asp:Parameter Name="SubGroupingID" Type="Int32" />

<asp:Parameter Name="WorkRate" Type="Int32" />

<asp:Parameter Name="TransferReasonID" Type="Int32" />