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