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

database table structure

73 Answers 1010 Views
ScheduleView
This is a migrated thread and some comments may be shown as answers.
schneeflocke
Top achievements
Rank 1
schneeflocke asked on 08 Mar 2011, 02:45 PM
Hi,

how will the entity model look for the new ScheduleView comparing to the old Scheduler?
Is there a sample or document available describing the table structure needed for the new ScheduleView?

We are currently developing a solution based on the "old" Scheduler using more or less the sample database layout described here: http://www.telerik.com/help/silverlight/radscheduler-populating-with-data-ria-service-creating-database.html

We just want to figure out if there are changes to the entity model an how big they are.

Thanks

Stefan

73 Answers, 1 is accepted

Sort by
0
Valeri Hristov
Telerik team
answered on 10 Mar 2011, 11:35 AM
Since in RadScheduleView the IAppointment properties are virtually the same as in RadScheduler, the database structure will be very similar. We are preparing a new reference application that will demonstrate the best way in our opinion to store appointments, resources, categories and time markers in a database. It will be available shortly after the Q1 2011 release next week.

Regards,
Valeri Hristov
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
0
Michael Rodriguez
Top achievements
Rank 1
answered on 17 Mar 2011, 10:27 PM
Where will that reference application be published and how can I see it?
0
George
Telerik team
answered on 23 Mar 2011, 04:55 PM
Hi Michael,

 
We are preparing some blog posts about this scenario. They will be published on our site by the end of this week.

Best wishes,
George
the Telerik team
0
Sami
Top achievements
Rank 2
Iron
Iron
Iron
answered on 26 Mar 2011, 12:11 AM
Hi, do you have any new about this demo?
Thanks in advance.
0
George
Telerik team
answered on 28 Mar 2011, 11:16 AM
Hello,

 
As I said - we are working on such integration example - how to use RadScheduleView control with RIA services (and using EF in WPF). Here are some instructions how to run the project:

  1. Run the ScheduleViewDB.sql file in your Management Studio. This will generate the Database for the RadScheduleView control.
  2. Create some resource types and resources in the database. The RadScheduleView control needs them in order to populate the ResourceTypesSource collection.
  3. Open the ScheduleView_EF_SL solution and modify the connection string in the ScheduleView_EF_SL.Web project in the Web.config file.
  4. Place the Telerik dlls in the Binaries folder.
  5. Run the project.

You could create, edit, delete appointments in run time. Every time you click the Save button, the changes will be saved in the database. No additional code is required. For the purpose of a real-time application, the Appointments are loaded from the database in the visible range only.

Here are some explanations about the project:
  • The Database is designed to store the objects in the AppointmentsSourceResourceTypesSourceTimeMarkersSourceCategoriesSource and their resources, exceptions, etc.
  • Please, pay attention to that the relation between the SqlAppointments and SqlResources is many-to-many. The same is for SqlExceptionAppointments and SqlResources. Unfortunately, the Ria Service doesn't support many-to-many relations at this stage. That's why we are using the following workaround - http://m2m4ria.codeplex.com/ 
  • All entities (models) implement interfaces so they can be plugged in the RadScheduleView control.
  • The application is written using the MVVM pattern.

Attached you can find the files. Please do not hesitate to contact us if you require any further information.


Greetings,
George
the Telerik team
0
sta
Top achievements
Rank 1
answered on 03 Apr 2011, 02:15 AM
Seem like one of your projects is missing, its unable to load, and the archive doesn't contain it.
Can you please create another zip and attach it?
Thank you - greatly appreciated!
Note that project that is missing is ScheduleView_SL - cannot load on first opening and is unavailable in the solution. Archive, as mentioned, doesn't contain the project.

Thank you very much in advance
0
George
Telerik team
answered on 04 Apr 2011, 03:34 PM
Hi,

 
Please, accept my apologies for this error in the attached project. Here is the modified project. Please, let me know if you need any further information.

Best wishes,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Scott
Top achievements
Rank 1
answered on 08 Apr 2011, 03:26 AM
Hi All,

Thanks very much for the MVVM samples. Can you confirm the recommended approach for persisting recurrence exceptions to the database in the futrue of the RadScheduleView control?

