public bool FillDiscounts(repositories.Discount discountRepository) { SQLiteCommand command = new SQLiteCommand("SELECT * FROM discount", db.connection); SQLiteDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { entities.Discount discount = new entities.Discount(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2)); discountRepository.Add(discount); } } reader.Close(); return(true); }
public Tuple <int> LoadDiscounts(repositories.Discount discounts) { List <string[]> lines = ParseCsv(GetCsvString("discounts")); int added = 0; foreach (string[] line in lines) { int id = Convert.ToInt32(line[0]); string code = line[1]; int discountSize; if (line[2] != "") { discountSize = Convert.ToInt32(line[2]); } else { discountSize = 0; } entities.Discount discount = discounts.FindOne(id); if (discount == null) { entities.Discount addDiscount = new entities.Discount(id, code, discountSize); discounts.SaveWithSql(addDiscount); } else { discount.SetId(id); discount.SetCode(code); discount.SetDiscount(discountSize); discounts.SaveWithSql(discount); added++; } } return(new Tuple <int>(added)); }