public static ExtendedCollection<PrivateMessage> GetBlockListedUsers()
{
ExtendedCollection<PrivateMessage> list = new ExtendedCollection<PrivateMessage>();
IDataReader dr = GetData;
while (dr.Read())
{
PrivateMessage item = new PrivateMessage();
if (dr["ID"] != DBNull.Value)
{
item.ID = (int)dr["ID"];
}
if (dr["UID"] != DBNull.Value)
{
item.SenderUserID = (int)dr["UID"];
}
if (dr["UserName"] != DBNull.Value)
{
item.SenderUserName = (string)dr["UserName"];
}
if (dr["Date"] != DBNull.Value)
{
item.DateCreated = (DateTime)(dr["Date"]);
}
list.Add(item);
}
dr.Close();
return list;
}
/// <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 prmLyricUserName = new SqlParameter("@ToUserName", SqlDbType.VarChar, 50);
prmLyricUserName.Value = pm.LyricUserName;
SqlParameter prmMessage = new SqlParameter("@Message", SqlDbType.VarChar, 4000);
prmMessage.Value = pm.Message;
return DataAccess.Execute("spInsertPrivateMessage", prmSubject, prmSenderUserID, prmLyricUserName, 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);
}
public ExtendedCollection<PrivateMessage> GetMessages()
{
ExtendedCollection<PrivateMessage> list = new ExtendedCollection<PrivateMessage>();
IDataReader dr = GetData;
while (dr.Read())
{
PrivateMessage item = new PrivateMessage();
if (dr["M_ID"] != DBNull.Value)
{
item.ID = (int)dr["M_ID"];
}
if (dr["M_Subject"] != DBNull.Value)
{
item.Subject = (string)dr["M_Subject"];
}
if (dr["M_From"] != DBNull.Value)
{
item.SenderUserID = (int)dr["M_From"];
}
if (dr["M_To"] != DBNull.Value)
{
item.LyricUserID = (int)dr["M_To"];
}
if (dr["UserName"] != DBNull.Value)
{
item.SenderUserName = (string)dr["UserName"];
}
if (dr["M_Sent"] != DBNull.Value)
{
item.DateSent = (DateTime)(dr["M_Sent"]);
}
if (dr["M_Read"] != DBNull.Value)
{
item.Read = (int)(dr["M_Read"]);
}
if (dr["PM_Message"] != DBNull.Value)
{
item.Message = (string)(dr["PM_Message"]);
}
list.Add(item);
}
dr.Close();
return list;
}
public virtual int DeleteSentPM(PrivateMessage pm)
{
return 0;
}
public virtual int Add(PrivateMessage pm)
{
return 0;
}
/// <summary>
/// Perform Delete Sent by user PM
/// </summary>
/// <returns></returns>
public override int DeleteSentPM(PrivateMessage pm)
{
return Blogic.DeleteSentPrivateMessage(pm);
}
/// <summary>
/// Perform Insert to Database
/// </summary>
/// <returns></returns>
public override int Add(PrivateMessage pm)
{
return Blogic.InsertPrivateMessage(pm);
}