public DataSet ExecuteQuery(Interface_Connection Connection, string Query)
{
Do_Constants.Str_Request_Execute Rqe = new Do_Constants.Str_Request_Execute();
Rqe.ConnectionString = (Connection as Connection_Wcf).pConnectionString;
Rqe.Query = Query;
Do_Constants.Str_Request_Session Rs = new Do_Constants.Str_Request_Session();
Rs.SessionID = ClsDataAccess_Wcf_Session.Instance.pSessionID;
Client_WcfService Client = Client_WcfService.CreateObject();
String ResponseData = Client.ExecuteQuery(Rs, Rqe);
SimpleDataSet Sds = SimpleDataSet.Deserialize(ResponseData);
return Sds.ToDataSet();
}
public int ExecuteNonQuery(Interface_Connection Connection, string Query)
{
Do_Constants.Str_Request_Execute Rqe = new Do_Constants.Str_Request_Execute();
Rqe.ConnectionString = (Connection as Connection_Wcf).pConnectionString;
Rqe.Query = Query;
Do_Constants.Str_Request_Session Rs = new Do_Constants.Str_Request_Session();
Rs.SessionID = ClsDataAccess_Wcf_Session.Instance.pSessionID;
Client_WcfService Client = Client_WcfService.CreateObject();
String ResponseData = Client.ExecuteNonQuery(Rs, Rqe);
Int32 Result = (Int32)Do_Methods.DeserializeObject_Json(typeof(Int32), ResponseData);
return Result;
}