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