public QueryObject GetSigleQuery(int queryId, string userCode) { try { GetQueryObject PostDataArrived = new GetQueryObject() { QueryId = queryId.ToString(), UserCode = userCode }; ConnectionStringSettings connectionStringSetting = ConfigurationManager.ConnectionStrings["ISTATWebClientConnection"]; if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString)) { throw new Exception("ConnectionString not set"); } QueryWidget qw = new QueryWidget(connectionStringSetting.ConnectionString); List <QueryObject> res = qw.Get(PostDataArrived); if (res != null && res.Count == 1) { return(res[0]); } else { return(null); } } catch (Exception) { return(null); } }
public ActionResult Get() { try { GetQueryObject PostDataArrived = CS.GetPostData<GetQueryObject>(this.Request); ConnectionStringSettings connectionStringSetting = ConfigurationManager.ConnectionStrings["ISTATWebClientConnection"]; if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString)) throw new Exception("ConnectionString not set"); QueryWidget qw = new QueryWidget(connectionStringSetting.ConnectionString); return CS.ReturnForJQuery(qw.Get(PostDataArrived)); } catch (Exception ex) { return CS.ReturnForJQuery(ex.Message); } }
public ActionResult Get() { try { GetQueryObject PostDataArrived = CS.GetPostData <GetQueryObject>(this.Request); ConnectionStringSettings connectionStringSetting = ConfigurationManager.ConnectionStrings["ISTATWebClientConnection"]; if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString)) { throw new Exception("ConnectionString not set"); } QueryWidget qw = new QueryWidget(connectionStringSetting.ConnectionString); return(CS.ReturnForJQuery(qw.Get(PostDataArrived))); } catch (Exception ex) { return(CS.ReturnForJQuery(ex.Message)); } }
public QueryObject GetSigleQuery(int queryId, string userCode) { try { GetQueryObject PostDataArrived = new GetQueryObject() { QueryId = queryId.ToString(), UserCode = userCode }; ConnectionStringSettings connectionStringSetting = ConfigurationManager.ConnectionStrings["ISTATWebClientConnection"]; if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString)) throw new Exception("ConnectionString not set"); QueryWidget qw = new QueryWidget(connectionStringSetting.ConnectionString); List<QueryObject> res = qw.Get(PostDataArrived); if (res != null && res.Count == 1) return res[0]; else return null; } catch (Exception) { return null; } }