Similar to the first post in this thread, we've been developing a solution based on the RadScheduler. Because that control is being phased out in favour of the RadScheduleView, we're migrating to the RSV control. I've downloaded the ScheduleView-EF-SL.zip sample solution which is very helpful. However to date, your sample solutions put forth at least three different approaches for persisting recurrence exceptions in the database. The first solution we followed (http://www.telerik.com/help/silverlight/radscheduler-populating-with-data-ria-service-creating-database.html) used an nvarchar(4000) ExceptionAppointments column for serialized exceptions. The second solution we followed (http://www.telerik.com/support/kb/silverlight/scheduler/manage-data-for-radscheduler-using-ria-services.aspx) uses a self-referencing SqlAppointments table/entity with a ParentID and Type to manage recurrence exceptions. The third sample solution presented in this thread uses a SqlExceptionAppointments entity/table which is almost an exact duplicate of the SqlAppointments entity/table.

Is there a reason you moved away from the sel-referencing SqlAppointment entity for recurrence exceptions?

Thanks,
Scott
0
Stelios Polykarpou
Top achievements
Rank 1
answered on 12 Apr 2011, 02:26 PM
Hi, can you please post the same example using VB.net?
0
Scott
Top achievements
Rank 1
answered on 13 Apr 2011, 10:55 PM
Bump... George? Is anyone at Telerik still monitoring this thread?

Thanks,
Scott
0
George
Telerik team
answered on 14 Apr 2011, 11:54 AM
Hello Scott,

The reason why we store tha appointments and the exceptions in two different tables is due to the usage of different approach for binding the ScheduleView with a SqlDataBase in this example.

With its current version RadScheduleView exposes some new interfaces: ITimeMarker, IResourceType, IResource, IRecurrenceRule, IExceptionOccurrence, IAppointment, IAppointment, ICategory. The implementation of these interfaces spares the need to create custom appointments and mapping their properties to the database entities. Because the entities (using RIA Services/EF) are partial classes and you can plug them directly in the RadScheduleView via the ViewModel, and since each change in an entity is automatically tracked by RIA/EF, we don't need to track it manually.
 
The reason for splitting the appointments and the exceptions is because they are actually two different objects. They have very common properties, but it has some major differences - for example, the exceptions don't have recurrence and exceptions. This makes sense when implementing the Copy and CopyFrom methods. If an exception is copied, we need to perform a slightly different operation. Also, it is easier to support, to make changes and to track which IAppointment is being copied (Appointment or Exception).

Regards,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
sta
Top achievements
Rank 1
answered on 14 Apr 2011, 08:23 PM
Hi George,

Thanks for the info. Is there any organized documentation about how to work with database and RIA using ScheduleView? Scheduler for example have multiple examples that can be built upon. Not so with ScheduleView and unfortunately so.
If I missed those, can you please point me to the right direction?
The example above is quite useful - thanks a lot, but I am looking for documented way of things.
For example: database structure is such and such. Ria is such and such. To create an appointment in the database do : 1. 2. 3 

Thank you a lot.
0
Scott
Top achievements
Rank 1
answered on 15 Apr 2011, 12:20 AM
Hi George.

That makes sense. We'll forge ahead with the data model / database schema outlined in ScheduleView-EF-SL.zip sample. The extra interfaces you mentioned make the MVVM binding much easier--thanks.

Cheers,
Scott.
0
sta
Top achievements
Rank 1
answered on 21 Apr 2011, 03:54 AM
HI George,

Can you please shed some light as to why did you have to define model classes on the client side, while they all are already defined by EF on the server. Seem like unnecessary duplication, but there must be some reason you did it. Please respond. 

Thank you in advance.
0
Scott
Top achievements
Rank 1
answered on 21 Apr 2011, 05:15 AM
@sta:

Do you mean the model partial classes in the ScheduleView_EF_SL project (versus the ScheduleView_EF_SL.Web project)? George can confirm, but I believe they are necessary in order to implement the required client-side interfaces such as IAppointment, IRecurrenceRule, IResource, IObjectGenerator, etc., on the RIA Service code-generated model classes. Some of those interfaces require code implementations as well as simple public properties.

For example, the SqlResource.cs class generated by the RIA Services code generator could not be used properly by the RadScheduleView control without the client-side addition of the Telerik.Windows.Controls.IResource interface.

Scott
0
sta
Top achievements
Rank 1
answered on 21 Apr 2011, 03:24 PM
@Scott,

Scott, thanks a lot, it actually makes sense, just wanted to double confirm that I am not missing something. Thanks a lot!
0
sta
Top achievements
Rank 1
answered on 26 Apr 2011, 12:51 AM
@George

