public bool UpdateUserTokenResponseDetail(UserTokenResponse response, List <GoogleData> responseDetail)
{
var responseType = UserDefinedTableTypes.UserTokenResponseType;
var responseDetailType = UserDefinedTableTypes.UserTokenResponseDetail;
responseType.Rows.Add(new object[]
{
response.UserTokenResponseId,
response.UserId,
response.Token,
response.ProcessDate,
response.CreatedBy,
response.CreatedDate,
response.ModifiedBy,
response.ModifiedDate
});
foreach (var item in responseDetail)
{
responseDetailType.Rows.Add(new object[]
{
0,
0,
DateTime.Now,
item.Link,
item.Count,
item.Description,
item.AnalyzeEntities,
item.AnalyzeEntitiesTokens,
item.AnalyzeEntitiesScore,
item.AnalyzeEntitiesMagnitude,
item.AnalyzeEntitySentiment,
item.AnalyzeEntitySentimentTokens,
item.AnalyzeEntitySentimentScore,
item.AnalyzeEntitySentimentMagnitude,
item.AnalyzeSyntax,
item.AnalyzeSyntaxTokens,
item.ClassifyText,
item.ClassifyTextTokens
});
}
var parmsCollection = new ParmsCollection();
this.unitOfWork.GetIdentityDbContext(true).ExecuteStoredProcedure <int>("[Scores].updateUserTokenResponseDetail",
parmsCollection
.AddParm("@userTokenResponse", SqlDbType.Structured, responseType, "[Scores].[UserTokenResponseType]")
.AddParm("@userTokenResponseDetail", SqlDbType.Structured, responseDetailType, "[Scores].UserTokenResponseDetailType"));
return(true);
}
protected override Response LogicImplementation()
{
var userTokens = UnitOfWork.Repository <UserToken>().GetItems(x => x.User == User).ToList();
var response = new UserTokenResponse
{
UserTokens = userTokens.Select(x => new UserTokenData
{
DeviceName = x.DeviceName,
Id = x.Id,
LastVisit = x.LastVisit
}).ToList()
};
return(CreateSuccessResponse("Токены успешно загружены", response));
}
