private void btnImportCSV_Click(object sender, EventArgs e) { string FileName = SelectFile("CSV files (*.csv)|*.csv|All files (*.*)|*.*"); if (FileName.Length == 0) { return; } StreamReader sr = new StreamReader(FileName); string line; while ((line = sr.ReadLine()) != null) { string[] lineparts = line.Split(';'); if (lineparts.Length == 2) { CVN C1 = new CVN(); C1.PN = lineparts[0]; C1.cvn = lineparts[1]; bool isinlist = false; for (int i = 0; i < StockCVN.Count; i++) { if (StockCVN[i].PN == C1.PN) { isinlist = true; if (StockCVN[i].cvn != C1.cvn) { //Update, is not correct CVN Logger("Updating PN: " + C1.PN + " Old: " + StockCVN[i].cvn + ", new: " + C1.cvn); C1.SegmentNr = StockCVN[i].SegmentNr; C1.Ver = StockCVN[i].Ver; C1.XmlFile = StockCVN[i].XmlFile; StockCVN.RemoveAt(i); StockCVN.Insert(i, C1); } } } if (!isinlist) { StockCVN.Add(C1); } } } sr.Close(); LoadStockCVN(); }
public void filterTables() { try { if (this.Text.Contains("Table Seek")) { List <TableSeek> compareList = new List <TableSeek>(); if (strSortOrder == SortOrder.Ascending) { compareList = tableSeeks.OrderBy(x => typeof(TableSeek).GetProperty(sortBy).GetValue(x, null)).ToList(); } else { compareList = tableSeeks.OrderByDescending(x => typeof(TableSeek).GetProperty(sortBy).GetValue(x, null)).ToList(); } bindingSource.DataSource = compareList; } else if (this.Text.Contains("Autodetect")) { List <DetectRule> compareList = new List <DetectRule>(); if (strSortOrder == SortOrder.Ascending) { compareList = DetectRules.OrderBy(x => typeof(DetectRule).GetProperty(sortBy).GetValue(x, null)).ToList(); } else { compareList = DetectRules.OrderByDescending(x => typeof(TableData).GetProperty(sortBy).GetValue(x, null)).ToList(); } bindingSource.DataSource = compareList; } else if (this.Text.Contains("stock CVN")) { List <CVN> compareList = new List <CVN>(); if (strSortOrder == SortOrder.Ascending) { compareList = StockCVN.OrderBy(x => typeof(CVN).GetProperty(sortBy).GetValue(x, null)).ToList(); } else { compareList = StockCVN.OrderByDescending(x => typeof(CVN).GetProperty(sortBy).GetValue(x, null)).ToList(); } bindingSource.DataSource = compareList; } else if (this.Text.Contains("DTC Search")) { List <DtcSearchConfig> compareList = new List <DtcSearchConfig>(); if (strSortOrder == SortOrder.Ascending) { compareList = dtcSearchConfigs.OrderBy(x => typeof(DtcSearchConfig).GetProperty(sortBy).GetValue(x, null)).ToList(); } else { compareList = dtcSearchConfigs.OrderByDescending(x => typeof(DtcSearchConfig).GetProperty(sortBy).GetValue(x, null)).ToList(); } bindingSource.DataSource = compareList; } dataGridView1.Columns[sortIndex].HeaderCell.SortGlyphDirection = strSortOrder; } catch (Exception ex) { Debug.WriteLine(ex.Message); } }