public SqlDataReader GetDataReaderSP(string sqlSP, SqlParameter[] param, CONNECTION_MODULE module, int Querytimeout = 120)
{
SqlDb sqlDb = new SqlDb();
return(sqlDb.GetDataReader(sqlSP, param, CommandType.StoredProcedure, sqlDb.GetConnection(module, ""), Querytimeout));
}
public SqlDataReader GetDataReaderQuery(string sqlQuery, CONNECTION_MODULE module, int Querytimeout = 120)
{
SqlDb sqlDb = new SqlDb();
return(sqlDb.GetDataReader(sqlQuery, null, CommandType.Text, sqlDb.GetConnection(module, ""), Querytimeout));
}
public SqlDataReader GetDataReaderSP(string sqlSP, int Querytimeout = 120)
{
SqlDb sqlDb = new SqlDb();
return(sqlDb.GetDataReader(sqlSP, null, CommandType.StoredProcedure, sqlDb.GetConnection(CONNECTION_MODULE.REGULAR, ""), Querytimeout = 120));
}