//Calls Procedure and loads data to dataset.
protected void CallProcedure()
{
DB_Toolbox environment_Tools_db = new DB_Toolbox();
DB_Toolbox.DBParameters[] dbParameters = new DB_Toolbox.DBParameters[3];
List<DB_Toolbox.DBParameters> infoList = new List<DB_Toolbox.DBParameters>();
dbParameters[0] = new DB_Toolbox.DBParameters();
dbParameters[0].ParamName = "PARAM1";
dbParameters[0].ParamDBType = OracleDbType.Varchar2;
dbParameters[0].ParamDirection = ParameterDirection.Input;
dbParameters[0].ParamValue = "123";
dbParameters[0].ParamSize = 100;
dbParameters[0].ParamReturn = false;
infoList.Add(dbParameters[0]);
dbParameters[1] = new DB_Toolbox.DBParameters();
dbParameters[1].ParamName = "PARAM2";
dbParameters[1].ParamDBType = OracleDbType.Varchar2;
dbParameters[1].ParamDirection = ParameterDirection.Output;
dbParameters[1].ParamSize = 100;
dbParameters[1].ParamReturn = true;
infoList.Add(dbParameters[1]);
dbParameters[2] = new DB_Toolbox.DBParameters();
dbParameters[2].ParamName = "PARAM3";
dbParameters[2].ParamDBType = OracleDbType.Varchar2;
dbParameters[2].ParamDirection = ParameterDirection.Output;
dbParameters[2].ParamSize = 100;
dbParameters[2].ParamReturn = true;
infoList.Add(dbParameters[2]);
DataTable dt = new DataTable();
dt = environment_Tools_db.SQL_PROCEDURE("Oracle", constr1, "TEST123", infoList);
dg.DataSource = dt;
dg.DataBind();
InstallerHolder.Controls.Add(dg);
InstallerHolder.Visible = true;
submitCmsName.Enabled = false;
}
public DataTable SQL_PROCEDURE_PARAMS(string DB_Platform, string ConnAuth, string ProcedureName, List<DBParameters> _dbParameters)
{
DBParameters[] dbParameters = new DBParameters[_dbParameters.Count];
List<DBParameters> infoList = new List<DBParameters>();
int iNumber = 0;
switch(DB_Platform)
{
case "Oracle":
case "ORACLE":
foreach (DBParameters i in _dbParameters)
{
dbParameters[iNumber] = new DB_Toolbox.DBParameters();
dbParameters[iNumber].ParamName = i.ParamName;
dbParameters[iNumber].OracleParamDataType = i.OracleParamDataType;
dbParameters[iNumber].ParamDirection = i.ParamDirection;
dbParameters[iNumber].ParamValue = i.ParamValue;
dbParameters[iNumber].ParamSize = i.ParamSize;
dbParameters[iNumber].ParamReturn = i.ParamReturn;
infoList.Add(dbParameters[iNumber]);
iNumber++; //++ Increments by 1.
}
break;
case "Microsoft":
case "MICROSOFT":
foreach (DBParameters i in _dbParameters)
{
dbParameters[iNumber] = new DB_Toolbox.DBParameters();
dbParameters[iNumber].ParamName = i.ParamName;
dbParameters[iNumber].MSSqlParamDataType = i.MSSqlParamDataType;
dbParameters[iNumber].ParamDirection = i.ParamDirection; //Not used by MSSQL
dbParameters[iNumber].ParamValue = i.ParamValue; //Not used by MSSQL
dbParameters[iNumber].ParamSize = i.ParamSize;
dbParameters[iNumber].ParamReturn = i.ParamReturn;
infoList.Add(dbParameters[iNumber]);
iNumber++; //++ Increments by 1.
}
break;
}
return SQL_PROCEDURE(DB_Platform, ConnAuth, ProcedureName, infoList);
}
public DataTable SQL_PROCEDURE_PARAMS(string DB_Platform, string ConnAuth, string ProcedureName, List<DBParameters> _dbParameters)
{
DBParameters[] dbParameters = new DBParameters[_dbParameters.Count];
List<DBParameters> infoList = new List<DBParameters>();
int iNumber = 0;
foreach (DBParameters i in _dbParameters)
{
dbParameters[iNumber] = new DB_Toolbox.DBParameters();
dbParameters[iNumber].ParamName = i.ParamName;
dbParameters[iNumber].ParamDBType = i.ParamDBType;
dbParameters[iNumber].ParamDirection = i.ParamDirection;
dbParameters[iNumber].ParamValue = i.ParamValue;
dbParameters[iNumber].ParamSize = i.ParamSize;
dbParameters[iNumber].ParamReturn = i.ParamReturn;
infoList.Add(dbParameters[iNumber]);
iNumber++; //++ Increments by 1.
}
return SQL_PROCEDURE(DB_Platform, ConnAuth, ProcedureName, infoList);
}
