database table structure

74 posts, 0 answers
  1. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 20 Jun 2011 Link to this post

    Just a word of encouragement here... we are eagerly awaiting the aforementioned documentation and sample.

    Thanks as always for your continued efforts!
  2. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 20 Jun 2011 Link to this post

    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

  3. DevCraft banner
  4. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 20 Jun 2011 Link to this post

    @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

  5. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 20 Jun 2011 Link to this post

    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.


  6. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 21 Jun 2011 Link to this post

    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.

  7. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 21 Jun 2011 Link to this post

    @Mark,
    I gave you solution that worked for me and haven't got any "thank you" other than blaming me for taking over.
     Thanks.
  8. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 21 Jun 2011 Link to this post

    Sta,

    You didn't provide any solution, just argument. 


  9. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 21 Jun 2011 Link to this post

    @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.
  10. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 21 Jun 2011 Link to this post

    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.
  11. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 21 Jun 2011 Link to this post

    Further confirmation from the developer of M2M4Ria.

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

  12. Mark Jakes
    Mark Jakes avatar
    27 posts
    Member since:
    Feb 2010

    Posted 07 Jul 2011 Link to this post

    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.
  13. InSource
    InSource avatar
    2 posts
    Member since:
    Dec 2010

    Posted 10 Aug 2011 Link to this post

    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. 


  14. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 11 Aug 2011 Link to this post

    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!
  15. George
    Admin
    George avatar
    1332 posts

    Posted 16 Aug 2011 Link to this post

    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 >>

  16. Aziz
    Aziz avatar
    32 posts
    Member since:
    Sep 2011

    Posted 13 Oct 2011 Link to this post

    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

  17. Mark
    Mark avatar
    155 posts
    Member since:
    Oct 2010

    Posted 13 Oct 2011 Link to this post

    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
  18. Aziz
    Aziz avatar
    32 posts
    Member since:
    Sep 2011

    Posted 13 Oct 2011 Link to this post

    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
  19. Aziz
    Aziz avatar
    32 posts
    Member since:
    Sep 2011

    Posted 13 Oct 2011 Link to this post

    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?
  20. George
    Admin
    George avatar
    1332 posts

    Posted 18 Oct 2011 Link to this post

    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 >>

  21. Aziz
    Aziz avatar
    32 posts
    Member since:
    Sep 2011

    Posted 18 Oct 2011 Link to this post

    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.
  22. George
    Admin
    George avatar
    1332 posts

    Posted 21 Oct 2011 Link to this post

    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 >>

  23. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 03 Nov 2011 Link to this post

    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.
  24. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 03 Nov 2011 Link to this post

    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.
  25. sta
    sta avatar
    34 posts
    Member since:
    Mar 2011

    Posted 03 Nov 2011 Link to this post

    Sorry for double posting. Unfortunately no way to delete unnecessary posting, even for the author.
  26. Garrett
    Garrett avatar
    23 posts
    Member since:
    Sep 2012

    Posted 07 Nov 2011 Link to this post

    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
  27. George
    Admin
    George avatar
    1332 posts

    Posted 08 Nov 2011 Link to this post

    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 >>

  28. NickName
    NickName avatar
    14 posts
    Member since:
    Nov 2010

    Posted 14 Nov 2011 Link to this post

    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!
  29. Surabaya
    Surabaya avatar
    3 posts
    Member since:
    Oct 2011

    Posted 14 Nov 2011 Link to this post

    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,
  30. Surabaya
    Surabaya avatar
    3 posts
    Member since:
    Oct 2011

    Posted 14 Nov 2011 Link to this post

    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,
  31. Garrett
    Garrett avatar
    23 posts
    Member since:
    Sep 2012

    Posted 14 Nov 2011 Link to this post

    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
Back to Top
DevCraft banner