public string execute_query(query q,bool noLinks) {
string extracted_query="";
try{
if(this.count) {
data_set res=null;
/*if(this.query_is_sp) {
res=db.sp_fetch(this.connection_string,q.getTotalQuery,q.totalParameters);
} else {*/
column_data res_count=db.execute_scalar(this.connection_string.Trim(),q.getTotalQuery,q.totalParameters);
//}
if(null!=res_count) {
this.results.total_rows=res_count;
}
}
data_set rows=null;
if(this.query_is_sp) {
rows=db.sp_fetch_all(this.connection_string,q.getResultsQuery,q.resultsParameters);
extracted_query=db.extract_query(new query_params(connection_string,
q.getResultsQuery,
q.resultsParameters,
true,
query_types.sp_multiple));
} else {
if(this.query_is_single) {
rows=db.fetch(this.connection_string,q.getResultsQuery,q.resultsParameters);
extracted_query=db.extract_query(new query_params(connection_string,
q.getResultsQuery,
q.resultsParameters,
true,
query_types.single));
} else {
rows=db.fetch_all(this.connection_string,q.getResultsQuery,q.resultsParameters);
extracted_query=db.extract_query(new query_params(connection_string,
q.getResultsQuery,
q.resultsParameters,
true,
query_types.multiple));
}
}
if(null!=rows) {
this.results.rows.Clear();
foreach(row row in rows) {
process_data_row(q,row,noLinks);
}
}//while reader has rows
} //try
catch (Exception e){
//Log.Write(LogSeverity.Error, "mango WS: execute err: "+ e.Message);
}
return extracted_query;
}
public int create_export_link_id(string web_token,security.titan_token s_token) {
string query=@"INSERT INTO titanDWS_exports ([token],[json],[web_token])
VALUES (@token,@json,@web_token);
SELECT CAST(SCOPE_IDENTITY() AS int) AS ProfileKey;";
System.Web.Script.Serialization.JavaScriptSerializer jss=new System.Web.Script.Serialization.JavaScriptSerializer();
string json=jss.Serialize(this.input);
string token=jss.Serialize(s_token);
if(string.IsNullOrWhiteSpace(web_token)) web_token="error";
parameters param=new parameters();
param.add("@web_token" ,web_token);
param.add("@token" ,token);
param.add("@json" ,json);
column_data res=db.execute_scalar("titan",query,param);
int res_id=0;
Int32.TryParse((string)res.ToString(),out res_id);
return res_id;
//return 0;
}
