Saving and Updating Gantt Data Using Code First Approach MVC 5 ASP.NET

Question

How do I save gantt data to the database using the database code first approach? Below is a sample application that I would like to save data and update the gantt data from (performing CRUD operations) using code first approach. Please kindly do assist.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Syncfusion.JavaScript;
using YothingoSprint1.Models;
using System.Data;
using System.Diagnostics;
using System.Data.SqlClient;
using System.Web.Configuration;

namespace YothingoSprint1
{
    public class TaskData
    {
        public int TaskId { get; set; }
        public string TaskName { get; set; }
        public DateTime StartDate { get; set; }
        public DateTime BaseLineStartDate { get; set; }
        public DateTime BaseLineEndDate { get; set; }
        public string ParentId { get; set; }
        public int Duration { get; set; }
        public int PercentDone { get; set; }
        public string Predecessor { get; set; }

        public partial class GanttController : Controller
    {

        ApplicationDbContext db = new ApplicationDbContext();

        public ActionResult GanttFeatures()
        {
            ViewBag.dataSource = db.GanttFeatureDatas.ToList();
            ViewBag.resources = ResourceList.GetResources();
            return View();
        }

        [HttpPost()]
        public ActionResult Update(List<TaskData> Tasks)
        {
            foreach (TaskData Task in Tasks)
            {
                int Id = Task.TaskId;
                GanttFeatureData data = db.GanttFeatureDatas.First(sv => sv.Id == Id);

                data.Id = Task.TaskId;
                data.Name = Task.TaskName;
                data.StartDate = Task.StartDate;
                data.BaselineStartDate = Task.BaseLineStartDate;
                data.BaselineEndDate = Task.BaseLineEndDate;
                data.Duration = Task.Duration;
                //data.ParentId = Task.ParentId;
                data.Predescessor = Task.Predecessor;
                data.PercentDone = Task.PercentDone;
            }
            db.SaveChanges();
            return Json(true, JsonRequestBehavior.AllowGet);

        }

        [HttpPost()]
        public ActionResult Add(TaskData Task)
        {

            GanttFeatureData data = new GanttFeatureData
            {
                data.Id = Task.TaskId;
                data.Name = Task.TaskName;
                data.StartDate = Task.StartDate;
                data.BaselineStartDate = Task.BaseLineStartDate;
                data.BaselineEndDate = Task.BaseLineEndDate;
                data.Duration = Task.Duration;
                //data.ParentId = Task.ParentId;
                data.Predescessor = Task.Predecessor;
                data.PercentDone = Task.PercentDone;

            };
            db.GanttFeatureDatas.Add(data);
            db.SaveChanges();
            return Json(Task, JsonRequestBehavior.AllowGet);
        }

        [HttpPost()]
        public ActionResult Delete(TaskData Task)
        {

            int id = Task.TaskId;
            GanttFeatureData GanttRow = db.GanttFeatureDatas.Find(id);
            db.GanttFeatureDatas.Remove(GanttRow);
            db.SaveChanges();
            return Json(Task, JsonRequestBehavior.AllowGet);
        }

    }
    public class Resource
        {
            public int ResourceId { get; set; }
            public string ResourceName { get; set; }
        }
        public class ResourceList
        {
            public static List<Resource> GetResources()
            {
                List<Resource> ResourceCollection = new List<Resource>();
                ResourceCollection.Add(new Resource() { ResourceId = 1, ResourceName = "Assembly Manager" });
                ResourceCollection.Add(new Resource() { ResourceId = 2, ResourceName = "Admin" });
                ResourceCollection.Add(new Resource() { ResourceId = 3, ResourceName = "Quality Inspector" });
                ResourceCollection.Add(new Resource() { ResourceId = 4, ResourceName = "Inventory Manager" });
                return ResourceCollection;
            }
        }

}

public class GanttFeatureData
    {
        public object StartDate { get; set; }
        public int Id { get; set; }
        public string Name { get; set; }
        public int Duration { get; set; }
        public int PercentDone { get; set; }
        public List<GanttFeatureData> Children { get; set; }
        public string Predescessor { get; set; }
        public DateTime BaselineStartDate { get; set; }
        public DateTime BaselineEndDate { get; set; }
        public List<int> Resources { get; set; }
    }

Jesus Arockia Sankaran S · Answer

Hi Nosihle, Thanks for contacting Syncfusion support. It is possible to pass all the CRUD operations over the Gantt records from client side to server side with the help of ActionComplete client side event which can be updated to the database using code first approach. Please find the below code example for details with reference sample. Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Mvc5GanttSample-1303203035 Code Snippet: [CSHTML] @(Html.EJ().Gantt("Gantt"). ClientSideEvents(eve=>{ eve.ActionComplete("ActionComplete"); }) //… ) Please get back to us if you need any further assistance. Regards, Jesus Arockia Sankaran S

Nosihle · Answer

Thank you so much, this was helpful.

Jesus Arockia Sankaran S · Answer

Hi Nosihle,  
Thanks for your update. 
Please get back to us if you need any further assistance.  
Regards,  
Jesus Arockia Sankaran S

Projectier · Answer

Hello Team,I'm getting issue on the same project. Error mention belowThe call is ambiguous between the following methods or 
properties: 
'Syncfusion.JavaScript.GanttPropertiesBuilder.Datasource(string)' and 
'Syncfusion.JavaScript.GanttPropertiesBuilder.Datasource(System.Action<Syncfusion.JavaScript.DataSourceBuilder>)'

Karthikeyan Raja · Answer

Hi Nosihle, 

We analyzed the query and the reported issue is due to improper data mapping in the dataSource property. We need to use the same variable name for the data source that is used in the controller. Please find the code snippet below, 




[Controller.cs] 
public ActionResult Index() 
{ 
    var data = GanttTaskData.GetData(); 
    ViewBag.dataSource = data; 
    return View(); 
} 
 
[Index.cshtml] 
@(Html.EJ().Gantt("Gantt") 
//……. 
   .Datasource(ViewBag.dataSource) 
) 
 
Please get back to us, if you need any further assistance on this. 

Regards, 
Karthikeyan Raja

Krunal · Answer

What is data fails to save to database using ajax call due to any reason e.g. connectivity issue, exception on server side, etc. In this case, UI should pop up error message informing user that something has gone wrong with saving data to database. Also, in case of such error, UI should not reflect the intended changes i.e. if I'm saving record then save dialog should not close and remain open only.

I understand actionBegin should be treated as preview event where attempt should be made to write data to database and if error occurs during data save then there should be way to prevent actionComplete event to fire.

So question basically is how to handle server side save errors and notify user about errors?

Pooja Priya Krishna Moorthy · Answer

Hi Krunal, 
We can handle server-side errors by using actionFailure event. Please refer the below documentation link for more details. 
https://ej2.syncfusion.com/aspnetmvc/documentation/gantt/data-binding/#handling-http-error 
Please get back to us if you need more information on this. 
  
Regards, Pooja K

Saving and Updating Gantt Data Using Code First Approach MVC 5 ASP.NET

The call is ambiguous between the following methods or properties: 'Syncfusion.JavaScript.GanttPropertiesBuilder.Datasource(string)' and 'Syncfusion.JavaScript.GanttPropertiesBuilder.Datasource(System.Action<Syncfusion.JavaScript.DataSourceBuilder>)'