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