This is a migrated thread and some comments may be shown as answers.

Advance Add,Edit Forms in RadScheduler

17 Answers 465 Views

Grid

This is a migrated thread and some comments may be shown as answers.

kunal patel asked on 13 Jan 2010, 12:20 PM

Hello,

         I have used Rad Scheduler in my application.
         Also, I am using the Recurrence Rule option for Scheduling the tasks.
         Now, I want in my application that, while adding new task in Scheduler,
               User can select Department from Combo Box, User Name from Another combo box.
               Also, user can select one value from radio button list.

   Same must go with the Advance Edit Form.

          I have already downloaded the examples given in the Telerik website, but they are using User Controls & are very complicated
          to be applied in my application.
          If anyone can provide me with the easier way, then it will be very useful to me.

         Please Reply,

Thanks & Regards
Kunal Patel

17 Answers, 1 is accepted

answered on 13 Jan 2010, 01:25 PM

Hello Kunal,

You can place the required controls directly in the AdvanceEditForm and AdvanceInsertForm:
aspx:

    
            <telerik:RadScheduler ID="RadScheduler1" StartEditingInAdvancedForm="true" StartInsertingInAdvancedForm="true" DataSourceID="SqlDataSource1" runat="server"...> 
        
                 <AdvancedInsertTemplate> 
        
                       <telerik:RadComboBox ID="RadComboBox1" runat="server">                                         
        
                       </telerik:RadComboBox> 
        
                       <telerik:RadComboBox ID="RadComboBox2" runat="server">                                         
        
                       </telerik:RadComboBox> 
        
                       .... 
        
                 </AdvancedInsertTemplate> 
        
                 <AdvancedEditTemplate>           
        
                       <telerik:RadComboBox ID="RadComboBox3" runat="server">                                         
        
                       </telerik:RadComboBox> 
        
                       <telerik:RadComboBox ID="RadComboBox4" runat="server">                                         
        
                       </telerik:RadComboBox> 
        
                       .... 
        
                 </AdvancedEditTemplate> 
        
            </telerik:RadScheduler>

Hope this helps..
Princy.

answered on 25 Nov 2011, 10:10 AM

Thank you for Your reply.. When I select my Options Value.. Only Two Combos are visible... but there is nothing to enter in RadScheduler
My Question is.... Is this Possible without any JavaScript,Web User Controls etc to Bind these combos with my RadScheduler??
any Simple and easy way??
Means these should be attached in my RadScheduler and when i should Select my values and save these should work same as Resource Type.
My combos are actually working like cascade combos thats why i dont want to use Resource Type.And i want to view these in my RadScheduler.

<telerik:RadScheduler ID="RadScheduler1" runat="server"

DataDescriptionField="Description" DataEndField="End" DataKeyField="ID"

DataSourceID="SqlDataSource1" DataStartField="Start"

DataSubjectField="Subject" >

<telerik:RadComboBox ID="RadComboBox1" runat="server">

</telerik:RadComboBox>

<telerik:RadComboBox ID="RadComboBox2" runat="server">

</telerik:RadComboBox>

</AdvancedInsertTemplate>

</telerik:RadScheduler>

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

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

SelectCommand="SELECT * FROM [Appointment]"></asp:SqlDataSource>

answered on 29 Nov 2011, 06:58 AM

1.jpg

2.jpg

Hello Peter,
As you suggested this Link/TV Telerik.I found this helpful to me.But i am still facing Problem. now i am writing here steps how and what i did.. and where i did wrong anything please help me.Thanks

1. I am Using Telerik Q3 Sp1 2009

2. Downloaded Pack from here
http://www.telerik.com/support/kb/aspnet-ajax/scheduler/sample-project-of-the-customizing-the-advanced-template-example.aspx
SchedulerCustomAdvancedFormQ3_SP1_2009.zip

3. Add all in my Project and this Run successfully.In this all data is saving in XML file(Appointments_CustomTemplates.xml)

4.Then I followed all these steps
http://www.telerik.com/support/kb/aspnet-ajax/scheduler/related-load-on-demand-radcomboboxes-in-the-advanced-form-of-radscheduler.aspx
and Put my Db String because in SchedulerCustomAdvancedFormQ3_SP1_2009.zip there is no Telerik db etc.

5.When I run my project i got this Window 1.jpg and when i click 'continue' it continues and shows same as me 2.jpg.

6.Two Combos are added in my Form but they are not working. means there is no data from my Database Table.

7. And when i make New appointment this is saving my data into XML File (without Country and Content) , but not changing in my DB as there is select insert update are in Dafult.aspx so this should save in DB but no data is inserted in table.

Please help me what should I do? I need same Combos in my RadScheuler.If this is solved I hope i can do next.
Thanks

answered on 29 Nov 2011, 07:58 AM

