- Home
- Forum
- ASP.NET MVC
- Use the same table data in gantt & schedule
Use the same table data in gantt & schedule
I have a really complicated problem. I want the same tasks to be present in the schedule & gantt controls (read, add, delete, modify from schedule and gantt should be possible).
The schedule works before I change the task table (in sql database), But now he does not show me anything in the schedule either the gantt control.
Then if it is possible to add more attributes (Status, Priority) to task and show the kanbanboard.
Help me please.
The tasks table:
CREATE TABLE [dbo].[Tasks] (
[TaskID] INT IDENTITY (1, 1) NOT NULL,
[Title] NCHAR (50) NOT NULL,
[Description] NCHAR (50) NULL,
[Start] DATETIME NOT NULL,
[StartTimezone] NCHAR (50) NULL,
[End] DATETIME NOT NULL,
[EndTimezone] NCHAR (50) NULL,
[RecurrenceRule] NCHAR (50) NULL,
[RecurrenceID] INT NULL,
[RecurrenceException] NCHAR (50) NULL,
[IsAllDay] BIT NULL,
[OwnerID] INT NULL,
[Duration] INT NULL,
[ParentID] INT NULL,
[ProjectID] INT NOT NULL,
[Progress] INT NULL,
[Predecessors] NCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([TaskID] ASC)
);
My tasks Model class:
public partial class Tasks
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int TaskID { get; set; }
[Required]
[StringLength(50)]
public string Title { get; set; }
[StringLength(50)]
public string Description { get; set; }
public DateTime Start { get; set; }
public string StartTimezone { get; set; }
public DateTime End { get; set; }
public string EndTimezone { get; set; }
[StringLength(50)]
public string RecurrenceRule { get; set; }
public int RecurrenceID { get; set; }
[StringLength(50)]
public string RecurrenceException { get; set; }
public bool IsAllDay { get; set; }
public int OwnerID { get; set; }
public int Duration { get; set; }
public int Progress { get; set; }
public int ParentID { get; set; }
public int ProjectID { get; set; }
public string Predecessors { get; set; }
public List<int> ResourceID { get; set; }
}
SIGN IN To post a reply.
1 Reply
MK
Mahalakshmi Karthikeyan
Syncfusion Team
November 18, 2016 12:01 PM UTC
Hi Anis,
Thanks for contacting Syncfusion support.
As we are working on the requested custom sample, a support incident has been created under your account for better follow up. Please log on to our support website to check for further updates.
Regards,
Mahalakshmi K.
SIGN IN To post a reply.
- 1 Reply
- 2 Participants
-
AN Anis
- Nov 17, 2016 01:57 PM UTC
- Nov 18, 2016 12:01 PM UTC