I have implemented the AppointmentInsert and it works perfectly. However, the AppointmentUpdate and AppointmentDelete never fire. any ideas?
<
telerik:RadScriptManager ID="RadScriptManager1" Runat="server" />
<telerik:RadAjaxManager runat="Server" ID="RadAjaxManager1">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadScheduler1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007" />
<telerik:RadScheduler ID="RadScheduler1" runat="server" Skin="Office2007"
OnAppointmentInsert="RadScheduler1_AppointmentInsert"
OnAppointmentDelete="RadScheduler1_AppointmentDelete"
OnAppointmentUpdate="RadScheduler1_AppointmentUpdate"
DataKeyField="AppointmentID" DataStartField="StartDate" DataEndField="EndDate" DataSubjectField="Subject"
DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentID"
DisplayDeleteConfirmation="true" />
| <radg:radgrid id="Relaciones" style="Z-INDEX: -111; LEFT: 8px; POSITION: absolute; TOP: 432px" runat="server" Height="96px" Width="940px" AllowPaging="True" VirtualItemCount="2" cssclass="RadGrid" GroupingEnabled="False" EnableAsyncRequests="True" HorizontalAlign="Center" GridLines="Vertical" AllowSorting="True" AllowFilteringByColumn="True"> |
| <MasterTableView HierarchyLoadMode="ServerBind" HierarchyDefaultExpanded="False" AutoGenerateColumns="False" CssClass="MasterTable" AllowFilteringByColumn="True" GridLines="Vertical" HorizontalAlign="Center"> |
| <DetailTables> |
| <radg:GridTableView DataKeyNames="id_relacion" AutoGenerateColumns="False" AllowSorting="False" DataMember="ItemsDetails" PageSize="1" AllowFilteringByColumn="False" GridLines="Vertical" HorizontalAlign="Center"> |
| <ParentTableRelation> |
| <radg:GridRelationFields DetailKeyField="id_relacion" MasterKeyField="id_relacion"></radg:GridRelationFields> |
| </ParentTableRelation> |
| <Columns> |
| <radg:GridBoundColumn HeaderText="Fecha Origen" ShowSortIcon="False" DataField="Fecha_Origen" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Fecha_Origen" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Original" DataType="System.Double" ShowSortIcon="False" DataField="Monto_Original" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Monto_Original" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Vto." DataType="System.Double" ShowSortIcon="False" DataField="Monto_Venci" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Monto_Venci" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Origen" ShowSortIcon="False" DataField="Origen_Nombre" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Origen_Nombre" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Categoria" ShowSortIcon="False" DataField="Cat_Nombre" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Cat_Nombre" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Fecha Origen" ShowSortIcon="False" DataField="Fecha_Origen_Prov" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Fecha_Origen_Prov" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Original" ShowSortIcon="False" DataField="Monto_Original_Prov" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Monto_Original_Prov" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Vto." ShowSortIcon="False" DataField="Monto_Venci_Prov" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Monto_Venci_prov" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Periodico" ShowSortIcon="False" DataField="Monto_Periodico_Prov" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Monto_Periodico_Prov" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Origen" ShowSortIcon="False" DataField="Origen_Nombre_Prov" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Origen_Nombre_Prov" Reorderable="False"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Categoria" ShowSortIcon="False" DataField="Cat_Nombre_Prov" ReadOnly="True" AllowSorting="False" AllowFiltering="False" UniqueName="Cat_Nombre_Prov" Reorderable="False"></radg:GridBoundColumn> |
| </Columns> |
| <PagerStyle Visible="False"></PagerStyle> |
| <ItemStyle BackColor="#FCEDB0"></ItemStyle> |
| <HeaderStyle ForeColor="Blue" BackColor="#003366"></HeaderStyle> |
| <AlternatingItemStyle BackColor="#D5B96A"></AlternatingItemStyle> |
| </radg:GridTableView> |
| </DetailTables> |
| <Columns> |
| <radg:GridBoundColumn Visible="False" DataField="id_relacion" AllowFiltering="False" UniqueName="id_relacion"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Fecha Estado" DataField="Fecha" UniqueName="Fecha"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Tipo Estado" DataField="descripcion" UniqueName="descripcion"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Estimado" DataType="System.Double" DataField="Monto_Estimado" UniqueName="Estimado_Provisorio_SSRP"></radg:GridBoundColumn> |
| <radg:GridBoundColumn HeaderText="Monto Definitivo" DataType="System.Double" DataField="Monto_Definitivo" UniqueName="Monto_Definitivo"></radg:GridBoundColumn> |
| </Columns> |
| <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn"> |
| <HeaderStyle Width="19px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| </MasterTableView> |
| <AlternatingItemStyle HorizontalAlign="Center" Height="24px" CssClass="GridAltRow" VerticalAlign="Middle"></AlternatingItemStyle> |
| <FooterStyle HorizontalAlign="Center"></FooterStyle> |
| <FilterMenu NotSelectedImageUrl="~/RadControls/Grid/Skins/Default/NotSelectedMenu.gif" HoverBackColor="LightSteelBlue" HoverBorderColor="Navy" SelectColumnBackColor="Control" EnableViewState="False" SelectedImageUrl="~/RadControls/Grid/Skins/Default/SelectedMenu.gif" TextColumnBackColor="Window"></FilterMenu> |
| <SelectedItemStyle HorizontalAlign="Center"></SelectedItemStyle> |
| <ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True" AllowExpandCollapse="True"> |
| <Selecting AllowRowSelect="True"></Selecting> |
| <Scrolling ScrollHeight="" AllowScroll="True" EnableAJAXScrollPaging="True"></Scrolling> |
| </ClientSettings> |
| <HeaderStyle HorizontalAlign="Center" CssClass="GridHeader" BackColor="#003366"></HeaderStyle> |
| <PagerStyle BackColor="#003366" CssClass="GridPager" Mode="NextPrevAndNumeric"></PagerStyle> |
| <ItemStyle HorizontalAlign="Center" Height="24px" CssClass="GridRow"></ItemStyle> |
| </radg:radgrid> |
| Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load |
| 'Introducir aquà el código de usuario para inicializar la página |
| If Not Page.IsPostBack Then |
| cargarGrillaRelaciones() |
| End If |
| End Sub |
| Private Sub cargarGrillaRelaciones() |
| Dim dao As New DAO_Clase.DAO_Clase |
| Dim ds As DataSet |
| ds = dao.ItemsRelaciones() |
| If (Not ds.HasErrors) Then |
| Me.Relaciones.DataSource = ds |
| Me.Relaciones.DataBind() |
| End If |
| End Sub |
| Private Sub Relaciones_DetailTableDataBind(ByVal source As Object, ByVal e As Telerik.WebControls.GridDetailTableDataBindEventArgs) Handles Relaciones.DetailTableDataBind |
| Dim parentItem As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem) |
| If parentItem.Edit Then |
| Return |
| End If |
| If (e.DetailTableView.DataMember = "ItemsDetails") Then |
| Dim id_rela As Integer = CType(parentItem("id_relacion").Text, Integer) |
| Dim dao As New DAO_Clase.DAO_Clase |
| Dim ds As DataSet = dao.ItemsDeRelacion(id_rela) |
| e.DetailTableView.DataSource = ds |
| End If |
| End Sub |
<%@ Page Language="C#" MasterPageFile="~/Master/UserPages.master" AutoEventWireup="true"
CodeFile="lkup_pronotes2.aspx.cs" Inherits="Lookup_lkup_pronotes2" %>
<%@ Register Assembly="RadAjax.Net2" Namespace="Telerik.WebControls" TagPrefix="radA" %>
<%@ Register Assembly="RadInput.Net2" Namespace="Telerik.WebControls" TagPrefix="radI" %>
<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cphWebData" runat="Server">
<div class='content'>
<radA:RadAjaxPanel ID="RadAjaxPanel1" LoadingPanelID="AjaxLoadingPanel1" runat="server"
Height="100%" Width="100%">
<radg:radgrid ID="RadGrid1" runat="server" OnDetailTableDataBind="RadGrid1_DetailTableDataBind"
AllowExpandCollapse="true" AllowMultiRowSelection="false">
<MasterTableView CommandItemDisplay="Bottom">
<%-- <EditFormSettings EditFormType="Template">
<FormTemplate>
<table style="width: 80%" align="center">
</table>
</FormTemplate>
</EditFormSettings> --%>
<Columns>
<radG:GridBoundColumn HeaderText="ID" UniqueName="cpk_pronotes" DataField="cpk_pronotes" Display="False" ReadOnly="True" />
<radG:GridBoundColumn HeaderText="Entered" UniqueName="date_" DataField="date_" HeaderButtonType="TextButton" />
<radG:GridBoundColumn HeaderText="Entered By" UniqueName="username" DataField="username" HeaderButtonType="TextButton" />
<radG:GridBoundColumn HeaderText="Subject" UniqueName="subject" DataField="subject" HeaderButtonType="TextButton" />
<radG:GridBoundColumn HeaderText="F/U Date" UniqueName="followup" DataField="followup" DataFormatString="{0:d}" HeaderButtonType="TextButton" />
<radG:GridBoundColumn HeaderText="F/U Assigned To..." UniqueName="funame" DataField="funame" HeaderButtonType="TextButton" />
<radG:GridBoundColumn HeaderText="F/U Complete" UniqueName="fudone" DataField="fudone" HeaderButtonType="TextButton" />
<%-- <radG:GridButtonColumn ButtonType="PushButton" Text="Edit" CommandName="Edit" UniqueName="edit" />
<radG:GridButtonColumn ButtonType="PushButton" Text="Delete" CommandName="Delete" UniqueName="delete" /> --%>
</Columns>
<DetailTables>
<radG:GridTableView DataKeyNames="cpk_pronotes">
<Columns>
<radG:GridBoundColumn HeaderText="ID" DataField="cpk_pronotes" Display="False" ReadOnly="True" />
<radG:GridBoundColumn HeaderText="Notes" UniqueName="notes" DataField="notes" HeaderButtonType="TextButton" />
</Columns>
</radG:GridTableView>
</DetailTables>
<CommandItemTemplate>
<asp:Button ID="btnInsert" CommandName="InitInsert"
runat="server" Text="Add Item" />
<asp:Button ID="btnRefresh" CommandName="RebindGrid"
runat="server" Text="Refresh List" />
</CommandItemTemplate>
</MasterTableView>
<HeaderStyle Font-Bold="True" Font-Size="14px" Font-Underline="False" HorizontalAlign="Left" />
<ItemStyle Font-Size="12px" />
<AlternatingItemStyle Font-Size="12px" />
</radg:radgrid>
</radA:RadAjaxPanel>
<radA:AjaxLoadingPanel ID="AjaxLoadingPanel1" runat="server" Height="75px" Width="75px">
<asp:Image ID="Image1" runat="server" AlternateText="Loading..." ImageUrl="~/RadControls/Ajax/Skins/Default/Loading3.gif" />
</radA:AjaxLoadingPanel>
</div>
<asp:SqlDataSource ID="dsParent" runat="server" DataSourceMode="DataReader" ConflictDetection="CompareAllValues"
OldValuesParameterFormatString="Original_{0}" OnUpdating="dsParent_RecordChanged"></asp:SqlDataSource>
<asp:SqlDataSource ID="dsDetails" runat="server" DataSourceMode="DataReader"></asp:SqlDataSource>
</asp:Content>
-----------------------------------------------
using System;
using System.Web.UI.WebControls;
using SQLDataAccess;
using Telerik.WebControls;
public partial class Lookup_lkup_pronotes2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
WP_Utility wpUtility = new WP_Utility();
wpUtility.GridDefaults(RadGrid1);
SqlBuilder sbCommand = new SqlBuilder();
dsParent.ConnectionString = sbCommand.GetConnectionString();
dsParent.SelectCommand = "wa_ProgressNotesList";
dsParent.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
if (!IsPostBack)
{
SessionParameter spMrn = new SessionParameter("MRN", TypeCode.String, "MRN");
dsParent.SelectParameters.Add(spMrn);
}
dsParent.DeleteCommand = "exec wa_ProgressNoteDelete @Original_CPK_PRONOTES";
dsParent.UpdateParameters.Add("CPK_PRONOTES", TypeCode.Int32, "0");
dsParent.UpdateParameters.Add("DATE_", TypeCode.String, "");
dsParent.UpdateParameters.Add("USERNAME", TypeCode.String, "");
dsParent.UpdateParameters.Add("SUBJECT", TypeCode.String, "");
dsParent.UpdateParameters.Add("FOLLOWUP", TypeCode.String, "");
dsParent.UpdateParameters.Add("FUNAME", TypeCode.String, "");
dsParent.UpdateParameters.Add("FUDONE", TypeCode.String, "");
//foreach (Parameter param in dsParent.UpdateParameters)
//{
// if (param.Name.Length < 4 || !param.Name.Substring(0, 4).Equals("CPK_"))
// sbCommand.UpdateFields.Add(param.Name.ToUpper());
//}
dsParent.UpdateCommand = "wa_ProgressNoteUpdate";
dsParent.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure;
dsParent.InsertParameters.Add("DATE_", TypeCode.String, "");
dsParent.InsertParameters.Add("USERNAME", TypeCode.String, "");
dsParent.InsertParameters.Add("SUBJECT", TypeCode.String, "");
dsParent.InsertParameters.Add("FOLLOWUP", TypeCode.String, "");
dsParent.InsertParameters.Add("FUNAME", TypeCode.String, "");
dsParent.InsertParameters.Add("FUDONE", TypeCode.String, "");
dsParent.InsertCommand = "wa_ProgressNoteInsert";
dsParent.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
RadGrid1.DataSourceID = "dsParent";
RadGrid1.MasterTableView.DataKeyNames = new string[] { "cpk_pronotes" };
}
protected void RadGrid1_DetailTableDataBind(object source, Telerik.WebControls.GridDetailTableDataBindEventArgs e)
{
GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
//string strKey = dataItem["pk"].Text;
string strKey = dataItem.GetDataKeyValue("cpk_pronotes").ToString();
SqlBuilder sbCommand = new SqlBuilder();
dsDetails.ConnectionString = sbCommand.GetConnectionString();
dsDetails.SelectCommand = "wa_PatientPronotesDetails";
dsDetails.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
if (dsDetails.SelectParameters.Count < 1)
{
dsDetails.SelectParameters.Add("CPK_PRONOTES", TypeCode.Int32, strKey);
}
else
{
Parameter pFKey = new Parameter("CPK_PRONOTES", TypeCode.Int32, strKey);
dsDetails.SelectParameters["CPK_PRONOTES"] = pFKey;
}
e.DetailTableView.DataSourceID = "dsDetails";
e.DetailTableView.Width = Unit.Percentage(90);
}
protected void dsParent_RecordChanged(object sender, SqlDataSourceCommandEventArgs e)
{
string eventname = e.Command.CommandText.Substring(0, 6).ToUpper();
string reason = "";
string username = Session["LastName"].ToString() + "," + Session["FirstName"].ToString();
switch (eventname)
{
case "UPDATE":
//reason = "Patient Contact Information updated.";
try
{
int pk = Convert.ToInt32(e.Command.Parameters["@Original_CPK_PRONOTES"].Value);
DataAccess Data = new DataAccess("PRONOTES", "CPK_PRONOTES", pk);
Data.LogTransaction(e.Command.Parameters, "original_", Convert.ToInt32(Session["cpruser_no"]), reason, username);
}
catch (Exception oError)
{
reason = oError.ToString();
reason = reason.Trim();
}
break;
default:
break;
}
}
}
Thanks for the help. Dan