in the example you've provided the following scenario crashing the application (and is reproducible) : 
Run application, open new appointment dialog, click "edit recurrence". Just opening this dialog crashes the silverlight.
Unfortunately there is no way for me to debug this issue, since those dialogs are built in.
Can you please shed some light on how to overcome / workaround this issue?

Thank you very much in advance.
0
George
Telerik team
answered on 26 Apr 2011, 03:24 PM
Hello,

 
Could you please let us know what is the error message? I tried to reproduce the problem, but to no avail. Attached you can find a video. Please, let me know if I miss something, I am glad to assist you further.

Meanwhile, please double check whether you have modified the connection string in the Web.config file. It could be a database connection problem.

Regards,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
sta
Top achievements
Rank 1
answered on 26 Apr 2011, 07:42 PM
@George,

Many thanks George. I watched a video, indeed you have no issues. I have this issue every time I click "edit recurrence". Silverlight plugin just crashes, the error message saying that I am accessing memory that is not accessible.
I ran the same app in different environment - no issue, so I tend to blame my environment. 
I will keep you posted if and when I manage to resolve the issue with my environment.

For now - thanks a lot for prompt response. It certainly projects confidence and means a lot! 

0
sta
Top achievements
Rank 1
answered on 06 May 2011, 12:09 AM
@George,
Hi George, better late than never. Here's my findings: problem is 64bit system
I ran the same code on 32 bit installation (same libraries and everything).
What was crushing on 64 bit as per my description above still does, but works on 32 bit fine.
Also another observation: I made a context menu precisely as on your examples.
It works as the example on 32 bit, it has weird behavior on 64 bit: regardless on where I right click (on appointment or off) I have both "open" and "delete" enabled, while on 32 bit its only enabled on right click event on appointment, and grayed out when right click is off the appointment, which is should be.
Please advise if there are any workarounds or special libraries I have to use with 64 bit system (which I assume is the cause of this strange behaviour of ScheduleView control)

I am running on Windows 7 64 bit, for testing the behaviour used Chrome and IE9, both show the same (problematic) behavior.

Thanks.
0
George
Telerik team
answered on 09 May 2011, 09:24 AM
Hello,

 
This sounds truly strange because we are testing the RadControls with the Windows 7 64bit as well and there are no problems. Please, check your silverlight version on both machines here - http://www.microsoft.com/getsilverlight/Get-Started/Install/Default.aspx.

Regards,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
sta
Top achievements
Rank 1
answered on 12 May 2011, 02:00 AM
@George,

Thanks for the link, checked, 32 and 64 bit are using the very same silverlight version, also the very same telerik release.
However, I figured that my compilation gives me following few warnings, that I wasn't paying much attention:

Could not load file or assembly

'System.Windows, Version=2.0.5.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e' or one of its dependencies. The system cannot find the file specified.


Full compilation dump is attached. Can that be related to my 64 bit misbehaving?
Thanks!

0
George
Telerik team
answered on 19 May 2011, 07:49 AM
Hello,

 
Please, refer to the following forum thread where you can find additional information about this error - http://www.telerik.com/community/forums/silverlight/general-discussions/280342.aspx

I hope this helps.

Best wishes,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Sachin
Top achievements
Rank 1
answered on 27 May 2011, 05:30 PM
Hi,

I was trying to use the project you posted here. I followed the instructions, created the database and changed the connection string in web.config. But for some reasons, it is unable to store appointments. I create appointment, click on save, it doesn't give me any error but when I come back to see the appointments created, nothing exists tehre. So I checked the database and found that it is empty. What's going wrong here? I am using SQL Server 2008 and VS 2010. Also is there any formal documentation for implementating ScheduleView with RIA services?
0
sta
Top achievements
Rank 1
answered on 27 May 2011, 06:10 PM
@Sachin

Hi. I took the provided example and it worked completely, except few little things like I described above, I guess related to some versioning issues. My take on your problem is to try first to understand what tables are storing what data, make sure you are pointing to the right database (happened to me I was writing to one database while thinking I am writing to another - took few hours to realize that before pulling the last hair). Bottom line - example provided works.

BTW did anybody managed to put this appointments schema into business template project so that appointments are per user rather than for everybody? 

 Good luck
0
George
Telerik team
answered on 02 Jun 2011, 08:26 AM
Hello,

Currently we are preparing a formal, very detailed documentation that explains how to populate the RadScheduleView with RIA Services and EF from database. We will pronounce it when it is ready and the document will be attached to this thread as well.


