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