public LocalNativeSqlReader(MgSqlDataReader reader)
{
_reader = reader;
_mgReader = new FixedWKTReader();
_agfRw = new MgAgfReaderWriter();
_wktRw = new MgWktReaderWriter();
}
public override TestResult Execute(int paramSetId)
{
try
{
NameValueCollection param = new NameValueCollection();
_unitTestVm.ReadParameterValue(paramSetId, "RESOURCEID", param);
_unitTestVm.ReadParameterValue(paramSetId, "SQL", param);
MgResourceIdentifier resId = null;
if (param["RESOURCEID"] != null)
{
resId = new MgResourceIdentifier(param["RESOURCEID"]);
}
MgSqlDataReader reader = _featureService.ExecuteSqlQuery(resId, param["SQL"]);
MgByteReader byteReader = reader.ToXml();
reader.Close();
return(TestResult.FromByteReader(byteReader));
}
catch (MgException ex)
{
return(TestResult.FromMgException(ex));
}
catch (Exception ex)
{
return(TestResult.FromException(ex));
}
}
public LocalNativeSqlReader(MgSqlDataReader reader)
{
_reader = reader;
_mgReader = new FixedWKTReader();
_agfRw = new MgAgfReaderWriter();
_wktRw = new MgWktReaderWriter();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
var fact = new MgdServiceFactory();
MgFeatureService featSvc = (MgdFeatureService)fact.CreateService(MgServiceType.FeatureService);
MgResourceIdentifier fsId = new MgResourceIdentifier(textBox1.Text);
string sql = textBox2.Text;
MgSqlDataReader reader = featSvc.ExecuteSqlQuery(fsId, sql);
new ReaderResponseDialog(reader).ShowDialog();
}
catch (MgException ex)
{
MessageBox.Show(ex.ToString(), "Error from MapGuide");
}
}
