Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save JoseGonzalez321/764aeb33a18a29de446b to your computer and use it in GitHub Desktop.
Save JoseGonzalez321/764aeb33a18a29de446b to your computer and use it in GitHub Desktop.
public DataTable GetTopLevel(DateTime valueDate, string branch)
{
var parameters = SetupStoredProcParameters(Level.Top, valueDate, branch);
const string storedProc = "GetTopLevel";
var result = storedProc.ToDataTable(dbConnection, parameters);
return result;
}
public DataTable GetFirstLevel(DateTime valuDate, string branch, string levelName)
{
var parameters = SetupStoredProcParameters(Level.Top, valueDate, branch, levelName);
const string storedProc = "GetLevelOne";
var result = storedProc.ToDataTable(dbConnection, parameters);
return result;
}
public DataTable GetSecondLevel(DateTime valueDate,
string branch,
string levelName,
string subLevelName)
{
var parameters = SetupStoredProcParameters(Level.Top, valueDate, branch, levelName, subLevel);
const string storedProc = "GetLevelTwo";
var result = storedProc.ToDataTable(dbConnection, parameters);
return result;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment