/// <summary>
/// 특정 게시물에 댓글 추가
/// </summary>
public void AddComment(SupportComment model)
{
//[A] SQL 쿼리문: 댓글 입력 및 게시판 코멘트 수 1 증가
string sql = @"
Insert Into SupportsComments (ArticleId, Name, Opinion, Password, UserName)
Values(@ArticleId, @Name, @Opinion, @Password, @UserName);
Update Supports Set CommentCount = CommentCount + 1
Where Id = @ArticleId
";
//[B] 파라미터 추가
var parameters = new DynamicParameters();
parameters.Add("@ArticleId", value: model.ArticleId, dbType: DbType.Int32);
parameters.Add("@Name", value: model.Name, dbType: DbType.String);
parameters.Add("@Opinion", value: model.Opinion, dbType: DbType.String);
parameters.Add("@Password", value: model.Password, dbType: DbType.String);
parameters.Add("@UserName", value: model.UserName, dbType: DbType.String);
//[C] 실행
db.Execute(sql, parameters, commandType: CommandType.Text);
}
public bool Edit(SupportComment model)
{
throw new NotImplementedException();
}
public SupportComment Add(SupportComment model)
{
throw new NotImplementedException();
}
