public static void AddNewBatch(SqlConnection connection) { Batch batch = new Batch(); Console.WriteLine("Please, enter the batch details: "); Console.Write("Date: "); batch.Date = ConsoleInput.InputDate(); Console.Write("Select batch type: "); batch.BatchType = SelectBatchType(); BatchQuery batchQuery = new BatchQuery(connection); batchQuery.AddNewRecord(batch); int lastId = batchQuery.GetLastId(); Console.WriteLine("Please, add products to the batch (input product's Id and quantity): "); ProductBatchQuery productBatchQuery = new ProductBatchQuery(connection); AddRecordsIntoProductBatch(lastId, productBatchQuery); }
public static void AddNewProduct(SqlConnection connection) { Product product = new Product(); Console.WriteLine("Please, enter the product details: "); Console.Write("Name: "); product.Name = Console.ReadLine(); Console.Write("UnitMeasure: "); product.UnitMeasure = Console.ReadLine(); Console.Write("UnitPrice: "); product.UnitPrice = ConsoleInput.InputDouble(); Console.Write("Quantity: "); product.Quantity = ConsoleInput.InputInt(); ProductQuery productQuery = new ProductQuery(connection); int result = productQuery.AddNewRecord(product); Console.WriteLine($"Affected rows: {result}"); }