Best wishes,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
sta
Top achievements
Rank 1
answered on 02 Jun 2011, 02:00 PM
Hi George,

This is great news, I think that many people are waiting for this passionately. My 2 cents in this is if you can include the integration of the code you've provided (or similar example) into business template so that every member (aspnet_user) has his own set of appointments, which may include user, user profile, Entity Framework all working in one solution.
As a  standalone code that you provided example for is great to show how to work with it and what it does, but not real life scenario, if you know what I mean. Please consider it as a feedback.

Thanks in advance!
0
George
Telerik team
answered on 07 Jun 2011, 09:49 AM
Hello,

 
Thank you for your feedback, we will consider implementing such scenario. Meanwhile, you can find the attached zip file that contains a document and two diagrams. 

I hope this helps. Please do not hesitate to contact us if you require any further information.


Kind regards,
George
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
sta
Top achievements
Rank 1
answered on 17 Jun 2011, 02:21 AM
Hi George,

thanks for the documentation, it really helps. however, as I said before, it will help even better some working example with business template application.
reason for this posting is different however. I think I found a bug in the sample provided above:
in the ScheduleViewViewModel.cs file there's a method called GenerateAppointments, that looks like this:
private void GenerateAppointments(DateSpan dateSpan)
{
this.Appointments.Clear();
this.IsLoading = true;


ScheduleViewRepository.Context.Load(ScheduleViewRepository.Context.GetSqlExceptionAppointmentsQuery());
ScheduleViewRepository.Context.Load(ScheduleViewRepository.Context.GetSqlExceptionOccurrencesQuery());
ScheduleViewRepository.Context.Load(
ScheduleViewRepository.Context.GetSqlAppointmentsByRangeQuery(dateSpan.Start, dateSpan.End)).Completed += (o, e) =>
{
this.Appointments.AddRange((o as LoadOperation).Entities.Select(a => a as SqlAppointment));
this.IsLoading = false;
};
}

