/// <summary>
/// Insert private message
/// </summary>
public static int InsertPrivateMessage(PrivateMessage pm)
{
SqlParameter prmSubject = new SqlParameter("@Subject", SqlDbType.VarChar, 100);
prmSubject.Value = pm.Subject;
SqlParameter prmSenderUserID = new SqlParameter("@FromUserID", SqlDbType.Int, 4);
prmSenderUserID.Value = pm.SenderUserID;
SqlParameter prmRecipientUserName = new SqlParameter("@ToUserName", SqlDbType.VarChar, 50);
prmRecipientUserName.Value = pm.RecipientUserName;
SqlParameter prmMessage = new SqlParameter("@Message", SqlDbType.VarChar, 4000);
prmMessage.Value = pm.Message;
return DataAccess.Execute("spInsertPrivateMessage", prmSubject, prmSenderUserID, prmRecipientUserName, prmMessage);
}
/// <summary>
/// Delete user sent private message
/// </summary>
public static int DeleteSentPrivateMessage(PrivateMessage pm)
{
SqlParameter prmUserID = new SqlParameter("@UserID", SqlDbType.Int, 4);
prmUserID.Value = pm.SenderUserID;
SqlParameter prmID = new SqlParameter("@ID", SqlDbType.Int, 4);
prmID.Value = pm.ID;
return DataAccess.Execute("spDeletePrivateMessageSent", prmUserID, prmID);
}