public void AddCriteriaToQuery(O2CV1QueryDto queryDto, CriteriaDto criteriaDto)
{
using (var dc = new CriteriaDataContext())
{
var query = dc.O2CVQueries.Single(q => q.QueryName == queryDto.QueryName);
var criteria = new O2CVQueryCriteria
{
Sequence = criteriaDto.Sequence,
TableName = criteriaDto.TableName,
TableColumn = criteriaDto.TableColumn,
CompareOperator = criteriaDto.CompareOperator,
CompareValue = criteriaDto.CompareValue,
Description = criteriaDto.Description,
Name =
$"{criteriaDto.TableName} {criteriaDto.TableColumn} {criteriaDto.CompareOperator} {criteriaDto.CompareValue}",
DisableBy = criteriaDto.Disabled ? criteriaDto.Createdby : null,
CreatedBy = criteriaDto.Createdby,
Disabled = criteriaDto.Disabled,
CreatedDate = Now
};
if (criteria.Disabled == true)
{
criteria.DisabledDate = Now;
}
query.O2CVQueryCriterias.Add(criteria);
dc.SubmitChanges();
}
}
private void BuildDtosForCriteriaAdd(CountsQueryModel model, out O2CV1QueryDto queryDto, out CriteriaDto criteriaDto)
{
queryDto = new O2CV1QueryDto
{
CreatedBy = Session.GetDataFromSession <string>("LogedUserFullname"),//User.Identity.Name,
Deleted = false,
Description = model.QueryName,
QueryName = model.QueryName,
QueryId = model.QueryId
};
criteriaDto = new CriteriaDto
{
CompareOperator = model.CriteriaModel.SelectedCriteria,
CompareValue = model.CriteriaModel.CriteriaCompareValue,
Createdby = Session.GetDataFromSession <string>("LogedUserFullname"),//User.Identity.Name,
TableName = model.SelectedTable,
Description =
$"{model.SelectedTable} {model.SelectedColumn} {model.CriteriaModel.SelectedCriteria} {model.CriteriaModel.CriteriaCompareValue}",
Disabled = false,
Name =
$"{model.SelectedTable} {model.SelectedColumn} {model.CriteriaModel.SelectedCriteria} {model.CriteriaModel.CriteriaCompareValue}",
TableColumn = model.SelectedColumn
};
}
private void ResetCountsQueryModel(CriteriaDto criteriaDto, O2CV1QueryDto queryDto, CountsQueryModel model)
{
var tableNames = _schemaRepository.GetSchemaTables();
IEnumerable <DropDownItem> temptablelist = tableNames.Select(name => new DropDownItem
{
DropDownDisplay = name,
DropDownValue = name
}).OrderBy(x => x.DropDownDisplay).ToList();
model.SelectedTable = criteriaDto.TableName;
model.QueryId = queryDto.QueryId;
model.QueryName = queryDto.QueryName;
model._tables = GetSelectListItems(temptablelist);
model.QueryId = queryDto.QueryId;
model.CriteriaModel = new CriteriaModel {
_criteria = BuildModelCriteria()
};
ViewBag.temptablelist = temptablelist;
var tableSchemaModels = _schemaRepository.GetSchemaTableColumns(criteriaDto.TableName);
IEnumerable <DropDownItem> tempColumnList = tableSchemaModels.MetaData.Select(col => new DropDownItem
{
DropDownDisplay = col.Name,
DropDownValue = $"{criteriaDto.TableName}.{col.Name}"
}).OrderBy(x => x.DropDownDisplay).ToList();
model._columns = tempColumnList.ToList();
CriteriaRepository criteriaRepository = new CriteriaRepository(_dbConnectionString);
var criteriaThisQuery = criteriaRepository.GetCriteriaForQuery(Convert.ToInt64(queryDto.QueryId));
model.QueryCriteria = CriteriaMapper.MapCriteriaDtoToCriteriaGridViewModel(criteriaThisQuery);
}
public CriteriaDto AddCriteria(CreateCriteriaInput input)
{
CriteriaDto results = new CriteriaDto();
return((CriteriaDto)_creditsHeroConnect.CallCreditsHeroService <CriteriaDto>(results, input,
"api/services/app/Criteria/CreateCriteria"));
}
public IActionResult Get([FromQuery] CriteriaDto criteria)
{
int total;
var values = _valueLogic.GetAll(criteria, out total, criteria.Fields);
var result = criteria.ToPagedResult(values, total, "Get", "Values", new { test = 0 });
return(Ok(result));
}
public IActionResult GetNew([FromQuery] CriteriaDto criteria)
{
int total;
var values = _valueLogic.GetAll(criteria, out total);
//var result = queryOptions.ToPagedResult(values, total, "kevin", new { test = 0 });
var result = criteria.ToPagedResult <ValueDto, EmbeddedValueDto>(values, total);
return(Ok(result));
}
public async Task <IHttpActionResult> PostCriteria(CriteriaDto criteriaDto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var criteria = DtoToEntityIMapper.Map <CriteriaDto, Criteria>(criteriaDto); ////
UoW.GetRepository <Criteria>().Insert(criteria);
await UoW.SaveAsync();
return(CreatedAtRoute("DefaultApi", new { id = criteria.ID }, criteria));
}
public static Criteria ConvertToModel(this CriteriaDto dto)
{
return(new Criteria
{
Area = dto.Area,
DirectAccess = dto.DirectAccess,
Equipments = dto.Equipments,
Orientation = dto.Orientation,
Price = dto.Price,
TypeOfClay = dto.TypeOfClay,
WaterAccess = dto.WaterAccess,
LocationTime = dto.LocationTime
});
}
public async Task <ActionResult <CriteriaDto> > PostCriteria([FromBody] CriteriaDto criteriaDto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Criteria criteria = DtoToEntityIMapper.Map <CriteriaDto, Criteria>(criteriaDto);
repository.Add(criteria);
await uoW.SaveAsync();
return(CreatedAtAction("GetCriteria", new { id = criteria.ID }, criteriaDto));
}
public async Task <ActionResult <User> > UpdateUserCriteria(int id, CriteriaDto criteriaDto)
{
var user = await _userService.Get(id);
if (user == null)
{
return(NotFound());
}
var criteria = _mapper.Map <Criteria>(criteriaDto);
var updatedCriteria = await _userService.UpdateCriteria(user, criteria);
return(Ok(updatedCriteria));
}
public async Task <ActionResult <CriteriaDto> > GetCriteria([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var criteria = await repository.GetAsync(a => a.ID == id);
if (criteria == null)
{
return(NotFound());
}
CriteriaDto criteriaDto = EntityToDtoIMapper.Map <Criteria, CriteriaDto>(criteria);
return(Ok(criteriaDto));
}
public void AddQueryAndFirstCriteriaToQuery(O2CV1QueryDto queryDto, CriteriaDto criteriaDto)
{
using (var dc = new CriteriaDataContext())
{
var query = new O2CVQuery
{
QueryName = queryDto.QueryName,
QuerySql = queryDto.QuerySql,
CreatedBy = queryDto.CreatedBy,
Deleted = queryDto.Deleted,
Description = queryDto.Description,
CreatedDate = Now
};
var criteria = new O2CVQueryCriteria
{
Sequence = 1,
TableName = criteriaDto.TableName,
TableColumn = criteriaDto.TableColumn,
Name = criteriaDto.Description,
CompareOperator = criteriaDto.CompareOperator,
CompareValue = criteriaDto.CompareValue,
Description = criteriaDto.Description,
DisableBy = criteriaDto.Disabled ? criteriaDto.Createdby : null,
CreatedBy = criteriaDto.Createdby,
Disabled = criteriaDto.Disabled,
CreatedDate = Now
};
if (criteria.Disabled == true)
{
criteria.DisabledDate = Now;
}
query.O2CVQueryCriterias.Add(criteria);
dc.O2CVQueries.InsertOnSubmit(query);
dc.SubmitChanges();
}
}
public async Task <ActionResult <CriteriaDto> > PutCriteria([FromRoute] int id, [FromBody] CriteriaDto criteriaDto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != criteriaDto.ID)
{
return(BadRequest());
}
Criteria criteria = DtoToEntityIMapper.Map <CriteriaDto, Criteria>(criteriaDto);
repository.ModifyEntryState(criteria, EntityState.Modified);
try
{
await uoW.SaveAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CriteriaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
