/// <summary>
/// 新增回覆留言後，查詢出此主留言下回覆留言資料
/// </summary>
/// <param name="addReplyMessage"></param>
/// <returns></returns>
public IEnumerable <GetReplyMessageViewModel> AddReplyMessage(ReplyGuestbooksModel addReplyMessage, bool Role)
{
IEnumerable <GetReplyMessageViewModel> getNewReplyMessage = null;
using (var conn = new SqlConnection(connection))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@GuestBookID", addReplyMessage.GuestBookID);
parameters.Add("@MemberID", addReplyMessage.MemberID);
parameters.Add("@ReplyContent", addReplyMessage.Reply_Content);
parameters.Add("@ReplyTime", addReplyMessage.ReplyTime);
parameters.Add("@SecurityMessage", addReplyMessage.SecurityMessage);
parameters.Add("@MemberIP", addReplyMessage.Member_IP);
parameters.Add("@Role", Role);
try
{
getNewReplyMessage = conn.Query <GetReplyMessageViewModel>(CommontSPName.InsertReplyMessage, parameters
, commandType: System.Data.CommandType.StoredProcedure);
}
catch (Exception ex)
{
}
}
return(getNewReplyMessage);
}
/// <summary>
/// 新增回覆留言後，查詢出此主留言下回覆留言資料
/// </summary>
/// <param name="Content">回覆留言內容</param>
/// <param name="MainMessageID">主留言ID</param>
/// <param name="IP">回覆留言者IP</param>
/// <param name="Isprivate">是否為悄悄話</param>
/// <param name="loginData">會員登入資料</param>
/// <returns></returns>
public List <GetReplyMessageViewModel> AddReplyMessage(string Content, string MainMessageID, string IP
, string Isprivate, MemberLoginModel loginData)
{
//組合新增回覆留言資料
ReplyGuestbooksModel replyGuestModel = new ReplyGuestbooksModel()
{
GuestBookID = Convert.ToInt32(MainMessageID),
MemberID = loginData.Member_ID,
Member_IP = IP,
ReplyTime = DateTime.Now,
Reply_Content = Content,
SecurityMessage = Isprivate.Equals("Private") ? true : false
};
List <GetReplyMessageViewModel> replyMessageList = new List <GetReplyMessageViewModel>();
//新增回覆留言後，查詢出此主留言下回覆留言資料
var replyMessagelist = guestbookRepository.AddReplyMessage(replyGuestModel, loginData.Role);
if (replyMessagelist.Count() > 0)
{
foreach (var replymessage in replyMessagelist)
{
replymessage.MemberName = replymessage.MemberName.Equals("??") ? "匿名" : replymessage.MemberName;
if (replymessage.IsPrivateMessage != "T")
{
replyMessageList.Add(replymessage);
}
}
}
return(replyMessageList);
}
