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