public string PreparedQuery_ExecuteQuery(Do_Constants.Str_Request_Session Request_Session, string PreparedQuerySessionID, Do_Constants.Str_Request_PreparedQuery_Parameters Request_Parameters) { SimpleDataSet Rv = new SimpleDataSet(); try { Str_PreparedQuerySession? Obj_Pqs = this.mPreparedQuerySessions.FirstOrDefault(X => X.Value.PreparedQuerySessionID == PreparedQuerySessionID && X.Value.SessionID == Request_Session.SessionID); if (Obj_Pqs != null) { Str_PreparedQuerySession Inner_Obj_Pqs = Obj_Pqs.Value; Inner_Obj_Pqs.SessionDate = DateTime.Now; PreparedQuery Obj_Pq = Obj_Pqs.Value.Obj; if (Request_Parameters.Parameters != null) { foreach (QueryParameter Sp in Request_Parameters.Parameters) { Obj_Pq.pParameter_Set(Sp.Name, Sp.Value); } } DataSet Ds = Obj_Pq.ExecuteQuery(); SimpleDataSet Sds = new SimpleDataSet(Ds); Rv = Sds; } } catch (Exception Ex) { this.ErrorHandler(Ex, "WcfService.Method: PreparedQuery_ExecuteQuery"); } return Rv.Serialize(); }
public string ExecuteQuery(Do_Constants.Str_Request_Session Request_Session, Do_Constants.Str_Request_Execute Request_Execute) { Interface_DataAccess Da = Do_Methods.CreateDataAccess(); String Rv = ""; try { if (Do_Methods.Convert_String(Request_Execute.ConnectionString) == "") { Da.Connect(); } else { Da.Connect(Request_Execute.ConnectionString); } if (Do_Methods.Convert_String(Request_Execute.Query) != "") { DataSet Ds = Da.ExecuteQuery(Request_Execute.Query); SimpleDataSet Sds = new SimpleDataSet(Ds); Rv = Sds.Serialize(); } else { DataSet Ds = Da.ExecuteQuery(Request_Execute.ProcedureName, Request_Execute.ProcedureParameters); SimpleDataSet Sds = new SimpleDataSet(Ds); Rv = Sds.Serialize(); } } catch (Exception Ex) { this.ErrorHandler(Ex, "WcfService.Method: ExecuteQuery"); } finally { Da.Close(); } return Rv; }