public void SaveQuery(string queryId, string sql) { using (var dc = new CriteriaDataContext()) { var cq = dc.O2CVQueries.FirstOrDefault(x => x.Id == Convert.ToInt64(queryId)); if (cq == null) { throw new Exception( $"Could not find query to save - query id {queryId} "); } cq.QuerySql = sql; cq.ModifiedDate = Now; dc.SubmitChanges(); } }
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 O2CV1QueryDto SaveQuery(O2CV1QueryDto queryDto) { using (var dc = new CriteriaDataContext()) { var cq = dc.O2CVQueries.FirstOrDefault(x => x.Id == Convert.ToInt64(queryDto.QueryId)); if (cq == null) { throw new Exception( $"Could not find query to save - query id {queryDto.QueryId} query name {queryDto.QueryName}"); } cq.QueryName = queryDto.QueryName; cq.QuerySql = queryDto.QuerySql; cq.Deleted = queryDto.Deleted; cq.Description = queryDto.Description; cq.ModifiedBy = queryDto.ModifiedBy; cq.ModifiedDate = Now; dc.SubmitChanges(); return(queryDto); } }