public domain.sm.Addressee moveMessageToFolder(domain.sm.Addressee addressee, domain.sm.Folder newFolder)
{
domain.sm.Addressee dbAddressee = new AddresseeDao(_cxn).getAddressee(addressee.Id);
if (dbAddressee == null || dbAddressee.Id <= 0)
{
throw new MdoException("Couldn't find that addressee record");
}
checkValidMove(Convert.ToInt32(dbAddressee.FolderId), Convert.ToInt32(newFolder.Id), addressee.Owner.Id);
dbAddressee.FolderId = newFolder.Id;
dbAddressee.Oplock = addressee.Oplock;
return(new AddresseeDao(_cxn).updateAddressee(dbAddressee));
}
internal OracleQuery buildCreateAddresseeQuery(domain.sm.Addressee addressee, Int32 messageId)
{
string sql = "INSERT INTO SMS.ADDRESSEE (ADDRESSEE_ROLE, SECURE_MESSAGE_ID, USER_ID, FOLDER_ID) VALUES (:addresseeRole, :smId, :userId, :folderId) " +
"RETURNING ADDRESSEE_ID INTO :outId";
OracleQuery query = new OracleQuery();
query.Command = new OracleCommand(sql);
OracleParameter addresseeRoleParam = new OracleParameter("addresseeRole", OracleDbType.Decimal);
addresseeRoleParam.Value = Convert.ToDecimal((Int32)addressee.Role);
query.Command.Parameters.Add(addresseeRoleParam);
OracleParameter smIdParam = new OracleParameter("smId", OracleDbType.Decimal);
smIdParam.Value = Convert.ToDecimal(messageId);
query.Command.Parameters.Add(smIdParam);
OracleParameter userIdParam = new OracleParameter("userId", OracleDbType.Decimal);
userIdParam.Value = Convert.ToDecimal(addressee.Owner.Id);
query.Command.Parameters.Add(userIdParam);
OracleParameter folderIdParam = new OracleParameter("folderId", OracleDbType.Decimal);
folderIdParam.Value = Convert.ToDecimal(addressee.Folder.Id);
query.Command.Parameters.Add(folderIdParam);
OracleParameter outParam = new OracleParameter("outId", OracleDbType.Decimal);
outParam.Direction = ParameterDirection.Output;
query.Command.Parameters.Add(outParam);
return(query);
}
