private List <RefProductOrder> TablelistProductFromIdUser(DataTable dt) { List <RefProductOrder> list = new List <RefProductOrder>(); foreach (DataRow item in dt.Rows) { RefProductOrder cart = new RefProductOrder(); cart._id_product = item[0].ToString(); cart._quantity = int.Parse(item[1].ToString()); cart._price = Double.Parse(item[2].ToString()); list.Add(cart); } return(list); }
public void creatRefProductOrder(RefProductOrder refProductOrder, int idOrder) { String sql = "INSERT dbo.ref_product_order( [_quantity] ,[_id_order] , [_id_product] ,[_price] )VALUES " + " ( @_quantity , @_id_order , @_id_product , @_price )"; SqlCommand cmd = new SqlCommand(sql, GetConnection()); if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } cmd.Parameters.AddWithValue("@_quantity", refProductOrder._quantity); cmd.Parameters.AddWithValue("@_id_order", idOrder); cmd.Parameters.AddWithValue("@_id_product", refProductOrder._id_product); cmd.Parameters.AddWithValue("@_price", refProductOrder._price); int reuslt = cmd.ExecuteNonQuery(); cmd.Connection.Close(); }