/// <summary>
        /// Calls [usp_Get_All_CertificateCategory]
        /// </summary>
        /// <returns></returns>
        public static List <CertificateCategory> GetListCertificateCategory()
        {
            List <CertificateCategoryDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.CertificateCategory.GetListCertificateCategory();

            if (lstDetails == null)
            {
                return(new List <CertificateCategory>());
            }
            else
            {
                List <CertificateCategory> lst = new List <CertificateCategory>();
                foreach (CertificateCategoryDetails objDetails in lstDetails)
                {
                    Rebound.GlobalTrader.BLL.CertificateCategory obj = new Rebound.GlobalTrader.BLL.CertificateCategory();
                    obj.CertificateCategoryId   = objDetails.CertificateCategoryId;
                    obj.CertificateCategoryName = objDetails.CertificateCategoryName;
                    obj.Description             = objDetails.Description;
                    obj.Inactive  = objDetails.Inactive;
                    obj.UpdatedBy = objDetails.UpdatedBy;
                    obj.DLUP      = objDetails.DLUP;
                    lst.Add(obj);
                    obj = null;
                }
                lstDetails = null;
                return(lst);
            }
        }
 /// <summary>
 /// Get
 /// Calls [usp_select_CertificateCategory]
 /// </summary>
 public static CertificateCategory Get(System.Int32?categoryId)
 {
     Rebound.GlobalTrader.DAL.CertificateCategoryDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.CertificateCategory.Get(categoryId);
     if (objDetails == null)
     {
         return(null);
     }
     else
     {
         CertificateCategory obj = new CertificateCategory();
         obj.CertificateCategoryId   = objDetails.CertificateCategoryId;
         obj.CertificateCategoryName = objDetails.CertificateCategoryName;
         obj.Description             = objDetails.Description;
         obj.Inactive  = objDetails.Inactive;
         obj.UpdatedBy = objDetails.UpdatedBy;
         obj.DLUP      = objDetails.DLUP;
         objDetails    = null;
         return(obj);
     }
 }