public Dictionary.DropView DROP_Dictionary_View(IConnectToDB _Connect, string ViewName)
{
List <DBParameters> EntryProcedureParameters = new List <DBParameters>();
ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run
{
sqlIn = "Select * from CSA.ER_VIEWS where UPPER(VIEW_NAME) = @VIEW_NAME",
_dbParameters = new List <DBParameters> {
new DBParameters {
ParamName = "VIEW_NAME", MSSqlParamDataType = SqlDbType.VarChar, ParamValue = ViewName.ToUpper()
}
}
};
DataTable _DT = ER_Query._RUN_PARAMETER_QUERY(_Connect, SQlin);
DataColumnCollection DCC = _DT.Columns;
Dictionary.DropView thisModel = new Dictionary.DropView();
if (_DT.Rows.Count > 0 && DCC.Contains("ER_VIEWS_ID"))
{
thisModel = new Dictionary.DropView {
I_ER_VIEWS_ID = _DT.Rows[0].Field <long?>("ER_VIEWS_ID")
};
Universal_Call <Dictionary.DropView> dv = new Universal_Call <Dictionary.DropView>();
thisModel = dv.GenericInputProcedure(_Connect, thisModel);
}
return(thisModel);
}
public DataTable GET_COLUMNS_VIA_TABLENAME(IConnectToDB _Connect, string TableName)
{
StringBuilder SQLin = new StringBuilder();
SQLin.Append("Select COLUMN_NAME, DATA_TYPE, ");
switch (_Connect.Platform)
{
case "Microsoft":
case "MICROSOFT":
SQLin.Append("CHARACTER_OCTET_LENGTH DATA_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE ");
SQLin.Append("from INFORMATION_SCHEMA.COLUMNS ");
SQLin.Append("where upper(TABLE_NAME) = upper(@TABLE_NAME) ");
SQLin.Append("order by ORDINAL_POSITION ASC ");
ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run
{
sqlIn = SQLin.ToString(),
_dbParameters = new List <DBParameters> {
new DBParameters {
ParamName = "TABLE_NAME", MSSqlParamDataType = SqlDbType.VarChar, ParamValue = TableName
}
}
};
return(ER_Query._RUN_PARAMETER_QUERY(_Connect, SQlin));
default:
return(new DataTable());
}
}
public static CommandResult RUN_SQL_FILE(IConnectToDB _NewConnect, string ServerPath, string ResultMessage, StringBuilder _sqlIn)
{
_sqlIn = convertStringArray(System.IO.File.ReadAllLines(ServerPath), _sqlIn);
CommandResult _Result = new CommandResult();
_Result._StartTime = DateTime.Now;
_Result._Response = ER_Query._RUN_NON_QUERY(_NewConnect, _sqlIn.ToString(), ResultMessage);
_Result._Successful = _Result._Response.IndexOf("Success") != -1 ? true : false;
_Result._EndTime = DateTime.Now;
return(_Result);
}
public static bool checkIfTableExist(IConnectToDB _Connect, string schema, string tablename)
{
string _sqlIn = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = @TABLE_SCHEMA AND TABLE_NAME = @TABLE_NAME";
ER_Query.Parameter_Run SQlin = new ER_Query.Parameter_Run
{
sqlIn = _sqlIn,
_dbParameters = new List <DBParameters> {
new DBParameters {
ParamName = "TABLE_SCHEMA", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = schema
},
new DBParameters {
ParamName = "TABLE_NAME", MSSqlParamDataType = SqlDbType.BigInt, ParamValue = tablename
}
}
};
DataTable _DT = ER_Query._RUN_PARAMETER_QUERY(_Connect, SQlin);
DataColumnCollection DCC = _DT.Columns;
return(_DT.Rows.Count > 0 && DCC.Contains("TABLE_SCHEMA") ? true : false);
}
public static DataTable _RUN_PARAMETER_QUERY(IConnectToDB _Connect, Parameter_Run ParamCall)
{
ER_Query eq = new ER_Query();
return(eq.RUN_PARAMETER_QUERY(_Connect, ParamCall));
}
public static DataTable _RUN_QUERY(IConnectToDB _Connect, string SQLin)
{
ER_Query er_query = new ER_Query();
return(er_query.RUN_QUERY(_Connect, SQLin));
}
public static string _RUN_NON_QUERY(IConnectToDB _Connect, string SQLin, string SuccessMessage)
{
ER_Query query = new ER_Query();
return(query.RUN_NON_QUERY(_Connect, SQLin, SuccessMessage));
}