Beispiel #1
0
 public static List <OutOfStockInfo> NotificationitemsGetAll(AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         NotificationItemList ih   = new NotificationItemList();
         SQLHandler           sqLH = new SQLHandler();
         DataSet ds = sqLH.ExecuteAsDataSet("[dbo].[usp_Aspx_NotificationItemsGetAll]", parameterCollection);
         List <OutOfStockInfo> OutOfStockDetails = new List <OutOfStockInfo>();
         if (ds.Tables.Count > 0)
         {
             OutOfStockDetails = DataSourceHelper.FillCollection <OutOfStockInfo>(ds.Tables[0]);
         }
         return(OutOfStockDetails);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public static List<OutOfStockInfo> NotificationitemsGetAll(AspxCommonInfo aspxCommonObj)
        {
            try
            {
                List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
                NotificationItemList ih = new NotificationItemList();
                SQLHandler sqLH = new SQLHandler();
                DataSet ds = sqLH.ExecuteAsDataSet("[dbo].[usp_Aspx_NotificationItemsGetAll]",parameterCollection);
                List<OutOfStockInfo> OutOfStockDetails = new List<OutOfStockInfo>();
                if (ds.Tables.Count > 0)
                {
                   OutOfStockDetails = DataSourceHelper.FillCollection<OutOfStockInfo>(ds.Tables[0]);   
                }                
                return OutOfStockDetails;
            }
            catch (Exception e)
            {
                throw e;
            }

        }