1: private DataSet1 _appDataset;

   2: protected void Page_Load(object sender, EventArgs e)

   3: {

   4:  

   5:  

   6:     _appDataset = new DataSet1();

   7:  

   8:      if (!Page.IsPostBack)

   9:      {

  10:          // Application load, Get values from database

  11:          FetchValuesFromStorage();

  12:          

  13:          SaveThisSessionsDataInTheCacheForFasterRetrievelOnPostback();

  14:      }

  15:      else

  16:      {

  17:          LoadDatasetFromCache();

  18:      }

  19:  

  20:     

  21:      InitTheGantt();

  22:  

  23:  

  24: }

   1: private void FetchValuesFromStorage()

   2: {

   3:     ConnectionStringSettingsCollection connections =

   4:                         ConfigurationManager.ConnectionStrings;

   5:     using (SqlConnection connection =

   6:                new SqlConnection(connections["Database1ConnectionString"].ConnectionString))

   7:     {

   8:         connection.Open();

   9:  

  10:         SqlCommand command1 = new SqlCommand("SELECT * FROM Activity where parentActivity='{00000000-0000-0000-0000-000000000000}'", connection);

  11:         SqlDataReader reader = command1.ExecuteReader();

  12:         _appDataset.Activity.Load(reader);

  13:         reader.Close();

  14:  

  15:         SqlCommand command2 = new SqlCommand("SELECT * FROM Activity where parentActivity<>'{00000000-0000-0000-0000-000000000000}'", connection);

  16:         SqlDataReader reader2 = command2.ExecuteReader();

  17:         _appDataset.SubActivity.Load(reader2);

  18:         reader2.Close();

  19:         

  20:         SqlCommand command3 = new SqlCommand("SELECT * FROM WorkItem ", connection);

  21:         SqlDataReader reader3 = command3.ExecuteReader();

  22:         _appDataset.WorkItem.Load(reader3);

  23:         reader3.Close();

  24:         

  25:     }

  26: }

   1: private void LoadDatasetFromCache()

   2: {

   3:     string data=this.Session["ganttSessionData"] as string;

   4:     if (data != null)

   5:     {

   6:         StringReader stre = new StringReader(data);

   7:         _appDataset.ReadXml(stre);

   8:     }

   9:     else

  10:         FetchValuesFromStorage();

  11: }

  12:  

  13: private void SaveThisSessionsDataInTheCacheForFasterRetrievelOnPostback()

  14: {

  15:     StringWriter xwri = new StringWriter();

  16:     _appDataset.WriteXml(xwri, XmlWriteMode.IgnoreSchema);

  17:     this.Session["ganttSessionData"] = xwri.ToString();

  18: }

   1: private void InitTheGantt()

   2: {

   3:     Gantt_ASP1.Gantt.Grid.Columns.Clear();

   4:     Gantt_ASP1.Gantt.Grid.Columns.Add(new GridColumn() { Title = "Activity", Tree=true, DataSourceColumn="Name" });

   5:  

   6:     Gantt_ASP1.Gantt.OnEachListItemWhenDataBound_GridNode += 
                                                           new EachListItemWhenDataBoundHandler(Gantt_OnEachListItemWhenDataBound_GridNode);

   7:     Gantt_ASP1.Gantt.OnEachListItemWhenDataBound_TimeItem += 
                                         new EachListItemWhenDataBoundHandler(Gantt_OnEachListItemWhenDataBound_TimeItem);

   8:  

   9:     InitLayouts();

  10:  

  11:     Gantt_ASP1.Gantt.GridProperties.RootNodes_DataSource = _appDataset.Activity;

  12:  

  13:     

  14:     

  15:     

  16:     if (!Page.IsPostBack)

  17:     { 

  18:         // fold out tree nodes the first time we show

  19:         for (int i = 0; i < Gantt_ASP1.Gantt.Grid.RootNodes.Count; i++)

  20:         {

  21:             GridNode gn = Gantt_ASP1.Gantt.Grid.RootNodes[i];

  22:             gn.Expanded = true;

  23:             Gantt_ASP1.SetExpandedStatusForGridNode(gn, true);

  24:         }

  25:     }

  26: }

   1: void Gantt_OnEachListItemWhenDataBound_GridNode(object GTPComponent, EachListItemWhenDataBoundArgs e)

   2: {

   3:     GridNode gn = (e.GTPObject as GridNode);

   4:     if (gn.SubLevel == 0)

   5:     { 

   6:         // root item

   7:         DataSet1.ActivityRow row=(e.CurrencyManagerListItem as DataRowView).Row as  DataSet1.ActivityRow;                

   8:         gn.SubNodes_DataSource=row.GetChildRows(_appDataset.Relations["FK_Activity_SubActivity"]);

   9:     }

  10:     else if (gn.SubLevel == 1)

  11:     {

  12:         // sub item

  13:         DataSet1.SubActivityRow row = e.CurrencyManagerListItem as DataSet1.SubActivityRow;

  14:         Layer l = GanttRow.FromGridNode(gn).Layers[0];

  15:         l.NameInDS_Identity = "id";

  16:         l.NameInDS_Start = "Start";

  17:         l.NameInDS_Stop = "Stop";

  18:         l.TimeItemLayout = "MyTimeItemLayout";

  19:         l.DataSource = row.GetChildRows(_appDataset.Relations["FK_SubActivity_WorkItem"]);            

  20:     }

  21:  

  22: }

  23:  

  24: void Gantt_OnEachListItemWhenDataBound_TimeItem(object GTPComponent, EachListItemWhenDataBoundArgs e)

  25: {

  26:     // This is a good place to apply data dependant styling per time item

  27: }

  28:  

   1: private void InitLayouts()

   2: {

   3:     CellLayout cl=Gantt_ASP1.Gantt.Grid.CellLayouts.GetFromName("MyCellLayout");

   4:     cl.Font=new System.Drawing.Font("Geneva",18);

   5:     cl.MinHeight = 30;

   6:  

   7:     Gantt_ASP1.Gantt.Grid.Columns[0].LayoutName = "MyCellLayout";

   8:  

   9:     TimeItemLayout til=Gantt_ASP1.Gantt.TimeItemLayouts.GetFromName("MyTimeItemLayout");

  10:     til.TimeItemStyle = TimeItemStyle.Glossy;

  11:     til.BrushKind = BrushKind.GradientHorizontal;

  12:     til.Color = Color.Pink;

  13:     til.GradientColor = Color.Red;

  14:  

  15:  

  16: }

   1: protected void ButtonAddRoot_Click(object sender, EventArgs e)

   2: {

   3:  

   4:     _appDataset.Activity.AddActivityRow(Guid.NewGuid(), "Activity", "", Guid.Empty);

   5: }

   6:  

   7: protected void ButtonAddSub_Click(object sender, EventArgs e)

   8: {

   9:     if (_appDataset.Activity.Count > 0)

  10:     {

  11:         _appDataset.SubActivity.AddSubActivityRow(Guid.NewGuid(), "SubAct", "", _appDataset.Activity[0]);

  12:     }

  13: }

  14:  

  15: protected void ButtonAddWork_Click(object sender, EventArgs e)

  16: {

  17:     if (_appDataset.Activity.Count > 0 && _appDataset.Activity[0].GetSubActivityRows().Count()>0)

  18:     {

  19:         DataSet1.SubActivityRow row = _appDataset.Activity[0].GetSubActivityRows()[0];

  20:         _appDataset.WorkItem.AddWorkItemRow(Guid.NewGuid(), Gantt_ASP1.Gantt.DateScaler.StartTime.AddDays(2), 
                                                         Gantt_ASP1.Gantt.DateScaler.StartTime.AddDays(12), (float)0.90, row);

  21:     }

  22: }

  23:  

  24: protected void ButtonSave_Click(object sender, EventArgs e)

  25: {

  26:     DataSet1TableAdapters.ActivityTableAdapter ta1=new DataSet1TableAdapters.ActivityTableAdapter();

  27:     DataSet1TableAdapters.SubActivityTableAdapter ta2 = new DataSet1TableAdapters.SubActivityTableAdapter();

  28:     DataSet1TableAdapters.WorkItemTableAdapter ta3 = new DataSet1TableAdapters.WorkItemTableAdapter();

  29:  

  30:     ta1.Update(_appDataset.Activity);

  31:     ta2.Update(_appDataset.SubActivity);

  32:     ta3.Update(_appDataset.WorkItem);

  33:  

  34:     _appDataset.AcceptChanges();

  35: }

   1:  

   2: protected void Gantt_ASP1_OnClientSideChangesApplied(object sender, EventArgs e)

   3: {

   4:     SaveThisSessionsDataInTheCacheForFasterRetrievelOnPostback();

   5: }

   6: