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); }