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