I think that the first line in the method (clearing appointments) should be right before the AddRange call. At least in my case here, I have this method called 3 times on visibility range changed event and instead of generating 2 appointments that I have saved in the database, it shows 6 : every appointment is duplicated 3 times basically. This must be tested in the following way: you must get those appointments right on the screen (not playing with the control to get to them, but directly to show on the screen after the RIA call.
I wonder if its just my environment causing this even to be fired 3 times, but anyway, just wanted to point it out and see if anybody else faced the same issue and if this is really a bug in the example. 
Thank you in advance, George



 
0
Mark
Top achievements
Rank 1
answered on 20 Jun 2011, 02:46 PM
Just a word of encouragement here... we are eagerly awaiting the aforementioned documentation and sample.

Thanks as always for your continued efforts!
0
Mark
Top achievements
Rank 1
answered on 21 Jun 2011, 12:44 AM

My apologies for the lack of sophistication of this request for help...

I've tried to recreate your sample, and am having problem with the Generator.includett file and its declaration of the edmx file location. While I understand this is a 3rd party component, as it was used in your sample and will suit the bill I was hoping to learn from it.  Specifically I have tried building a project on my desktop and in "my documents" where it normally resides, but it seems that the relative path isn't picking up the location.  It does work without issue on the downloaded sample (in any location).

I've tried

EdmxFilePath = @"ScheduleView.Web\Models\ScheduleViewModel.edmx";
EdmxFilePath = @"ScheduleView\ScheduleView.Web\Models\ScheduleViewModel.edmx";

My project looks like "ScheduleView\ScheduleView.Web\Models\ScheduleViewModel.edmx".

with its current absolute location: "C:\Users\Mark\Documents\Visual Studio 2010\Projects\ScheduleView\ScheduleView.Web\Models\ScheduleViewModel.edmx"

The failure indicates it is looking for the edmx ...

[error trimmed for brevity]

Error 33 Running transformation: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\ScheduleView\ScheduleView.Web\Models\ScheduleViewModel.edmx'.

Is there a step or setting I'm missing to enable the relative path? A nudge in the correct direction would be greatly appreciated.  As the larger "how-to" document hasn't been release yet I'd really appreciate a bit of assistance.

Thanks and regards,

Mark

0
sta
Top achievements
Rank 1
answered on 21 Jun 2011, 01:25 AM
@Mark,
this is not a forum about M2M4Ria. 
What you need do is in M2MGenerator.ttinclude provide an absolute path to your model, rather than relative.
Please don't post questions here that aren't related to ScheduleView control by Telerik.
Thank you for understanding

0
Mark
Top achievements
Rank 1
answered on 21 Jun 2011, 01:41 AM
Sta,

Pehaps you should consider letting Telerik speak for themselves in respect to the forums they maintain and the content within.

As Telerik opted to implement the M2M4Ria component in their provided sample of the ScheduleView within this thread it makes it more than reasonable to ask for clarification on the specific sample.  If they prefer not to do so, that disposition is theirs to make.


0
Mark
Top achievements
Rank 1
answered on 21 Jun 2011, 12:46 PM
For anyone trying to recreate the example provided and running into the relative path issue, it is derived from the manner in which you open the solution. 

For some reason I'm yet to understand, there is a difference between opening the project directly by opening the solution file (*.sln) versus opening Visual Studio then opening the project.  By doubleclicking on the .sln file we seem to cache the location of the solution / project directory and relative paths work.

0
sta
Top achievements
Rank 1
answered on 21 Jun 2011, 01:47 PM
@Mark,
I gave you solution that worked for me and haven't got any "thank you" other than blaming me for taking over.
 Thanks.
0
Mark
Top achievements
Rank 1
answered on 21 Jun 2011, 01:52 PM
Sta,

You didn't provide any solution, just argument. 


0
sta
Top achievements
Rank 1
answered on 21 Jun 2011, 02:24 PM
@Mark
There is no difference whatsoever in opening the project by 1. double clicking *.sln file 2. opening VS2010 and from it opening the same *.sln file.
To your previous question: the example telerik provided is great, I was able to fully recreated it in my environment and built more logic on top of it.  
There is also documentation, google search and your own experience and trial and error process. You can't expect every little question you have (like how to open solution in VS) to be answered here. 

Thank you George for giving this example, without it, I don't think the use of ScheduleView would not be as easy.
0
Mark
Top achievements
Rank 1
answered on 21 Jun 2011, 02:45 PM
http://www.gitshah.com/2011/06/visual-studio-2010-fixing-referenced.html

By opening the project directly versus via the IDE, you effectively change the cached character count between the two methods.
0
Mark
Top achievements
Rank 1
answered on 21 Jun 2011, 02:53 PM
Further confirmation from the developer of M2M4Ria.

http://m2m4ria.codeplex.com/discussions/262080

0
Mark Jakes
Top achievements
Rank 1
answered on 08 Jul 2011, 12:06 AM
Hello Mark

I had exactly the same problem and was pulling my hair out.  Just wanted to say thanks for sharing this information as it helped me, and I am sure it will help others.

Cheers

Mark.
0
InSource
Top achievements
Rank 1
answered on 10 Aug 2011, 03:41 PM
I completely agree with the previous posting:
"Is there any organized documentation about how to work with database and RIA using ScheduleView?
Scheduler for example have multiple examples that can be built upon. Not so with ScheduleView and unfortunately so."

I reviewed the RIA document that was provided as well as the sample solution but I really need something more like the tutorial included with the Scheduler control. 


0
sta
Top achievements
Rank 1
answered on 11 Aug 2011, 08:40 PM
HI George,

Simple, yet important question: in the document provided earlier in this thread (April 26 to be precise), on page 3 we have IResource that has FK to SqlResourceType, which is obviously is int. However, its corresponding interface has ResourceType as string. (see attached picture).
Please let me know if this is a bug.

Thank you in advance!
0
George
Telerik team
answered on 16 Aug 2011, 08:55 AM
Hello,

This implementation is by design. The SqlResourceTypeId is a FK to the SqlResourceType table and the EF will generate a navigation property from SqlResource entity to SqlResourceType entity. Please, refer to the Model/SqlResource partial class where the IResource interface is implemented using the SqlResourceType navigation property.

Meanwhile, we are working on improving implementing RadScheduleView with the database by adding a new interface, which will allow integrating the Categories, TimeMarkers and Importance with the appointment when is in an edit state (as you may know, there were known issues with saving the Categories, TimeMarkers and Importance in the database).

Hope this helps.


Kind regards,
George
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

0
Aziz
Top achievements
Rank 1
answered on 13 Oct 2011, 08:03 PM
Perhaps someone can help me out here.

I download the project (second link). i ran the sql script on my database server to create the database.

I then unpacked and double clicked to open the project.

This is when I'm lost, I assume I need to put the connection string in some place but I can't locate where to do so on this project. as such when I run the project I get an error:
"Missing partial modifier on declaration of type 'ScheduleView_EF_SL.Web.AppData.M2M4Ria.EntityCollection<JoinType,TEntity>'; another partial declaration of this type exists"

and yes I did think enough to open the Web.Config and change the ConnectioString from:

metadata=res://*/AppData.ScheduleViewEntity.csdl|res://*/AppData.ScheduleViewEntity.ssdl|res://*/AppData.ScheduleViewEntity.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.;Initial Catalog=ScheduleViewDB;Integrated Security=True;MultipleActiveResultSets=True&quot;"

to 
Data Source=web-dev;Initial Catalog=ScheduleViewDB;Integrated Security=True

still i get the same partial modifier error

can someone help me out?

Visual studio 2011, RadControls Q2 2011, SQL R2

0
Mark
Top achievements
Rank 1
answered on 13 Oct 2011, 08:09 PM
Hi Jacob

Although this isn't directly to your concern, I just wanted to comment that some significant changes have been made to the ScheduleView control since this thread / demo was created including changes to some of the interfaces it uses.  I mention this because you may be better served using a different example as a basis for usage.

Perhaps Telerik has one more current available.

Good luck,
Mark
0
Aziz
Top achievements
Rank 1
answered on 13 Oct 2011, 08:13 PM
thanks for the info, hopefully is able to provide a detailed guide on how to data bind the scheduleview control to a database of 'appointments' then
0
Aziz
Top achievements
Rank 1
answered on 13 Oct 2011, 08:28 PM
Its strange that it does throw an error in VS 2010 but if i just browse the page it works. so thats ok. My question now is how do i customize the appointments so that they had a listbox that is populated from a database table?
0
George
Telerik team
answered on 18 Oct 2011, 03:53 PM
Hello,

Jacob:

I believe that the problem you had may be caused by the M2MRia and I am glad to know that it is resolved. About your question for creating a custom appointment with a listbox, I would suggest referring the following documentation - http://www.telerik.com/help/silverlight/radscheduleview-features-appointments-custom-appointment.html. The article is about creating a custom boolean property, but you could use the same pattern for creating a custom collection as a property to the custom appointment.


Mark:

It's true that we made some changes to the RadScheduleView interfaces, and the biggest change was adding the new IExtendedAppointment interface and moving the TimeMarker, Category and Importance properties there(there are not in the IAppointment interface anymore). Also the brush properties are removed from the ITimeMarker and ICategory interfaces.


Hope this helps.


Greetings,
George
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Aziz
Top achievements
Rank 1
answered on 18 Oct 2011, 04:36 PM
While i did manage to get a solution the one that is posted on here is buggy and not simple to follow. I think that binding schedules to a database is very important and useful and I would really like to see a good telerik example (compatible with SL4) that shows how this is done. It would be great if this example used a custom appointment type as I think most users do tweek the appointment a bit. Also if you can include the sample data from the MSSQL database (SQL generation file for say...R2?).

I think a sample project of this type would be a great asset.
0
George
Telerik team
answered on 21 Oct 2011, 04:16 PM
Hello Jacob,

The provided example (from 04-Apr-2011) is storing the custom appointments using SL4, MSSQL, EntityFramework and RIA Services. Could you please point me which example is not compatible with SL4?

We the current Q2 release me truly made some changes to the interfaces (this is the reason why the attached project cannot be compiled) and we are preparing a modified sample that uses our latest binaries.

Greetings,
George
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
sta
Top achievements
Rank 1
answered on 03 Nov 2011, 09:29 PM
HI George,
The new example you've mentioned in your previous post, will it be equivalent to the one you've shared in April but using new interface hierarchy you described above?
When is the new example is slated to be released please?
Thanks in advance.
0
sta
Top achievements
Rank 1
answered on 03 Nov 2011, 09:30 PM
HI George,
The new example you've mentioned in your previous post, will it be equivalent to the one you've shared in April but using new interface hierarchy you described above?
When is the new example is slated to be released please?
Thanks in advance.
0
sta
Top achievements
Rank 1
answered on 03 Nov 2011, 09:31 PM
Sorry for double posting. Unfortunately no way to delete unnecessary posting, even for the author.
0
Garrett
Top achievements
Rank 1
answered on 07 Nov 2011, 06:33 PM
Hi,

Just wondering if there was an update to the promised step-by-step tutorial?

I'm having significant difficulty trying to figure out how to get the ScheduleView working with custom/standard appointments.

Thanks,

Garrett
0
George
Telerik team
answered on 08 Nov 2011, 04:40 PM
Hello,

We are working on the example we will post it as a Code Library with a documentation these days. Hope this helps.

Kind regards,
George
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
NickName
Top achievements
Rank 1
answered on 14 Nov 2011, 10:15 AM
Hi! I`ve downloaded example ScheduleView-EF-SL.zip with database structure. Everything is ok. I can create and save appointments.
BUT, I cannot add resources at runtime!
This simple source code:
var myResourceType = ScheduleViewRepository.Context.SqlResourceTypes.First(x =>   x.SqlResourceTypeId == myResourceTypeId);
ScheduleViewRepository.Context.SqlResources.Add(
  new SqlResource
  {
    ResourceName = "Test Resource",
    DisplayName = "Test Resource",
    SqlResourceType = contactType,
    SqlResourceTypeId = contactType.SqlResourceTypeId
  }
);
 
ScheduleViewRepository.Context.SubmitChanges(op => {  }, null);


saves resource correctly to database, BUT after submit changes operation complete, it throws exception:
Object reference not set to an instance of an object in ResourceType getter
this.SqlResourceType.Name
because SqlResourceType is null. Why it is null?

Thank you!
0
Surabaya
Top achievements
Rank 1
answered on 14 Nov 2011, 10:23 AM
Hi,

We have this requirement of customized scheduling control and as part of evaluation, we had good look on Radscheduler.. Now that RadScheduleView being more advanced control and all pointers are towards this control for new developement, we now want to use it for our development..

From the date this thread started, its been over 8 months, I couldn't see SQL database support guide with example as given for RadScheduler (For WCF, RIA and ADO.net data services)

We have almost initiated process to buy teleric premium suite. Now that we are finding lack of information on database support, we are scared if at all we making right decision.

Necessary documentation with example would solve most of the users problems..

Thanks,
0
Surabaya
Top achievements
Rank 1
answered on 14 Nov 2011, 10:23 AM
Hi,

We have this requirement of customized scheduling control and as part of evaluation, we had good look on Radscheduler.. Now that RadScheduleView being more advanced control and all pointers are towards this control for new developement, we now want to use it for our development..

From the date this thread started, its been over 8 months, I couldn't see SQL database support guide with example as given for RadScheduler (For WCF, RIA and ADO.net data services)

We have almost initiated process to buy teleric premium suite. Now that we are finding lack of information on database support, we are scared if at all we making right decision.

Necessary documentation with example would solve most of the users problems..

Thanks,
0
Garrett
Top achievements
Rank 1
answered on 14 Nov 2011, 02:22 PM
We are in the same situation. I have approval to purchase two more Telerik premium licenses, but I won't purchase them until documentation is fleshed out.

There's no point in buying software we can't use.

We are just idling at this point... which is also costing us money.

It would be great to see this documentation moved up in priority.

Garrett
0
Yana
Telerik team
answered on 16 Nov 2011, 03:22 PM
Hello,

You are right about the missing documentation for the SQL support of RadScheduleView.  Currently we're working on an example (it will be uploaded as a code-library) and a detailed explanation of the approach. This task is set with a high priority for the next week. I'll write here as soon as it is ready.

All the best,
Yana
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Garrett
Top achievements
Rank 1
answered on 28 Nov 2011, 05:02 PM
Hello,

Just wanted to find out if there was an update on this?

Thanks,

Garrett
0
Yana
Telerik team
answered on 29 Nov 2011, 12:58 PM
Hello,

Please check here for more details about  binding the RadScheduleView to a database.

Greetings,
Yana
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Jose
Top achievements
Rank 1
answered on 09 Mar 2012, 06:29 PM

Hello,

 I have my scenario properly prepared to store data in SQL Server. I want to know how I can add custom properties if my Custom Appointment not inherit from Appointment it implements IAppointment?

Thanks and sorry for my English.

0
Garrett
Top achievements
Rank 1
answered on 09 Mar 2012, 06:35 PM
Hi Jose,

Telerik has been posting XAMLFlix videos and this one in particular might go a long way in helping you achieve your goal.

Evan is pretty quick in the video on how he customized the Appointment, but it's a critical step that isn't shown in any tutorial I've found, Telerik-based or not.
0
Jose
Top achievements
Rank 1
answered on 09 Mar 2012, 07:47 PM
Thanks!!!!!
0
Jose
Top achievements
Rank 1
answered on 12 Mar 2012, 01:03 PM
The solution proposed by Telerik, is to edit a template already set.

My application allows the user to indicate that template Telerik want to work. With the solution proposed by them, I can only work with a single template is not?
 
Any way to add fields allowing compatibility with all the templates?
 
Thank you,
Jose
0
AndyRutter
Top achievements
Rank 2
answered on 13 Mar 2012, 02:28 PM
I am sorry but it is a year on from saying you were going to provide detailed instructions on how to implement scheduleViewer and bind it to a database and this is the best you can do?
How exactly does that help out the VB developers also, why 'yet again' should we have to spend hours trying to convert code just to get a sample working? Which by the way I have not been able to do yet because your converter cannot code with large parts of it!
And why are we still having to use RIA with a custom hack to cope with many to many relationships when your own ORM and Data Services can deal with this no problem. Maybe you should invest more time in helping people actually use your controls instead of preening all the time about how great your new features are...! 
0
Alberto
Top achievements
Rank 1
answered on 20 Jun 2012, 03:16 PM

Hi! I`ve downloaded example ScheduleView-EF-SL.zip with database structure and When I tried to generate the project I get and error

0
George
Telerik team
answered on 25 Jun 2012, 02:30 PM
Hello,

 
Please, clean and rebuild the solution. If this doesn't help, I would suggest regenerating the T4 templates.

Kind regards,
George
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
mike okon
Top achievements
Rank 1
answered on 19 Feb 2013, 09:43 AM
Hi

I there an updated version for SL5 and EF 4.5. I am Unable to make this open on vs2012 after having to do an upgrade to Telerik v2012Q3

I have been using this example as well Scheduleview_DB_CS. However it is NOT the same DB . The SQL Appointments table is far different. For one is contains a ParentId (which I trust ties in with userId (ria services business app) This is definitely the way I want to go as I already have a website which uses the userId and wish to tie in RadScheduleView into the existing application.

Please can you point me to the updated versions download location.
regards
mike
0
Yana
Telerik team
answered on 19 Feb 2013, 12:14 PM
Hello Mike,

You could find the latest version uploaded as a Code Library at the following link:
http://www.telerik.com/community/code-library/silverlight/scheduleview/binding-to-database-example.aspx

All the best,
Yana
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
mike okon
Top achievements
Rank 1
answered on 19 Feb 2013, 01:31 PM
Hi

I believe you have sent me the incorrect link. I have already mentioned this link (ie DB "Scheduleview_DB_CS") in my email. I am looking for the updated DB for "ScheduleView_EF_SL". As mentioned the _SL version has parentId (uniqueidentifier) in the SQLAppointments table. The _CS version does not.

If you are unable to locate the SL version please provide location to documentation, so as  to provide steps on how to implement the ParentID with (userID ). IE How can one pass the userID to Scheduleview,savedata to that the DB field is correctly populated with the currently logged in user in SQLAppointments table?

regards
mike
0
Yana
Telerik team
answered on 22 Feb 2013, 09:43 AM
Hello Mike,

Actually Scheduleview_DB_CS is the updated version of ScheduleView_EF_SL - it is for Silverlight 5, doesn't use M2MRia anymore (so it is available for VB.NET) and has some other improvements as well. Also our documentation is updated in order to explain the updated example.

All the best,
Yana
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Tags
ScheduleView
Asked by
schneeflocke
Top achievements
Rank 1
Answers by
Valeri Hristov
Telerik team
Michael Rodriguez
Top achievements
Rank 1
George
Telerik team
Sami
Top achievements
Rank 2
Iron
Iron
Iron
sta
Top achievements
Rank 1
Scott
Top achievements
Rank 1
Stelios Polykarpou
Top achievements
Rank 1
Sachin
Top achievements
Rank 1
Mark
Top achievements
Rank 1
Mark Jakes
Top achievements
Rank 1
InSource
Top achievements
Rank 1
Aziz
Top achievements
Rank 1
Garrett
Top achievements
Rank 1
NickName
Top achievements
Rank 1
Surabaya
Top achievements
Rank 1
Yana
Telerik team
Jose
Top achievements
Rank 1
AndyRutter
Top achievements
Rank 2
Alberto
Top achievements
Rank 1
mike okon
Top achievements
Rank 1
Share this question
or