public Query(QueryModel query, QueryTypeModel queryType, List<QueryInParameter> inParameters_, List<QueryOutParameter> outParameters_) { this.ID = query.ID; this.queryTypeID = query.queryTypeID; this.sqlText = queryType.sqlText; this.inParameters = inParameters_; this.outParameters = outParameters_; }
public JsonResult SaveQueryType(QueryTypeModel queryType, List<QueryInParameterModel> queryInParameters, List<QueryOutParameterModel> queryOutParameters) { try { RequestObjectPackage<QueryTypeModel> reqType = new RequestObjectPackage<QueryTypeModel>() { requestData = queryType }; ResponsePackage responseType = new QueryEditorLogic().SaveQueryType(reqType).GetSelfOrExceptionIfError(); int typeID = responseType.GetIdOrExceptionIfError(); if (queryInParameters != null && queryInParameters.Count > 0) { foreach (QueryInParameterModel param in queryInParameters) { param.queryTypeID = typeID; RequestObjectPackage<QueryInParameterModel> reqIn = new RequestObjectPackage<QueryInParameterModel>() { requestData = param }; ResponsePackage responseIn = new QueryEditorLogic().SaveQueryInParameter(reqIn).GetSelfOrExceptionIfError(); } } if (queryOutParameters != null && queryOutParameters.Count > 0) { foreach (QueryOutParameterModel param in queryOutParameters) { param.queryTypeID = typeID; RequestObjectPackage<QueryOutParameterModel> reqOut = new RequestObjectPackage<QueryOutParameterModel>() { requestData = param }; ResponsePackage responseOut = new QueryEditorLogic().SaveQueryOutParameter(reqOut).GetSelfOrExceptionIfError(); } } return Json(responseType); } catch (Exception ex) { return this.HandleException(ex); } }