public void Storning(entities.OrderElement orderElement)
{
driver.OpenDocument(DOC_TYPE_OUTCOME);
driver.Storning(orderElement.GetProductName(), orderElement.GetCount(), orderElement.GetPrice());
driver.PrintTotal();
driver.CloseDocument();
}
public void Annulate(entities.OrderElement orderElement)
{
driver.OpenDocument(DOC_TYPE_ANNULATE);
driver.AnnulateProduct(orderElement.GetProductName(), orderElement.GetCount(), orderElement.GetPrice());
driver.PrintTotal();
driver.RegisterPayment(orderElement.GetPrice(), 0);
driver.CloseDocument();
}
public void CancelElement(entities.OrderElement element)
{
SQLiteCommand orderCommand = new SQLiteCommand("UPDATE order_element_list SET cancel_at = @cancel_at WHERE id = @id", db.connection);
orderCommand.Parameters.AddWithValue("@cancel_at", DateTime.Now.ToLongDateString());
orderCommand.Parameters.AddWithValue("@id", element.GetId());
orderCommand.ExecuteNonQuery();
}
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);
}
public void AddElement(entities.OrderElement element)
{
elements.Add(element);
}
