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