private OrderPruduct GetOrderProductsFromDataRow(DataRow row) { OrderPruduct product = new OrderPruduct(); product.OrderID = row["ORDER_ID"].ToString(); product.SubID = (int)row["SUB_ID"]; product.ProductName = row["PRODUCT_NAME"].ToString(); product.Category = row["CATEGORY"].ToString(); product.ItemUnit = row["ITEM_UNIT"].ToString(); product.Quantity = (int)row["QUANTITY"]; product.ItemPrice = (Decimal)row["ITEM_PRICE"]; return(product); }
private void InsertOrderProduct(OrderPruduct product, SqlConnection conn, SqlTransaction ts) { //SqlCommand cmd = new SqlCommand("INSERT ORDERS_PRODUCTS " + // "(ORDER_ID, SUB_ID, PRODUCT_NAME, CATEGORY, ITEM_UNIT, QUANTITY, ITEM_PRICE)" + // "VALUES(@ORDER_ID, @SUB_ID, @PRODUCT_NAME, @CATEGORY, @ITEM_UNIT, @QUANTITY, @ITEM_PRICE)", // conn); //cmd.Transaction = ts; //cmd.Parameters.AddWithValue("ORDER_ID", product.OrderID); //cmd.Parameters.AddWithValue("SUB_ID", product.SubID); //cmd.Parameters.AddWithValue("PRODUCT_NAME", product.ProductName); //cmd.Parameters.AddWithValue("CATEGORY", product.Category); //cmd.Parameters.AddWithValue("ITEM_UNIT", product.ItemUnit); //cmd.Parameters.AddWithValue("QUANTITY", product.Quantity); //cmd.Parameters.AddWithValue("ITEM_PRICE", product.ItemPrice); //cmd.ExecuteNonQuery(); }
public OrderPruduct AppendEmptyProduct() { OrderPruduct product = new OrderPruduct(); product.OrderID = this.OrderID; int subID = 1; if (Products.Count > 0) { subID = Products[Products.Count - 1].SubID + 1; } product.SubID = subID; Products.Add(product); return(product); }