public IActionResult CreateSemanticDetails([FromBody] CreateSemanticViewDetailsRequest request)
{
if (request != null && request.SemanticId != 0 && request.SemanticTableObj != null && request.SemanticTableObj.Count() > 0)
{
var isCreated = semanticService.CreateSemanticViewDetails(request);
if (isCreated)
{
return(Ok(new CreateSemanticResponse()
{
Message = $"Semantic View details successfully updated.",
Success = true,
SemanticId = request.SemanticId
}));
}
else
{
return(BadRequest(new CreateSemanticResponse()
{
Message = $"Semantic View details not updated.",
Success = false,
SemanticId = 0
}));
}
}
else
{
return(BadRequest(new CreateSemanticResponse()
{
Message = $"Data is invalid",
Success = false,
SemanticId = 0
}));
}
}
public bool CreateSemanticViewDetails(CreateSemanticViewDetailsRequest request)
{
return(this.dbPlugin.Execute(context =>
{
try
{
context.SemanticViewDetails.Where(x => x.SemanticViewId == request.SemanticId).Delete();
foreach (var svd in request.SemanticTableObj)
{
context.SemanticViewDetails.Add(new SemanticViewDetails()
{
TableName = request.TableName,
SemanticColumnAlias = svd.Alias == null? svd.Name: svd.Alias,
SemanticColumnDescription = svd.Description,
SemanticColumnName = svd.Name,
SemanticColumnType = svd.Type,
SemanticViewId = request.SemanticId
});
}
context.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}));
}
public bool CreateSemanticViewDetails(CreateSemanticViewDetailsRequest request)
{
return(this.semanticRepository.CreateSemanticViewDetails(request));
}
