public int Insert(LeetAnswerEntity entity) { string sql = @"INSERT INTO [Leet_Answer] ([UserId],[LeetCodeId],[Status],[Answer]) VALUES (@UserId,@LeetCodeId,@STATUS,@Answer)"; return(base.Execute(OpenMsSqlConnection(), sql, entity)); }
public int Update(LeetAnswerEntity entity) { string sql = @"UPDATE [Leet_Answer] SET [Status] = @Status ,[Answer] = @Answer ,[UpdateTime] = GETDATE() WHERE [UserId] = @UserId AND [LeetCodeId] = @LeetCodeId "; return(base.Execute(base.OpenMsSqlConnection(), sql, new { UserId = entity.UserId, LeetCodeId = entity.LeetCodeId, Status = entity.Status, Answer = entity.Answer })); }
public int Update(LeetAnswerEntity entity) { string sql = @"UPDATE [Leet_Answer] SET [Status] = @STATUS ,[Answer] = @Answer ,[UpdateTime] = @UpdateTime WHERE Id = @Id"; return(0); }
public JsonResult AddAnswer(int questionId, string answer) { LeetAnswerEntity entity = new LeetAnswerEntity(); entity.UserId = Account.UserId; entity.Answer = answer; entity.Status = 1; entity.LeetCodeId = questionId; LeetAnswerService _service = new LeetAnswerService(); return(Json(new { result = (_service.Insert(entity) > 0) })); }
/// <summary> /// 插入一条回答记录 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Insert(LeetAnswerEntity entity) { string sql = @"INSERT INTO [Leet_Answer] ([UserId] ,[LeetCodeId] ,[Status] ,[Answer] ,[CreateTime] ,[UpdateTime]) VALUES (@UserId ,@LeetCodeId ,@Status ,@Answer ,GETDATE() ,GETDATE())"; return(base.Execute(base.OpenMsSqlConnection(), sql, new { UserId = entity.UserId, LeetCodeId = entity.LeetCodeId, Status = entity.Status, Answer = entity.Answer })); }
public int Insert(LeetAnswerEntity entity) { return(_repository.Insert(entity)); }