public void tblOrder_Delete(string OrderID)
{
string sql = "DELETE FROM tblOrder WHERE OrderID = @OrderID";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection,ConnectionData._MyTransaction);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@OrderID", SqlDbType.NVarChar).Value = OrderID;
if (ConnectionData._MyConnection.State == ConnectionState.Closed)
{
ConnectionData._MyConnection.Open();
}
OrderDatailDAO orDao = new OrderDatailDAO();
orDao.tblOrderDetail_Delete(OrderID);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public OrderDatailBUS()
{
odBUS = new OrderDatailDAO();
}