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