Hi I Download Infragestic Data in Sql server Database.
I am opening my Customize Dialog box (AddAppointement) from WebdayView.
In my Dialog I am Calling Infragestic Procedure [dbo.Activity_Add]and passing all the data from my Custom Form.
After Press Save MY Dialog Close and Main screen with Dayview get Refreshed and bind with WebSchduleSqldataprovider.
Problem:My webDayview showing activity at different time not the Time which I Clicked on WebDayview.
I.e I clicked on 12AM it is showing appointement at 6AM.
Can you please help me .
I am passing var StartTime = Activity.getStartDateTime() In query String and pass it to Database.Am i Missing Something.
Please Help its urgent.
Happy to help where I can.
If you can get into the Appointment object in your code behind thats where you can manipulate your Keys.
Thanks Heran
For your Valuable Suggeston.
Can you Please Help me in Finding out where to Assign Unique Id.
Should I need to pass It to Databse if yes then which Field.
Currently I am opening my Custom Form and Passing all the Data
Mention in Appointments table provide by Infragestic.
Data Currently Passed by my form to Databse are as followes.
arParams[0, 0] = "AllDayEvent";
arParams[0, 1] = DbType.Boolean;
arParams[0, 2] = false;
arParams[2, 0] = "Duration";
arParams[2, 1] = DbType.Int32;
arParams[2, 2] = 1800;
arParams[3, 0] = "Location";
arParams[3, 1] = DbType.String;
arParams[3, 2] = "Test";
arParams[4, 0] = "StartDateTimeUtc";
arParams[4, 1] = DbType.DateTime;
arParams[4, 2] = strStartTimeUTC;
arParams[5, 0] = "Subject";
arParams[5, 1] = DbType.String;
arParams[5, 2] = "Test";
arParams[6, 0] = "EnableReminder";
arParams[6, 1] = DbType.Boolean;
arParams[6, 2] = true;
arParams[7, 0] = "ReminderInterval";
arParams[7, 1] = DbType.Int32;
arParams[7, 2] = 800;
arParams[8, 0] = "ShowTimeAs";
arParams[8, 1] = DbType.Int32;
arParams[8, 2] = 2;
arParams[9, 0] = "Importance";
arParams[9, 1] = DbType.Int32;
arParams[9, 2] = 1;
arParams[10, 0] = "Status";
arParams[10, 1] = DbType.Int32;
arParams[10, 2] = 0;
arParams[11, 0] = "RecurrenceKey";
arParams[11, 1] = DbType.Int32;
arParams[11, 2] = 999;
arParams[12, 0] = "ResourceName";
arParams[12, 1] = DbType.String;
arParams[12, 2] = null;
I've done a lot of work with the webdayview and custom dialog box. I ran into a similar problem with my setup as well except all my appoinments were being placed in the same day at 12am so first thing to do is to verify that each appoinment added is being given a unique Key ID. If not this can cause problems with your times and dates.