Hello Peter
Now I Followed all these steps

http://www.telerik.com/support/kb/aspnet-ajax/scheduler/implement-related-radcombobox-controls-in-the-advanced-form.aspx

and in my RadComboboxes are Showing Continents and Countries... and this data is coming from my Database Table.
But i am facing still problem is that.. Its all Appointments data saving in XML File...
How can I Save all this stuff into my Database?
and I am using this code to save data into my database...

<telerik:RadScheduler runat="server" ID="RadScheduler1" OnClientFormCreated="schedulerFormCreated"

Width="750px" SelectedDate="2009-03-30" TimeZoneOffset="03:00:00" CustomAttributeNames="Description,Continent,Country"

OnDataBound="RadScheduler1_DataBound" OnAppointmentDataBound="RadScheduler1_AppointmentDataBound"

DataEndField="End" DataKeyField="ID" DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentID"

DataStartField="Start" DataSubjectField="Subject"

HoursPanelTimeFormat="htt" ValidationGroup="RadScheduler1"

DataSourceID="SqlDataSource1"> <AdvancedForm Modal="true" />

<AdvancedEditTemplate>

<scheduler:AdvancedForm runat="server" ID="AdvancedEditForm1" Mode="Edit" Subject='<%# Bind("Subject") %>'

Start='<%# Bind("Start") %>' End='<%# Bind("End") %>' RecurrenceRuleText='<%# Bind("RecurrenceRule") %>'

Continent='<%# Bind("Continent") %>'

Country='<%# Bind("Country") %>'/>

</AdvancedEditTemplate>

<AdvancedInsertTemplate>

<scheduler:AdvancedForm runat="server" ID="AdvancedInsertForm1" Mode="Insert" Subject='<%# Bind("Subject") %>'

Start='<%# Bind("Start") %>' End='<%# Bind("End") %>' RecurrenceRuleText='<%# Bind("RecurrenceRule") %>'

Continent='<%# Bind("Continent") %>'

Country='<%# Bind("Country") %>' />

</AdvancedInsertTemplate>

</telerik:RadScheduler>

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

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

DeleteCommand="DELETE FROM [Appointment] WHERE [ID] = @ID"

InsertCommand="INSERT INTO [Appointment] ([Subject], [Start], [End], [UserID], [RoomID], [RecurrenceRule], [RecurrenceParentID], [Description], [Continent], [Country]) VALUES (@Subject, @Start, @End, @UserID, @RoomID, @RecurrenceRule, @RecurrenceParentID, @Description, @Continent, @Country)"

SelectCommand="SELECT * FROM [Appointment]"

UpdateCommand="UPDATE [Appointment] SET [Subject] = @Subject, [Start] = @Start, [End] = @End, [UserID] = @UserID, [RoomID] = @RoomID, [RecurrenceRule] = @RecurrenceRule, [RecurrenceParentID] = @RecurrenceParentID, [Description] = @Description, [Continent] = @Continent, [Country] = @Country WHERE [ID] = @ID">

<DeleteParameters>

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

</DeleteParameters>

<UpdateParameters>

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

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

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

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

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

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

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

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

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

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

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

</UpdateParameters>

<InsertParameters>

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

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

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

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

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

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

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

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

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

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

</InsertParameters>

</asp:SqlDataSource>

Please provide some help me..
Thanks and Regards

answered on 02 Dec 2011, 05:49 AM

Hello Peter
Thank you so much.
I was doing something wrong...i was using RelatedCombosInAdvForm instead of RelatedLoDRadComboboxesinAdvForm.
So now my all data is saving into Telerik.mdf database afters using (RelatedLoDRadComboboxesinAdvForm)
I have some other queries should i put here or should start a new thread?

(RelatedLoDRadComboboxesinAdvForm) now is running in my Project Successfully.
Using this i want to add my own textboxes and 3 related combos in my RadSchdeuler,Like my attached image 4.jpg.
How is this possible?
Any help topic or Video please suggest?

Again thanks Mr.Peter

answered on 02 Dec 2011, 07:26 AM

Hello Peter
I have added successfully custom attributes in RadScudler's AdvancedForm. My own textboxes.
Now my question is i want to bind 3 RadCombos and 1 Textbox.
Suppose if RadCombob1 data is selected then according to this Combo's data 2 Combos and data of textbox should be changed. This is similar as
http://demos.telerik.com/aspnet-ajax/scheduler/examples/customattributes/defaultvb.aspx
and Continents and Countries example.

But all this in two examplaes i want to do in RadScheduler Advance Form.Is this possible?

(Like
- Conitnent is selected and Countries are present in next combo,
- Country is selected then
- Cities are in third Combobox list, when user selects
- City it should be displayed in my textbox.
and all data should be saved into DB.)
( I am using RelatedLoDRadComboboxesInAdvForm)
Regards