public void Add(Record record) { this.Items.Add(record); }
private SupermarketData ProcessFile(FileInfo fileInfo, DirectoryInfo directoryInfo) { string filePath = fileInfo.FullName; var result = new SupermarketData(); result.Date = DateTime.Parse(directoryInfo.Name); var connectionString = string.Format( @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source={0};" + "Extended Properties=\"Excel 8.0; HDR=YES\";", filePath ); var connectionStringForName = string.Format( @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source={0};" + "Extended Properties=\"Excel 8.0; HDR=No\";", filePath ); var dbName = new OleDbConnection(connectionStringForName); dbName.Open(); using (dbName) { var cmd = new OleDbCommand("SELECT * from [Sales$B2:EZ]", dbName); using (var reader = cmd.ExecuteReader()) { reader.Read(); var name = reader.GetString(0); result.Name = name; } } var dbCon = new OleDbConnection(connectionString); dbCon.Open(); using (dbCon) { var cmd = new OleDbCommand("SELECT * from [Sales$B3:EZ]", dbCon); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader["ProductID"].ToString() != string.Empty) { var productID = (int)((double)reader["ProductID"]); var quantity = (int)((double)reader["Quantity"]); var unitPrice = Convert.ToDecimal((double)reader["Unit Price"]); var sum = Convert.ToDecimal((double)reader["Sum"]); var record = new Record { Id = productID, Quantity = quantity, UnitPrice = unitPrice }; result.Add(record); //Debug.WriteLine("{0} | {1} | {2} | {3}", productID, quantity, unitPrice, sum); } } } } return result; }