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