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