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