private void btnSubmit_Click(object sender, EventArgs e)
{
objTechArea = (IHomePageConfiguration)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BHomePageConfiguration,BusinessProcess.FormBuilder");
string strParse = rtbQuery.Text.Trim().ToString().ToUpper();
// string strParse = (string)objTechArea.ParseSQLColoumns(rtbQuery.Text.Trim().ToString());
if (strParse.Contains("@PatientId".ToUpper()))
{
strParse = strParse.Replace("@PatientId".ToUpper(), "0");
}
//else
//{
// IQCareWindowMsgBox.ShowWindow("ParameterPatientId", this);
// return;
//}
strParse = (string)objTechArea.ParseSQLColoumns(strParse);
if (strParse == "Valid Value" || strParse == "No Records")
{
string sqlstr = rtbQuery.Text;
char[] charsToTrim = { ';' };
sqlstr = sqlstr.TrimEnd(charsToTrim);
GblIQCare.Query = sqlstr.ToString();
this.Close();
}
else
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = strParse.ToString();
IQCareWindowMsgBox.ShowWindow("#C1", theBuilder, this);
return;
}
}
private void btnTestQuery_Click(object sender, EventArgs e)
{
if (rtbQuery.Text.Trim() == "")
{
IQCareWindowMsgBox.ShowWindow("BlankQuery", this);
return;
}
try
{
//objTechArea = (IHomePageConfiguration)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BHomePageConfiguration,BusinessProcess.FormBuilder");
string strParse = rtbQuery.Text.Trim().ToString().ToUpper();
if (strParse.Contains("@PatientId".ToUpper()))
{
strParse = strParse.Replace("@PatientId".ToUpper(), "0");
}
//else
//{
// IQCareWindowMsgBox.ShowWindow("ParameterPatientId", this);
// return;
//}
objTechArea = (IHomePageConfiguration)ObjectFactory.CreateInstance("BusinessProcess.FormBuilder.BHomePageConfiguration,BusinessProcess.FormBuilder");
//strParse = (string)objTechArea.ParseSQLColoumns(rtbQuery.Text.Trim().ToString());
strParse = (string)objTechArea.ParseSQLColoumns(strParse);
if (strParse == "Valid Value" || strParse == "No Records")
{
IQCareWindowMsgBox.ShowWindow("CheckSyntax", this);
return;
}
else
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = strParse.ToString();
IQCareWindowMsgBox.ShowWindow("#C1", theBuilder, this);
return;
}
}
catch (Exception err)
{
MsgBuilder theBuilder = new MsgBuilder();
theBuilder.DataElements["MessageText"] = err.ToString();
IQCareWindowMsgBox.ShowWindow("#C1", theBuilder, this);
return;
}
finally
{
objTechArea = null;
}
}