public async Task <IActionResult> NewQuery(QueryEntity queryEntity) { try { ModelState.Remove("Id"); if (ModelState.IsValid) { const string sql = @"SELECT * FROM ITEM "; queryEntity.Query.RemoveSqlTags(); queryEntity.Query = sql + queryEntity.Query; queryEntity.CreUser = await CurrentUser; _queryRepository.Add(queryEntity); return(RedirectToAction("EditQuery", new { id = queryEntity.Id })); } else { return(View()); } } catch (System.Exception ex) { _logRepo.LogError(ex, Request.Path, Microsoft.Extensions.Logging.LogLevel.Error); return(View()); } }
public GeneralResponse AddQuery(AddQueryRequestOld request) { GeneralResponse response = new GeneralResponse(); try { Query query = new Query(); query.ID = Guid.NewGuid(); query.CreateDate = PersianDateTime.Now; query.CreateEmployee = _employeeRepository.FindBy(request.CreateEmployeeID); query.xType = request.xType; query.PrmDefinition = request.PrmDefinition; query.PrmValues = request.PrmValues; query.QueryText = request.QueryText; query.Title = request.Title; query.RowVersion = 1; #region Validation if (query.GetBrokenRules().Count() > 0) { foreach (BusinessRule businessRule in query.GetBrokenRules()) { response.ErrorMessages.Add(businessRule.Rule); } return(response); } #endregion _queryRepository.Add(query); _uow.Commit(); ////response.success = true; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); } return(response); }