private DataTable GetEquipmentInfo(string equipment)
        {
            // database call
            var TANK_usp_sel_EquipmentInfo_spParams = new TANK_usp_sel_EquipmentInfo_spParams();

            TANK_usp_sel_EquipmentInfo_spParams.EquipmentAN = equipment;

            DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentInfo", TANK_usp_sel_EquipmentInfo_spParams);

            @ViewBag.TotalRecordsEquipmentInfo = data.Rows.Count;
            return(data);
        }
        private DataTable GetEquipmentInfo(bool showColumnsOnly, int majorLocationID, string equipment)
        {
            // database call
            var TANK_usp_sel_EquipmentInfo_spParams = new TANK_usp_sel_EquipmentInfo_spParams();

            //TANK_usp_sel_EquipmentInfo_spParams.EquipmentID = equipmentId;
            TANK_usp_sel_EquipmentInfo_spParams.EquipmentAN     = equipment;
            TANK_usp_sel_EquipmentInfo_spParams.MajorLocationID = majorLocationID;

            DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentInfo", TANK_usp_sel_EquipmentInfo_spParams);

            if (showColumnsOnly)
            {
                data.Clear();
            }

            @ViewBag.TotalRecordsEquipmentInfo = data.Rows.Count;
            return(data);
        }