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