public DataTable RUN_PARAMETER_QUERY(IConnectToDB _Connect, Parameter_Run ParamCall)
{
DataTable dt = new DataTable("ReturnData");
DataColumn column;
DataRow row;
switch (_Connect.Platform)
{
case "Microsoft":
case "MICROSOFT":
using (SqlConnection connection = new SqlConnection(_Connect.DBConnString))
{
try
{
connection.Open();
SqlCommand sqlplus = connection.CreateCommand();
sqlplus.CommandText = ParamCall.sqlIn;
foreach (var item in ParamCall._dbParameters)
{
sqlplus.Parameters.AddWithValue("@" + item.ParamName, item.ParamValue);
}
SqlDataReader dr = sqlplus.ExecuteReader();
dt.Load(dr);
}
catch (SqlException ex)
{
//Return Oracle Error.
//return ex.ToString();
// Create first column and add to the DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "ChildID";
column.AutoIncrement = true;
column.AutoIncrementSeed = 0;
column.AutoIncrementStep = 1;
column.Caption = "ID";
column.ReadOnly = true;
column.Unique = true;
dt.Columns.Add(column);
// Create second column and add to the DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ChildType";
column.AutoIncrement = false;
column.Caption = "ChildType";
column.ReadOnly = false;
column.Unique = false;
dt.Columns.Add(column);
// Create third column and add to the DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ChildItem";
column.AutoIncrement = false;
column.Caption = "ChildItem";
column.ReadOnly = false;
column.Unique = false;
dt.Columns.Add(column);
// Create fourth column and add to the DataTable.
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "ChildValue";
column.AutoIncrement = false;
column.Caption = "ChildValue";
column.ReadOnly = false;
column.Unique = false;
dt.Columns.Add(column);
row = dt.NewRow();
row["ChildType"] = "RETURN";
row["ChildItem"] = "ERROR";
row["ChildValue"] = DB_ERROR_FORMATTER(_Connect, ex);
dt.Rows.Add(row);
}
finally
{
connection.Close();
connection.Dispose();
}
return(dt);
}
default:
return(dt);
}
}
public static DataTable _RUN_PARAMETER_QUERY(IConnectToDB _Connect, Parameter_Run ParamCall)
{
ER_Query eq = new ER_Query();
return(eq.RUN_PARAMETER_QUERY(_Connect, ParamCall));
}
