public MegaCategorySettingInfo GetMegaCategorySetting(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         MegaCategoryProvider    mega = new MegaCategoryProvider();
         MegaCategorySettingInfo lstGetMegaCategorySetting = mega.GetMegaCategorySetting(aspxCommonObj);
         return(lstGetMegaCategorySetting);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public MegaCategorySettingInfo GetMegaCategorySetting(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         SQLHandler sqlH = new SQLHandler();
         MegaCategorySettingInfo view =
             sqlH.ExecuteAsObject <MegaCategorySettingInfo>("[dbo].[usp_Aspx_GetMegaCategorySetting]", paramCol);
         return(view);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }