void InitStantoneProjectData(ProjectObject stantoneProject)
{
stantoneProject.Executor = "Ruben Ackerman";
Task Task21 = new Task()
{
Name = "Information Gathering", Executor = "Huyen Trinklein", Tasks = new ObservableCollection <Task>()
};
Task21.Tasks.Add(new Task()
{
Name = "Market research", Executor = "Tanner Crittendon", State = "Completed"
});
Task21.Tasks.Add(new Task()
{
Name = "Making specification", Executor = "Carmine Then", State = "Completed"
});
Task Task22 = new Task()
{
Name = "Planning", Executor = "Alfredo Sookoo", Tasks = new ObservableCollection <Task>()
};
Task22.Tasks.Add(new Task()
{
Name = "Documentation", Executor = "Gorf Wobbe", State = "Completed"
});
Task Task23 = new Task()
{
Name = "Design", Executor = "Saphire Plump", Tasks = new ObservableCollection <Task>()
};
Task23.Tasks.Add(new Task()
{
Name = "Design of a web pages", Executor = "Dominic Minden", State = "In progress"
});
Task23.Tasks.Add(new Task()
{
Name = "Pages layout", Executor = "Pinkerton Trezise", State = "In progress"
});
Task Task24 = new Task()
{
Name = "Development", Executor = "Lauren Partain", Tasks = new ObservableCollection <Task>()
};
Task24.Tasks.Add(new Task()
{
Name = "Design", Executor = "Delilah Beamer", State = "In progress"
});
Task24.Tasks.Add(new Task()
{
Name = "Coding", Executor = "Dunaway Dupriest", State = "Not started"
});
stantoneProject.Tasks.Add(Task21);
stantoneProject.Tasks.Add(Task22);
stantoneProject.Tasks.Add(Task23);
stantoneProject.Tasks.Add(Task24);
}
void InitBetaronProjectData(ProjectObject betaronProject)
{
betaronProject.Executor = "Mcfadyen Ball";
Task Task11 = new Task()
{
Name = "Information Gathering", Executor = "Kaiden Savastano", Tasks = new ObservableCollection <Task>()
};
Task11.Tasks.Add(new Task()
{
Name = "Market research", Executor = "Carmine Then", State = "Completed"
});
Task11.Tasks.Add(new Task()
{
Name = "Making specification", Executor = "Seto Kober", State = "In progress"
});
Task Task12 = new Task()
{
Name = "Planning", Executor = "Manley Difrancesco", Tasks = new ObservableCollection <Task>()
};
Task12.Tasks.Add(new Task()
{
Name = "Documentation", Executor = "Martez Gollin", State = "Not started"
});
Task Task13 = new Task()
{
Name = "Design", Executor = "Clint Mary", Tasks = new ObservableCollection <Task>()
};
Task13.Tasks.Add(new Task()
{
Name = "Design of a web pages", Executor = "Gasper Hartsell", State = "Not started"
});
Task13.Tasks.Add(new Task()
{
Name = "Pages layout", Executor = "Shirish Huminski", State = "Not started"
});
betaronProject.Tasks.Add(Task11);
betaronProject.Tasks.Add(Task12);
betaronProject.Tasks.Add(Task13);
}
private ObservableCollection <ProjectObject> InitData()
{
ObservableCollection <ProjectObject> projects = new ObservableCollection <ProjectObject>();
ProjectObject betaronProject = new ProjectObject()
{
Name = "Project: Betaron", Tasks = new ObservableCollection <Task>()
};
ProjectObject stantoneProject = new ProjectObject()
{
Name = "Project: Stanton", Tasks = new ObservableCollection <Task>()
};
InitBetaronProjectData(betaronProject);
InitStantoneProjectData(stantoneProject);
projects.Add(betaronProject);
projects.Add(stantoneProject);
return(projects);
}
private ObservableCollection <ProjectObject> InitData()
{
ObservableCollection <ProjectObject> projects = new ObservableCollection <ProjectObject>();
ProjectObject betaronProject = new ProjectObject()
{
Name = "ProductTopGroup Электротехника", Tasks = new ObservableCollection <BaseObject>()
};
ProjectObject stantoneProject = new ProjectObject()
{
Name = "ProductTopGroup Механика", Tasks = new ObservableCollection <BaseObject>()
};
InitBetaronProjectData(betaronProject);
//InitStantoneProjectData(stantoneProject);
projects.Add(betaronProject);
projects.Add(stantoneProject);
return(projects);
}
void InitBetaronProjectData(ProjectObject betaronProject)
{
// либо создадим эту строку сами напрямую
string connectionString = @"Provider=Microsoft.JET.OLEDB.4.0; Data Source=C:\Users\bugrov\source\repos\WpfApp1\ESS_part002.mdb";
//Создадим объект класса DataSet, в который происходит копирование из OleDbDataAdapter
DataSet dataSet = new DataSet();
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
string SQLQuery = "SELECT * FROM tblPart";
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
// MessageBox.Show("Подключились к базе. Путь и имя базы " + connection.DataSource);
// MessageBox.Show(connection.Provider);
//создадим объект-команду, которая отсылает запрос на сревер (в БД) и в конструкто сразу передадим строку запроса и соединение
using (OleDbCommand command = new OleDbCommand(SQLQuery, connection))
{
//Отправляем команду на сервер и запоминаем результат в объект OleDbDataAdapter
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
//Создадим объект класса DataSet, в который происходит копирование из OleDbDataAdapter
// DataSet dataSet = new DataSet();
//Заполняем (копируем) данные
adapter.Fill(dataSet);
}
//закрываем соединение
connection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
#region ЗАПИСЬ в ФАЙЛ ДЛЯ ПРОВЕРКИ
/*
* StreamWriter sw = File.CreateText(@"C:\Users\bugrov\Desktop\qwe.txt");
* try
* {
* foreach (Placement3D SelectedPlacements3D in SO)
* {
* PlacementsList.Add(SelectedPlacements3D);
* sw.WriteLine(SelectedPlacements3D.Properties.FUNC_FULLDEVICETAG.ToString() +
* " Имя пространства " + SelectedPlacements3D.InstallationSpace.VisibleName);
*
* //MessageBox.Show("Имя выделенного пространства метод Selection: " + SelectedSpaces.VisibleName);
* }
* }
* catch
* {
* MessageBox.Show("Что-то сука пошло не так");
* }
* finally
* {
* MessageBox.Show("Запись окончена");
* sw.Close();
* }
*/
#endregion
betaronProject.Executor = "Mcfadyen Ball";
DataRow row = dataSet.Tables[0].Rows[0];
string str = dataSet.Tables[0].Rows[0].ItemArray[71].ToString(); // только для текущей тестовой базы 55-partnr 21-description1 22-description2 26-erpnr 33-groupnumber 38-id 45-maintanance 46-manifacturer 50-note 51-ordernr 59-productgroup 71-supplier 73-typenr
ProjectObject suppl = new ProjectObject()
{
Name = "Supplier " + str, Executor = dataSet.Tables[0].Rows[0].ItemArray[55].ToString(), Tasks = new ObservableCollection <BaseObject>()
};
// project11.Tasks.Add(new Task() { Name = "Market research", Executor = "Carmine Then", State = "Completed" });
//project11.Tasks.Add(new Task() { Name = "Making specification", Executor = "Seto Kober", State = "In progress" });
ProjectObject prodgroup = new ProjectObject()
{
Name = "ProductGroup Клеммы " + dataSet.Tables[0].Rows[0].ItemArray[59].ToString(), Executor = "Manley Difrancesco", Tasks = new ObservableCollection <BaseObject>()
};
// project12.Tasks.Add(new Task() { Name = "Tddfgr ", Executor = "Martez Gollin", State = "Not started" });
ProjectObject typenr = new ProjectObject()
{
Name = "TypeNr " + dataSet.Tables[0].Rows[0].ItemArray[73].ToString(), Tasks = new ObservableCollection <BaseObject>()
};
// project112.Tasks.Add(new Task() { Name = "afafsasfafs", Executor = "Maasfafs", State = "Not asfafs" });
// project12.Tasks.Add(project112);
// project11.Tasks.Add(project12);
ProjectObject desc1 = new ProjectObject()
{
Name = "Descr1 " + dataSet.Tables[0].Rows[0].ItemArray[21].ToString(), Tasks = new ObservableCollection <BaseObject>()
};
ProjectObject desc2 = new ProjectObject()
{
Name = "Descr2 " + dataSet.Tables[0].Rows[0].ItemArray[22].ToString(), Tasks = new ObservableCollection <BaseObject>()
};
desc2.Tasks.Add(new Task {
Name = "Заказн " + dataSet.Tables[0].Rows[0].ItemArray[55].ToString(), Executor = "Описалово " + dataSet.Tables[0].Rows[0].ItemArray[50].ToString()
});
// ProjectObject prpartnr = new ProjectObject() { Name = "Descr1 " + dataSet.Tables[0].Rows[0].ItemArray[55].ToString() };
suppl.Tasks.Add(prodgroup);
prodgroup.Tasks.Add(typenr);
typenr.Tasks.Add(desc1);
desc1.Tasks.Add(desc2);
// project13.Tasks.Add(new Task() { Name = "Design of a web pages", Executor = "Gasper Hartsell", State = "Not started" });
// project13.Tasks.Add(new Task() { Name = "Pages layout", Executor = "Shirish Huminski", State = "Not started" });
// project11.Tasks.Add(project13);
betaronProject.Tasks.Add(suppl);
// betaronProject.Tasks.Add(project12);
// betaronProject.Tasks.Add(project13);
betaronProject.Tasks.Add(new Task()
{
Name = "Task007", Executor = "Ex", State = "Completed"
});
}