public override void TestPerformed() { QueryDataRequest ws = new QueryDataRequest(); ws.WebServiceType = GetWebServiceType(); ws.Login = GetLogin(); ws.Limit = 1; ws.Offset = 8; WebServiceConnection client = GetClient(); try { WindowTabDataResponse response = client.SendRequest(ws); if (response.Status == WebServiceResponseStatus.Error) { Console.WriteLine(response.ErrorMessage); } else if (response.Status == WebServiceResponseStatus.Unsuccessful) { Console.WriteLine("Unsuccessful"); } else { Console.WriteLine("Total rows: " + response.NumRows); Console.WriteLine(); for (int i = 0; i < response.DataSet.GetRowsCount(); i++) { Console.WriteLine("Row: " + (i + 1)); for (int j = 0; j < response.DataSet.GetRow(i).GetFieldsCount(); j++) { Field field = response.DataSet.GetRow(i).GetFields()[j]; Console.WriteLine("Column: " + field.Column + " = " + field.Value); if (field.Column.Equals("BinaryData") && !string.IsNullOrEmpty(field.Value.ToString())) { File.WriteAllBytes("img/QueryImageTest_" + response.DataSet.GetRow(i).GetField("AD_Image_ID").Value.ToString() + ".png", field.GetByteValue()); } } Console.WriteLine(); } } } catch (Exception e) { Console.WriteLine(e); } }
public override void TestPerformed() { QueryDataRequest ws = new QueryDataRequest(); ws.WebServiceType = GetWebServiceType(); ws.Login = GetLogin(); ws.Offset = 1; ws.Limit = 2; DataRow data = new DataRow(); data.AddField("Name", "%Store%"); ws.DataRow = data; WebServiceConnection client = GetClient(); try { WindowTabDataResponse response = client.SendRequest(ws); if (response.Status == WebServiceResponseStatus.Error) { Console.WriteLine(response.ErrorMessage); } else { Console.WriteLine("Total rows: " + response.TotalRows); Console.WriteLine("Num rows: " + response.NumRows); Console.WriteLine("Start rows: " + response.StartRow); Console.WriteLine(); for (int i = 0; i < response.DataSet.GetRowsCount(); i++) { Console.WriteLine("Row: " + (i + 1)); for (int j = 0; j < response.DataSet.GetRow(i).GetFieldsCount(); j++) { Field field = response.DataSet.GetRow(i).GetFields()[j]; Console.WriteLine("Column: " + field.Column + " = " + field.Value); } Console.WriteLine(); } } } catch (Exception e) { Console.WriteLine(e); } }
public override void TestPerformed() { ReadDataRequest readData = new ReadDataRequest(); readData.Login = GetLogin(); readData.WebServiceType = GetWebServiceType(); readData.RecordID = 1000000; WebServiceConnection client = GetClient(); try { WindowTabDataResponse response = client.SendRequest(readData); if (response.Status == WebServiceResponseStatus.Error) { Console.WriteLine(response.ErrorMessage); } else if (response.Status == WebServiceResponseStatus.Unsuccessful) { Console.WriteLine("Unsuccessful"); } else { Console.WriteLine("Total rows: " + response.NumRows); Console.WriteLine(); for (int i = 0; i < response.DataSet.GetRowsCount(); i++) { Console.WriteLine("Row: " + (i + 1)); for (int j = 0; j < response.DataSet.GetRow(i).GetFieldsCount(); j++) { Field field = response.DataSet.GetRow(i).GetFields()[j]; Console.WriteLine("Column: " + field.Column + " = " + field.Value); } Console.WriteLine(); } } } catch (Exception e) { Console.WriteLine(e); } }
public override void TestPerformed() { GetListRequest ws = new GetListRequest(); ws.WebServiceType = GetWebServiceType(); ws.Login = GetLogin(); ws.AD_Reference_ID = 350; WebServiceConnection client = GetClient(); try { WindowTabDataResponse response = client.SendRequest(ws); if (response.Status == WebServiceResponseStatus.Error) { Console.WriteLine(response.ErrorMessage); } else { Console.WriteLine("Total rows: " + response.NumRows); Console.WriteLine(); for (int i = 0; i < response.DataSet.GetRowsCount(); i++) { Console.WriteLine("Row: " + (i + 1)); for (int j = 0; j < response.DataSet.GetRow(i).GetFieldsCount(); j++) { Field field = response.DataSet.GetRow(i).GetFields()[j]; Console.WriteLine("Column: " + field.Column + " = " + field.Value); } Console.WriteLine(); } } } catch (Exception e) { Console.WriteLine(e); } }