/// <summary>
/// 更新主留言內容
/// </summary>
/// <param name="loginData">會員登入資料</param>
/// <param name="Content">編輯內容</param>
/// <param name="MainMessageID">主留言編號</param>
/// <returns>新留言內容</returns>
public string UpdateMainMessage(MemberLoginModel loginData, string Content, string MainMessageID)
{
//資料庫編輯過後的留言
string UpdatedMessage = string.Empty;
//前端取得ID 為M_32
string[] MainID = MainMessageID.Split('_');
//判斷是否分析字串後是否長度大於0 & 是否可轉型 & 轉型後ID不可為0
int guestbookID = 0;
if (MainID.Length > 0 && int.TryParse(MainID[1], out guestbookID) && guestbookID != 0)
{
UpdateMainMessageModel updateModel = new UpdateMainMessageModel
{
MemberID = loginData.Member_ID,
GuestBookID = guestbookID,
Content = Content,
UpdateTime = DateTime.Now
};
UpdatedMessage = guestbookRepository.UpdateMainMessageContent(updateModel);
}
return(UpdatedMessage);
}
/// <summary>
/// 更新主留言
/// </summary>
/// <param name="updateModel">更新主留言資料</param>
/// <returns>新的主留言內容</returns>
public string UpdateMainMessageContent(UpdateMainMessageModel updateModel)
{
string newMainMessage = string.Empty;
using (var conn = new SqlConnection(connection))
{
var updatedContent = conn.QuerySingle <string>(CommontSPName.UpdateMainMessage,
new { MemberID = updateModel.MemberID, UpdatedContent = updateModel.Content, MainID = updateModel.GuestBookID, UpdateTime = updateModel.UpdateTime },
commandType: System.Data.CommandType.StoredProcedure);
newMainMessage = updatedContent;
}
return(newMainMessage);
}
