public void CloseAsOrderSlip(Int64 TransactionID)
{
try
{
string SQL = "UPDATE tblTransactions SET " +
"TransactionStatus = @TransactionStatus, " +
"LastModified = NOW() " +
"WHERE TransactionID = @TransactionID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmTransactionID = new MySqlParameter("@TransactionID",MySqlDbType.Int64);
prmTransactionID.Value = TransactionID;
cmd.Parameters.Add(prmTransactionID);
MySqlParameter prmTransactionStatus = new MySqlParameter("@TransactionStatus",MySqlDbType.Int16);
prmTransactionStatus.Value = TransactionStatus.OrderSlip.ToString("d");
cmd.Parameters.Add(prmTransactionStatus);
base.ExecuteNonQuery(cmd);
SalesTransactionItems clsSalesTransactionItems = new SalesTransactionItems(base.Connection, base.Transaction);
clsSalesTransactionItems.CloseAsOrderSlip(TransactionID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
