public void CreateQuery(O2CV1QueryDto queryDto) { using (var dc = new CriteriaDataContext()) { var q = new O2CVQuery { QueryName = queryDto.QueryName, QuerySql = queryDto.QuerySql, CreatedBy = queryDto.CreatedBy, Deleted = queryDto.Deleted, Description = queryDto.Description, CreatedDate = Now }; dc.O2CVQueries.InsertOnSubmit(q); dc.SubmitChanges(); } }
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(); } }
partial void DeleteO2CVQuery(O2CVQuery instance);
partial void UpdateO2CVQuery(O2CVQuery instance);
partial void InsertO2CVQuery(O2CVQuery instance);