public static DataTable GetAllJobs(string name = null) { try { using (IDBHelper dBHelper = DBTypeSelector.GetDBInstant("dbo.GetAllJobs")) { dBHelper.AddParameter("@Name", name); return(dBHelper.FillDataTable()); } } catch (Exception ex) { throw ex; } }