/// <summary> /// 提交课程评论 /// </summary> /// <param name="request"></param> /// <returns></returns> public SubmitCourseCommentResponse SubmitCourseComment(SubmitCourseCommentRequest request) { var result = new SubmitCourseCommentResponse() { Result = true, ResultMessage = "提交课程评论成功" }; try { //var courseComment = new coursecomment() //{ // UserID = request.UserID, // CourseNumber = request.CourseNumber, // CourseBookingID = request.CourseBookingID, // CoachNumber = request.CoachNumber, // CoachComment = request.CoachComment, // CommentDate = DateTime.Now, // DataChange_CreateTime = DateTime.Now, // DataChange_LastTime = DateTime.Now //}; //db.coursecomments.Add(courseComment); //db.SaveChanges(); } catch (Exception ex) { result.Result = false; result.ResultMessage = "提交课程评论异常"; result.Errors.Add(ex.Message); } return(result); }
public SubmitCourseCommentResponse SubmitCourseComment(SubmitCourseCommentRequest request) { var result = new SubmitCourseCommentResponse() { ResultMessage = "提交课程评论成功", Result = ResultCode.Success }; try { using (var con = new DbConnectionProvider(dbName).GetOpenConnection()) { var parms = new DynamicParameters(); parms.Add("P_UserID", request.UserID, DbType.Int32); parms.Add("P_CourseBookingID", request.CourseBookingID, DbType.Int32); parms.Add("P_Comment", request.Comment, DbType.String); result.CommentID = con.ExecuteScalar <int>("sp_SubmitCourseComment" , parms , CommandType.StoredProcedure); } } catch (Exception ex) { result.ResultMessage = "提交课程评论异常"; result.Result = ResultCode.Error; result.Errors = new List <string>(); result.Errors.Add(ex.Message); LogHelper.WriteErrorLog(ex); } return(result); }