private void btnLoadFromXML_Click(object sender, RoutedEventArgs e) { Test_Data.LKUPData.LoadLKUPInformationFromFile(); foreach (var adDomain in Test_Data.LKUPData.ADDomains) { SQLInformation.Data.ApplicationDataSet.LKUP_ADDomainsRow newRow = Common.ApplicationDataSet.LKUP_ADDomains.NewLKUP_ADDomainsRow(); newRow.ID = adDomain.ID; newRow.ADDomainName = adDomain.Name; Common.ApplicationDataSet.LKUP_ADDomains.AddLKUP_ADDomainsRow(newRow); } Common.ApplicationDataSet.LU_ADDomainsTA.Update(Common.ApplicationDataSet.LKUP_ADDomains); foreach (var environment in Test_Data.LKUPData.Environments) { SQLInformation.Data.ApplicationDataSet.LKUP_EnvironmentsRow newRow = Common.ApplicationDataSet.LKUP_Environments.NewLKUP_EnvironmentsRow(); newRow.ID = environment.ID; newRow.EnvironmentName = environment.Name; Common.ApplicationDataSet.LKUP_Environments.AddLKUP_EnvironmentsRow(newRow); } Common.ApplicationDataSet.LU_EnvironmentsTA.Update(Common.ApplicationDataSet.LKUP_Environments); foreach (var sqlVersion in Test_Data.LKUPData.SQLServerVersions) { SQLInformation.Data.ApplicationDataSet.LKUP_SQLServerVersionsRow newRow = Common.ApplicationDataSet.LKUP_SQLServerVersions.NewLKUP_SQLServerVersionsRow(); newRow.ID = sqlVersion.ID; newRow.Name = sqlVersion.Name; newRow.CodeName = sqlVersion.CodeName; newRow.RTM = sqlVersion.RTM; newRow.SP1 = sqlVersion.SP1; newRow.SP2 = sqlVersion.SP2; newRow.SP3 = sqlVersion.SP3; newRow.SP4 = sqlVersion.SP4; Common.ApplicationDataSet.LKUP_SQLServerVersions.AddLKUP_SQLServerVersionsRow(newRow); } Common.ApplicationDataSet.LU_SQLServerVersionsTA.Update(Common.ApplicationDataSet.LKUP_SQLServerVersions); }
private void btnLoadFromXML_Click(object sender, RoutedEventArgs e) { // Read the data from the XML file. //Test_Data.InstanceData.LoadNewInstanceListFromFile(); Test_Data.LKUPData.LoadNewListFromFile(); foreach (var adDomain in Test_Data.LKUPData.ADDomains) { SQLInformation.Data.ApplicationDataSet.LKUP_ADDomainsRow newRow = Common.ApplicationDataSet.LKUP_ADDomains.NewLKUP_ADDomainsRow(); newRow.ID = adDomain.ID; newRow.ADDomainName = adDomain.Name; Common.ApplicationDataSet.LKUP_ADDomains.AddLKUP_ADDomainsRow(newRow); } foreach (var environment in Test_Data.LKUPData.Environments) { SQLInformation.Data.ApplicationDataSet.LKUP_EnvironmentsRow newRow = Common.ApplicationDataSet.LKUP_Environments.NewLKUP_EnvironmentsRow(); newRow.ID = environment.ID; newRow.EnvironmentName = environment.Name; Common.ApplicationDataSet.LKUP_Environments.AddLKUP_EnvironmentsRow(newRow); } }