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