public Tuple <int> SendOrders(repositories.Order orders) { int counter = 0; SQLiteCommand command = new SQLiteCommand("SELECT * FROM order_list WHERE cancel_at IS NULL AND (dvizh_id = 0 OR dvizh_id IS NULL) ORDER BY id DESC", db.connection); SQLiteDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { entities.Order order = DataMapper.BuildOrder(reader); int dvizhid = SendOrder(order); if (dvizhid > 0) { orders.SaveDvizhIdWithSql(order, dvizhid); counter++; } } } reader.Close(); return(new Tuple <int>(counter)); }
public bool FillOrders(repositories.Order orderRepository) { DateTime dt1 = DateTime.Now; SQLiteCommand command = new SQLiteCommand("SELECT * FROM order_list WHERE cancel_at IS NULL ORDER BY id DESC LIMIT 1000", db.connection); SQLiteDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { entities.Order order = BuildOrder(reader); orderRepository.Add(order); } } reader.Close(); foreach (entities.Order order in orderRepository.GetList()) { SQLiteCommand elementCommand = new SQLiteCommand("SELECT * FROM order_element_list WHERE order_id = " + order.GetId().ToString(), db.connection); SQLiteDataReader elementReader = elementCommand.ExecuteReader(); if (elementReader.HasRows) { while (elementReader.Read()) { string cancelAt; if (!elementReader.IsDBNull(6)) { cancelAt = elementReader.GetString(6); } else { cancelAt = ""; } entities.OrderElement element = new entities.OrderElement(elementReader.GetInt32(0), elementReader.GetInt32(1), elementReader.GetString(3), Convert.ToDouble(elementReader.GetDecimal(5)), elementReader.GetInt32(4), cancelAt); order.AddElement(element); } } elementReader.Close(); } return(true); }