public void Cancel(long TransferInID, DateTime CancelledDate, string Remarks, long CancelledByID)
{
try
{
string SQL = "UPDATE tblTransferIn SET " +
"CancelledDate = @CancelledDate, " +
"CancelledRemarks = @CancelledRemarks, " +
"CancelledByID = @CancelledByID, " +
"Status = @Status " +
"WHERE TransferInID = @TransferInID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmCancelledDate = new MySqlParameter("@CancelledDate",MySqlDbType.DateTime);
prmCancelledDate.Value = CancelledDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmCancelledDate);
MySqlParameter prmCancelledRemarks = new MySqlParameter("@CancelledRemarks",MySqlDbType.String);
prmCancelledRemarks.Value = Remarks;
cmd.Parameters.Add(prmCancelledRemarks);
MySqlParameter prmCancelledByID = new MySqlParameter("@CancelledByID",MySqlDbType.Int64);
prmCancelledByID.Value = CancelledByID;
cmd.Parameters.Add(prmCancelledByID);
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = TransferInStatus.Cancelled.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmTransferInID = new MySqlParameter("@TransferInID",MySqlDbType.Int64);
prmTransferInID.Value = TransferInID;
cmd.Parameters.Add(prmTransferInID);
base.ExecuteNonQuery(cmd);
/*******************************************
* Update the status of items
* ****************************************/
TransferInItem clsTransferInItem = new TransferInItem(base.Connection, base.Transaction);
clsTransferInItem.Cancel(TransferInID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
