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