private DataTable GetLocationDDL(bool includeBlank, int?locationTypeCD, int?majorLocationID)
{
// database call
var TANK_usp_sel_LocationDDL_spParams = new TANK_usp_sel_LocationDDL_spParams();
TANK_usp_sel_LocationDDL_spParams.IncludeBlank = includeBlank;
TANK_usp_sel_LocationDDL_spParams.LocationTypeCD = locationTypeCD;
TANK_usp_sel_LocationDDL_spParams.MajorLocationID = majorLocationID;
DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_LocationDDL", TANK_usp_sel_LocationDDL_spParams);
return(data);
}
public IEnumerable <TANK_usp_sel_LocationDDL_spParams_spResults> PopulateGroundedSections(int MajorLocationID, bool iIncludeBlank)
{
// database call
var TANK_usp_sel_LocationDDL_spParams = new TANK_usp_sel_LocationDDL_spParams()
{
//TODO: re-factor it later from hard coded
IncludeBlank = iIncludeBlank,
MajorLocationID = MajorLocationID,
LocationTypeCD = 7
};
var data = _utilityService.ExecStoredProcedureWithResults <TANK_usp_sel_LocationDDL_spParams_spResults>("TANK_usp_sel_LocationDDL", TANK_usp_sel_LocationDDL_spParams);
return(data);
}
