public static List <Notification> GetNotificationList(int offset, int limit, GetAllNotificationInfo getAllNotificationObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <Notification> lstNotification = AspxOutStockNotifyProvider.GetNotificationList(offset, limit, getAllNotificationObj, aspxCommonObj);
         return(lstNotification);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List<Notification> GetNotificationList(int offset, int limit, GetAllNotificationInfo getAllNotificationObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<Notification> lstNotification = AspxOutStockNotifyProvider.GetNotificationList(offset, limit, getAllNotificationObj, aspxCommonObj);
         return lstNotification;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List <Notification> GetNotificationList(int offset, int limit, GetAllNotificationInfo getAllNotificationObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > ParaMeter = CommonParmBuilder.GetParamSP(aspxCommonObj);
         ParaMeter.Add(new KeyValuePair <string, object>("offset", offset));
         ParaMeter.Add(new KeyValuePair <string, object>("limit", limit));
         ParaMeter.Add(new KeyValuePair <string, object>("itemSKU", getAllNotificationObj.ItemSKU));
         ParaMeter.Add(new KeyValuePair <string, object>("mailStatus", getAllNotificationObj.MailStatus));
         ParaMeter.Add(new KeyValuePair <string, object>("itemStatus", getAllNotificationObj.ItemStatus));
         ParaMeter.Add(new KeyValuePair <string, object>("customer", getAllNotificationObj.Customer));
         OracleHandler       sqLH            = new OracleHandler();
         List <Notification> lstNotification = sqLH.ExecuteAsList <Notification>("usp_Aspx_GetNotificationList", ParaMeter);
         return(lstNotification);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List<Notification> GetNotificationList(int offset, int limit, GetAllNotificationInfo getAllNotificationObj, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> ParaMeter = CommonParmBuilder.GetParamSP(aspxCommonObj);
         ParaMeter.Add(new KeyValuePair<string, object>("@offset", offset));
         ParaMeter.Add(new KeyValuePair<string, object>("@limit", limit));
         ParaMeter.Add(new KeyValuePair<string, object>("@itemSKU", getAllNotificationObj.ItemSKU));
         ParaMeter.Add(new KeyValuePair<string, object>("@mailStatus", getAllNotificationObj.MailStatus));
         ParaMeter.Add(new KeyValuePair<string, object>("@itemStatus", getAllNotificationObj.ItemStatus));
         ParaMeter.Add(new KeyValuePair<string, object>("@customer", getAllNotificationObj.Customer));
         SQLHandler sqLH = new SQLHandler();
         List<Notification> lstNotification= sqLH.ExecuteAsList<Notification>("usp_Aspx_GetNotificationList", ParaMeter);
         return lstNotification;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public List<Notification> GetNotificationList(int offset, int limit, GetAllNotificationInfo getAllNotificationObj, AspxCommonInfo aspxCommonObj) // not used In Item Detail Page
 {
     try
     {
         List<Notification> lstNotification = AspxOutStockNotifyController.GetNotificationList(offset, limit, getAllNotificationObj, aspxCommonObj);
         return lstNotification;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }