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); }