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