public Result CancelTransactionHeader() { // must delete first to remove any references from transaction details Result result = Destroy(); if (!result.Success) { return(result); } IsCancelled = true; result = Create(); if (!result.Success) { return(result); } var transactionDetail = new TransactionDetail(); transactionDetail.TransactionHeaderId = TransactionHeaderId; transactionDetail.MemberCode = "CANCELLED"; transactionDetail.MemberName = "CANCELLED"; transactionDetail.AccountCode = "CANCELLED"; transactionDetail.AccountTitle = "CANCELLED"; result = transactionDetail.Create(); return(result); }
public static List <TransactionDetail> GetTransactionDetailsByTransactionHeaderId(int transactionHeaderId) { string sqlCommandText = string.Format( "SELECT * FROM {0} WHERE TransactionHeaderId = ?TransactionHeaderId ORDER BY TransactionDetailId", TableName); DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlCommandText, new SqlParameter("?TransactionHeaderId", transactionHeaderId)); var transactionDetails = new List <TransactionDetail>(); foreach (DataRow dataRow in dataTable.Rows) { var trd = new TransactionDetail(); trd.SetPropertiesFromDataRow(dataRow); transactionDetails.Add(trd); } return(transactionDetails); }