========================
I solved that, it works now. Thank you!
========================
Xylon wrote on Mar 21^st, 2014 at 2:54pm:

Hi Lyubo, one more question in Javascript.

Say I create new appointment, right now in the "New Appointment" window I have subject as a textbox, location as a dropdownlist, then start time and end time of course. Values in the dropdownlist are from database, here I achieved that.

My code is here 

var a = JSON.parse('<% = this.javaSerial.Serialize(this.eventValue) %>');

		    var populateEventTypeItems = function ()
		    {
		        var result = [];
		        for (var i = 0; i < a.length; i++) {
		            result.push({value: a[i], text: a[i]});
		        }
		        return result;
		    }

var eventType = this.createDropDownList({
		            id: 'EventsType',
		            items: populateEventTypeItems(),
		            initValue: this.item.subject,
		            addEmptyValue: false
		        });
		        eventType.element.style.width = "355px"

var locationOriginal = this.getControls()['location'];
		        locationOriginal.element.parentNode.appendChild(eventType.element);
		        //locationOriginal.element.remove();
		        locationOriginal.element.parentNode.removeChild(locationOriginal.element);

		        // Replace also the control in the forms controls collection
		        this.getControls()['location'] = eventType;

 

It seems work, but to obtain the textbox value of subject, I got error saying sth like "id is null blablabla"

My code of subject textbox is below

var subjectText = document.getElementById('subject');
		        document.getElementById('subject').appendChild(subjectText);

var subjectOriginal = this.getControls()['subject'];
		        subjectOriginal.element.parentNode.appendChild(subjectText.element);
		        subjectOriginal.element.parentNode.removeChild(subjectOriginal.element);
		        this.getControls()['subject'] = subjectText;


 

How to correct my code to display new created appointment properly?

Lyubo wrote on Mar 21^st, 2014 at 12:58pm:

In your example, the  "CreateAppointment" method seems will loop entire app.contacts every time if user create new appointment, is that right?

foreach (Contact con in app.Contacts)
				{
					using (SqlCeCommand cmd = new SqlCeCommand
						(
							"INSERT INTO ContactEvents ([EventID], [ContactID]) " +
							"VALUES (@EVTID, @CNTID); ", conn
						))
					{
						cmd.Parameters.AddWithValue("EVTID", app.Tag);
						cmd.Parameters.AddWithValue("CNTID", con.Tag);

						cmd.ExecuteNonQuery();
					}
				} 

What if I only would like synchronize new appointment? Say only add new appointment value record into database/datatable?

Lyubo wrote on Mar 21^st, 2014 at 12:58pm:

Xylon wrote on Mar 27^th, 2014 at 3:22pm:

That's right. It's done so because of how the database in the sample is designed. How exactly you will handle database updates in your application may be different. It will depend on your database design and specifications.

Xylon wrote on Mar 27^th, 2014 at 9:03pm:

In the sample, after a new appointment is inserted into the database, the generated auto-id of the new DB record is assigned to the Appointment.Tag property. It is then used for matching the DB record with the respective Appointment object. In the sample this is handled by these lines in the CreateAppointment method:

cmd.CommandText = "SELECT @@IDENTITY as NewId";
// assign the id from the newly inserted database record
app.Tag = (int)(decimal)cmd.ExecuteScalar();

// Below is a snippet from the DeleteAppointment method

// using the id later for matching the appointment with its db record
using (SqlCeCommand cmd =
    new SqlCeCommand("DELETE FROM ContactEvents " +
                     "WHERE [EventID] = @EVTID ", conn))
{
    cmd.Parameters.AddWithValue("EVTID", app.Tag);
    // ... 

Regards,
Lyubo

Hi,

Have a look at the tutorial here: http://msdn.microsoft.com/en-us/library/ks9f57t0(v=vs.100).aspx

You can assign temporary unique ids (i.e. generate new GUIDs) to newly created items' Tag property and store them also in your DataTable.
When inserting the new records with your stored procedure, you can query the database for the newly created auto-id (how this can be done is explained in the link above), match the appointment by the record's GUID value and update its Tag to the corresponding auto-id.

Regards,
Lyubo

Hi,

In the resource view, contacts are automatically associated with the appointments when creating new items. By default one can add or remove contact associations interactively through the New/Edit popup Form through the Contacts checkboxes or by moving an item with the mouse from one resource row to another. Contacts assigned to appointments can be accessed via the Appointment.Contacts collection.

The Database sample we provided there are three tables - 'Events' - to store appointments (there is no contact field there), 'Contacts' - to store contacts and 'ContactEvents' - to store associations between appointments and the contacts assigned to them. When inserting a new appointment into the database, first it's property values are stored in the Events table and an ID is assigned. Then, the item-contact relationship is established in the database with this query:

using (SqlCeCommand cmd = new SqlCeCommand(
    "INSERT INTO ContactEvents ([EventID], [ContactID]) " +
    "VALUES (@EVTID, @CNTID); ", conn))
{
    cmd.Parameters.AddWithValue("EVTID", app.Tag);
    cmd.Parameters.AddWithValue("CNTID", con.Tag);

    cmd.ExecuteNonQuery();
} 

In your case, when you insert a new appointment, you can enumerate the Appointment.Contacts collection to get the contact name and add it too. Be aware though, that an appointment by default can be associated with more than one contact instance, so your code and/or database structure may need to adapt to that.

Regards,
Lyubo

Are there any errors in your browser's developer console? It's difficult to guess where the problem may be. Can you paste here the code you use to load the appointments from the database in the calendar?
Or, you can attach here (or send to support@mindfusion.eu) a sample project that reproduces the issue, so that our developer can investigate.

Regards,
Lyubo