public Tuple <int> LoadCashiers(repositories.Cashier cashiers) { List <string[]> lines = ParseCsv(GetCsvString("cashiers")); int added = 0; foreach (string[] line in lines) { int id = Convert.ToInt32(line[0]); string name = line[1]; entities.Cashier cashier = cashiers.FindOne(id); if (cashier == null) { entities.Cashier addCashier = new entities.Cashier(id, name); cashiers.SaveWithSql(addCashier); } else { cashier.SetId(id); cashier.SetName(name); cashiers.SaveWithSql(cashier); added++; } } return(new Tuple <int>(added)); }
public bool FillCashiers(repositories.Cashier cashierRepository) { SQLiteCommand command = new SQLiteCommand("SELECT * FROM cashier", db.connection); SQLiteDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { //MessageBox.Show(reader["name"].ToString()); entities.Cashier cashbox = new entities.Cashier(Convert.ToInt32(reader["id"].ToString()), reader["name"].ToString()); cashierRepository.Add(cashbox); } } reader.Close(); return(true); }