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