public IEnumerable <TANK_usp_sel_LocationTreeFLAT_spResults> PopulateLoadPointLocationTreeFlatBlock(int majorLocationId)
{
var TANK_usp_sel_locationTreeFLAT_spParams = new TANK_usp_sel_locationTreeFLAT_spParams()
{
//TODO: re-factor it later from hard coded
MajorLocationID = majorLocationId,
LocationTypeCD = 3
};
var data = _utilityService.ExecStoredProcedureWithResults <TANK_usp_sel_LocationTreeFLAT_spResults>("TANK_usp_sel_LocationTreeFLAT", TANK_usp_sel_locationTreeFLAT_spParams);
//# database call
return(data);
}
public IEnumerable <TANK_usp_sel_LocationTreeFLAT_spResults> PopulateLoadPointLocationTreeFlatOverTheRoad(int majorLocationId)
{
//Case "Over The Road" '-- Over the road
// SA.SelectCommand.CommandText = "dbo.TANK_usp_sel_LocationTreeFLAT"
// SA.SelectCommand.Parameters.Add("@LocationTypeCD", 4)
// database call
var TANK_usp_sel_locationTreeFLAT_spParams = new TANK_usp_sel_locationTreeFLAT_spParams()
{
//TODO: re-factor it later from hard coded
LocationTypeCD = 4
};
var data = _utilityService.ExecStoredProcedureWithResults <TANK_usp_sel_LocationTreeFLAT_spResults>("TANK_usp_sel_LocationTreeFLAT", TANK_usp_sel_locationTreeFLAT_spParams);
//# database call
return(data);
}
