private void FillProduct() { IDProvider id = new IDProvider(); string filePath = @"Data/products.csv"; StreamReader reader; if (File.Exists(filePath)) { reader = new StreamReader(File.OpenRead(filePath)); string header = reader.ReadLine(); while (!reader.EndOfStream) { var line = reader.ReadLine(); line = StripHTML(line); var values = line.Split(';'); Product p = new Product(id.Next(), values[1], Convert.ToDecimal(values[2]), Convert.ToInt32(values[3])); products.Add(p); } reader.Close(); } else { throw new FileNotFoundException("File not found"); } }
private void FillUser() { IDProvider id = new IDProvider(); string filePath = @"Data/users.csv"; StreamReader reader; if (File.Exists(filePath)) { reader = new StreamReader(File.OpenRead(filePath)); string header = reader.ReadLine(); while (!reader.EndOfStream) { var line = reader.ReadLine(); line = StripHTML(line); var values = line.Split(','); User u = new User(id.Next(), values[1], values[2], values[3], values[5], Convert.ToInt32(values[4])); users.Add(u); } reader.Close(); } else { throw new FileNotFoundException("File not found"); } }
private void FillTransaction() { string filePath = @"Data/Transactions.txt"; StreamReader reader; if (File.Exists(filePath)) { reader = new StreamReader(File.OpenRead(filePath)); while (!reader.EndOfStream) { var line = reader.ReadLine(); var values = line.Split(';'); if (line != String.Empty) { if (values[7] == "Buy") { BuyTransaction t = new BuyTransaction(Transid.Next(), new User(Convert.ToInt32(values[0]), values[1], values[2], values[3], values[4], Convert.ToDecimal(values[5])), DateTime.Parse(values[6]), new Product(Convert.ToInt32(values[8]), values[9], Convert.ToDecimal(values[10]), Convert.ToInt32(values[11]))); transactions.Add(t); } else if (values[7] == "Insert") { InsertCashTransaction t = new InsertCashTransaction(Transid.Next(), new User(Convert.ToInt32(values[0]), values[1], values[2], values[3], values[4], Convert.ToDecimal(values[5])), DateTime.Parse(values[6]), Convert.ToDecimal(values[8])); transactions.Add(t); } } } reader.Close(); } else { throw new FileNotFoundException("File not found"); } }