public LogComment InsertComment(LogComment entity)
{
string mySQL = "INSERT INTO [dbo].[TM_DIST_CHG_LOG_COMMENTS] "
+ "([LOG_NUM] "
+ ",[BASIC_NUMBER] "
+ ",[TYPE] "
+ ",[LINK_TO_SEQ_NUM] "
+ ",[CREATED_DATE]"
+ ",[CREATED_BY_SEQ_NUM]"
+ ",[COMMENT_TEXT]"
+ ",[CREATED_BY]"
+ ",[TYPE_DESC]) VALUES ("
+ entity.LogNumber
+ ",'" + entity.BasicNumber + "'"
+ ",'" + entity.CommentTypeCode + "'"
+ "," + entity.LinkToSeqNum
+ ",'" + DateTime.Now + "'"
+ "," + entity.CreatedBySeqNum
+ ",'" + entity.Comment + "'"
+ ",'" + entity.CreatedBy + "'"
+ ",'" + entity.TypeDesc + "')";
int rowsAffected = _db.Execute(mySQL);
return(entity);
}
public CreateLogCommentVM InsertComment(CreateLogCommentVM ThisComment)
{
var insertComment = new LogComment()
{
CommentTypeCode = ThisComment.CommentTypeCode,
TypeDesc = ThisComment.TypeDesc,
BasicNumber = ThisComment.BasicNumber,
Comment = ThisComment.Comment,
CreateDate = ThisComment.CreateDate,
CreatedBy = ThisComment.CreatedBy,
CreatedBySeqNum = ThisComment.CreatedBySeqNum,
LinkToSeqNum = ThisComment.LinkToSeqNum,
LogNumber = ThisComment.LogNumber,
SeqNum = ThisComment.SeqNum
};
_commentsRepo.InsertComment(insertComment);
return(ThisComment);
}
